MybatisPlus实现多表联查

销售表：sale_manager。客户表：customer_manager
根据销售ID连接两个表
部分字段：
销售表

客户表

service层

 @Override
    public IPage<CustomerVO> findCustomers(Page page, CustomerManager customerManager) {
        QueryWrapper<CustomerManager> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("c.del_flag",0)
                .like(StringUtil.isNotBlank(customerManager.getCompanyFullname()),"c.company_fullname",customerManager.getCompanyFullname())
                .apply("c.sale_id = s.sale_id")
                .orderByDesc("c.create_time");
        return customerManagerMapper.findCustomer(page,queryWrapper);
    }

1
2
3
4
5
6
7
8
9
10

mapper层

 /**
     * 动态查询
     */
    @Select("SELECT c.customer_id," +
            "c.company_fullname," +
            "s.sale_name," +
            "c.create_time," +
            "c.park_id," +
            "c.del_flag," +
            "c.customer_status" +
            " FROM customer_manager c,sale_manager s" +
            " ${ew.customSqlSegment}")
    IPage<CustomerVO> findCustomer(IPage<CustomerVO> page, @Param("ew")Wrapper wrapper);
1
2
3
4
5
6
7
8
9
10
11
12
13

结果省略。。。。。。。。。。。。。