empstorydaoimpl.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.EmpStoryDAO;
import com.entity.EmpStory;
import com.hibernate.HibernateSessionFactory;

public class EmpStoryDAOImpl implements EmpStoryDAO {

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

	public boolean delEmpStory(int empStoryId) {

		EmpStory empStory = null;
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			empStory = (EmpStory) session.get(EmpStory.class, empStoryId);
			System.out.print(empStory.getEmpId());
			session.delete(empStory);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public List queryEmpStory() {

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

	public List queryEmpStoryByEmpId(int empId) {

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

	public boolean updateEmpStory(EmpStory empStory) {

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

	public EmpStory queryEmpStoryByStoId(int stoId) {
		
		Session session = HibernateSessionFactory.openHibernateSession();
		EmpStory empStory = null;
		try {
			empStory = (EmpStory) session.get(EmpStory.class, stoId);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return empStory;
	}

}