/** refresh */
public void refresh(EntityBean eb, boolean forUpdate) throws Exception {
ArdaisstaffBean b = (ArdaisstaffBean) eb;
com.ardais.bigr.iltds.beans.ArdaisstaffKey _primaryKey =
new com.ardais.bigr.iltds.beans.ArdaisstaffKey();
_primaryKey.ardais_staff_id = b.ardais_staff_id;
load(b, _primaryKey, forUpdate);
}
/** getPrimaryKey */
public Object getPrimaryKey(Object data) throws Exception {
com.ardais.bigr.iltds.beans.ArdaisstaffKey key =
new com.ardais.bigr.iltds.beans.ArdaisstaffKey();
java.sql.ResultSet resultSet = (java.sql.ResultSet) data;
if (resultSet != null) {
Object objectTemp = null;
key.ardais_staff_id = resultSet.getString(1);
return key;
}
return null;
}
/** store */
public void store(EntityBean eb) throws Exception {
Object objectTemp = null;
ArdaisstaffBean b = (ArdaisstaffBean) eb;
com.ardais.bigr.iltds.beans.ArdaisstaffKey _primaryKey =
new com.ardais.bigr.iltds.beans.ArdaisstaffKey();
_primaryKey.ardais_staff_id = b.ardais_staff_id;
PreparedStatement pstmt;
pstmt = getPreparedStatement(_storeString);
try {
if (_primaryKey.ardais_staff_id == null) {
pstmt.setNull(6, java.sql.Types.VARCHAR);
} else {
pstmt.setString(6, _primaryKey.ardais_staff_id);
}
if (b.ardais_staff_lname == null) {
pstmt.setNull(1, java.sql.Types.VARCHAR);
} else {
pstmt.setString(1, b.ardais_staff_lname);
}
if (b.ardais_staff_fname == null) {
pstmt.setNull(2, java.sql.Types.VARCHAR);
} else {
pstmt.setString(2, b.ardais_staff_fname);
}
if (b.ardais_acct_key == null) {
pstmt.setNull(3, java.sql.Types.VARCHAR);
} else {
pstmt.setString(3, b.ardais_acct_key);
}
if (b.ardais_user_id == null) {
pstmt.setNull(4, java.sql.Types.VARCHAR);
} else {
pstmt.setString(4, b.ardais_user_id);
}
if (b.geolocation_location_address_id == null) {
pstmt.setNull(5, java.sql.Types.VARCHAR);
} else {
pstmt.setString(5, b.geolocation_location_address_id);
}
pstmt.executeUpdate();
} finally {
returnPreparedStatement(pstmt);
}
}
/** remove */
public void remove(EntityBean eb) throws Exception {
Object objectTemp = null;
ArdaisstaffBean b = (ArdaisstaffBean) eb;
com.ardais.bigr.iltds.beans.ArdaisstaffKey _primaryKey =
new com.ardais.bigr.iltds.beans.ArdaisstaffKey();
_primaryKey.ardais_staff_id = b.ardais_staff_id;
PreparedStatement pstmt;
pstmt = getPreparedStatement(_removeString);
try {
if (_primaryKey.ardais_staff_id == null) {
pstmt.setNull(1, java.sql.Types.VARCHAR);
} else {
pstmt.setString(1, _primaryKey.ardais_staff_id);
}
pstmt.executeUpdate();
} finally {
returnPreparedStatement(pstmt);
}
}