mybatis plus 联合查询

在xml中只需要需要写如下的代码即可实现分页：

<select id="selectUserList" parameterType="map" resultType="com.test.mybatisplus.pojo.User">
        SELECT
        <include refid="Base_Column_List" />
        FROM user
        WHERE name LIKE CONCAT("%",#{name},"%")
    </select>

　调用方法

/**
     * 分页插件
     */
    public static void testPageListUser() {
        Page<User> page = new Page<User>(1,10);

        Map<String, Object> condition=new HashMap<String, Object>();
        condition.put("name", "测试");
        //String name="测试";
        List<User> lstUser = userDao.selectUserList(page,condition);
        for(User user:lstUser) {
            System.out.println(user);
        }
    }

感谢此文章作者：https://blog.csdn.net/BtWangZhi/article/details/79098420

贡献一波自己的代码

1、调用：
        Page<CarView> page = new Page<CarView>(current, limit);

        List<CarView> pageList = baseMapper.queryCarPage(page, params);
　　　　page.setRecords(pageList);

　　　　return new PageUtils(page);

或者
//使用 com.github.pagehelper

@Override
public PageUtils queryPage(Map<String, Object> params) {

    int current = Integer.parseInt(params.get("page").toString());
    int size = Integer.parseInt(params.get("limit").toString());
   /* Page<Jt952inforEntity> page = new Page<>(current, size);
    page.setRecords(this.baseMapper.query952InfoList(page,params));
     return new PageUtils(page);
    */
    com.github.pagehelper.PageHelper.startPage(current, size);
    List<Jt952inforEntity> data = this.baseMapper.query952InfoList(params);
    com.github.pagehelper.Page<Jt952inforEntity> pageInfo = (com.github.pagehelper.Page<Jt952inforEntity>) data;

    PageUtils pageUtils = new PageUtils(data, (int) pageInfo.getTotal(), (int) pageInfo.getPageSize(), pageInfo.getPageNum());

    return pageUtils;
}

　2、Dao

/**
     * 查询数据分页
     *
     * @param page
     * @param params
     * @return
     */
    List<CarView> queryCarPage(Page<CarView> page, Map<String, Object> params);

　　
　　//这是使用 com.github.pagehelper xml代码一样的

　　List<CarView> queryCarPage(@Param("params")Map<String, Object> params);

　3、xml 后面自己传递的传输参数配置就可以了

 <!--查询车辆数据分页-->
    <select id="queryCarPage" parameterType="map" resultType="io.sale.modules.sale.entity.dto.CarView">
    SELECT
    sl_car.id,sl_car.customer_id,sl_car.number,sl_car.type,sl_car.frame,sl_car.annual_time,sl_car.service_time,sl_car.driver_name,
    sl_car.owner_phone,sl_car.image,sl_car.ramark,sl_car.dept_id,sl_car.user_id,sl_car.add_time,sl_car.del_flag,sl_car.`change`,sl_car.add_user
    FROM sl_car , sl_sale   where sl_car.del_flag=0 GROUP BY sl_car.id

</select>