@Override
public List<String> retrieveCityDetails() {
context.authenticatedUser();
final AddressMapper1 mapper = new AddressMapper1();
final String sql = "select " + mapper.sqlschema("city_name", "city") + " where is_delete = 'N'";
return this.jdbcTemplate.query(sql, mapper, new Object[] {});
}
@Override
public List<String> retrieveStateDetails() {
context.authenticatedUser();
final AddressMapper1 mapper = new AddressMapper1();
final String sql = "select " + mapper.sqlschema("state_name", "state");
return this.jdbcTemplate.query(sql, mapper, new Object[] {});
}