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