Hibernate通用的baseDao

最新推荐文章于 2018-11-05 08:39:18 发布
最新推荐文章于 2018-11-05 08:39:18 发布
阅读量214 收藏
点赞数
文章标签： Hibernate DAO SQL log4j Apache
本文介绍了一个基于Hibernate的通用DAO接口及其实现类的设计方案，该方案提供了多种数据库操作方法，如增删改查等，并支持HQL和SQL查询，便于进行高效的数据处理。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

IBaseDao

/**
 * 
 */

package zhenjw.hibernate.dao;

import java.util.Collection;
import java.util.List;

import org.hibernate.Session;

/**
 * @author zhenjw
 * 
 */
public interface IBaseDao {

	/**
	 * 功能：获得数据库连接的Session
	 * 
	 * @return Session
	 */
	public Session getSession();

	/**
	 * 功能：根据hql语句得到记录总数
	 * 
	 * @param strhql
	 * @return int
	 */
	public int getTotalCount(String strhql);

	/**
	 * 功能：根据sql语句得到记录总数
	 * 
	 * @param strsql
	 * @return int
	 */
	public int getTotalCountBySql(String strsql);

	/**
	 * 功能：根据hql语句得到记录总数
	 * 
	 * @param strhql
	 * @param obj
	 * @return int
	 */
	public int getTotalCount(String strhql, Object obj);


	/**
	 * 功能：根据hql语句得到记录总数
	 * @param strhql
	 * @param params
	 * @return int
	 */
	public int getTotalCount(String strhql, List params);

	/**
	 * 功能：根据sql语句得到记录总数
	 * @param strsql
	 * @param param
	 * @return
	 */
	public int getTotalCountBySql(String strsql, List params);



	/**
	 * 功能：增加记录
	 * 
	 * @param entity
	 */
	public void create(Object entity);

	/**
	 * 功能：修改记录
	 * 
	 * @param entity
	 */
	public void update(Object entity);

	/**
	 * 功能：删除记录
	 * 
	 * @param entity
	 */
	public void delete(Object entity);

	/**
	 * 功能：删除数据
	 * 
	 * @param clazz
	 * @param id
	 */
	public void delete(Class clazz, long id);

	/**
	 * 功能：批量删除数据
	 * 
	 * @param clazz
	 * @param id
	 */
	public void batchDelete(Class clazz, long[] id);

	/**
	 * 功能：删除表中的所有的记录
	 * 
	 * @param clazz
	 */
	public void deleteAll(Class clazz);

	/**
	 * 功能：删除记录集中的所有的记录
	 * 
	 * @param entities
	 */
	public void deleteAll(Collection entities);;

	/**
	 * 功能：通过主键查询记录
	 * 
	 * @param clazz
	 * @param id
	 * @return Object
	 */

	public Object getByPk(Class clazz, int id);

	/**
	 * 功能：通过主键查询记录
	 * 
	 * @param clazz
	 * @param id
	 * @return Object
	 */
	public Object getByPk(Class clazz, long id);

	/**
	 * 功能：通过主键查询记录
	 * 
	 * @param clazz
	 * @param id
	 * @return Object
	 */
	public Object getByPk(Class clazz, String id);

	/**
	 * 功能：通过关键字和值来进行查询
	 * 
	 * @param clazz
	 * @param keyName
	 * @param keyValue
	 * @return 得到的Object是List
	 */
	public Object loadByPk(Class clazz, String keyName, Object keyValue);

	/**
	 * 功能：根据hql查询记录
	 * 
	 * @param strhql
	 * @return List
	 */
	public List find(String strhql);

	/**
	 * 功能：根据hql查询记录
	 * 
	 * @param strhql
	 * @param param
	 * @return List
	 */
	public List find(String strhql, Object param);

	/**
	 * 功能：根据hql查询记录
	 *  
	 * @param strhql
	 * @param name
	 * @param param
	 * @return List
	 */
	public List findByNamedParam(String strhql, String name, Object param);


	/**
	 * 功能：SQL查询
	 * @param strsql
	 * @return
	 */
	public List findBySql(String strsql);

	/**
	 * 功能：查询符合条件的记录。
	 * @param strsql
	 * @param params
	 * @return
	 */
	public List findBySql(String strsql,List params);  

	/**
	 * 功能：分页查询
	 * 
	 * @param pageNo
	 * @param pageSize
	 * @param strhql
	 * @return List
	 */
	public List query(int pageNo, int pageSize, String strhql);

	/**
	 * 功能：分页查询
	 * 
	 * @param pageNo
	 * @param pageSize
	 * @param queryString
	 * @param obj
	 * @return List
	 */
	public List query(int pageNo, int pageSize, String strhql, Object obj);


	/**
	 * 功能：分页查询
	 * @param pageNo
	 * @param pageSize
	 * @param strhql
	 * @param params
	 * @return
	 */
	public List query(int pageNo, int pageSize, String strhql, List params );



	/**
	 * 功能：分页查询
	 * 
	 * @param pageNo
	 * @param pageSize
	 * @param strsql
	 * @return List
	 */
	public List queryBySql(int pageNo, int pageSize, String strsql); 

	/**
	 * 功能：分页查询
	 * @param pageNo
	 * @param pageSize
	 * @param strsql
	 * @param params
	 * @return
	 */
	public List queryBySql(int pageNo, int pageSize, String strsql, List params) ;


	/**
	 * 功能：执行SQL语句，主要是更新与删除记录的SQL语句，不需要返回值的
	 * 
	 * @param strsql
	 */
	public void excuteSql(String strsql);

}



BaseDao



/**
 * 
 */
package zhenjw.hibernate.dao;

import java.util.Collection;
import java.util.Iterator;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;

import zhenjw.hibernate.HibernateSessionFactory;


/**
 * @author zhenjw
 *
 */
public class BaseDao implements IBaseDao {

	private Logger logger = Logger.getLogger(this.getClass());

	// private Messages Messages=new Messages();

	private String databeaseError = Messages
			.getString("BaseDao.databeaseError");

	private SessionFactory sessionFactory;


	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#batchDelete(java.lang.Class, long[])
	 */
	public void batchDelete(Class clazz, long[] id) {
		// TODO Auto-generated method stub

		String strId = "";

		for (int i = 0; i < id.length; i++) {

			if (i > 0)

				strId += ", " + id[i];

			else

				strId = "" + id[i];

		}
		logger.debug("batchDelete(Class, long[])  id[]={" + strId + "}");

		for (int i = 0; i < id.length; i++) {

			this.delete(clazz, id[i]);

		}


	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#create(java.lang.Object)
	 */
	public void create(Object entity) {
		// TODO Auto-generated method stub

		Session session = null;

		Transaction tr = null;

		boolean commitflag=false;

		try {
			session = this.getSession();

			tr = session.beginTransaction(); 

			session.save(entity);

			tr.commit();

			commitflag=true;

			session.flush();

			session.clear();

			// super.getHibernateTemplate().save(entity);

			logger.debug("保存" + entity.getClass().getName() + " 的实例到数据库成功！");

		} catch (Exception e) { 


			String error = Messages.getString("BaseDao.create.saveError");

			logger.debug("保存" + entity.getClass().getName() + " 的实例到数据库 ,"
						+ error, e);

			e.printStackTrace();

			throw new DaoException(error);

		} finally {

			if(!commitflag)
			{
				try{

					if (tr != null)

						tr.rollback();

				}catch(Exception e1)
				{

					logger.debug("事务",e1);

				}
			}

			this.closeSession(session);

		}


	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#delete(java.lang.Object)
	 */
	public void delete(Object entity) {
		// TODO Auto-generated method stub

		logger.debug("delete(Object) entity.class="
				+ entity.getClass().getName()); 

		Session session = null;

		Transaction tr = null;

		boolean commitflag=false;

		try {

			session = this.getSession();

			tr = session.getTransaction();

			tr.begin();

			session.delete(entity);

			tr.commit();

			commitflag=true;

			session.flush();

			session.clear();

		} catch (Exception e) {

			if (tr != null)

				tr.rollback();

			String Error = Messages.getString("BaseDao.delete.Error");

			logger.debug(Error + " Class=" + entity.getClass().getName(), e);

			throw new DaoException(Error);
		} finally {

			if(!commitflag)
			{
				try
				{
					if (tr != null)

						tr.rollback();

				}catch(Exception e)
				{
					e.printStackTrace();
				}
			}

			this.closeSession(session);

		}

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#delete(java.lang.Class, long)
	 */
	public void delete(Class clazz, long id) {
		// TODO Auto-generated method stub

		logger.debug("ClassName=" + clazz.getName() + "  ,id=" + id);

		try {

			Object entity = this.getByPk(clazz, id);

			if (entity != null)

				this.delete(entity);

			else

				logger.debug(clazz.getName() + " 的关键字为 " + id + "  的对象不存在 ");

		} catch (Exception e) {

			logger.debug("  delete(Class, long)  excute is error  . Error="
					+ e.toString());

			throw new DaoException(Messages.getString("BaseDao.delete.Error"));

		}

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#deleteAll(java.lang.Class)
	 */
	public void deleteAll(Class clazz) {
		// TODO Auto-generated method stub

		logger.debug("deleteAll(Class) ClassName=" + clazz.getName()); 

		Session session = null;

		Transaction tr = null;

		boolean commitflag=false;

		try {

			session = this.getSession();

			tr = session.beginTransaction();

			Query query = session.createQuery(" delete   from "
					+ clazz.getName());

			query.executeUpdate();

			tr.commit();

			commitflag=true;

			session.flush();

		} catch (Exception e) { 

			String Error = Messages.getString("BaseDao.delete.Error");

			logger.debug("从数据库中删除" + clazz.getName() + "的所有实例失败！", e);

			throw new DaoException(Error);

		} finally {

			if(!commitflag)
			{
				try
				{
					if (tr != null)

						tr.rollback();

				}catch(Exception e)
				{
					e.printStackTrace();
				}
			}

			this.closeSession(session);

		}

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#deleteAll(java.util.Collection)
	 */
	public void deleteAll(Collection entities) {
		// TODO Auto-generated method stub

		Session session = null;

		Transaction tr = null;

		boolean commitflag=false;

		try {

			session = this.getSession();

			tr = session.beginTransaction();

			Iterator ite = entities.iterator();


			while (ite.hasNext())

				session.delete(ite.next());

			// super.getHibernateTemplate().deleteAll(entities);
			tr.commit();

			commitflag=true;

			session.flush();


		} catch (Exception e) { 

			String error = Messages.getString("BaseDao.deleteAll.Error");

			logger.debug(error, e);

			throw new DaoException(error);

		} finally {

			if(!commitflag)
			{
				try
				{
					if (tr != null)

						tr.rollback();

				}catch(Exception e)
				{
					e.printStackTrace();
				}
			}

			this.closeSession(session);

		}



	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#excuteSql(java.lang.String)
	 */
	public void excuteSql(String strsql) {
		// TODO Auto-generated method stub

		logger.debug("excuteSql(String) strsql=" + strsql);

		Session session = null;

		Transaction tr = null;

		boolean commitflag=false;

		try {

			session = this.getSession();

			tr = session.beginTransaction();

			SQLQuery query = session.createSQLQuery(strsql);


			query.executeUpdate();

			tr.commit();

			commitflag=true;

			session.flush();

			// super.getHibernateTemplate().update(entity);

		} catch (Exception e) {



			String Error = Messages.getString("BaseDao.excuteSql.Error");

			logger.debug(Error, e);

			throw new DaoException(Error);

		} finally {

			if(!commitflag)
			{
				try
				{
					if (tr != null)

						tr.rollback();

				}catch(Exception e)
				{
					e.printStackTrace();
				}
			}

			this.closeSession(session);

		}



	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#find(java.lang.String)
	 */
	public List find(String strhql) {
		// TODO Auto-generated method stub

		List result = null;

		logger.debug("find(String) queryString=" + strhql);

		Session session = null;

		try {

			// result = super.getHibernateTemplate().find(queryString);

			session = this.getSession();

			Query query = session.createQuery(strhql);

			result = query.list();

		} catch (Exception e) {

			logger.debug("执行数据库中查询时失败,语句为：" + strhql, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result; 
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#find(java.lang.String, java.lang.Object)
	 */
	public List find(String strhql, Object param) {
		// TODO Auto-generated method stub

		logger.debug("find(String, Object) queryString=" + strhql
				+ " ,param=" + param);

		List result = null;

		Session session = null;

		try {

			session = this.getSession();

			Query query = session.createQuery(strhql);

			query.setParameter(0, param);

			result = query.list();

			// result = super.getHibernateTemplate().find(queryString, param);

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#findByNamedParam(java.lang.String, java.lang.String, java.lang.Object)
	 */
	public List findByNamedParam(String strhql, String name, Object param) {
		// TODO Auto-generated method stub


		logger.debug("findByNamedParam(String, String, Object) strhql="
				+ strhql + "name=" + name + " ,param=" + param);

		List result = null;

		Session session = null;

		try {
			session = this.getSession();

			Query query = session.createQuery(strhql);

			query.setParameter(name, param);

			result = query.list();

			// result =
			// super.getHibernateTemplate().findByNamedParam(queryString,
			// name, param);

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#findBySql(java.lang.String)
	 */
	public List findBySql(String strsql) {
		// TODO Auto-generated method stub

		logger.debug("exceuteSQL(String) strsql=" + strsql);

		System.out.println(strsql);

		Session session = null;

		List result=null;


		try {

			session = this.getSession(); 

			SQLQuery query = session.createSQLQuery(strsql);

			result=query.list();

			// super.getHibernateTemplate().update(entity);

		} catch (Exception e) { 

			String Error = Messages.getString("BaseDao.exceuteSQL.Error");

			logger.debug(Error, e);

			throw new DaoException(Error);

		} finally {

			this.closeSession(session);

		}

		return result;
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#findBySql(java.lang.String, java.util.List)
	 */
	public List findBySql(String strsql, List params) {
		// TODO Auto-generated method stub

		String paramnameArray=""; 

		if(params!=null)
		{

			for (int i = 0; i < params.size(); i++) {

					if (i > 0)

						paramnameArray += " , " + params.get(i);

					else

						paramnameArray = ""+params.get(i);

			}

		}

		logger.debug("excuteSql(String, List) strsql="+strsql+" , List="+paramnameArray);

		System.out.println(strsql);

		List result =null;

		Session session = null;

		try { 

			session = this.getSession();


			SQLQuery query = session.createSQLQuery(strsql);

			if(params!=null)
			{
				for (int i = 0; i < params.size(); i++) {

					query.setParameter(i, params.get(i));

				} 
			}

			result  = query.list();

		} catch (Exception e) {

			String error = Messages.getString("BaseDao.findBySql.Error");

			logger.debug(error, e);

			e.printStackTrace();

			throw new DaoException(error);

		} finally {

			this.closeSession(session);

		}

		return result;  

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getByPk(java.lang.Class, int)
	 */
	public Object getByPk(Class clazz, int id) {
		// TODO Auto-generated method stub


		logger.debug("getByPk(Class, Integer) class=" + clazz.getName()
				+ " , ID=" + id);

		Object result = null;

		Session session = null;

		try {

			session = this.getSession();

			result = session.get(clazz, new Integer(id));			

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getByPk(java.lang.Class, long)
	 */
	public Object getByPk(Class clazz, long id) {
		// TODO Auto-generated method stub

		logger.debug("getByPk(Class, Long) Class=" + clazz.getName() + ",id="
				+ id);

		Object result = null;

		Session session = null;

		try {
			session = this.getSession();

			result = session.get(clazz, new Long(id));

			// (Object) super.getHibernateTemplate().get(clazz, id);

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getByPk(java.lang.Class, java.lang.String)
	 */
	public Object getByPk(Class clazz, String id) {
		// TODO Auto-generated method stub

		logger.debug("getByPk(Class, String) Class=" + clazz.getName() + ",id="
				+ id);

		Object result = null;

		Session session = null;

		try {

			session = this.getSession();

			result = session.get(clazz, id);

			// result = (Object) super.getHibernateTemplate().get(clazz, id);

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getSession()
	 */
	public Session getSession() {
		// TODO Auto-generated method stub

		return HibernateSessionFactory.getSession();

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getTotalCount(java.lang.String)
	 */
	public int getTotalCount(String strhql) {
		// TODO Auto-generated method stub

		logger.debug("getTotalCount() strhql=" + strhql);

		int result = 0;

		Session session = null;

		try {

			String strsql = this.getQueryTotalCountString(strhql);

			session = this.getSession();

			Query query = session.createQuery(strsql);

			List list = query.list();

			result = this.getNum(list);

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getTotalCount(java.lang.String, java.lang.Object)
	 */
	public int getTotalCount(String strhql, Object obj) {
		// TODO Auto-generated method stub

		logger.debug("getTotalCount(String,Object)  strhql=" + strhql
				+ "" + obj.getClass().getName());

		int result = 0;

		Session session = null;

		try {

			String strsql = this.getQueryTotalCountString(strhql);

			//System.out.println(strsql);

			logger.debug("strsql="+strsql);

			session = this.getSession();

			Query query = session.createQuery(strsql);

			List list = query.setProperties(obj).list(); 

			result = this.getNum(list);


		} catch (Exception e) {

			String error = Messages.getString("BaseDao.getTotalCount.Error");

			logger.debug(error, e);

			e.printStackTrace();

			throw new DaoException(error);

		} finally {

			this.closeSession(session);

		}

		return result;
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getTotalCount(java.lang.String, java.util.List)
	 */
	public int getTotalCount(String strhql, List params) {
		// TODO Auto-generated method stub

		String paramnameArray=""; 

		if(params!=null)
		{

			for (int i = 0; i < params.size(); i++) {

					if (i > 0)

						paramnameArray += " , " + params.get(i);

					else

						paramnameArray = ""+params.get(i);

			}

		}

		logger.debug("getTotalCount(String, List) strhql="+strhql+" , List="+paramnameArray);


		int result = 0;

		Session session = null;

		try {

			String strquery = this.getQueryTotalCountString(strhql);

			//System.out.println(strsql);

			session = this.getSession();

			logger.debug("strquery=="+strquery);

			Query query = session.createQuery(strquery);

			if(params!=null)
			{
				for (int i = 0; i < params.size(); i++) {

					query.setParameter(i, params.get(i));

				} 
			}

			List list = query.list();

			result = this.getNum(list);


		} catch (Exception e) {

			String error = Messages.getString("BaseDao.getTotalCount.Error");

			logger.debug(error, e);

			e.printStackTrace();

			throw new DaoException(error);

		} finally {

			this.closeSession(session);

		}

		return result;  
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getTotalCountBySql(java.lang.String)
	 */
	public int getTotalCountBySql(String strsql) {
		// TODO Auto-generated method stub

		logger.debug("getTotalCountBySql(String) strsql=" + strsql);

		int result = 0;

		Session session = null;

		try {

			strsql = this.getQueryTotalCountString(strsql);

			session = this.getSession(); 

			logger.debug("strsql=="+strsql);

			List list=session.createSQLQuery(strsql).list();

			result = this.getNum(list);

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#getTotalCountBySql(java.lang.String, java.util.List)
	 */
	public int getTotalCountBySql(String strsql, List params) {
		// TODO Auto-generated method stub

		String paramnameArray=""; 

		if(params!=null)
		{

			for (int i = 0; i < params.size(); i++) {

					if (i > 0)

						paramnameArray += " , " + params.get(i);

					else

						paramnameArray = ""+params.get(i);

			}

		}

		logger.debug("getTotalCountBySql(String, List) strsql="+strsql+" , List="+paramnameArray);


		int result = 0;

		Session session = null;

		try {

			strsql = this.getQueryTotalCountString(strsql);

			logger.debug("strsql=="+strsql);

			session = this.getSession();

			SQLQuery query = session.createSQLQuery(strsql);

			if(params!=null)
			{
				for (int i = 0; i < params.size(); i++) {

					query.setParameter(i, params.get(i));

				} 
			}

			List list = query.list();

			result = this.getNum(list);


		} catch (Exception e) {

			String error = Messages.getString("BaseDao.getTotalCount.Error");

			logger.debug(error, e);

			e.printStackTrace();

			throw new DaoException(error);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#loadAll(java.lang.String)
	 */
	public List loadAll(String strhql) {
		// TODO Auto-generated method stub
		return this.find(strhql);
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#loadByPk(java.lang.Class, java.lang.String, java.lang.Object)
	 */
	public Object loadByPk(Class clazz, String keyName, Object keyValue) {
		// TODO Auto-generated method stub

		Object result = null;

		String query = "from " + clazz.getName() + "  where " + keyName + "=? ";

		logger.debug("loadByPk(Class, String, Object) queryString=" + query
				+ "  ,keyValue=" + keyValue);

		Session session = null;

		try {

			session = this.getSession();

			result = session.createCriteria(clazz).add(
					Restrictions.eq(keyName, keyValue)).list();


		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;		

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#query(int, int, java.lang.String)
	 */
	public List query(int pageNo, int pageSize, String strhql) {
		// TODO Auto-generated method stub

		logger.debug("query(int, int, String) pageNo=" + pageNo + ",pageSize="
				+ pageSize + " ,strhql=" + strhql);

		List result = null;

		Session session = null;

		try {
			session = this.getSession();

			Query query = session.createQuery(strhql);
			//System.out.println(queryString);

			if (pageNo > 0 && pageSize > 0) {

				query.setFirstResult((pageNo - 1) * pageSize);

				query.setMaxResults(pageSize);
			}

			result = query.list();

			//System.out.println()
		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;
	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#query(int, int, java.lang.String, java.lang.Object)
	 */
	public List query(int pageNo, int pageSize, String strhql, Object obj) {
		// TODO Auto-generated method stub

		logger.debug("query(int, int, String, Object) pageNo=" + pageNo
				+ ",pageSize=" + pageSize + "strhql="+strhql+"  ,obj"
				+ obj.getClass().getName());

		List result = null;

		Session session = null;

		try {

			session = this.getSession();

			Query query = session.createQuery(strhql);

			query.setProperties(obj);

			if (pageNo > 0 && pageSize > 0) {

				query.setFirstResult((pageNo - 1) * pageSize);

				query.setMaxResults(pageSize);

			}

			result = query.list();

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result;

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#query(int, int, java.lang.String, java.util.List)
	 */
	public List query(int pageNo, int pageSize, String strhql, List params) {
		// TODO Auto-generated method stub

		logger.debug("query(int, int, String, Object) pageNo=" + pageNo + ",pageSize=" + pageSize + ",strhql="+strhql);		

		String paramnameArray="";

		if(params!=null)
		{

			for (int i = 0; i < params.size(); i++) {

					if (i > 0)

						paramnameArray += " , " + params.get(i);

					else

						paramnameArray = ""+params.get(i);

			}

		}

		logger.debug("params="+params);

		List result = null;

		Session session = null;

		try {

			session = this.getSession();

			Query query = session.createQuery(strhql);

			if(params!=null)
			{
				for (int i = 0; i < params.size(); i++) {

					query.setParameter(i, params.get(i));

				} 
			}

			if (pageNo > 0 && pageSize > 0) {

				query.setFirstResult((pageNo - 1) * pageSize);

				query.setMaxResults(pageSize);

			}

			result = query.list();

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result; 

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#queryBySql(int, int, java.lang.String)
	 */
	public List queryBySql(int pageNo, int pageSize, String strsql) {
		// TODO Auto-generated method stub


		logger.debug("query(int, int, String) pageNo=" + pageNo + ",pageSize="
				+ pageSize + " ,strsql=" + strsql);

		List result = null;

		Session session = null;

		try {

			session = this.getSession();			

			SQLQuery query = session.createSQLQuery(strsql);

			if (pageNo > 0 && pageSize > 0) {

				query.setFirstResult((pageNo - 1) * pageSize);

				query.setMaxResults(pageSize);

			}

			result = query.list();

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}

		return result; 

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#queryBySql(int, int, java.lang.String, java.util.List)
	 */
	public List queryBySql(int pageNo, int pageSize, String strsql, List params) {
		// TODO Auto-generated method stub

		logger.debug("query(int, int, String, Object) pageNo=" + pageNo + ",pageSize=" + pageSize + " , strsql="+strsql);		

		String paramnameArray="";

		if(params!=null)
		{

			for (int i = 0; i < params.size(); i++) {

					if (i > 0)

						paramnameArray += " , " + params.get(i);

					else

						paramnameArray = ""+params.get(i);

			}

		}

		logger.debug("params="+params);

		List result = null;

		Session session = null;

		try {

			session = this.getSession();

			SQLQuery query = session.createSQLQuery(strsql);

			if(params!=null)
			{
				for (int i = 0; i < params.size(); i++) {

					query.setParameter(i, params.get(i));

				} 
			}

			if (pageNo > 0 && pageSize > 0) {

				query.setFirstResult((pageNo - 1) * pageSize);

				query.setMaxResults(pageSize);

			}

			result = query.list();

		} catch (Exception e) {

			logger.debug(databeaseError, e);

			throw new DaoException(databeaseError);

		} finally {

			this.closeSession(session);

		}
		return result; 

	}

	/* (non-Javadoc)
	 * @see zhenjw.hibernate.dao.IBaseDao#update(java.lang.Object)
	 */
	public void update(Object entity) {
		// TODO Auto-generated method stub

		logger.debug("update(Object) entity.class="
				+ entity.getClass().getName());

		Session session = null;

		Transaction tr = null;

		try {
			session = this.getSession();

			tr = session.beginTransaction();

			session.update(entity);

			tr.commit();

			session.flush();

			session.clear();

			// super.getHibernateTemplate().update(entity);

		} catch (Exception e) {

			if (tr != null)

				tr.rollback();

			String Error = Messages.getString("BaseDao.update.Error");

			logger.debug(Error, e);

			throw new DaoException(Error);

		} finally {

			this.closeSession(session);

		}

	}

	/**
	 * 功能：关闭session
	 * @param session
	 */
	protected void closeSession(Session session) {

		if (session != null && session.isOpen())

			session.close();

		session = null;

	}

	/**
	 * 功能：得到查询记录总数的语句（包含sql与hql）
	 * @param queryString
	 * @return
	 */
	private String getQueryTotalCountString(String queryString) {

		int form_index = queryString.indexOf("from ");

		int orderby_index = queryString.indexOf(" order by ");

		if (form_index < 0) {

			throw new DaoException(Messages
					.getString("BaseDao.getTotalCount.notFromkeyword"));

		}

		String strsql = " select count(*) ";

		if (orderby_index > -1) {

			strsql = strsql + queryString.substring(form_index, orderby_index);

		} else {

			strsql = strsql + queryString.substring(form_index);
		}

		return strsql;
	}

	/**
	 * 功能：得到记录数的方法
	 * @param list
	 * @return
	 */
	protected int getNum(List list)
	{

		int result=0;

		if (list != null || list.size() > 0) 

			result = Integer.parseInt(list.get(0).toString());

		 return result;
	}



}

iteye_10343
关注
基于hibernate的BaseDAO接口
Thinking的专栏
04-21 1万+
BaseDao.java import java.io.Serializable; import java.util.Collection; import java.util.List; import java.util.Map; import com.xxx.finance.utils.HibernateHandler; import com.xxx.finance.utils.
基于hibernate封装的BaseDao
01-02
基于hibernate封装的BaseDao，有完整的增删改查，分页，执行hql sql 方法 约 20个方法，详情地址 https://blog.csdn.net/qq_41861261/article/details/85595872
spring和hibernate集成后，通用的basedao
08-03
对dao中的基础的增删改查和分页功能进行了封装，可以通用，代码复用性提高了
hibernate通用 BaseDao(通用分页)
LJD_2001的博客
11-05 601
基于分页的通用类 StringUtils 类 package com.eight.dao; public class StringUtils { // 私有的构造方法，保护此类不能在外部实例化 private StringUtils() { } /** * 如果字符串等于null或去空格后等于""，则返回true，否则返回false * * @param s * @r...
通用的HibernateBaseDAO
程序员的杯具--你懂的！
12-06 212
通用一个HibernateBaseDAO 有了这个基类在一般的项目里面可以对项目一切的数据操作,不需要任何SQL语句： package com.doer.template.hibernate.dao.impl; import java.io.Serializable; import java.lang.reflect.InvocationTargetException; imp...
HibernateBaseDAO
weixin_30421809的博客
04-12 138
HibernateBaseDAO接口 1 package com.iotek.homework.dao; 2 3 import java.io.Serializable; 4 import java.util.List; 5 6 /** 7 * Created by Bo on 2017/4/9. 8 */ 9 public interface Hi...
打造Hibernate通用BaseDAO
aNoobCoder的博客
03-13 731
在看老师写的一个项目时发现的一个不错的东西，节省了很多DAO曾开发时的代码，很不错，推荐一波1.声明DAO的通用接口/** * */ package ts.daoBase;import java.io.Serializable; import java.util.List;import org.hibernate.criterion.Criterion; /** * 提供hibernate
基于hibernate的baseDao
06-11
BaseDAO是一种通用的设计模式，它封装了Hibernate框架的基本操作，使得业务逻辑层可以更加专注于业务处理，而不需要关心底层的数据访问细节。本压缩包提供的"baseDAO"文件，包含了一个详细注释的BaseDAO实现，旨在...
基于Spring和Hibernate的通用BaseDAO封装实践
解析：标签表明，文件中很可能包含具体的代码示例，旨在指导开发者如何实现基于Spring和Hibernate集成的通用BaseDAO。 ### 压缩包子文件的文件名称列表解析 文件名称列表：“ssh” 解析：这很可能是对“Spring、...
深入解析Hibernate封装BaseDao的实现与应用
在给出的文件信息中，BaseDao是基于Hibernate框架进行封装的，它提供了包括但不限于以下知识点： 1. **Hibernate框架的基本概念与应用**： - Hibernate是一个Java语言编写的开源对象关系映射（Object Relational ...
深入封装Hibernate：baseDao与baseDaoImpl应用反射技术
为了解决这一问题，很多Java开发项目会引入`BaseDao`和`BaseDaoImpl`这两个设计模式的概念，它们的主要目的是封装Hibernate的常用方法，实现代码的复用，以及提高开发效率。 `BaseDao`和`BaseDaoImpl`两个概念通常...
hibernate basedao
05-18
涵盖通过hibernate进行数据库操作的通用方法
hibernate basedao（泛型版本）
05-18
利用泛型编写的hibernate basedao，涵盖几乎所有数据库操作方法,需导入spring相关jar包
hibernate>>BaseDAO
06-02
hibernate的BaseDAO源代码
Spring整合hibernate（4）之BaseDao的编写示例
10-12
Spring整合hibernate（4）之BaseDao的编写示例 说明：因为我们在实际编码中会编写一些重复的数据库操作方法CRUD，每个类都写一次感觉很繁琐，因此可以考虑考虑把所有公共的方法都写在BaseDao中，这个时候，让所有的DAO都继承BaseDao；这样基本上就实现了大量的基础方法，如果DAO中又一些特殊方法，再再具体的实现类的DAO中创建。
hibernate中的通用分页basedao
Niexiaoya的博客
10-30 390
hibernate原生态分页写法 public List&lt;Book&gt; list1(Book book,PageBean pageBean) { Session session = SessionFactoryUtil.getSession(); Transaction transaction = session.beginTransaction(); String hql=...
基于hibernate的BaseDao
人生如逆旅，我亦是行人。。。
03-03 768
1.BaseDao接口： package com.dear.simpler.dao; import java.io.Serializable; import java.util.List; import com.dear.simpler.db.utils.SPLDBException; /** * * @author lixiang * * 定义所有表的公共的方法接口 */ pu
基于Hibernate的BaseDao类
zhaoyanjun008的博客
01-09 492
package com.jiisb.app.dao;import java.io.Serializable; import java.util.List; import java.util.Map;import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import
Hibernate常用的BaseDao
12-30 388
package org.accp.house.dao.hbimpl; import java.io.Serializable; import java.util.List; import org.accp.house.dao.ICommonDao; import org.accp.house.dao.IHibernateCallback; import org.accp.house.hi
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值