public static List getRecords(Dao dao, String sql, Class t, int page, int size) {
Sql s = Sqls.create(sql);
s.setCallback(Sqls.callback.entities());
s.setPager(dao.createPager(page, size));
s.setEntity(dao.getEntity(t));
dao.execute(s);
return s.getList(Record.class);
}
/**
* 用没有处理过的Nutz.sql带分页
*
* @param dao
* @param s
* @param page
* @param size
* @return
*/
public static Record getRecordsByNutSql(Dao dao, Sql s, int page, int size) {
int total = getRecordSize(dao, s.toString());
s.setCallback(Sqls.callback.entities());
s.setPager(dao.createPager(page, size));
s.setEntity(dao.getEntity(Record.class));
dao.execute(s);
Record rd = new Record();
List<Record> records = s.getList(Record.class);
rd.put("total", total);
rd.put("rows", records);
return rd;
}