hibernate分页

package com.redbaby.dao;

import java.math.BigDecimal;

importjava.util.HashMap;

importjava.util.List;

import java.util.Map;

import javacommon.xsqlbuilder.XsqlBuilder;import javacommon.xsqlbuilder.XsqlBuilder.XsqlFilterResult;

import org.hibernate.Query;

importorg.hibernate.Session;

importorg.hibernate.transform.Transformers;

importorg.springframework.dao.DataAccessException;

importorg.springframework.orm.hibernate3.HibernateCallback;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.redbaby.util.Page;

public abstract class HibernateGenericDao extends HibernateDaoSupport {

/**

*得到一条数据(整个Object对象)

*

*hql:fromObjectwhere.....

*

*@paramhql

*@paramvalues

*@return

*@throwsDataAccessException

*/

 public Object getInfo(String hql, Object... values) throws DataAccessException {

  List list = null;  list = super.getHibernateTemplate().find(hql, values);

  if (list != null && list.size() > 0) {

returnlist.get(0);

}

  return null;

 }

 /**

*得到对象Object某一个属性select中必选指定要查询字段名称（一个）

*

*hql:selectp.idfromobjectwhere1=1.....

*/

 public Object getInfoParam(final String hql, Object... values) throws DataAccessException {

  Session session = super.getSession();  Query query = session.createQuery(hql);

  if (values != null) {

for(inti=0;i<values.length;i++){

query.setParameter(i,values[i]);

}

}

Objectobj=query.uniqueResult();

returnobj;

 }

 /**

*得到List

*

*@paramhql

*@paramvalues

*@return

*@throwsDataAccessDataAccessException

*/

publicList<?>getListByParam(Stringhql,Object...values)throwsDataAccessException{

returnsuper.getHibernateTemplate().find(hql,values);

 }

 /**

*执行带参数的DMLUPDATEDELETE

*

*@paramhql

*@paramvalues

*@return

*@throwsDataAccessDataAccessException

*/

 public void updateForParam(final String hql, final Object... values) throws DataAccessException {

  super.getHibernateTemplate().execute(new HibernateCallback() {

publicObjectdoInHibernate(Sessionsession){

Queryquery=session.createQuery(hql);

if(values!=null){

for(inti=0;i<values.length;i++){

query.setParameter(i,values[i]);

}

}

returnquery.executeUpdate();

}

});

 }

 /**

*HQL分页(带查询)

*

*@paramhql

*@paramparams

*@parampage

*@return

*@throwsDataAccessDataAccessException

*/

publicList<?>getListPage(Stringhql,Map<Object,Object>params,Pagepage)throwsDataAccessException{

if(params==null){

params=newHashMap<Object,Object>();

}

intfirst=0;

intmax=0;

if(null!=page){

first=(int)((page.getCurrentPage()-1)*page.getPageSize());

max=(int)page.getPageSize();

}

finalintfirstResult=first;

  final int maxResults = max;

  XsqlFilterResult result = new XsqlBuilder().generateHql(hql, params);

Longcount=getTotalCount(result.getXsql(),1);

if(page!=null){

page.setTotalSize(count);

  }

  final Page pageFin = page;

finalStringnewHql=result.getXsql();

returnsuper.getHibernateTemplate().executeFind(newHibernateCallback(){

publicObjectdoInHibernate(Sessionsession){

Queryquery=session.createQuery(newHql);

if(pageFin!=null){

query.setFirstResult(firstResult);

query.setMaxResults(maxResults);

}

returnquery.list();

}

});

 }

 /**

*SQL分页查询

*/

 public List<?> getListPageSQL(String sql, Map<Object, Object> params, Page page, Class<?> tclass) throws DataAccessException {

  XsqlFilterResult result = new XsqlBuilder().generateHql(sql, params);

if(page!=null){

Longcount=getTotalCount(result.getXsql(),2);

page.setTotalSize(count);//

  }

  Session session = super.getSession();

QueryqueryList=session.createSQLQuery(result.getXsql()).addEntity(tclass);

if(page!=null){

queryList.setFirstResult((int)((page.getCurrentPage()-1)*page.getPageSize()));//

queryList.setMaxResults((int)page.getPageSize());//

}

List<?>tList=queryList.list();

return(List<?>)tList;

 }

 // 返回总记录数

publiclonggetTotalCount(Stringhql,longnum){

longcount=0;

intsql_from=hql.toLowerCase().indexOf("from");

intsql_orderby=hql.toLowerCase().indexOf("orderby");

StringcountStr="";

if(sql_orderby>0){

countStr="selectcount(*)"+hql.substring(sql_from,sql_orderby);

}else{

countStr="selectcount(*)"+hql.substring(sql_from);

}

Sessionsession=super.getSession();

if(num==1){//1,HQL查询

Queryquery=session.createQuery(countStr);

count=(Long)query.uniqueResult();

}elseif(num==2){//2,SQL查询

count=((BigDecimal)(session.createSQLQuery(countStr)).uniqueResult()).longValue();//

}

  return count;

 }

 /**

*通过sql查询Object...values形式且无分页

*

*@paramsql

*@paramtclass

*@paramvalues

*@return

*@throwsDataAccessException

*/

publicList<?>getListByParamSQL(Stringsql,Class<?>tclass,Object...values)throwsDataAccessException{

Sessionsession=super.getSession();

QueryqueryList=session.createSQLQuery(sql).addEntity(tclass);

if(values!=null){

for(inti=0;i<values.length;i++){

queryList.setParameter(i,values[i]);

}

}

List<?>tList=queryList.list();

return(List<?>)tList;

 }

 /**

*通过sql查询params形式且无分页

*

*@paramhql

*@paramparams

*@return

*@throwsDataAccessException

*/

publicList<?>getListByParam(Stringhql,Map<Object,Object>params)throwsDataAccessException{

if(params==null){

params=newHashMap<Object,Object>();

}

XsqlFilterResultresult=newXsqlBuilder().generateHql(hql,params);

finalStringnewHql=result.getXsql();

returnsuper.getHibernateTemplate().executeFind(newHibernateCallback(){

publicObjectdoInHibernate(Sessionsession){

Queryquery=session.createQuery(newHql);

returnquery.list();

}

});

 }

 /**

*无分页，无所属类的SQL查询

*/

 public List<Map> getListMapBySQL(String sql, Map<Object, Object> params) throws DataAccessException {

  XsqlFilterResult result = new XsqlBuilder().generateHql(sql, params);

Sessionsession=super.getSession();

QueryqueryList=session.createSQLQuery(result.getXsql());

List<Map>tListMap=queryList.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();

  return tListMap;

 }

 /**

*有分页，无所属类的SQL查询

*/

 public List<Map> getListMapByPageSQL(String sql, Map<Object, Object> params, Page page) throws DataAccessException {

  XsqlFilterResult result = new XsqlBuilder().generateHql(sql, params);

if(page!=null){

Longcount=getTotalCount(result.getXsql(),2);

page.setTotalSize(count);//

}

Sessionsession=super.getSession();

QueryqueryList=session.createSQLQuery(result.getXsql());

if(page!=null){

queryList.setFirstResult((int)((page.getCurrentPage()-1)*page.getPageSize()));//

queryList.setMaxResults((int)page.getPageSize());//

}

List<Map>tListMap=queryList.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();

  return tListMap;

 }

}