/** * Method 'insert' * * @param dto * @return CityPk */ public CityPk insert(City dto) { getJdbcTemplate() .update( "INSERT INTO " + getTableName() + " ( CITY, SUMMARY, IMAGE_URL, STATE_ID ) VALUES ( ?, ?, ?, ? )", dto.getCityName(), dto.getSummary(), dto.getImageUrl(), dto.getStateId()); CityPk pk = new CityPk(); pk.setId(getJdbcTemplate().queryForInt("select last_insert_id()")); return pk; }