reseacherdao.java

来自「struts」· Java 代码 · 共 80 行

package com.wiely.dao.impl;

import java.util.List;

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

import com.wiely.commons.BaseDAO;
import com.wiely.vo.Reseacher;

public class ReseacherDAO extends BaseDAO implements com.wiely.dao.ReseacherDAO {

	public boolean delReseacher(int rid) {
		try {
			Session session = getSession();
			Transaction tx = session.beginTransaction();
			Reseacher reseacher = (Reseacher) session.get(Reseacher.class,
					new Integer(rid));
			session.delete(reseacher);
			tx.commit();
			session.close();
			return true;
		} catch (HibernateException e) {
			e.printStackTrace();
			return false;
		}
	}

	@SuppressWarnings("unchecked")
	public int getTotalSize() {
		Session session=getSession();
		String sql="from Reseacher r";
		Query query=session.createQuery(sql);
		List list=query.list();
		int i=list.size();
		session.close();
		return i;
	}

	@SuppressWarnings("unchecked")
	public List getReseacher(int currentPage, int pageSize) {
		try {
			Session session = getSession();
			String sql = "from Reseacher r";
			Query query = session.createQuery(sql);
			int startRows = (currentPage - 1) * pageSize;
			query.setFirstResult(startRows);
			query.setMaxResults(pageSize);
			List list = query.list();
			session.close();
			return list;
		} catch (HibernateException e) {
			e.printStackTrace();
			return null;
		}
	}

	public boolean saveResearcher(Reseacher reseacher) {
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.save(reseacher);
		tx.commit();
		session.close();
		return true;

	}

	public boolean updateReseacher(Reseacher reseacher) {
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.update(reseacher);
		tx.commit();
		session.close();
		return true;
	}

}