empchangedaoimpl.java

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

package com.dao.impl;

import java.sql.Date;
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.EmpChangeDAO;
import com.entity.EmpChange;
import com.hibernate.HibernateSessionFactory;

public class EmpChangeDAOImpl implements EmpChangeDAO {

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

	public boolean delEmpChange(int changeId) {
		EmpChange empChange = null;
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			
			empChange = queryEmpChangeByChangeId(changeId);
				
			session.delete(empChange);
			
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

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

	public EmpChange queryEmpChangeByChangeId(int changeId) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		EmpChange empChange = null;
		try {
			empChange = (EmpChange) session.get(EmpChange.class, changeId);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return empChange;
	}

	public EmpChange queryEmpChangeByEmpId(int empId) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		EmpChange empChange = null;
		Query query = null;
		List list = null;
		try {
			query = session.createQuery("from EmpChange e where e.empId="+empId+"");
			list = query.list();
			empChange = (EmpChange)list.get(1);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return empChange;
	}

	public boolean updateEmpChange(EmpChange empChange) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			session.update(empChange);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}	
		return state;
	}
	
	public List queryEmpChangeAll(String changeType,String empName,Date changeTime){
		
		Session session = HibernateSessionFactory.openHibernateSession();
		Query query = null;
		List list = null;
		try {
			query = session.createQuery("from EmpChange e where e.changeType="+changeType+"and e.empName="+empName+"and e. changeTime="+changeTime+"");
			list = query.list();
		} catch (HibernateException e) {
			e.printStackTrace();
		}

			
		
		return list;
	}

}