HQL (四) 原生sql查询

hibernate也支持直接sql进行查询
参见：SqlQueryTest.java

package com.bjsxt.hibernate;

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

import org.hibernate.Session;

import junit.framework.TestCase;

/**
 * 原生sql查询
 * @author Administrator
 *
 */
public class SqlQueryTest extends TestCase {

	public void testQuery1() {
		Session session = null;
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			//session.createSQLQuery（"sql语句"），sql语句可以是特定数据库的sql语句
			List students = session.createSQLQuery("select * from t_student").list();
			for (Iterator iter =students.iterator(); iter.hasNext();) {
				Object[] o = (Object[])iter.next();
				System.out.println(o[0] + ", " + o[1]);
			}
			session.getTransaction().commit();
		}catch(Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}	

}