SSH使用QBC查询时无法将查处的集合存入实体集合中，而是返回Object[]

最新推荐文章于 2020-09-02 10:53:09 发布

lex_001

最新推荐文章于 2020-09-02 10:53:09 发布

阅读量381

点赞数

分类专栏： ssh

本文链接：https://blog.csdn.net/lex_001/article/details/70477335

版权

ssh 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

public PaginationSupport<SysUser> findForPage_Users(Integer roleId,
			String userName, int pageNo, int pageSize) {
		PaginationSupport<SysUser> page=new PaginationSupport<SysUser>();
		DetachedCriteria criteria = DetachedCriteria.forClass(SysUser.class);
		if(pageNo>0){
			page.setCurrPageNo(pageNo);
		}
		if(pageSize>0){
			page.setPageSize(pageSize);
		}
		if(roleId!=null){
			criteria.add(Restrictions.eq("sysRole.roleId", roleId));
		}
		if(userName!=null&&userName.length()>0){
			criteria.add(Restrictions.like("userName","%"+userName+"%"));
		}
		criteria.setProjection(Property.forName("userId").count());
		System.out.println(criteria);
		int totalCount=userDao.getTotalCount(criteria).intValue();
		page.setTotalCount(totalCount);
		criteria.setProjection(null);
		criteria.setResultTransformer(Criteria.ROOT_ENTITY);//解决同时查出两张表的数据无法保存对应的实体中
		List<SysUser> items=userDao.findForPage(criteria, page.getCurrPageNo(),
				page.getPageSize());
		page.setItems(items);
		return page;
	}

可参考http://blog.csdn.net/flyingfalcon/article/details/8517928