mybatis plus当月数据查询_mybatis plus 联合查询

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

SELECT

FROM user

WHERE name LIKE CONCAT("%",#{name},"%")

调用方法

/**

* 分页插件*/

public static voidtestPageListUser() {

Page page = new Page(1,10);

Map condition=new HashMap();

condition.put("name", "测试");//String name="测试";

List lstUser =userDao.selectUserList(page,condition);for(User user:lstUser) {

System.out.println(user);

}

}

贡献一波自己的代码

1、调用：

Page page = new Page(current, limit);

List pageList = baseMapper.queryCarPage(page, params);

page.setRecords(pageList);

return new PageUtils(page);

2、Dao

/**

* 查询数据分页

*

* @param page

* @param params

* @return

*/

List queryCarPage(Page page, Map params);

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

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_salewhere sl_car.del_flag=0GROUP BY sl_car.id