public Page<M> paginate(int pageNumber, int pageSize, String select, String sqlExceptSelect, Object... paras) { } //该出直接select count 会导致查出来的数据跟实际不匹配 List result = Db.query(config, conn, "select count(*) " + DbKit.replaceFormatSqlOrderBy(sqlExceptSelect), paras);
项目:JFinal
paginate(1, 10, "select *", "from ( select distinct ....) as temp", p1, p2,..., pn)