mybatis分页插件

mybatis分页插件：

　　1，maven包

    
      com.github.pagehelper
      pagehelper
      5.1.2
    

　　springconfig配置文件引入

　　2，controller层

    /**
     * 单表mybatis插件分页方法测试
     * @param request
     * @return
     * @throws Exception
     */
    @RequestMapping("/queryList")
    @ResponseBody
    public PageInfo queryList(HttpServletRequest request) {
        PageInfo pageInfo= new PageInfo<>();
        Notice notice = new Notice();

        String pageNums = request.getParameter("pageNum");//页码
        String pageSizes = request.getParameter("pageSize");//当页显示条数
        Integer pageNum=0;
        Integer pageSize=10;
        if(pageNums != null && !"".equals(pageNums)){
            pageNum = Integer.parseInt(pageNums);
        }
        if(pageSizes != null && !"".equals(pageSizes)){
            pageSize = Integer.parseInt(pageSizes);
        }
        pageInfo = iNoticeService.queryList(notice,pageNum,pageSize);
        return pageInfo;
    }

　　3，、serviceImpl层

    @Override
    @Transactional
    public PageInfo queryList(Notice notice, Integer pageNum, Integer pageSize){

        //利用PageHelper分页查询 注意：这个一定要放查询语句的前一行,否则无法进行分页,因为它对紧随其后第一个sql语句有效
        PageHelper.startPage(pageNum,pageSize);
        List list = noticeMapper.queryList(notice);
        PageInfo pageInfo = new PageInfo(list);
        return pageInfo;
    }

　　4，SQL

<?xml version="1.0" encoding="UTF-8"?>


  
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
  
  
    
    id, isdelete, DATE_FORMAT(createtime,'%Y-%m-%d') as createtime, createUser, projectName, opening_area, construction, plot_ratio,
    total_area, area_of_plot_ratio, assessment, research, source, project_summary, organization, 
    intention, conditions, cooperation, benefit, proportion, deadline, instruction, decision, 
    plot, enterprise, filename, payment, trading_terms, information, complaint, fax, 
    url, weChat_official, address, is_partner, is_guarantee, is_client
  
  
    select
      
      from notice
      where isdelete=0
      <if test="projectName !=null and projectName!=''">
       and projectName like CONCAT('%',CONCAT(#{projectName},'%'))
      if>