/**
  * Method 'insert'
  *
  * @param dto
  * @return StatusCodePk
  */
 public StatusCodePk insert(StatusCode dto) {
   getJdbcTemplate()
       .update(
           "INSERT INTO "
               + getTableName()
               + " ( CODE_NAME, CODE_VALUE, DELETE_IND ) VALUES ( ?, ?, ? )",
           dto.getCodeName(),
           dto.getCodeValue(),
           dto.getDeleteInd());
   StatusCodePk pk = new StatusCodePk();
   pk.setId(getJdbcTemplate().queryForInt("select last_insert_id()"));
   return pk;
 }
 /** 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());
 }