package cn.xx.org;
import cn.x.org.domain.Department;
import cn.x.org.mapper.DepartmentMapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import java.util.List;
@Slf4j
@SpringBootTest
@RunWith(SpringRunner.class)
public class 分页查询 {
@Autowired
private DepartmentMapper departmentMapper;
@Test
public void findByPage(){
//根据条件sn like xxx and name like xx 进行分页查询,每页只查4条记录
QueryWrapper<Department> wrapper = new QueryWrapper<>();
wrapper.like("sn","dept").like("name","部门");
Page<Department> page = new Page<>();
page.setSize(4);//每页显示几条数据
page.setCurrent(2);//查询第几页
Page<Department> departmentPage = departmentMapper.selectPage(page, wrapper);//分页查询,携带条件
long total = departmentPage.getTotal();//所查询的总条数
long pages = departmentPage.getPages();//查询出来的总页数
List<Department> records = departmentPage.getRecords();//查询出来的数据集合
log.error("总条数为:"+total+"总页数为:"+pages);
//当前页的集合数据
for (Department d:records) {
log.error(d.toString());
}
}
}
mybatis-plus分页查询
最新推荐文章于 2024-04-19 15:49:21 发布