emprecorddaoimpl.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.EmpRecordDAO;
import com.entity.EmpRecord;
import com.hibernate.HibernateSessionFactory;

public class EmpRecordDAOImpl implements EmpRecordDAO {

	public boolean addEmpRecord(EmpRecord empRecord) {

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

	public boolean delEmpRecord(int recId) {
		
		EmpRecord empRecord = null;
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			
				empRecord = queryEmpRecordByRecId(recId);
				
				session.delete(empRecord);
			
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

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

	public EmpRecord queryEmpRecordByEmpId(int empId) {

		Session session = HibernateSessionFactory.openHibernateSession();
		EmpRecord empRecord = null;
		Query query = null;
		List list = null;
		try {
			query = session.createQuery("from EmpRecord e where e.empId="+empId+"");
			list = query.list();
			empRecord = (EmpRecord)list.get(0);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return empRecord;
	}

	public EmpRecord queryEmpRecordByRecId(int recId) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		EmpRecord empRecord = null;
		try {
			empRecord = (EmpRecord) session.get(EmpRecord.class, recId);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return empRecord;
	}

	public boolean updateEmpRecord(EmpRecord empRecord) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			session.update(empRecord);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}	
		return state;
	}
	

}