empdaoimpl.java

来自「这是大唐电信的一个管理系统」· Java 代码 · 共 63 行

package com.tatang.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.tatang.dao.IEmpDao;
import com.tatang.po.TEmployee;
import com.tatang.util.HibernateSessionFactory;

public class EmpDaoImpl implements IEmpDao{

	public List<TEmployee> empList(Integer id) {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		String sql="from TEmployee";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			q.setInteger(0,id);
			List<TEmployee> list = new ArrayList();
			list = q.list();
			tx.commit();
			return list;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return null;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

	public List<TEmployee> empList() {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		String sql="from TEmployee";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			List<TEmployee> list = new ArrayList();
			list = q.list();
			tx.commit();
			return list;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return null;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}
   
}