Hibernate返回vo对象集合

佚名 7年前 (2019-04-11) 随笔 1381人围观抢沙发百度已收录

	@SuppressWarnings("unchecked")
	private Page<List<RepairHeader>> findPage (int pageIndex, int pageSize, String findPageSQLStr){
		Pageable pageable = new Pageable();
		SQLQuery q = factory.getCurrentSession().createSQLQuery(findPageSQLStr);
		
		//查询结果集总条数
		String sqlCount = "SELECT COUNT(*) FROM ( " + findPageSQLStr + " ) temp";
		Long total = ((Integer) factory.getCurrentSession().createSQLQuery(sqlCount).uniqueResult()).longValue();
		int totalPages = (int) Math.ceil((double)total / (double)pageSize);//总页码
		if (totalPages < pageIndex) {
			pageable.setPageNumber(totalPages);
		}
		q.setFirstResult(1 + (pageIndex - 1) * pageSize);
		q.setMaxResults(pageSize);
		pageable.getPageSize());
		q.setMaxResults(pageable.getPageSize());*/
		// return new Page(q.list(), total, pageable);
		return new Page(q.setResultTransformer(Transformers.aliasToBean(RepairHeader.class)).list(), total, pageable);
	}