## 翻頁查詢 ```java public class S3PageSample { SQLManager sqlManager; UserMapper mapper =null; public S3PageSample(SQLManager sqlManager) { this.sqlManager = sqlManager; mapper = sqlManager.getMapper(UserMapper.class); } public static void main(String[] args) throws Exception { SQLManager sqlManager = SampleHelper.getSqlManager(); S3PageSample page = new S3PageSample(sqlManager); page.baseRange(); page.page(); page.jdbcPage(); page.resourceSqlPage(); page.resourceGroupSqlPage(); } /** * 范圍查詢 */ public void baseRange(){ List<UserEntity> all = mapper.all(); long count = mapper.allCount(); UserEntity template = new UserEntity(); template.setDepartmentId(1); UserEntity user1 = mapper.templateOne(template); } /** * 翻頁查詢，使用模板sql */ public void page(){ /** * sql模板語句的page函數能自動把sql模板語句轉為為求總數語句 */ String sql = "select #{page('*')} from user where department_id=#{id}"; PageRequest request = DefaultPageRequest.of(1,10); Map map = new HashMap<>(); map.put("id",1); PageResult pr = sqlManager.executePageQuery(sql,UserEntity.class,map,request); //強制轉化為DefaultPageResult, DefaultPageResult pageResult = (DefaultPageResult)pr; printPageResult(pageResult); } /** * 直接使用jdbc sql */ public void jdbcPage(){ /** * 解析jdbc sql語句，生成求總數語句 */ String sql = "select * from user where department_id=?"; PageRequest request = DefaultPageRequest.of(1,10); SQLReady sqlReady = new SQLReady(sql,new Object[]{1}); PageResult pr = sqlManager.execute(sqlReady,UserEntity.class,request); DefaultPageResult pageResult = (DefaultPageResult)pr; printPageResult(pageResult); } /** * 翻頁查詢通常很復雜，SQL很長，把sql語句放到sql文件里是個好辦法，也是最常用的辦法 */ public void resourceSqlPage(){ PageRequest request = DefaultPageRequest.of(1,10); PageResult pr = mapper.pageQuery(1,request); DefaultPageResult pageResult = (DefaultPageResult)pr; printPageResult(pageResult); } /** * 對分組語句進行翻頁查詢，需要嵌套在子查詢里，比如 * <pre> * select count(1),name from user group by name * </pre> * 如上分組提供給beetlsql的時候，應該編寫成 * <pre> * select #{page()} from ( select count(1),name from user group by name ) a * </pre> * */ public void resourceGroupSqlPage(){ PageRequest request = DefaultPageRequest.of(1,10); PageResult pr = mapper.pageQuery2(1,request); DefaultPageResult pageResult = (DefaultPageResult)pr; printPageResult(pageResult); } public void printPageResult(DefaultPageResult pageResult){ System.out.println(pageResult.getPage()); System.out.println(pageResult.getPageSize()); System.out.println(pageResult.getTotal()); System.out.println(pageResult.getTotalPage()); System.out.println(pageResult.getResult()); } } ```