params.put("offset", pagina * offset);
return getSqlMapClientTemplate().queryForList("getUtentiByCitta", params);
}
public List<Utente> getUtentiByNominativo(String nominativo, long idCentro, int pagina) throws DataAccessException {
Map params = new FastMap();
params.put("nominativoLower", (new StringBuilder(nominativo.toLowerCase().concat("%")).toString()));
// params.put("nominativoUpper", (new
// StringBuilder(nominativo.toUpperCase().concat("%")).toString()));
params.put("idCentro", idCentro);
params.put("limit", offset);
params.put("offset", pagina * offset);
return getSqlMapClientTemplate().queryForList("getUtentiByNominativo", params);
}