一：前台代码如下

1   2   3   4 
       5   6     
       7     
       8     
       9     
      10     
      11      12      13      14      15      16      17      18      19      20      21      70  71  72  73     
     
       74         75          
      
        76          
       
         77                 
        
          78                      
          79                      
         
           80                      
          标题/内容: 81                       
           82                      
          用户名:  83                       
           84                       
          频道:  85                        
           94                     
          品牌:  95                        
          104                     
          分类: 105                       106                     
          107 全部108 出售109 求购110 111                     
          帖子状态: 112                        
          113 全部114 未删除115 已删除116 置顶117 118             119                     
         
120                     
         
          121                     
          发布时间:122                      
           -123                      
          124                         
          查询125                     
         
126                     
         
          127                         
          全选128                         
          反选129                         
          置顶130                         
          管理员删除131                         
          取消置顶132                         
          
           133 
           134 多选135 单选136 137 138 
          
139                     140         
         
141                 
        
142             
       
143         144      
      
145     
     
146     
     
      147         148          149     
150     
     
      151         
      
       152             后台处理中。。。153         
      
154     
     
155 156     468 469 

 

二：后台返回的数据格式

 　　后台返回的数据格式和经典的easyui的数据格式是一样的

　　数据格式：

　　{"total":67,"errmsg":"查询成功","errcode":1,"rows":[{"postId":77,"dealType":0,"title":"理解","partNo":null,"content":"理解[图片]","location":null,"tradeType":0,"brandId":0,"quantity":0,"contacts":"SakuraAoi","contactNumber":null,"color":null,"channelId":1,"createDate":"2018-10-16 10:12:19","updateDate":null,"status":0,"isDelete":0,"isAdmindel":0,"isTop":0,"replyNumber":0,"readNumber":0,"thumbNumber":0,"authorId":0,"isOem":0,"type":0,"amount":0.0,"channelPostAttach":[{"attachId":99,"postId":77,"uploadDate":1539655939000,"attachName":"record-attach/sell/371-20181016101221.png","type":10121001,"typeName":null,"attachNameUrl":""}],"nickName":"SakuraAoi","avatar":"","channelName":"新车交易","brandName":"长安铃木","startDate":null,"endDate":null,"brandIds":null,"channelIds":null,"strBrandIds":null,"strChannelIds":null,"begin":0,"end":0,"dealTypes":null,"isDeletes":null,"item":null,"value":0,"userId":0,"actId":0,"dealTypeName":null,"tradeTypeName":null,"isTopName":null,"createDate2":null}]}

三：视图效果

四：后台数据的获取

　　　　后台数据的获取为一对多，因为一个帖子会包含多个图片附件。

　　帖子实体类：

public class BsChannelPost {    private int postId;    private int dealType;    private String title;    private String partNo;    private String content;    private String location;    private int tradeType;    private int brandId;    private int quantity;    private String contacts;    private String contactNumber;    private String color;    private int channelId;    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")     private Date createDate;    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")     private Date updateDate;    private int status;    private int isDelete;    private int isAdmindel;    private int isTop;    private int replyNumber;    private int readNumber;    private int thumbNumber;    private int authorId;    private int isOem;    private int type;    private double amount;    private List
     
       channelPostAttach;//附件        private String nickName;    private String avatar;    private String channelName;    private String brandName;        private String startDate;    private String endDate;    private List
      
        brandIds;    private List
       
         channelIds;    private String strBrandIds;    private String strChannelIds;    private int begin;    private int end;    private String dealTypes;    private String isDeletes;        private String item;    private int value;    private int userId;    private int actId;        private String dealTypeName;    private String tradeTypeName;    private String isTopName;    private String createDate2;}
       
      
     

　　　附件实体类：

import lombok.Data;@Data//lombok 免写get setpublic class BsChannelPostAttach {    private int attachId;    private int postId;    private Date uploadDate;    private String attachName;    private int type;    private String typeName;    private String attachNameUrl;}

 

 　　　dao：　

1 
     
       2         
          3         
          4     
      5      6      7         select attach_id attachId,post_id postId,upload_date uploadDate,attach_name attachName,type from bs_channel_post_attach where post_id = #{postId} order by attach_id  8      9     10     11     select p.post_id postId,u.nickname nickName,c.channel_name channelName,b.brand_name brandName,p.create_date createDate,p.title title,p.content content,p.part_no partNo,p.contacts contacts,u.avatar avatar,p.is_top isTop,12     is_delete isDelete,p.is_admindel isAdmindel,p.channel_id channelId13     from bs_channel_post p left join bs_channel c on p.channel_id=c.channel_id left join bs_brand b14     on p.brand_id=b.brand_id left join bs_user u on p.author_id=u.user_id  where 1=115     16         and (p.content like '%${content}%' or p.title like '%${content}%' )17     18     19         and u.nickname like '%${nickName}%'20     21     22         and p.deal_type=#{dealType}23     24     25         and (is_delete=0 and is_admindel=0)26     27     28         and (is_delete=1 or is_admindel=1)29     30     31         and is_top=132     33     34               and p.brand_id in35                 36                     #{id}37                  38     39     40               and p.channel_id in41                 42                     #{id}43                  44     45     46           and p.create_date>#{beginDate}47       48       49           and p.create_date <#{endDate}50       51       52           and p.create_date between #{beginDate} and #{endDate}53       54         order by p.create_date desc limit #{begin},#{end}55