empinfodaoimpl.java

用jsp,servlet实现人力资源管理系统

package com.dao.impl;

import java.util.List;

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



import com.dao.EmpInfoDAO;
import com.entity.EmpInfo;

import com.hibernate.HibernateSessionFactory;

public class EmpInfoDAOImpl implements EmpInfoDAO {

	public boolean addEmpInfo(EmpInfo empInfo) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			session.save(empInfo);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public boolean delEmpInfo(int empId) {

		EmpInfo empInfo = null;
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			empInfo = queryEmpInfoByEmpId(empId);
			System.out.print(empInfo.getEmpId());
			session.delete(empInfo);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public List queryEmpInfo() {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		Query query = null;
		List result = null;
		try {
			query = session.createQuery("from EmpInfo");
			result = query.list();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return result;
	}

	public EmpInfo queryEmpInfoByEmpId(int empId) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		EmpInfo empInfo = null;
		try {
			empInfo = (EmpInfo) session.get(EmpInfo.class, empId);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return empInfo;
	}

	public boolean updateEmpInfo(EmpInfo empInfo) {

		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			session.update(empInfo);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}	
		return state;
	}
	
	public int queryEmpIdByEmpName(String empName){
		Session session = HibernateSessionFactory.openHibernateSession();
		EmpInfo empInfo = null;
		Query query = null;
		List list = null;
		int empId = 0;
		try {
			query = session.createQuery("from EmpInfo e where e.empName='"+empName+"'");
			list = query.list();
			empInfo = (EmpInfo)list.get(0);
		    empId = empInfo.getEmpId();
		} catch (HibernateException e) {

			e.printStackTrace();
		}
		
		
		return empId;
		
	}

}