empdao.java

来自「用JSP做界面」· Java 代码 · 共 67 行

package dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import domain.Emp;

public class EmpDao {
	public static List findAllEmp() {
		Session session = HibernateSessionFactory.openSession();
		Query query = session.createQuery("from Emp");
		List list = query.list();
		session.close();  
		return list;
	}

	public void addEmp(Emp emp) {
		Session session = HibernateSessionFactory.openSession();
		Transaction ts = session.beginTransaction();
		session.save(emp);
		ts.commit();
		session.close();

	}

	public List findAllEmp(int i, int j) {
		Session session = HibernateSessionFactory.openSession();
		Query query = session.createQuery("from Emp");
		query.setFirstResult((j - 1) * i);
		query.setMaxResults(i);
		List list = query.list();
		session.close();
		return list;
	}

	public void deleteEmp(String id) {
	/*	Session session = HibernateSessionFactory.openSession();
		Transaction ts = session.beginTransaction();
		session.delete(session.load(Emp.class, id));
		ts.commit();
		session.close();*/
		Session session =HibernateSessionFactory.openSession();
		session.beginTransaction();
		String hql="from Emp where id=?";
		Emp emp=(Emp)session.createQuery(hql).setString(0, id).uniqueResult();
		session.delete(emp);
		session.getTransaction().commit();
		session.close();
	}

	public long getTotalPages(int rowsPerPage) {
		Session session = HibernateSessionFactory.openSession();
		Query query = session.createQuery("select count(*) from Emp");
		 
		long totalRows=(Long) (query.uniqueResult());
		if(totalRows%rowsPerPage==0){
			return totalRows/rowsPerPage;
		}else{
		return totalRows/rowsPerPage+1;
		}
	
		
	}
}