分页公共处理工具

淡淡的烟草味﹌ 2022-10-22 09:23 98阅读 0赞

package com.hhh.framework.tools.utils;
    
    import com.hhh.framework.tools.bean.BasePage;
    import com.hhh.framework.tools.bean.Pageable;
    import org.hibernate.SQLQuery;
    import org.hibernate.transform.Transformers;
    
    import javax.persistence.Query;
    import java.util.List;
    import java.util.Map;
    
    /**
     *  分页公共处理工具
     */
    public final class PagerUtil {
    
       /**
        * 分页处理返回
        * @param query
        * @return
        */
       public static <T> BasePage<T> findPage(Query query, Pageable pager){
          List<Object> list = findList(query, pager);
          return BasePage.build(list,pager);
       }
       /**
        * 分页处理返回
        * @param query
        * @return
        */
       public static <T> BasePage<T> findPage(Query query,List<Object> parms,Pageable pager){
          List<Object> list = findList(query,parms, pager);
          return BasePage.build(list,pager);
       }
       /**
        * 分页处理返回
        * @param query
        * @return
        */
       public static <T> BasePage<T> findPage(Query query, Map<String,Object> parms, Pageable pager){
          List resultList = findList(query,parms, pager);
          return BasePage.build(resultList,pager);
       }
    
       public static <T> BasePage<T> findPage(Query query, Map<String,Object> parms, Pageable pager,Class<T> cla){
          List resultList = findList(query,parms,pager,cla);
          return BasePage.build(resultList,pager);
       }
    
       public static <T> BasePage<T> findPage(Query query, List<Object> parms, Pageable pager,Class<T> cla){
          List resultList = findList(query,parms,pager,cla);
          return BasePage.build(resultList,pager);
    
       }
       /**
        * 分页处理返回
        * @param query
        * @return
        */
       public static <T> List<T> findList(Query query, Pageable pager){
          if(pager!=null&&pager.getPaging()){
             int total = query.getResultList().size();
             pager.setTotal(total);
             //分页
             query.setFirstResult((pager.getPage()-1)* pager.getLimit());
             query.setMaxResults(pager.getLimit());
          }
          query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); //牺牲性能返回map类型数据
          return query.getResultList();
       }
       /**
        * 分页处理返回
        * @param query
        * @return
        */
       public static <T> List<T> findList(Query query,List<Object> parms,Pageable pager){
          for(int i=0;i<parms.size();i++){
             query.setParameter(i+1,parms.get(i));
          }
          if(pager!=null&&pager.getPaging()){
             int total = query.getResultList().size();
             pager.setTotal(total);
             //分页
             query.setFirstResult((pager.getPage()-1)* pager.getLimit());
             query.setMaxResults(pager.getLimit());
          }
          query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); //牺牲性能返回map类型数据
          return query.getResultList();
       }
       /**
        * 分页处理返回
        * @param query
        * @return
        */
       public static <T> List<T> findList(Query query, Map<String,Object> parms, Pageable pager){
          for (Map.Entry<String, Object> parm : parms.entrySet()) {
             query.setParameter(parm.getKey(),parm.getValue());
          }
          if(pager!=null&&pager.getPaging()){
             int total = query.getResultList().size();
             pager.setTotal(total);
             //分页
             query.setFirstResult((pager.getPage()-1)* pager.getLimit());
             query.setMaxResults(pager.getLimit());
          }
          query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); //牺牲性能返回map类型数据
          return query.getResultList();
       }
    
       public static <T> List<T> findList(Query query, Map<String,Object> parms, Pageable pager,Class<T> cla){
          List resultList = findList(query,parms,pager);
          resultList = BeanConvertUtil.convert(resultList,cla,true);
          return resultList;
       }
    
       public static <T> List<T> findList(Query query, List<Object> parms, Pageable pager,Class<T> cla){
          List resultList = findList(query,parms,pager);
          resultList = BeanConvertUtil.convert(resultList,cla,true);
          return resultList;
       }
    }