1 packagecom.cjs.example.service.impl;2
3 importcom.cjs.example.dao.CouponMapper;4 importcom.cjs.example.model.Coupon;5 importcom.cjs.example.model.CouponExample;6 importcom.cjs.example.service.CouponService;7 importcom.github.pagehelper.Page;8 importcom.github.pagehelper.PageHelper;9 importcom.github.pagehelper.PageInfo;10 importcom.github.pagehelper.PageRowBounds;11 importorg.springframework.beans.factory.annotation.Autowired;12 importorg.springframework.stereotype.Service;13
14 importjava.util.List;15
16
19 @Service20 public class CouponServiceImpl implementsCouponService {21
22 @Autowired23 privateCouponMapper couponMapper;24
25
28 @Override29 public ListgetCouponListByPage(CouponExample couponExample, Integer pageNum, Integer pageSize) {30 //在你需要進行分頁的 MyBatis 查詢方法前調用 PageHelper.startPage 靜态方法即可，緊跟在這個方法後的第一個MyBatis 查詢方法會被進行分頁。31 //隻要你可以保證在 PageHelper 方法調用後緊跟 MyBatis 查詢方法，這就是安全的
32 PageHelper.startPage(pageNum, pageSize);33 returncouponMapper.selectByExample(couponExample);34 }35
36
40 @Override41 public PagegetCouponListByPage1(CouponExample couponExample, Integer pageNum, Integer pageSize) {42 PageHelper.startPage(pageNum, pageSize);43 List list =couponMapper.selectByExample(couponExample);44 if (null !=list) {45 Page page = (Page) list;46 System.out.println(page);47 returnpage;48 }49 return null;50 }51
52
55 @Override56 public ListgetCouponListByPage2(CouponExample couponExample, Integer pageNum, Integer pageSize) {57 PageRowBounds pageRowBounds = newPageRowBounds(pageNum, pageSize);58 List couponList =couponMapper.selectByExample(couponExample, pageRowBounds);59
60 System.out.println(pageRowBounds.getTotal());61
62 Page page = (Page) couponList;63 System.out.println(page);64
65 returncouponList;66 }67
68 @Override69 public PagegetCouponListByPage3(CouponExample couponExample, Integer pageNum, Integer pageSize) {70 Page page = PageHelper.startPage(pageNum, pageSize).doSelectPage(()->couponMapper.selectByExample(couponExample));71 System.out.println(page);72 returnpage;73 }74
75
78 @Override79 public PageInfogetCouponListByPage4(CouponExample couponExample, Integer pageNum, Integer pageSize) {80 PageInfo pageInfo = PageHelper.startPage(pageNum, pageSize).doSelectPageInfo(()->couponMapper.selectByExample(couponExample));81 System.out.println(pageInfo);82 returnpageInfo;83 }84
85
88 @Override89 public PageInfogetCouponListByPage5(CouponExample couponExample, Integer pageNum, Integer pageSize) {90 List list =couponMapper.selectByExample(couponExample);91 if (null ==list) {92 return null;93 }94 PageInfo pageInfo = new PageInfo<>(list);95 System.out.println(pageInfo);96 returnpageInfo;97 }98
99 @Override100 public PagegetCouponListByPage6(CouponExample couponExample, Integer offset, Integer limit) {101 return (Page) couponMapper.selectByExample(couponExample, newPageRowBounds(offset, limit));102 }103 }