Java Page类代码示例

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
/**
 * 循环标签 测试
 */
public static void main(String[] args) {

    // 加载配置文件
    InputStream in = CircularLabelsTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    UserMapper userMapper = session.getMapper(UserMapper.class);
    Page<User> page = new Page<>(1, 6);
    List<User> users = userMapper.forSelect(page, Arrays.asList("1", "2", "3"));
    System.out.println(users.toString());
    System.out.println(page);
    User user = new User();
    user.setId(1L);
    User users1 = userMapper.selectOne(user);
    System.out.println(users1);
    TestMapper mapper = session.getMapper(TestMapper.class);
    Test test = new Test();
    test.setCreateTime(new Date());
    test.setType("11111");
    mapper.insert(test);
    session.rollback();
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public static void main(String[] args) {
     /*
      * 加载配置文件
*/
     InputStream in = NoXMLTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
     MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
     SqlSessionFactory sessionFactory = mf.build(in);
     SqlSession sqlSession = sessionFactory.openSession();
     /**
      * 查询是否有结果
      */
     TestMapper testMapper = sqlSession.getMapper(TestMapper.class);
     testMapper.insert(new Test(IdWorker.getId(), "Caratacus"));
     List<Map<String, Object>> list = testMapper.selectMaps(null);
     List<Map<String, Object>> list1 = testMapper.selectMapsPage(RowBounds.DEFAULT, null);
     List<Map<String, Object>> list2 = testMapper.selectMapsPage(new Page<>(1, 5), null);
     System.out.println(list);
     System.out.println(list1);
     System.out.println(list2);
     testMapper.delete(null);

 }
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public Page<SysUser> query(Map<String, Object> params) {
	Map<String, String> userTypeMap = sysDicService.queryDicByType("USERTYPE");
	Page<SysUser> pageInfo = super.query(params);
	for (SysUser userBean : pageInfo.getRecords()) {
		if (userBean.getUserType() != null) {
			userBean.setUserTypeText(userTypeMap.get(userBean.getUserType()));
		}
		List<String> permissions = sysAuthorizeService.queryUserPermission(userBean.getId());
		for (String permission : permissions) {
			if (StringUtils.isBlank(userBean.getPermission())) {
				userBean.setPermission(permission);
			} else {
				userBean.setPermission(userBean.getPermission() + ";" + permission);
			}
		}
	}
	return pageInfo;
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public Parameter(Object result) {
	if (result instanceof Long) {
		this.id = (Long) result;
	} else if (result instanceof BaseModel) {
		this.model = (BaseModel) result;
	} else if (result instanceof Page) {
		this.page = (Page<?>) result;
	} else if (result instanceof Map<?, ?>) {
		this.map = (Map<?, ?>) result;
	} else if (result instanceof List<?>) {
		this.list = (List<?>) result;
	} else if (result instanceof Object[]) {
		this.param = (Object[]) result;
	} else {
		this.result = result;
	}
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public Page<SysEvent> query(Map<String, Object> params) {
	Page<SysEvent> page = super.query(params);
	for (SysEvent sysEvent : page.getRecords()) {
		if (sysEvent != null) {
			Long createBy = sysEvent.getCreateBy();
			if (createBy != null) {
				SysUser sysUser = sysUserService.queryById(createBy);
				if (sysUser != null) {
					sysEvent.setUserName(sysUser.getUserName());
				} else {
					sysEvent.setUserName(createBy.toString());
				}
			}
		}
	}
	return page;
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public Page<SysRole> query(Map<String, Object> params) {
	Page<SysRole> pageInfo = super.query(params);
	// 权限信息
	for (SysRole bean : pageInfo.getRecords()) {
		if (bean.getDeptId() != null) {
			SysDept sysDept = sysDeptService.queryById(bean.getDeptId());
			if (sysDept != null) {
				bean.setDeptName(sysDept.getDeptName());
			}
		}
		List<String> permissions = sysAuthorizeService.queryRolePermission(bean.getId());
		for (String permission : permissions) {
			if (StringUtils.isBlank(bean.getPermission())) {
				bean.setPermission(permission);
			} else {
				bean.setPermission(bean.getPermission() + ";" + permission);
			}
		}
	}
	return pageInfo;
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
/**
 * 初始化文章列表
 *
 * @param pages  分页对象
 * @param typeId 搜索条件 分类id
 * @param tagIds 搜索条件 tag集合
 * @param title  搜索条件 文章标题
 * @param model
 * @return
 */

@RequestMapping("/list")
public String selectPage(Page pages, String typeId, String tagIds, String title, Model model) {
    //封装查询条件
    Map<String, Object> param = new HashMap<>();
    if (tagIds != null && !"".equals(tagIds)) {
        param.put("tags", tagIds.split(","));
    } else {
        param.put("tags", null);
    }
    param.put("typeId", typeId);
    param.put("title", title);
    //获取文章列表
    Page<Article> page;
    page = iArticleService.selectArticlePage(pages, param);

    model.addAttribute("page", page);

    return "admin/article/articleTable";
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
/**
 * 加载分页列表数据
 *
 * @param model
 * @return
 */
@RequestMapping("/article/list")
public String selectArticleList(Page pages, Model model) {
    Page<ArticleVo> page;
    page = iArticleService.selectArticleList(new Page(pages.getCurrent(), 5));
    model.addAttribute("page", page);

    return "blog/main";
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public Page<SysRole> query(Map<String, Object> params) {
	Page<SysRole> pageInfo = super.query(params);
	// 权限信息
	for (SysRole bean : pageInfo.getRecords()) {
		if (bean.getDeptId() != null) {
			SysDept sysDept = sysDeptService.queryById(bean.getDeptId());
			bean.setDeptName(sysDept.getDeptName());
		}
		List<String> permissions = sysRoleMenuMapper.queryPermission(bean.getId());
		for (String permission : permissions) {
			if (StringUtils.isBlank(bean.getPermission())) {
				bean.setPermission(permission);
			} else {
				bean.setPermission(bean.getPermission() + ";" + permission);
			}
		}
	}
	return pageInfo;
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
public Page<SysUser> query(Map<String, Object> params) {
	Map<String, String> userTypeMap = sysDicService.queryDicByType("USERTYPE");
	Page<SysUser> pageInfo = super.query(params);
	for (SysUser userBean : pageInfo.getRecords()) {
		if (userBean.getUserType() != null) {
			userBean.setUserTypeText(userTypeMap.get(userBean.getUserType().toString()));
		}
		if (userBean.getDeptId() != null) {
			userBean.setDeptName(sysDeptService.queryById(userBean.getDeptId()).getDeptName());
		}
		List<String> permissions = sysUserMenuMapper.queryPermission(userBean.getId());
		for (String permission : permissions) {
			if (StringUtils.isBlank(userBean.getPermission())) {
				userBean.setPermission(permission);
			} else {
				userBean.setPermission(userBean.getPermission() + ";" + permission);
			}
		}
	}
	return pageInfo;
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
/** 分页查询 */
public static Page<Long> getPage(Map<String, Object> params) {
	Integer current = 1;
	Integer size = 10;
	String orderBy = "id_";
	if (DataUtil.isNotEmpty(params.get("pageNum"))) {
		current = Integer.valueOf(params.get("pageNum").toString());
	}
	if (DataUtil.isNotEmpty(params.get("pageSize"))) {
		size = Integer.valueOf(params.get("pageSize").toString());
	}
	if (DataUtil.isNotEmpty(params.get("orderBy"))) {
		orderBy = (String) params.get("orderBy");
	}
	if (size == -1) {
		return new Page<Long>();
	}
	Page<Long> page = new Page<Long>(current, size, orderBy);
	page.setAsc(false);
	return page;
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
/**
 * 填充Wrapper
 *
 * @param page
 * @param wrapper
 */
public static void fillWrapper(Page<?> page, Wrapper wrapper) {
    if (null == page) {
        return;
    }
    if (isNotEmptyOfWrapper(wrapper)) {
        if (page.isOpenSort()) {
            wrapper.orderBy(page.getOrderByField() + (page.isAsc() ? " ASC " : " DESC "));
        }
    }
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
@Test
public void pageSimpleTest() {
    // 最基础分页
    Page<PageUser> page1 = new Page<>(current, size);
    Page<PageUser> result1 = pageUserService.selectPage(page1);
    Assert.assertTrue(!result1.getRecords().isEmpty());

}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
@Test
public void pageOrderByTest() {
    // 带OrderBy
    Page<PageUser> page2 = new Page<>(current, size);
    Page<PageUser> result2 = pageUserService.selectPage(page2);
    Assert.assertTrue(!result2.getRecords().isEmpty());
    // 没有orderby但是设置了倒叙
    Page<PageUser> page3 = new Page<>(current, size);
    Page<PageUser> result3 = pageUserService.selectPage(page3);
    Assert.assertTrue(!result3.getRecords().isEmpty());
    // 有orderby设置了倒叙
    Page<PageUser> page4 = new Page<>(current, size);
    Page<PageUser> result4 = pageUserService.selectPage(page4);
    Assert.assertTrue(!result4.getRecords().isEmpty());
}
 

import com.baomidou.mybatisplus.plugins.Page; //导入依赖的package包/类
@Test
public void pageCountTest() {
    // 设置不count
    Page<PageUser> page = new Page<>(current, size);
    page.setSearchCount(false);
    Page<PageUser> result = pageUserService.selectPage(page);
    Assert.assertTrue(result.getTotal() == 0);
}