js+ssh实现树 DTree

package com.baosight.rbac.dao.impl; import java.util.List; import org.hibernate.Query; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.baosight.rbac.model.PagerModel; import com.baosight.rbac.utils.SystemContext; import com.baosight.rbac.utils.SystemException; public class AbstractManager extends HibernateDaoSupport { public PagerModel searchPaginated(String hql){ return searchPaginated(hql, null); } public PagerModel searchPaginated(String hql,Object param){ return searchPaginated(hql, new Object[]{param}); } public PagerModel searchPaginated(String hql,Object[] params){ return searchPaginated(hql, params,SystemContext.getOffset(), SystemContext.getPagesize()); } public PagerModel searchPaginated(String hql,int offset,int pagesize){ return searchPaginated(hql,null, offset, pagesize); } public PagerModel searchPaginated(String hql,Object param,int offset,int pagesize){ return searchPaginated(hql, new Object[]{param}, offset, pagesize); } @SuppressWarnings("unchecked") public PagerModel searchPaginated(String hql,Object[] params,int offset,int pagesize){ //获取记录总数 String countHql = getCountQuery(hql); Query query = getSession().createQuery(countHql); if(params != null && params.length > 0){ for(int i=0; i<params.length; i++){ query.setParameter(i, params[i]); } } int total = ((Long)query.uniqueResult()).intValue(); //获取结果�? query = getSession().createQuery(hql); if(params != null && params.length > 0){ for(int i=0; i<params.length; i++){ query.setParameter(i, params[i]); } } query.setFirstResult(offset); query.setMaxResults(pagesize); List datas = query.list(); //返回PagerModel PagerModel pm = new PagerModel(); pm.setDatas(datas); pm.setTotal(total); return pm; } /** * 根据HQL语句，获得查询�?记录数的HQL语句 * 如： * select ... from Organization o where o.parent is null * 经过转换，可以得到： * select count(*) from Organziation o where o.parent is null * @param hql * @return */ private String getCountQuery(String hql){ int index = hql.indexOf("from"); if(index != -1){ return "select count(*) " + hql.substring(index); } throw new SystemException("无效的HQL查询语句�?+hql+"); } }