Pom.xml    　　　　
                
     
      com.baomidou
                 
     
      mybatis-plus-boot-starter
                 
     
      3.0.7.1
             
    

//Spring boot方式  @EnableTransactionManagement@Configuration@MapperScan("com.baomidou.cloud.service.*.mapper*")public class MybatisPlusConfig {    /**     * 分页插件     */    @Bean    public PaginationInterceptor paginationInterceptor() {        return new PaginationInterceptor();    }}

@ResponseBody@GetMapping("/artList")   public Map
    
     articleList(int page,int limit,Article article){    Page
     
       pageArt=new Page
      
       (page,limit);    Page
       
         page1 = articleMapper.findAllAndPage(pageArt); //自定义方法，多表//    QueryWrapper
        
          diseaseQueryWrapperw = new QueryWrapper
         
          (article); // IPage
          
            page1 = articleService.page(pageArt,diseaseQueryWrapperw); //自带的分页查询。只能单表// List
           
             list = articleService.list(); int total = (int)page1.getTotal(); return TableMap.ResultJson(0,total,"ok",page1.getRecords()); //layui table 解析返回格式}
           
          
         
        
       
      
     
    

mapper  Xml          SELECT a.id,a.title,a.uid,a.isDel,a.createTime,a.type,ae.`name` FROM article a JOIN article_enum ae ON a.type=ae.id    

mapper接口

public interface ArticleMapper extends BaseMapper
    
      {     Page
     
       findAllAndPage( Page
      
        page); }