package xing.five.daos;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import xing.five.beans.BaseHibernateDAO;
import xing.five.beans.HibernateSessionFactory;

import xing.five.beans.ProjectInf;

public class ProjectDAO extends BaseHibernateDAO {

	 public void addproject(ProjectInf p)
		{
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			session.save(p);
			tx.commit();
			session.close();
		}
	 public void delproject(ProjectInf p)
		{
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			session.delete(p);
			tx.commit();
			session.close();
		}
		public List query()
		{
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			String hql="from xing.five.beans.ProjectInf";
			Query q=session.createQuery(hql);
			tx.commit();
			List l=q.list();
			//Iterator iter=l.iterator();
			//Iterator iter=l.iterator();
			return l;
		}
		public ProjectInf findbyid(Integer id)
		{
			Session session=HibernateSessionFactory.getSession();
			String hql="from xing.five.beans.ProjectInf where id=?";
			Query q=session.createQuery(hql);
			q.setParameter(0,id);
			ProjectInf p=(ProjectInf) q.list().get(0);
			return p;
		}
	 
		public List querybynameorid(String name,String type)
		{
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			String hql="from xing.five.beans.ProjectInf where name=? or type=?";
			Query q=session.createQuery(hql);
			q.setParameter(0, name);
			q.setParameter(1, type);
			tx.commit();
			List l=q.list();
			//Iterator iter=l.iterator();
			//Iterator iter=l.iterator();
			return l;
		}
}