完整的Mybatis分页解决方案综述.docx

1. /**? 2. ?*?封装分页数据? 3. ?*/?? 4. import?java.util.List;?? 5. import?java.util.Map;?? 6. ?? 7. import?org.codehaus.jackson.map.ObjectMapper;?? 8. import?org.slf4j.Logger;?? 9. import?org.slf4j.LoggerFactory;?? 10. ?? 11. import?mon.base.Joiner;?? 12. import?mon.collect.Lists;?? 13. import?mon.collect.Maps;?? 14. ?? 15. public?class?Page?{?? 16. ?? 17. ??private?static?final?Logger?logger?=?LoggerFactory.getLogger(Page.class);?? 18. ??private?static?ObjectMapper?mapper?=?new?ObjectMapper();?? 19. ?? 20. ??public?static?String?DEFAULT_PAGESIZE?=?10;?? 21. ??private?int?pageNo;??????????//当前页码?? 22. ??private?int?pageSize;????????//每页行数?? 23. ??private?int?totalRecord;??????//总记录数?? 24. ??private?int?totalPage;????????//总页数?? 25. ??private?MapString,?String?params;??//查询条件?? 26. ??private?MapString,?ListString?paramLists;??//数组查询条件?? 27. ??private?String?searchUrl;??????//Url地址?? 28. ??private?String?pageNoDisp;???????//可以显示的页号(分隔符|，总页数变更时更新)?? 29. ?? 30. ??private?Page()?{?? 31. ????pageNo?=?1;?? 32. ????pageSize?=?Integer.valueOf(DEFAULT_PAGESIZE);?? 33. ????totalRecord?=?0;?? 34. ????totalPage?=?0;?? 35. ????params?=?Maps.newHashMap();?? 36. ????paramLists?=?Maps.newHashMap();?? 37. ????searchUrl?=?;?? 38. ????pageNoDisp?=?;?? 39. ??}?? 40. ????? 41. ??public?static?Page?newBuilder(int?pageNo,?int?pageSize,?String?url){?? 42. ????Page?page?=?new?Page();?? 43. ????page.setPageNo(pageNo);?? 44. ????page.setPageSize(pageSize);?? 45. ????page.setSearchUrl(url);?? 46. ????return?page;?? 47. ??}?? 48. ???? 49. ??/**? 50. ???*?查询条件转JSON? 51. ???*/?? 52. ??public?String?getParaJson(){?? 53. ????MapString,?Object?map?=?Maps.newHashMap();?? 54. ????for?(String?key?:?params.keySet()){?? 55. ??????if?(?params.get(key)?!=?null??){?? 56. ????????map.put(key,?params.get(key));?? 57. ??????}?? 58. ????}?? 59. ????String?json=;?? 60. ????try?{?? 61. ??????json?=?mapper.writeValueAsString(map);?? 62. ????}?catch?(Exception?e)?{?? 63. ??????logger.error(转换JSON失败,?params,?e);?? 64. ???