viewbean.java

这是一段用struts和hibernate做的单位数据库管理程序

package pp;

import java.util.Collection;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class ViewBean 
{
	private Session jj;
	private List kk,kk1,kk2;
	
	public ViewBean()
	{
		Configuration oo=new Configuration();
		oo.configure();
		SessionFactory  sfy=oo.buildSessionFactory();
		jj=sfy.openSession();		
	}
	public Collection getDepartment()
	{
		try
		{
			Query aa=jj.createQuery("from Department");
			kk=aa.list();
		}catch(Exception e){System.out.print(e);} 
		return kk;
	}
	public Collection getEmployee()
	{
		try
		{
			Query aa=jj.createQuery("from Employee");
			 kk1=aa.list();
		}catch(Exception e){System.out.print(e);} 
		return kk1;
		
	}
	public Collection getQueryemp(String pp)
	{
		try
		{
			Query aa=jj.createQuery("select e,d from Employee e,Department d " +
					"where e.id=? and d.id=e.departmentBean.id");
			aa.setString(0,pp);
			
			kk2=aa.list();
		}catch(Exception e){System.out.print(e);} 
		return kk2;
	}
}