entitymanager.java

这是本人曾经在公司里用的,内部开发框架,基于struts+hibernate今天分享给大家

package cn.bway.common.dao;

import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import cn.bway.common.BwayHibernateException;


public class EntityManager {
    public static int RECORDS_PER_PAGE = 5;

    private static Log log = LogFactory.getLog(EntityManager.class);

    public static int getRecordCount(String queryStr) {
    	Session session = null;
        int rt = 0;
        try {
            session = HibernateUtil.currentSession();
            rt = ((Integer) session.iterate(queryStr).next()).intValue();
            //     HibernateUtil.closeSession();
        } catch (Exception e) {
            //if (log.isDebugEnabled())
            e.printStackTrace();
            //     HibernateUtil.closeSession();
            rt = 0;
        }

        return rt;
    }

    public static String getRecordSum(String queryStr) {
        Session session = null;
        String rt = "0";
        try {
            session = HibernateUtil.currentSession();
            //System.out.println("queryStr:"+queryStr+" Result is:"+session.iterate(queryStr).next());
            Object obj = session.iterate(queryStr).next();
            if (obj != null) {
                rt = obj.toString();
                //System.out.println("-----------------------------------------");
            }
            //  HibernateUtil.closeSession();
        } catch (Exception e) {
            //if (log.isDebugEnabled())
            //  log.error(e.getMessage());
            e.printStackTrace();
            //    HibernateUtil.closeSession();
            rt = "0";
        }

        return rt;
    }

    //杩斿洖瀛楃