Nutz分页查询

Nutz分页查询记录总数

以Student为例

0默认存在,-1假删

单表分页查询

 Cnd where = Cnd.where("del","=",0);
//一页10条
List<Student> list = dao.query(Student.class,where,dao.createPager(1,10));
//记录总条数
int count = dao.count(HouseType.class,where);
return ajaxTable(list,count);

多表分页查询

//自定义sql

Sql sql = dao.sqls().create("XXXXXXX");
sql.setPager(dao.createPager(1,10));
sql.setCallback(Sqls.callback.records());
Cnd where = Cnd.where("a.del","=",0);
sql.setCondition(where);
dao.execute(sql);
List<Record> lst = sql.getList(Record.class);
int count = (int)Daos.queryCount(dao,sql);
return ajaxTable(lst,count);