EasyUI左邊樹菜單和datagrid分頁

2019-11-14 23:53:22
字體：大中小
來源：轉載
供稿：網友
//這個頁面是Home.html  1 <!DOCTYPE html>  2 <html>  3   <head>  4     5     6       <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">  7     <meta charset="utf-8">  8     <meta http-equiv="X-UA-Compatible" content="IE=edge">  9     <meta name="viewport" content="width=device-width,initial-scale=1"> 10       <link rel="stylesheet" href="EasyUI-1.4.2/themes/default/easyui.CSS" type="text/css"></link> 11       <link rel="stylesheet" href="EasyUI-1.4.2/themes/icon.css" type="text/css"></link> 12      13     <title>Home.html</title> 14      15   </head> 16    17   <body class="easyui-layout" > 18     <!-- 正上方panel -->  19     <div data-options="region:'north',title:'頂部',split:true" style="height:100px;padding: 10px;"></div>  20     <!-- 正左方 --> 21     <div data-options="region:'west',title:'菜單欄',split:true" style="width:280px;padding1:1px;overflow:hidden;"> 22          23         <div class="easyui-accordion" style="position: absolute; top: 27px; left: 0px; right: 0px; bottom: 0px;"> 24   25             <div title="博文管理" selected="true" iconcls="icon-save" style="overflow: auto; padding: 10px;"> 26             <ul id="LeftTree" class="easyui-tree"></ul>   27  28             </div> 29             <div title="新聞管理" iconcls="icon-reload" style="padding: 10px;"> 30                 <ul class="easyui-tree" id="LeftTree"></ul>  31             </div> 32             <div title="資源管理" style="padding: 10px;"> 33                 content3  34             </div> 35         </div> 36     </div> 37     <!-- 正中間 --> 38     <div data-options="region:'center',title:'功能區'" style="padding:5px;background:#eee;"> 39         <div class="easyui-tabs" id="Tabs" fit="true" border="false">   40             <div title="歡迎頁" style="padding:20px;overflow:hidden;">    41                 <div style="margin-top:20px;">   42                     <h3>你好，歡迎來到權限管理系統</h3>   43                 </div>   44             </div>   45         </div> 46     </div>  47     <!-- 正右方 --> 48     <div data-options="region:'east',iconCls:'icon-reload',title:'右邊',split:true" style="width:280px;"></div>  49     <!-- 正下方panel -->  50     <div data-options="region:'south',title:'底部 ',split:true" style="height:100px;"align="center"></div> 51      52   </body> 53    54   <script type="text/javascript" src="EasyUI-1.4.2/jquery.min.js"></script> 55   <script type="text/Javascript" src="EasyUI-1.4.2/jquery.easyui.min.js"></script> 56   <script type="text/javascript" src="EasyUI-1.4.2/locale/easyui-lang-zh_CN.js"></script> 57   <script type="text/javascript"> 58    59   /**   60  * 創建新選項卡   61  * @param title    選項卡標題   62  * @param url      選項卡遠程調用路徑   63  */  64    function AddTab(title, url) { 65                if($("#Tabs").tabs("exists",title)){ 66                    $("#Tabs").tabs("select",title); 67                }else{ 68                    CreateFrame(url); 69                    $("#Tabs").tabs("add",{    70                  title:title,    71                  content:CreateFrame(url), 72                   closable:true, 73                   cache : false 74                   });  75                } 76                  77            }  78             79        80        81       function CreateFrame(url){ 82           var content="<iframe src='"+url+"' width='100%' height='100%' frameborder='0' scrolling='auto' ></iframe>"; 83           return content; 84       } 85  86   87 //動態創建樹菜單 88     $(function(){ 89         $("#LeftTree").tree({ 90          91              data:[{   92                 "id":"1",     93                 "text":"文件", 94                 "state":"closed", 95                 //創建子節點    96                 "children":[{ 97                     "id":"1.1",   98                     "text":"用戶管理",  99                     "state":"closed",100                     "children":[{101                         "id":"1.1.1", 102                         "text":"photoshop",103                         "url":"content.html",104                         /* "checked":true */105                     },{    106                         "id": "1.1.2",    107                         "text":"Sub Bookds", 108                         "state":"closed",109                         //創建子孫節點 110                         "children":[{111                             "id":"1.1.2_1",112                             "text":"HTML5",113                             "url":"http://www.baidu.com"114                             /* "checked":true */115                             },{    116                             "id": "1.1.2_2",    117                             "text":"CSS3", 118                             "url":"http://www.QQ.com"119                         }]  120                     }]      121                     /* "checked":true,  */     122                 },{123                     "id":"1.2",124                     "text":"微博審核",    125                     "state":"closed",    126                     "attributes":{127                         "url":"/demo/book/abc",    128                         "//這里是Content.html頁面 因為center只執行body里面的內容 所以我這個頁面只寫了body,JS也要放在body里面否則是不執行的,我剛才說了 只執行body里面的內容 1   <body> 2   <!--<div class="easyui-tabs" id="Tab" fit="true" border="false"> 3           <div title="歡迎頁" style="overflow:hidden;">   --> 4                 <!-- <div style="margin-top:20px;">   5                     <h3>你好，歡迎來到權限管理系統</h3>   6                 </div>  -->  7     //只要一個table就可以了 8                 <table id="dg"></table> 9        <!--   </div>  10   </div> -->11   12   <script type="text/javascript">13       $(function(){14           $("#dg").datagrid({15               /* title:"用戶管理", */  //可要可不要16               url: "List.action",17               method: "POST",18               singleSelect:true,//如果為true，則只允許選擇一行。19               ctrlSelect:true, //在啟用多行選擇的時候允許使用Ctrl鍵+鼠標點擊的方式進行多選操作。20               fitColumns:true, //真正的自動展開/收縮列的大小，以適應網格的寬度，防止水平滾動。21               striped:true,    //是否顯示斑馬線效果22               fit:true,23               /* loadMsg:"Processing, please wait …", */ //在從遠程站點加載數據的時候顯示提示消息。24               rownumbers: true, //如果設置為true則會添加一列來顯示行號。25               pagination: true, //如果為true，則在DataGrid控件底部顯示分頁工具欄。26               pageSize: 10, //在設置分頁屬性的時候初始化頁面數據條數。27               pageList: [10, 20, 50], //在設置分頁屬性的時候 初始化頁面數據顯示條數選擇列表28               toolbar:[{29                   text:"增加",30                   iconCls:"icon-add",31                   handler:function(){32                   }33               },"-",{34                   text:"刪除",35                   iconCls:"icon-remove",36                   handler:function(){37                   }38               },"-",{39                   text:"修改",40                   iconCls:"icon-edit",41                   handler:function(){42                   43                   }44               },"-",{45                   text:"查詢",46                   iconCls:"icon-search",47                   handler:function(){48                   49                   }50               } ],51               52               53               54               columns:[[55                   //這里的field對應的是后臺的字段屬性56                   {field:"id",title:"編號",width:100},57                   {field:"userName",title:"用戶名",width:100},58                   {field:"passWord",title:"密碼",width:100},59                   {field:"email",title:"Email",width:100},60                   {field:"mobile",title:"電話",width:100},61               ]]62           });63       });64   </script>65   </body>
//后臺分頁JavaBean
 1 public class Page<T> { 2         private Integer pageIndex; // 當前頁碼 3         private Integer pageSize; // 每頁的數據量 4         private Integer pageCount; // 總頁碼 5          6         /*private Integer page; // 當前頁碼 7         private Integer rows; // 每頁的數據量 8         private Integer total; // 總頁碼 9 */        private Integer count; // count統計(總數據量 或 其他)10         private double sum;    // sum統計11         private List<T> list;12         13         // 構造方法14         public Page(int pageIndex, int pageSize){15             this.pageIndex = pageIndex;16             this.pageSize = pageSize;17         }18         19         public Integer getPageIndex() {20             return pageIndex;21         }22         public void setPageIndex(Integer pageIndex) {23             this.pageIndex = pageIndex;24         }25         public Integer getPageSize() {26             return pageSize;27         }28         public void setPageSize(Integer pageSize) {29             this.pageSize = pageSize;30         }31         public Integer getPageCount() {32             return pageCount;33         }34         public void setPageCount(Integer pageCount) {35             this.pageCount = pageCount;36         }37         public Integer getCount() {38             return count;39         }40 41     public void setCount(Integer count) {42         this.count = count;43 44         if (this.pageSize != 0) {45             // 順帶將總頁碼給賦值了46             this.pageCount = this.count % this.pageSize == 0 ? this.count47                     / this.pageSize : this.count / this.pageSize + 1;48         }49     }50         public double getSum() {51             return sum;52         }53         public void setSum(double sum) {54             this.sum = sum;55         }56         public List<T> getList() {57             return list;58         }59         public void setList(List<T> list) {60             this.list = list;61         }62         63         64 }
//BaseDao
 1     public List  FindList(final String bhql,int pageIndex,int pageSize) { 2         final int limit = pageSize; 3  4         final int start = (pageIndex - 1) * limit; 5  6         /*final String bhql = hql;*/ 7  8         List<Object> list = null; 9 10         list = this.getHibernateTemplate().executeFind(new HibernateCallback() {11 12             public Object doInHibernate(session session)13                     throws HibernateException, SQLException {14                 List result = session.createQuery(bhql).setFirstResult(start)15                         .setMaxResults(limit).list();16                 /*if(session!=null){17                     session.close();18                 }*/19                 return result;20             }21 22         });23         return list;24     }
//DaoImpl
 1 public class UsersDaoImpl extends BaseDao implements UsersDao { 2  3     public Page<Users> FindList(Users user, Integer pageIndex, Integer pageSize) { 4         String Ahql="From Users where 1=1"; 5          6         List<Users> pageList=super.FindList(Ahql, pageIndex, pageSize); 7          8         String Bhql="Select count(*) From Users";  //這句話可不要 直接調用下面的方法 9         10         Long s=(Long) super.getCount(Bhql);11         int count=s.intValue();12         13         Page<Users> page=new Page<Users>(pageIndex, pageSize);14         /*page.setPageIndex(pageIndex);15         page.setPageSize(pageSize);*/16         page.setList(pageList);17         page.setCount(count);18         return page;19     }20 21     public Integer getObject() {22         String hql="Select count(*) From Users";23         Long s=(Long) super.getCount(hql);24         return s.intValue();25     }26     27 28 }
//Action
 1 public class UsersAction extends ActionSupport { 2  3     /** 4      *  5      */ 6     private static final long serialVersionUID = 1L; 7      8     private int page; 9     private int rows;10 11     public Users getUser() {12         return user;13     }14 15     public void setUser(Users user) {16         this.user = user;17     }18 19 20     public Page<Users> getUserList() {21         return userList;22     }23 24     public void setUserList(Page<Users> userList) {25         this.userList = userList;26     }27 28     private Users user;29     private UsersBiz userBiz;30     public UsersBiz getUserBiz() {31         return userBiz;32     }33 34     public void setUserBiz(UsersBiz userBiz) {35         this.userBiz = userBiz;36     }37 38     private Page<Users> userList;39     40     41     public void getList() throws IOException {42         ServletActionContext.getResponse().setContentType(43                 "text/json;charset=utf-8");44         Users user=(Users) ActionContext.getContext().getSession().get("users");45         Page<Users> pageList= userBiz.FindList(user, page,rows);46         JSONObject json = new JSONObject();47         json.put("rows", pageList.getList());48         json.put("total", pageList.getCount());49         ServletActionContext.getResponse().getWriter().print(json);50 51     }52 53     public int getPage() {54         return page;55     }56 57     public void setPage(int page) {58         this.page = page;59     }60 61     public int getRows() {62         return rows;63     }64 65     public void setRows(int rows) {66         this.rows = rows;67     }68     69 }
好累啊,看在我這么無私奉獻的份上,就高抬貴手頂一頂,最怕高抬臭腳來踩了。。。^v^