pagedao.java

在线考试系统: 这是基于struts和Hibernate的最新技术的在线考试系统.数据库是MySql.能添加课程

/**
 * 
 */
package com.zjxy.hibernate.base;

/**
 * @author gradenarn
 *
 */
import java.util.*;

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

import com.zjxy.hibernate.HibernateSessionFactory;
import com.zjxy.hibernate.model.TitleSystem;

public class PageDAO {

  public List findWithPage(int pageSize, int startRow, String sqlBean) throws
      HibernateException {
    List list = null;
    Transaction tx = null;
    try {
      Session session = HibernateSessionFactory.currentSession();
      tx = session.beginTransaction();
      Query q = session.createQuery(sqlBean);
      q.setFirstResult(startRow);
      q.setMaxResults(pageSize);
      list = q.list();
      tx.commit();

    } catch (HibernateException he) {
      if (tx != null) {
        tx.rollback();
      }
      throw he;
    } finally {
    	HibernateSessionFactory.closeSession();
    }
    return list;
  }

  public List findWithPage_search(int pageSize, int startRow, String sqlBean, String para) throws
      HibernateException {
      List list = null;
      Transaction tx = null;
      try {
      Session session = HibernateSessionFactory.currentSession();
      tx = session.beginTransaction();
      Query q = session.createQuery(sqlBean);
      q.setString(0, para);
      q.setFirstResult(startRow);
      q.setMaxResults(pageSize);
      list = q.list();
      tx.commit();

      } catch (HibernateException he) {
     if (tx != null) {
        tx.rollback();
      }
        throw he;
      } finally {
	      HibernateSessionFactory.closeSession();
      }
      return list;
}

  public List findWithPage_tikuSearch(int pageSize, int startRow, String sqlBean, TitleSystem titleSystem) throws
  HibernateException {
  List list = null;
  Transaction tx = null;
  try {
  Session session = HibernateSessionFactory.currentSession();
  tx = session.beginTransaction();
  Query q = session.createQuery(sqlBean);
  q.setString(0, titleSystem.getKemuID());
  q.setString(1, titleSystem.getTikuNO());
  q.setFirstResult(startRow);
  q.setMaxResults(pageSize);
  list = q.list();
  tx.commit();

  } catch (HibernateException he) {
 if (tx != null) {
    tx.rollback();
  }
    throw he;
  } finally {
      HibernateSessionFactory.closeSession();
  }
  return list;
}
  
}