c/c++语言开发共享JPA Specification常用查询+排序实例

目录

• jpa specification常用查询+排序
• 1.第一步：继承父类
• 2.第二步
• jpa specification复杂查询+排序
• 需求
• 开始了
• 一、dao
• 二、service
• 三、排序
• 前端
• 结束语

  public interface tblcarton2rcardlogrepository extends jparepository<tblcarton2rcardlog, string>,jpaspecificationexecutor<tblcarton2rcardlog> {

  tblcarton2rcardlogrepository.findall(new specification<tblcarton2rcardlog>() {      @override      public  predicate topredicate(root<tblcarton2rcardlog> root, criteriaquery<?> query,criteriabuilder cb) {          list<predicate> list = new arraylist<predicate>();          list.add(cb.equal(root.get("cartonno").as(string.class), cartonno));//某普通字段          list.add(cb.equal(root.get("id").get("rcard").as(string.class), rcard));//主键中某字段          list.add(cb.like(root.get("mocode").as(string.class), "%" + mocode + "%"));//like          list.add(cb.between(root.get("frozendate").as(long.class), frozendatestart, frozendateend));//between and          list.add(cb.greaterthanorequalto(root.get("id").get("rcard").as(string.class), rcardstart));//大于等于          list.add(root.get("id").get("lotno").as(string.class).in(lotnos));//in          //order by packdate desc,packtime desc          predicate[] p = new predicate[list.size()];          query.where(cb.and(list.toarray(p)));          query.orderby(cb.desc(root.get("packdate")),cb.desc(root.get("packtime")));          return query.getrestriction();      }  });  

  @data  public class deptsort {  private string id;//编码  private string name;//名称  private string highdeptname;//上级部门  private string principal;//负责人  private string depttype;//部门类型  private string enable;//启用  }

  public responsemodel table(@requestparam("search")string search,  @requestparam("pagenumber")integer pagenumber,  @requestparam("pagesize")integer pagesize,  @requestbody deptsort deptsort){  responsemodel model = null;  try {  list<sort.order> orders = new arraylist<sort.order>();  if (stringutils.isnotblank(deptsort.getid())){  orders.add(new sort.order(sort.direction.fromstring(deptsort.getid()),"id"));  }  if (stringutils.isnotblank(deptsort.getname())){  orders.add(new sort.order(sort.direction.fromstring(deptsort.getname()),"name"));  }  if (stringutils.isnotblank(deptsort.gethighdeptname())){  orders.add(new sort.order(sort.direction.fromstring(deptsort.gethighdeptname()),"highdeptname"));  }  if (stringutils.isnotblank(deptsort.getprincipal())){  orders.add(new sort.order(sort.direction.fromstring(deptsort.getprincipal()),"principal"));  }  if (stringutils.isnotblank(deptsort.getdepttype())){  orders.add(new sort.order(sort.direction.fromstring(deptsort.getdepttype()),"depttype"));  }  if (stringutils.isnotblank(deptsort.getenable())){  orders.add(new sort.order(sort.direction.fromstring(deptsort.getenable()),"enable"));  }  //orders不能为空，所以如果为空设置按id排序[/code][code] if (orders.size() == 0){  orders.add(new sort.order(sort.direction.asc,"id"));  }  sort sort = new sort(orders);  pageable pageable = new pagerequest(pagenumber,pagesize,sort);  page<businessdept> all = service.findall(search, pageable);  model = responsemodel.getsuccessresponsemodel().setdata(all);  }catch (exception e){  e.printstacktrace();  model = responsemodel.getfailedresponsemodel();  }  return model;  }

  list<sort.order> orders = new arraylist<sort.order>();

  orders.add(new sort.order(sort.direction.fromstring(deptsort.getenable()),"enable"))

  hibernate:   /* select  count(generatedalias0)   from  businessdept as generatedalias0   where  (  generatedalias0.name like :param0   )   and (  generatedalias0.deleteis=1   ) */ select  count(businessde0_.id) as col_0_0_   from  t_department businessde0_   where  (  businessde0_.name like ?  )   and businessde0_.delete_is=1  hibernate:   /* select  generatedalias0   from  businessdept as generatedalias0   where  (  generatedalias0.name like :param0   )   and (  generatedalias0.deleteis=1   )   order by  generatedalias0.depttype asc,  generatedalias0.enable desc */ select  businessde0_.id as id1_3_,  businessde0_.delete_is as delete_i2_3_,  businessde0_.dept_type as dept_typ3_3_,  businessde0_.enable as enable4_3_,  businessde0_.high_dept_id as high_dep5_3_,  businessde0_.high_dept_name as high_dep6_3_,  businessde0_.name as name7_3_,  businessde0_.principal as principa8_3_   from  t_department businessde0_   where  (  businessde0_.name like ?  )   and businessde0_.delete_is=1   order by  businessde0_.dept_type asc,  businessde0_.enable desc limit ?