【java】实体类中按照特定的字段进行升序/降序排序-白红宇

【java】实体类中按照特定的字段进行升序/降序排序

阅读量：7082 次

发布时间：2019-06-28

本文共 17311 字，大约阅读时间需要 57 分钟。

背景：

实际页面上所有的分值都是按照JSON格式存储在一个字符串中存储在同一个字段中：

{"ownPTotal":"10>0","ownOTotal":"8>0","ownTotal1":"18","ownTotal2":"80","ownTotal3":"20","ownTotal4":"118","leadTotal1":"20","leadTotal2":"80","leadTotal3":"20","leadTotal4":"120","chiefCheck1":"","chiefCheck2":"","leadTotal5":"140"}

现在需要按照其中的几种分值进行升序/降序的排序操作

解决方法：

【因为不是按照原实体的中的字段进行排序，因此需要新建一个实体，将原实体中有用的字段和需要使用的值从字段中抽离出来在新实体中设置成字段，如果需要进行排序的字段是原实体中就存在的，那就不需要新建实体了】

重点关注：

实现 Comparable接口需要实现的比较方法这里动态比较是按照 1.哪个字段进行排序 2.升序/降序

//排序方法    @Override    public int compareTo(NewMonthPerEntity o) {        double a1 = this.whichProperty.equals("leadTotal5") ? this.leadTotal5 : (this.whichProperty.equals("leadTotal4") ? this.leadTotal4 :(this.whichProperty.equals("ownTotal4") ? this.ownTotal4 :this.ownTotal4));        double a2 = o.whichProperty.equals("leadTotal5") ? o.leadTotal5 : (o.whichProperty.equals("leadTotal4") ? o.leadTotal4 :(o.whichProperty.equals("ownTotal4") ? o.ownTotal4 :o.ownTotal4));        if(this.ascDesc){
   //若是升序            return a1 > a2 ? 1  : -1;        }else{            return a1 > a2 ? -1 : 1;        }    }

【注意:这里 return a1 > a2 ? 1 : -1;并没有写成 return a1 > a2 ? 1 :(a1==a2 ? 0 :-1); 这个样子，是因为如果在比较的时候判定两个相等，那在放入TreeSet中时会发生覆盖现象】

新实体完整代码：

1 package com.agen.util;  2   3 public class NewMonthPerEntity implements Comparable
      
       {  4       5     private String monthPerId;            //月度考核Id  6     private String userId;                //用户Id  7     private String userName;            //用户名称  8     private String createDate;        //考核创建时间  9     private double leadTotal5;            //调控分值 10     private double leadTotal4;            //考评分值 11     private double ownTotal4;            //自评分值 12     private boolean ascDesc;            //true升序/false降序 13     private String whichProperty;        //需要对哪个分值排序 14      15      16      17      18      19     public String getMonthPerId() { 20         return monthPerId; 21     } 22  23     public void setMonthPerId(String monthPerId) { 24         this.monthPerId = monthPerId; 25     } 26     public String getUserId() { 27         return userId; 28     } 29     public void setUserId(String userId) { 30         this.userId = userId; 31     } 32     public String getUserName() { 33         return userName; 34     } 35     public void setUserName(String userName) { 36         this.userName = userName; 37     } 38     public String getCreateDate() { 39         return createDate; 40     } 41  42     public void setCreateDate(String createDate) { 43         this.createDate = createDate; 44     } 45  46     public double getLeadTotal5() { 47         return leadTotal5; 48     } 49     public void setLeadTotal5(double leadTotal5) { 50         this.leadTotal5 = leadTotal5; 51     } 52     public double getLeadTotal4() { 53         return leadTotal4; 54     } 55     public void setLeadTotal4(double leadTotal4) { 56         this.leadTotal4 = leadTotal4; 57     } 58  59     public double getOwnTotal4() { 60         return ownTotal4; 61     } 62  63     public void setOwnTotal4(double ownTotal4) { 64         this.ownTotal4 = ownTotal4; 65     } 66     public boolean isAscDesc() { 67         return ascDesc; 68     } 69  70     public void setAscDesc(boolean ascDesc) { 71         this.ascDesc = ascDesc; 72     } 73  74     public String getWhichProperty() { 75         return whichProperty; 76     } 77     public void setWhichProperty(String whichProperty) { 78         this.whichProperty = whichProperty; 79     } 80  81     public NewMonthPerEntity(String monthPerId, String userId, String userName, 82             String createDate, double leadTotal5, double leadTotal4, 83             double ownTotal4) { 84         super(); 85         this.monthPerId = monthPerId; 86         this.userId = userId; 87         this.userName = userName; 88         this.createDate = createDate; 89         this.leadTotal5 = leadTotal5; 90         this.leadTotal4 = leadTotal4; 91         this.ownTotal4 = ownTotal4; 92     } 93  94  95  96  97  98     public NewMonthPerEntity(String monthPerId, String userId, String userName, 99             String createDate, double leadTotal5, double leadTotal4,100             double ownTotal4, boolean ascDesc, String whichProperty) {101         super();102         this.monthPerId = monthPerId;103         this.userId = userId;104         this.userName = userName;105         this.createDate = createDate;106         this.leadTotal5 = leadTotal5;107         this.leadTotal4 = leadTotal4;108         this.ownTotal4 = ownTotal4;109         this.ascDesc = ascDesc;110         this.whichProperty = whichProperty;111     }112 113 114 115 116 117 118     //排序方法119     @Override120     public int compareTo(NewMonthPerEntity o) {121         double a1 = this.whichProperty.equals("leadTotal5") ? this.leadTotal5 : (this.whichProperty.equals("leadTotal4") ? this.leadTotal4 :(this.whichProperty.equals("ownTotal4") ? this.ownTotal4 :this.ownTotal4));122         double a2 = o.whichProperty.equals("leadTotal5") ? o.leadTotal5 : (o.whichProperty.equals("leadTotal4") ? o.leadTotal4 :(o.whichProperty.equals("ownTotal4") ? o.ownTotal4 :o.ownTotal4));123         if(this.ascDesc){
    //若是升序124             return a1 > a2 ? 1  : -1;125         }else{126             return a1 > a2 ? -1 : 1;127         }128     }129     130     131     132     133     134 }

View Code

@RequestMapping("allMonthPer")    @ResponseBody    public TreeSet
     
       allMonthPer(HttpServletRequest request,boolean ascDesc,String whichProperty) {//-----------------部分代码--------------------------------------------------- . . . .       //原实体 得到的List        DetachedCriteria criteria = DetachedCriteria.forClass(Monthper.class);        criteria.add(Restrictions.in("userId", userIds));        List
      
        monthPers = monthperService.list(criteria);      //新建TreeSet 将原实体的List 对应的放置在新的实体中，放入TreeSet的时候就已经是按照传入【按照 哪个字段排序/升序或降序 】 排好顺序的        TreeSet
       
         newSet = new TreeSet
        
         ();        for (Monthper monthper : monthPers) {            String totalStr = monthper.getTotalStr();             double leadTotal5 = Double.parseDouble(JSONObject.fromObject(totalStr).getString("leadTotal5"));             double leadTotal4 = Double.parseDouble(JSONObject.fromObject(totalStr).getString("leadTotal4"));             double ownTotal4 = Double.parseDouble(JSONObject.fromObject(totalStr).getString("ownTotal4"));                        NewMonthPerEntity entity = new NewMonthPerEntity(monthper.getMonthPerId(),monthper.getUserId(),userService.get(monthper.getUserId()).getUserName(),monthper.getCreateDate().toLocaleString(),leadTotal5,leadTotal4,ownTotal4);            entity.setAscDesc(ascDesc);//设置升序/降序            if("".equals(whichProperty) || null == whichProperty){                entity.setWhichProperty("ownTotal4");            }else{                entity.setWhichProperty(whichProperty);            }                        newSet.add(entity);        }                        return newSet; //在前台  只需要$.each取出来 追加到页面就好    }

效果如下图：

附带前台jsp代码

1 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> 2 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; 6 %> 7  8  9 10   11     考核列表12     13     
      14     
      15     
          16     
      17     18     
      19        20 21   22   23   24     25     
      
       26           
       
        27                
        
          28                  
         月度绩效考评列表29                        30                    
         31                   
         32                   
         
          33                       
          
           34                           
           
            35 
            
             36 
             39 
            
40 
           
41                           
           
            42 
            
             43 
             44 
            
45 
           
46                           
           
            47 
            
             48 
             49 
            
50 
           
51                           
           
            52 
            
             53 
             54 
            
55 
           
56                         
          
57                   
         58                   59              
        
 60           
       
61           
       
        62           
        63           
        64           
        65           66                 
        
         67                           
           68                             
69                           
70                           
71                           
72                           
73                           
74                           
75                           
76                         
77                  
                                          考核月份            员工名称            考评时间            调控分值            考评分值            自评分值            操作           
         
        
78           
       
79     
      
80     81   82   83   84   85   86   87   88

View Code

附带前台js代码

1 function refreshAll(ascDesc,whichProperty){  2     $("table tbody tr").not(":first").remove();  3     $.ajax({url:"../monthPerCon/allMonthPer.htmls",  4         dataType:'json',  5         type:"post",  6         data:{ascDesc:ascDesc,whichProperty:whichProperty},  7         traditional:false,  8         success:function(data){  9             var temp =""; 10             $.each(data,function(i,d){ 11                 temp += '' 12                             +'  ' 13                                 +'' 14                                 +'' 15                             +'' 16                             +'' 17                                 +(new Date(d.createDate).getMonth()+"月考核") 18                             +'' 19                             +'' 20                                 +'' 21                                 +d.userName 22                             +'' 23                             +'' 24                                 +d.createDate 25                             +'' 26                             +'' 27                                 +'【调控分值：'+d.leadTotal5+'】' 28                             +'' 29                             +'' 30                                 +'【考评分值：'+d.leadTotal4+'】' 31                             +'' 32                             +'' 33                                 +'【自评分值：'+d.ownTotal4+'】' 34                             +'' 35                             +'' 36                                 +'详情      删除'     37                             +'' 38                         +''; 39                 $(".whichProperty").val(d.whichProperty); 40                 $(".ascDesc").val(d.ascDesc); 41             }); 42             $(".firstTr").after(temp); 43              44              45             /*//判断 此时按那列排序 升序降序 改变图标 46             var whichProperty = $(".whichProperty").val(); 47             var ascDesc = $(".ascDesc").val(); 48             var thisSpan; 49             var cla = ""; 50             whichProperty == "ownTotal4"? thisSpan = $("span").eq(2):(whichProperty == "leadTotal4"? thisSpan = $("span").eq(1) :thisSpan = $("span").eq(0)); 51             ascDesc == "true" ? cla = "glyphicon glyphicon-sort-by-attributes" : cla="glyphicon glyphicon-sort-by-attributes-alt"; 52             $(thisSpan).attr("class",cla);*/ 53         } 54     });     55 } 56  57  58  59  60  61 function mohu(ascDesc,whichProperty,dep,us,mon){ 62      63     $("table tbody tr").not(":first").remove(); 64     $.ajax({url:"../monthPerCon/mohuAllMonthPer.htmls", 65         dataType:'json', 66         type:"post", 67         data:{ascDesc:ascDesc,whichProperty:whichProperty,departmentId:dep,userName:us,month:mon}, 68         traditional:false, 69         success:function(data){ 70             var temp =""; 71             $.each(data,function(i,d){ 72                 temp += '' 73                         +'  ' 74                             +'' 75                             +'' 76                         +'' 77                         +'' 78                             +(new Date(d.createDate).getMonth()+"月考核") 79                         +'' 80                         +'' 81                             +'' 82                             +d.userName 83                         +'' 84                         +'' 85                             +d.createDate 86                         +'' 87                         +'' 88                             +'【调控分值：'+d.leadTotal5+'】' 89                         +'' 90                         +'' 91                             +'【考评分值：'+d.leadTotal4+'】' 92                         +'' 93                         +'' 94                             +'【自评分值：'+d.ownTotal4+'】' 95                         +'' 96                         +'' 97                             +'详情      删除'     98                         +'' 99                     +'';100             });101             $(".firstTr").after(temp);102             103         }104     });    105 106 }107 108 109 110 111 112 $(document).ready(function(){113     refreshAll();114     115     //升序 降序116     $("span").click(function(){117         118         var whichProperty = $(this).attr("alt");119         if($(this).attr("class") == "glyphicon glyphicon-sort"){120             $(this).attr("class","glyphicon glyphicon-sort-by-attributes-alt");121         }else if($(this).attr("class") == "glyphicon glyphicon-sort-by-attributes-alt"){122             $(this).attr("class","glyphicon glyphicon-sort-by-attributes");123         }else if($(this).attr("class") == "glyphicon glyphicon-sort-by-attributes"){124             $(this).attr("class","glyphicon glyphicon-sort-by-attributes-alt");125         }126         127         $("span").not(this).attr("class","glyphicon glyphicon-sort");128         var ascDesc = $(this).attr("class") == "glyphicon glyphicon-sort" ? false : ($(this).attr("class") == "glyphicon glyphicon-sort-by-attributes-alt" ? false : true);129         130         //判断是否模糊查询131          var dep = $(".dep option:selected").val();132          var us = $(".us").val();133          var mon = $(".mon").val();134          if(dep !="" || us !="" || mon !=""){
    //只要模糊查询有值135              if(( parseInt(mon)<0 || parseInt(mon)>12 )){136                  layer.msg("月份不正确",{icon:2,time:1000});137                  $(".mon").val("");138              }else{139                  mohu(ascDesc,whichProperty,dep,us,mon);140              }141          }else{
    //否则  查询142              refreshAll(ascDesc,whichProperty);143          }144         145     });146     147     148     149     $(document).on("click",".aClick",function(){150         var monthPerId = $(this).parents("tr").children().first().find("input:hidden").val();151         location.href = "../monthPerCon/showThisMonper.htmls?monthPerId="+monthPerId;152     });153     $(document).on("click",".Adelete",function(){154         var operationId = $(".operationId").val();//操作人的ID155         var userId = $(this).parents("tr").children().eq(2).find(":hidden").val();//本条考核的人员156         if(operationId != userId){157             layer.msg("非本人无法删除！",{icon:2,time:2000});158         }else{159             var monthPerId = $(this).parents("tr").children().first().find("input:hidden").val();160             var leadTotal4 = JSON.parse($(this).parents("tr").children().eq(4).find(":hidden").val()).leadTotal4;161             if( !(leadTotal4 == undefined || leadTotal4=="") ){162                 layer.msg("经理已经考评无法删除！");163             }else{164                 $.ajax({url:"../monthPerCon/deleteThisMonper.htmls",165                     dataType:'json',166                     type:"post",167                     data:{monthPerId:monthPerId},168                     traditional:false,169                     success:function(data){170                         if(data){171                             layer.msg("删除成功",{icon:1,time:2000},function(){172                                 refreshAll();173                             });174                         }else{175                             layer.msg("删除失败",{icon:2,time:2000},function(){176                                 refreshAll();177                             });178                         }179                         180                     }181                 });182             }183         }184         185 //        location.href = "../monthPerCon/deleteThisMonper.htmls?monthPerId="+monthPerId;186     });187     188     //跳转到本月考核页面189     $(".thisMonth").click(function(){190         location.href = "../monthPerCon/perContent.htmls";191     });192     193     194     //部门195     $.getJSON("../department/showAlldepartment.htmls", function(data){196           if(data!=null){197               var temp = "";198               $.each(data,function(i,a){199                   temp+="";200               });201               $('.dep option').first().after(temp);202           }203     });204     205     206     //模糊查询207      $(".mohu").click(function(){208          var dep = $(".dep option:selected").val();209          var us = $(".us").val();210          var mon = $(".mon").val();211          if(( parseInt(mon)<0 || parseInt(mon)>12 )){212              layer.msg("月份不正确",{icon:2,time:1000});213              $(".mon").val("");214          }else{215              mohu(false,"ownTotal4",dep,us,mon);216          }217          218      });219     220     221 });

View Code

转载地址：http://rnlml.baihongyu.com/

你可能感兴趣的文章