/** * 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; }