employeeinfodao.java

这是一个物流管理系统

package dao;

import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import bean.Employeeinfo;
import bean.Dutyinfo;
import util.HibernateSessionFactory;

public class EmployeeinfoDAO {
	Session s = null;
	Transaction tr = null;

	public boolean addEmployee(Employeeinfo emp) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		tr.begin();
		s.save(emp);
		tr.commit();
		return true;
	}

	public List<Employeeinfo> allEmp() {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp";
		Query q = s.createQuery(hql);
		List<Employeeinfo> sps = q.list();
		tr.commit();
		return sps;
	}

	public boolean checkById(long id) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp where emp.employeeid=" + id;
		if (s.createQuery(hql).list().size() != 0) {
			return true;
		}
		return false;
	}

	public boolean checkByName(String name) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp where emp.employeename='" + name
				+ "'";
		if (s.createQuery(hql).list().size() != 0) {
			return true;
		}
		return false;
	}

	public boolean checkByIdName(long id, String name) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp where emp.employeeid=" + id
				+ "and emp.employeename='" + name + "'";
		if (s.createQuery(hql).list().size() != 0) {
			return true;
		}
		return false;
	}

	public List<Employeeinfo> selectById(long id) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp where emp.employeeid=" + id;
		Query q = s.createQuery(hql);
		List<Employeeinfo> sps = q.list();
		tr.commit();
		return sps;
	}

	public List<Employeeinfo> selectByName(String name) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp where emp.employeename='" + name
				+ "'";
		Query q = s.createQuery(hql);
		List<Employeeinfo> sps = q.list();
		tr.commit();
		return sps;
	}

	public List<Employeeinfo> search(long id, String name) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		String hql = "from Employeeinfo emp where emp.employeeid=" + id
				+ "and emp.employeename='" + name + "'";
		Query q = s.createQuery(hql);
		List<Employeeinfo> sps = q.list();
		tr.commit();
		return sps;
	}

	public void updateEmp(long id, Employeeinfo e) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		/*
		 * String hql="update Employeeinfo emp set emp.employeename=
		 * :newname,emp.employeepass= :newpass," +"emp.Dutyinfo.dutyid=
		 * :newdutyid where emp.employeeid="+id;
		 */
		Employeeinfo emp = (Employeeinfo) s.get("bean.Employeeinfo", id);
		System.out.println(s.toString());
		emp.setDutyinfo(e.getDutyinfo());
		emp.setEmployeename(e.getEmployeename());
		emp.setEmployeepass(e.getEmployeepass());
		s.update(emp);
		/*
		 * Query q=s.createQuery(hql); q.setString("newname",
		 * e.getEmployeename()); q.setString("newpass", e.getEmployeepass());
		 * q.setLong("newdutyid", e.getDutyinfo().getDutyid()); int
		 * index=q.executeUpdate();
		 */
		tr.commit();
	}

	public void delEmp(long id) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();

		String hql = "delete from Employeeinfo emp where emp.employeeid=" + id;
		s.createQuery(hql).executeUpdate();
		tr.commit();
	}

	public boolean checkEmployee(String employeename) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		tr.begin();

		List li = s.createQuery(
				"from Employeeinfo e where e.employeename = :employeename")
				.setString("employeename", employeename).list();
		if (li.size() == 1) {
			return true;
		}
		return false;
	}

	public Employeeinfo quaryByEmployeeid(String employeename) {
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		tr.begin();
		Employeeinfo emp = new Employeeinfo();
		List li = s.createQuery(
				"from Employeeinfo e where e.employeename = :employeename")
				.setString("employeename", employeename).list();
		for (Iterator pit = li.iterator(); pit.hasNext();) {
			emp = (Employeeinfo) pit.next();
		}
		tr.commit();
		//		session.close();
		return emp;
	}
}