params.put("offset", pagina * offset);
return getSqlMapClientTemplate().queryForList("getCentriByAlfabetico", params);
}
public List<CentroLight> getCentriByNominativo(String nominativo, Integer 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("limit", offset);
params.put("offset", pagina * offset);
return getSqlMapClientTemplate().queryForList("getCentriByNominativo", params);
}