/** Updates a single row in the STATUS_CODE table. */
public void update(StatusCodePk pk, StatusCode dto) throws DataBaseJdbcException {
getJdbcTemplate()
.update(
"UPDATE "
+ getTableName()
+ " SET ID = ?, CODE_NAME = ?, CODE_VALUE = ?, DELETE_IND = ? WHERE ID = ?",
dto.getId(),
dto.getCodeName(),
dto.getCodeValue(),
dto.getDeleteInd(),
pk.getId());
}
/** Deletes a single row in the STATUS_CODE table. */
public void delete(StatusCodePk pk) throws DataBaseJdbcException {
getJdbcTemplate().update("DELETE FROM " + getTableName() + " WHERE ID = ?", pk.getId());
}
/** Returns the rows from the STATUS_CODE table that matches the specified primary-key value. */
public StatusCode findByPrimaryKey(StatusCodePk pk) throws DataBaseJdbcException {
return findByPrimaryKey(pk.getId());
}
