src/com/dao/DefaultDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dao;

import java.sql.SQLException;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;


/**
 * 基于spring2.X的hibernate通用dao
 * @author Administrator
 *
 */
public class DefaultDao extends HibernateDaoSupport implements IDefaultDao {
	
	
	//@Override
	public Object getObjsByHql(final String hql,final Integer begin,final Integer size) {
		Object obj=this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query=session.createQuery(hql);
				query.setFirstResult(begin);
				query.setMaxResults(size);
				if(query.list().size()>0)
				{
					return query.list();
				}
				else
				{
					return null;
				}
				
			}});
		return obj;
	}

	//@Override
	public Integer ecObjs(final String hql) {
		Integer num=Integer.parseInt(this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query=session.createQuery(hql);
				return query.executeUpdate();
			}}).toString());
		return num;
	}

	public Integer getCountByHql(final String hql) {
		Integer count=Integer.parseInt(this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query=session.createQuery(hql);
				return query.uniqueResult();