JAVA代码

  1. package com.tj.qywx.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  5. import com.tj.qywx.domain.WxBillList;
  6. import com.tj.qywx.service.WxBillListService;
  7. import com.tj.qywx.mapper.WxBillListMapper;
  8. import com.tj.utils.R;
  9. import lombok.extern.slf4j.Slf4j;
  10. import org.apache.commons.lang3.StringUtils;
  11. import org.springframework.stereotype.Service;
  12. import java.util.List;
  13. /**
  14. *
  15. */
  16. @Slf4j
  17. @Service
  18. public class WxBillListServiceImpl extends ServiceImpl<WxBillListMapper, WxBillList>
  19. implements WxBillListService{
  20. @Override
  21. public R show(Integer pagenum, Integer pagesize, WxBillList wxBillList) {
  22. //构造条件构造器
  23. LambdaQueryWrapper<WxBillList> lqw = new LambdaQueryWrapper();
  24. //添加过滤条件
  25. lqw.like(StringUtils.isNotEmpty(wxBillList.getPayeeName()), WxBillList::getPayeeName, wxBillList.getPayeeName());
  26. //判断是否有分页
  27. if (pagenum != null || pagesize != null) {
  28. //构造分页构造器,
  29. Page page = new Page(pagenum, pagesize);
  30. //执行查询
  31. page(page, lqw);
  32. //如果查询后的pagenum(当前页码)>(实际的总页码),
  33. if (pagenum > page.getPages()) {
  34. log.info("当前页码>总的页码");
  35. //那么当前页码就等于总页码,然后重新查询
  36. page = new Page(page.getPages(), pagesize);
  37. //执行查询
  38. page(page, lqw);
  39. }
  40. log.info("查询到的page数据:{}", page.toString());
  41. if (page.getTotal() > 0) {
  42. return R.success(page);
  43. } else {
  44. return R.error("未查询到数据");
  45. }
  46. }
  47. //2,不分页的查询,返回list
  48. List<WxBillList> list = list(lqw);
  49. log.info("查询到的list数据:{}", list.toString());
  50. if (list != null) {
  51. return R.success(list);
  52. }
  53. return R.error("未查询到数据");
  54. }
  55. }