conditionquerytest.java

实现一些hibernate底层的东西

package com.bjsxt.hibernate;


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

import junit.framework.TestCase;

import org.hibernate.Session;


public class ConditionQueryTest extends TestCase {

	public void testQuery1()
	{
		Session session = null;
		try{
			session = HibernateUtils.getSession();
			session.beginTransaction();

			//条件查询，用like关键字
			List students = session.createQuery( "select id, name from Student where name like '%1%'" ).list();
			for( Iterator ite = students.iterator() ; ite.hasNext() ; ){
				Object[] student = ( Object[] )ite.next();
				System.out.println( student[0] + "," + student[1] );
			}
			
			session.getTransaction().commit();
			
		}catch( Exception e ){
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally{
			HibernateUtils.closeSession(session);
		}
	}
	
	public void testQuery2()
	{
		Session session = null;
		try{
			session = HibernateUtils.getSession();
			session.beginTransaction();

			//条件查询，用like关键字
			List students = session.createQuery( "select s.id, s.name from Student as s where s.id in (:myids) ")
									.setParameterList( "myids" , new Object[]{ 1 , 2 , 3, 4 })
									.list();
			for( Iterator ite = students.iterator() ; ite.hasNext() ; ){
				Object[] student = ( Object[] )ite.next();
				System.out.println( student[0] + "," + student[1] );
			}
			
			session.getTransaction().commit();
			
		}catch( Exception e ){
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally{
			HibernateUtils.closeSession(session);
		}
	}
}