通用List查询

package com.demo.hibernate.service;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Session;

import com.demo.hibernate.utils.HibernateSessionFactory;

public class Main {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		Session session = HibernateSessionFactory.getSession();
		List list = session.createSQLQuery(
				"SELECT T_CARD.CARD_NUM,SUM(T_CARD_EXPENSE.MONEY) "
						+ "FROM T_CARD_EXPENSE,T_CARD "
						+ "WHERE T_CARD_EXPENSE.CARD_ID=T_CARD.ID "
						+ "AND TO_CHAR(T_CARD_EXPENSE.CREATE_DT, 'yymmdd') BETWEEN '120701' AND '120707' "
						+ "GROUP BY T_CARD.CARD_NUM "
						+ "ORDER BY SUM(T_CARD_EXPENSE.MONEY) DESC")
				.setMaxResults(10).list();
		session.close();

		for (Iterator iter = list.iterator(); iter.hasNext();) {

			Object[] object = (Object[]) iter.next();
			System.out.println(object[0] + "    " + object[1]);
		}
	}
}

//通用List查询
	@Override
	public List QueryForGeneralEntity(String hql, int currentRecordIndex,
			int resultMaxSize) {
		// TODO Auto-generated method stub
		List list=new ArrayList();
		Session session=HibernateSessionFactory.getSession();
		Query query=session.createQuery(hql);
		query.setFirstResult(currentRecordIndex);
		query.setMaxResults(resultMaxSize);
		list=query.list();
		session.close();
		return list;
	}