sqlquerytest.java

来自「实现一些hibernate底层的东西」· Java 代码 · 共 34 行

package com.bjsxt.hibernate;

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

import org.hibernate.Session;

import junit.framework.TestCase;

public class SqlQueryTest extends TestCase {
	public void testQuery2()
	{
		Session session = null;
		try{
			session = HibernateUtils.getSession();
			session.beginTransaction();

			List students = session.createSQLQuery( "select * from t_student" ).list();
			for( Iterator ite = students.iterator() ; ite.hasNext() ; ){
				Object[] object = ( Object[] )ite.next();
				System.out.println( "id=" + object[ 0 ] + " , classid=" + object[ 3 ] );
			}
			
			session.getTransaction().commit();
			
		}catch( Exception e ){
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally{
			HibernateUtils.closeSession(session);
		}
	}
}