hqlbusinesstest.java

本代码是在eclipse下开发hibernate的典型实例

package com.jgao.hql.test.business.others;

import java.util.Iterator;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;

import com.jgao.hql.test.modulebean.Gaodb;

/**
 *和course相关的业务逻辑
 */
public class HqlBusinessTest extends HibernateBase{
    
	public HqlBusinessTest()throws HibernateException
	{
		super();
	}
	/**
	 *增加一个Course
	 */
	public void addCourse(Gaodb st)throws HibernateException
	{
		beginTransaction();
         session.save(st);         
         endTransaction(true);
    }
    
    /**
     *查询系统中所有的Course，返回的是包含有Course持久对象的Iterator。
     */
    public Iterator getAllCourses()throws HibernateException
    {
     	String queryString = "select courses from Course as courses";
        beginTransaction();
        Query query = session.createQuery(queryString);
        Iterator it= query.iterate();
        return it;
    }
    
    /**
     *删除给定ID的course
     */
    public void deleteCourse(String id)throws HibernateException
    {
     	beginTransaction();    	
     	Gaodb course=(Gaodb)session.load(Gaodb.class,id);    	
     	session.delete(course);
     	endTransaction(true);
     }
    
    /**
     *按course的名字进行模糊查找，返回的是包含有Course持久对象的Iterator。
     */
    public Iterator getSomeCourse(String name)throws HibernateException
    {
      	String queryString = "select usersid,usersname,userspassword from GAODB where gaodb.usersid = 1" ;
        beginTransaction();
        Query query = session.createQuery(queryString);
        //query.setString("name", name);
        Iterator it= query.iterate();
        return it;
    }    	
}