SpringBoot+BootStrapTable+PageHelper用户新增，删除，修改

转自：http://blog.csdn.net/damionew/article/details/78630895

前面已经配置好其他环境，现在就是在iframe中使用BootStrapTable

用户管理页面：增加，批量删除，修改，分页，修改是使用模态框获取一行数据

爬爬遇到的坑

1、使用BootStrapTable传递到后台时，分页时，queryParam方法传递pageNumber和pageSize传递到后台死活传不过去，找了好久，

[html]  view plain  copy
  1. <span style="white-space:pre">          </span>method:"POST",  
  2. <span style="white-space:pre">          </span>//极为重要，缺失无法执行queryParams，传递page参数  
  3. <span style="white-space:pre">          </span>contentType : "application/x-www-form-urlencoded",  
  4. <span style="white-space:pre">          </span>dataType:"json",  
  5. <span style="white-space:pre">          </span>url:'/user/pageInfo',   
  6. <span style="white-space:pre">          </span>queryParams:queryParam,  
  7. <span style="white-space:pre">          </span>pagination:true,//显示分页条：页码，条数等  
  8. <span style="white-space:pre">          </span>striped:true,//隔行变色  
  9. <span style="white-space:pre">          </span>pageNumber:1,//首页页码  
  10. <span style="white-space:pre">          </span>pageSize:10,//分页，页面数据条数  
加上这句
[html]  view plain  copy
  1. contentType : "application/x-www-form-urlencoded",  
就搞定了，这是我的情况。。

2、BootStrapTable获取一个表单中填入的值

[html]  view plain  copy
  1. var param = $("#addUserForm").serializeArray();  
BootStrapTable获取选中一行数据

[html]  view plain  copy
  1. var rows = $("#dataGrid").bootstrapTable('getSelections');  
3、获取选中一行的数据到模态框中

[html]  view plain  copy
  1. <span style="white-space:pre">      </span>//获取选中行的数据  
  2.         var rows = $("#dataGrid").bootstrapTable('getSelections');  
  3.         if(rows.length!=1){  
  4.             document.getElementById("tipContent").innerText="请选择一行数据";  
  5.             $("#Tip").modal('show');  
  6.         }  
  7.         else{  
  8.         var row = rows[0];  
  9.         $('#editId').val(row.id);  
  10.         $('#editAccount').val(row.account);  
  11.         $('#editPassword').val(row.password);  
  12.         $('#editName').val(row.name);  
  13.         $('#editSex').val(row.sex);  
  14.         $('#editEmail').val(row.email);  
  15.         $('#editPhone').val(row.phone);  
  16.         $('#editStates').val(row.states);  
  17.         $('#editCreated_at').val(row.created_at);  
  18.         $("#editModal").modal("show");  
  19.         }  
[html]  view plain  copy
  1. #editId是模态框里面input的id，row.id中的id是模态框一个input中的name属性。  
4、后台传递从数据库查到的数据需要转为json
[java]  view plain  copy
  1.     List<User> users =userService.getUserList();  
  2. <span style="white-space:pre">  </span>int total = users.size();  
  3. <span style="white-space:pre">  </span>PageHelper.startPage(pageNumber,pageSize);  
  4. <span style="white-space:pre">  </span>List<User> pageInfo=userService.getUserList();  
  5. <span style="white-space:pre">  </span>JSONObject result = new JSONObject();  
  6. <span style="white-space:pre">  </span>result.put("rows",pageInfo);  
  7. <span style="white-space:pre">  </span>result.put("total",total);  
  8. <span style="white-space:pre">  </span>System.out.println(result.toJSONString());  
  9. <span style="white-space:pre">  </span>return result.toJSONString();  
导入import com.alibaba.fastjson.JSONObject;

5、批量删除无非存入多个id，到后台循环调用删除。

[html]  view plain  copy
  1. function deleteUser(){  
  2.         var rows = $("#dataGrid").bootstrapTable("getSelections");  
  3.         var ids = [];  
  4.         var len = rows.length;  
  5.         debugger;  
  6.         for(var i=0;i<len;i++){  
  7.             ids.push(rows[i].id);  
  8.         }  
  9.         debugger;  
  10.         $.ajax({  
  11.             url:"/user/deleteUser",  
  12.             dataType:"json",  
  13.             traditional: true,//属性在这里设置  
  14.             method:"post",  
  15.             data:{  
  16.                 "ids":ids  
  17.             },  
  18.             success:function(data){  
  19.                 document.getElementById("tipContent").innerText="删除成功";  
  20.                 $("#Tip").modal('show');  
  21.                 $("#dataGrid").bootstrapTable("refresh");  
  22.             },  
  23.             error:function(){  
  24.                 document.getElementById("tipContent").innerText="删除失败";  
  25.                 $("#Tip").modal('show');  
  26.             }  
  27.         });  
  28.     }  
后台获取ajax传的数组

String[] list=request.getParameterValues("ids");

6、SpringBoot中templates使用thymeleaf时，<,>都报错，使用了&lt;，用了for，最后还是放到了别的包下面。这样在html里面就不会使用<,>

就记得这么些了。。

贴代码：index.html

[html]  view plain  copy
  1. <?xml version="1.0" encoding="utf-8" ?>  
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  3. <html lang="en" xmlns:th="http://www.thymeleaf.org">  
  4. <head th:include="back/header">  
  5. <title>Insert title here</title>  
  6. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />  
  7.   
  8. </head>  
  9. <body>  
  10.         <section class="content-header">  
  11.         <h1>用户管理</h1>  
  12.         </section>  
  13.         <section class="content table-content">  
  14.             <form class="form-inline" >  
  15.             <!-- 工具栏 -->  
  16.             <div id="toolbar">  
  17.                     <input type="button" value="新增用户" id="addBtn" data-toggle="modal" data-target="#addUserModal" class="btn btn-primary"></input>  
  18.                     <input type="button" value="修改用户" id="editBtn" data-toggle="modal" data-target="#editUserModal" class="btn btn-primary" onclick="editUser()"></input>  
  19.                     <input type="button" value="删除用户" id="deleteBtn" data-toggle="modal" data-target="#deleteUserModal" class="btn btn-primary" onclick="deleteUser()"></input>  
  20.             </div>  
  21.             <!-- bootstrapTable -->  
  22.             </form>  
  23.             <table id="dataGrid">  
  24.             </table>  
  25.         </section>  
  26.         <!-- 新增用户的模态框，在修改用户中将获取一行的值放入input中，改变一些参数继续使用 -->  
  27.         <div class="modal fade" id="addUserModal" tabindex="-1" role="dialog">  
  28.             <div class="modal-dialog" role="document">  
  29.                 <div class="modal-content">  
  30.                     <div class="modal-header">  
  31.                         <h3>新增用户</h3>  
  32.                     </div>  
  33.                     <div class="modal-body">  
  34.                         <form id="addUserForm" action="/user/addUser" method="post" class="form-horizontal">  
  35.                             <div class="form-group">  
  36.                                 <label for="inputAccount" class="col-sm-2 control-label">账户</label>  
  37.                                 <div class="col-sm-7">  
  38.                                     <input type="account" name="account" class="form-control" id="inputAccount" placeholder="账户"/>  
  39.                                 </div>  
  40.                                 <label id="errorAccount" for="inputAccount" class="col-sm-3 control-label"></label>  
  41.                             </div>  
  42.                             <div class="form-group" >  
  43.                                 <label for="inputPassword" class="col-sm-2 control-label">密码</label>  
  44.                                 <div class="col-sm-7">  
  45.                                     <input type="text" name="password" class="form-control" id="inputPassword" placeholder="密码"/>  
  46.                                 </div>  
  47.                                 <label id="errorPassword" for="inputPassword" class="col-sm-3 control-label"></label>  
  48.                             </div>  
  49.                             <div class="form-group">  
  50.                                 <label for="inputName" class="col-sm-2 control-label">姓名</label>  
  51.                                 <div class="col-sm-7">  
  52.                                     <input type="name" name="name" class="col-sm-4 form-control" id="inputName" placeholder="姓名"/>  
  53.                                 </div>  
  54.                                 <label id="errorName" for="inputName" class="col-sm-3 control-label"></label>  
  55.                             </div>  
  56.                             <div class="form-group">  
  57.                                 <label for="inputSex" class="col-sm-2 control-label">性别</label>  
  58.                                 <div class="col-sm-7">  
  59.                                     <input type="sex" name="sex" class="col-sm-4 form-control" id="inputSex" placeholder="性别"/>  
  60.                                 </div>  
  61.                                 <label id="errorSex" for="inputSex" class="col-sm-3 control-label"></label>  
  62.                             </div>  
  63.                             <div class="form-group">  
  64.                                 <label for="inputPhone" class="col-sm-2 control-label">手机</label>  
  65.                                 <div class="col-sm-7">  
  66.                                     <input type="phone" name="phone" class="col-sm-4 form-control" id="inputPhone" placeholder="手机"/>  
  67.                                 </div>  
  68.                                 <label id="errorPhone" for="inputPhone" class="col-sm-3 control-label"></label>  
  69.                             </div>  
  70.                             <div class="form-group">  
  71.                                 <label for="inputEmail" class="col-sm-2 control-label">邮箱</label>  
  72.                                 <div class="col-sm-7">  
  73.                                     <input type="email" name="email" class="col-sm-4 form-control" id="inputEmail" placeholder="邮箱"/>  
  74.                                 </div>  
  75.                                 <label id="errorEmail" for="inputEmail" class="col-sm-3 control-label"></label>  
  76.                             </div>  
  77.                         </form>  
  78.                     </div>  
  79.                     <div class="modal-footer">  
  80.                         <button type="button" id="conf" class="btn btn-default" onclick="addUser()">确定</button>  
  81.                         <button type="button" class="btn btn-default" data-dismiss="modal" onclick="resetAddModal()">取消</button>  
  82.                     </div>  
  83.                 </div>                  
  84.             </div>  
  85.         </div>  
  86.         <!-- 修改用户的模态框 -->  
  87.         <div class="modal fade" id="editModal" tabindex="-1" role="dialog">  
  88.             <div class="modal-dialog" role="document">  
  89.                 <div class="modal-content">  
  90.                     <div class="modal-header">  
  91.                         <h3>修改用户</h3>  
  92.                     </div>  
  93.                     <div class="modal-body">  
  94.                         <form id="editForm" method="post" class="form-horizontal">  
  95.                             <div class="form-group" style="display:none">  
  96.                                 <label for="editId" class="col-sm-2 control-label">ID</label>  
  97.                                 <div class="col-sm-7">  
  98.                                     <input type="id" name="id"   class="form-control" id="editId" placeholder="ID" />  
  99.                                 </div>  
  100.                                 <label id="errorId" for="editId" class="col-sm-3 control-label"></label>  
  101.                             </div>  
  102.                             <div class="form-group">  
  103.                                 <label for="inputAccount" class="col-sm-2 control-label">账户</label>  
  104.                                 <div class="col-sm-7">  
  105.                                     <input type="account" name="account" class="form-control" id="editAccount" placeholder="账户"/>  
  106.                                 </div>  
  107.                                 <label id="errorAccount" for="inputAccount" class="col-sm-3 control-label"></label>  
  108.                             </div>  
  109.                             <div class="form-group" >  
  110.                                 <label for="inputPassword" class="col-sm-2 control-label">密码</label>  
  111.                                 <div class="col-sm-7">  
  112.                                     <input type="text" name="password" class="form-control" id="editPassword" placeholder="密码"/>  
  113.                                 </div>  
  114.                                 <label id="errorPassword" for="inputPassword" class="col-sm-3 control-label"></label>  
  115.                             </div>  
  116.                             <div class="form-group">  
  117.                                 <label for="inputName" class="col-sm-2 control-label">姓名</label>  
  118.                                 <div class="col-sm-7">  
  119.                                     <input type="name" name="name" class="col-sm-4 form-control" id="editName" placeholder="姓名"/>  
  120.                                 </div>  
  121.                                 <label id="errorName" for="inputName" class="col-sm-3 control-label"></label>  
  122.                             </div>  
  123.                             <div class="form-group">  
  124.                                 <label for="inputSex" class="col-sm-2 control-label">性别</label>  
  125.                                 <div class="col-sm-7">  
  126.                                     <input type="sex" name="sex" class="col-sm-4 form-control" id="editSex" placeholder="性别"/>  
  127.                                 </div>  
  128.                                 <label id="errorSex" for="inputSex" class="col-sm-3 control-label"></label>  
  129.                             </div>  
  130.                             <div class="form-group">  
  131.                                 <label for="inputPhone" class="col-sm-2 control-label">手机</label>  
  132.                                 <div class="col-sm-7">  
  133.                                     <input type="phone" name="phone" class="col-sm-4 form-control" id="editPhone" placeholder="手机"/>  
  134.                                 </div>  
  135.                                 <label id="errorPhone" for="inputPhone" class="col-sm-3 control-label"></label>  
  136.                             </div>  
  137.                             <div class="form-group">  
  138.                                 <label for="inputEmail" class="col-sm-2 control-label">邮箱</label>  
  139.                                 <div class="col-sm-7">  
  140.                                     <input type="email" name="email" class="col-sm-4 form-control" id="editEmail" placeholder="邮箱"/>  
  141.                                 </div>  
  142.                                 <label id="errorEmail" for="inputEmail" class="col-sm-3 control-label"></label>  
  143.                             </div>  
  144.                             <div class="form-group">  
  145.                                 <label for="inputStates" class="col-sm-2 control-label">状态</label>  
  146.                                 <div class="col-sm-7">  
  147.                                     <input type="states" name="states" class="col-sm-4 form-control" id="editStates" placeholder="状态"/>  
  148.                                 </div>  
  149.                                 <label id="errorStates" for="inputStates" class="col-sm-3 control-label"></label>  
  150.                             </div>  
  151.                             <div class="form-group" style="display:none">  
  152.                                 <label for="inputCreated_at" class="col-sm-2 control-label">创建时间</label>  
  153.                                 <div class="col-sm-7">  
  154.                                     <input type="created_at" name="created_at" class="col-sm-4 form-control" id="editCreated_at" placeholder="创建时间" />  
  155.                                 </div>  
  156.                                 <label id="errorCreated_at" for="inputCreated_at" class="col-sm-3 control-label"></label>  
  157.                             </div>  
  158.                         </form>  
  159.                     </div>  
  160.                     <div class="modal-footer">  
  161.                         <button type="button" id="conf" class="btn btn-default" onclick="updateUser()">确定</button>  
  162.                         <button type="button" class="btn btn-default" data-dismiss="modal" onclick="resetAddModal()">取消</button>  
  163.                     </div>  
  164.                 </div>                  
  165.             </div>  
  166.         </div>  
  167.         <div class="modal fade" id="Tip" role="dialog">  
  168.             <div class="modal-dialog" role="document">  
  169.                 <div class="modal-content">  
  170.                     <div class="modal-header">  
  171.                         <h3>提示</h3>  
  172.                     </div>  
  173.                     <div class="modal-body" align="center">  
  174.                         <h4 id="tipContent">新增成功</h4>  
  175.                     </div>  
  176.                     <div class="modal-footer">  
  177.                         <button type="button" class="btn btn-default" data-dismiss="modal">确定</button>  
  178.                     </div>  
  179.                 </div>  
  180.             </div>  
  181.         </div>  
  182.         <div class="modal fade" id="updateEnd" role="dialog">  
  183.             <div class="modal-dialog" role="document">  
  184.                 <div class="modal-content">  
  185.                     <div class="modal-header">  
  186.                         <h3>提示</h3>  
  187.                     </div>  
  188.                     <div class="modal-body" align="center">  
  189.                         <h4 id="al">修改成功</h4>  
  190.                     </div>  
  191.                     <div class="modal-footer">  
  192.                         <button type="button" class="btn btn-default" data-dismiss="modal">确定</button>  
  193.                     </div>  
  194.                 </div>  
  195.             </div>  
  196.         </div>  
  197.         <div th:include="back/footer"></div>  
  198. </body>  
  199. <script type="text/javascript">  
  200.     $(function() {  
  201.         //初始加载  
  202.         initDataGrid();  
  203.     });  
  204.     function initDataGrid() {  
  205.         //创建bootstrapTable  
  206.         $("#dataGrid").bootstrapTable({  
  207.             method:"POST",  
  208.             //极为重要，缺失无法执行queryParams，传递page参数  
  209.             contentType : "application/x-www-form-urlencoded",  
  210.             dataType:"json",  
  211.             url:'/user/pageInfo',   
  212.             queryParams:queryParam,  
  213.             pagination:true,//显示分页条：页码，条数等  
  214.             striped:true,//隔行变色  
  215.             pageNumber:1,//首页页码  
  216.             pageSize:10,//分页，页面数据条数  
  217.             uniqueId:"id",//Indicate an unique identifier for each row  
  218.             sidePagination:"server",//在服务器分页  
  219.             height:tableModel.getHeight(),  
  220.             toolbar:"#toolbar",//工具栏  
  221.             columns : [{  
  222.                 checkbox:"true",  
  223.                 field : "box"  
  224.             },  {  
  225.                 title : "ID",  
  226.                 field : "id",  
  227.                 visible: false  
  228.             }, {  
  229.                 title : "账户",  
  230.                 field : "account"  
  231.             }, {  
  232.                 title : "密码",  
  233.                 field : "password"  
  234.             }, {  
  235.                 title : "姓名",  
  236.                 field : "name"  
  237.             }, {  
  238.                 title : "性别",  
  239.                 field : "sex"  
  240.             }, {  
  241.                 title : "手机",  
  242.                 field : "phone"  
  243.             }, {  
  244.                 title : "邮箱",  
  245.                 field : "email"  
  246.             }, {  
  247.                 title : "状态",  
  248.                 field : "states"  
  249.             }, {  
  250.                 title : "创建时间",  
  251.                 field : "created_at",  
  252.                 sortable : true  
  253.             }],  
  254.             search : true,//搜索  
  255.             searchOnEnterKey : true,  
  256.             showRefresh : true,//刷新  
  257.             showToggle : true//  
  258.   
  259.         });  
  260.     }  
  261.     function queryParam(params){  
  262.         var param = {  
  263.                 limit : this.limit, // 页面大小  
  264.                 offset : this.offset, // 页码  
  265.                 pageNumber : this.pageNumber,  
  266.                 pageSize : this.pageSize  
  267.         };  
  268.         return param;  
  269.     }  
  270.     //点击取消后清空表单中已写信息  
  271.     function resetAddModal(){  
  272.         document.getElementById("addUserForm").reset();  
  273.     }  
  274.     //新增用户  
  275.     function addUser(){  
  276.         var param = $("#addUserForm").serializeArray();  
  277.         debugger;  
  278.         $("#conf").attr("onclick","addUser()");  
  279.         $.ajax({  
  280.             url:"/user/addUser",  
  281.             method:"post",  
  282.             data:param,  
  283.             dataType:"json",  
  284.             success:function(data){  
  285.                 if(data.state=="success"){  
  286.                     document.getElementById("al").innerText="新增成功";  
  287.                     $("#addEnd").modal('show');  
  288.                     $("#addUserModal").modal('hide');  
  289.                     $("#dataGrid").bootstrapTable('refresh');  
  290.                 }  
  291.             },  
  292.             error:function(){  
  293.                 document.getElementById("al").innerText="新增失败";  
  294.                 $("#addEnd").modal('show');  
  295.             }  
  296.         });  
  297.     }  
  298.     //修改用户  
  299.     function editUser(){  
  300.         //获取选中行的数据  
  301.         var rows = $("#dataGrid").bootstrapTable('getSelections');  
  302.         if(rows.length!=1){  
  303.             document.getElementById("tipContent").innerText="请选择一行数据";  
  304.             $("#Tip").modal('show');  
  305.         }  
  306.         else{  
  307.         var row = rows[0];  
  308.         $('#editId').val(row.id);  
  309.         $('#editAccount').val(row.account);  
  310.         $('#editPassword').val(row.password);  
  311.         $('#editName').val(row.name);  
  312.         $('#editSex').val(row.sex);  
  313.         $('#editEmail').val(row.email);  
  314.         $('#editPhone').val(row.phone);  
  315.         $('#editStates').val(row.states);  
  316.         $('#editCreated_at').val(row.created_at);  
  317.         $("#editModal").modal("show");  
  318.         }  
  319.     }  
  320.     function updateUser(){  
  321.         var param = $("#editForm").serializeArray();  
  322.         //设为disable则无法获取  
  323.         $.ajax({  
  324.             url:"/user/updateUser",  
  325.             method:"post",  
  326.             data:param,  
  327.             dataType:"json",  
  328.             success:function(data){  
  329.                 if(data.state=="success"){  
  330.                     $("#editModal").modal("hide");  
  331.                     document.getElementById("tipContent").innerText="修改成功";  
  332.                     $("#Tip").modal('show');  
  333.                 }  
  334.             },  
  335.             error:function(data){  
  336.                 alert("wrong");  
  337.             }  
  338.         });  
  339.     }  
  340. </script>  
  341. </html>  
引入user.js

[javascript]  view plain  copy
  1. /** 
  2.  *  
  3.  */  
  4. function deleteUser(){  
  5.         var rows = $("#dataGrid").bootstrapTable("getSelections");  
  6.         var ids = [];  
  7.         var len = rows.length;  
  8.         debugger;  
  9.         for(var i=0;i<len;i++){  
  10.             ids.push(rows[i].id);  
  11.         }  
  12.         debugger;  
  13.         $.ajax({  
  14.             url:"/user/deleteUser",  
  15.             dataType:"json",  
  16.             traditional: true,//属性在这里设置  
  17.             method:"post",  
  18.             data:{  
  19.                 "ids":ids  
  20.             },  
  21.             success:function(data){  
  22.                 document.getElementById("tipContent").innerText="删除成功";  
  23.                 $("#Tip").modal('show');  
  24.                 $("#dataGrid").bootstrapTable("refresh");  
  25.             },  
  26.             error:function(){  
  27.                 document.getElementById("tipContent").innerText="删除失败";  
  28.                 $("#Tip").modal('show');  
  29.             }  
  30.         });  
  31.     }  
后台Controller

[java]  view plain  copy
  1. package com.damionew.website.controller.back;  
  2.   
  3. import java.text.SimpleDateFormat;  
  4. import java.util.ArrayList;  
  5. import java.util.Date;  
  6. import java.util.List;  
  7.   
  8. import javax.servlet.http.HttpServletRequest;  
  9. import javax.servlet.http.HttpServletResponse;  
  10.   
  11. import com.alibaba.fastjson.JSONObject;  
  12. import com.damionew.website.model.back.User;  
  13. import com.damionew.website.service.back.UserService;  
  14. import org.springframework.beans.factory.annotation.Autowired;  
  15. import org.springframework.stereotype.Controller;  
  16. import org.springframework.web.bind.annotation.RequestMapping;  
  17. import org.springframework.web.bind.annotation.RequestParam;  
  18. import org.springframework.web.bind.annotation.ResponseBody;  
  19. import com.github.pagehelper.PageHelper;  
  20.   
  21. @Controller  
  22. @RequestMapping("/user")  
  23. public class UserController {  
  24.     @Autowired  
  25.     private UserService userService;  
  26.     @RequestMapping("/insert")  
  27.     public void insert(User user) {  
  28.     System.out.println("before");  
  29.     userService.addUser(user);  
  30.     System.out.println("after");  
  31.     }  
  32.     @RequestMapping("/index")  
  33.     public String index(User user) {  
  34.     return "back/user/index";  
  35.     }  
  36.     @ResponseBody  
  37.     @RequestMapping(value="getUser",produces="html/text;charset=UTF-8")  
  38.     public  String queryUserList() {  
  39.     List<User> users =userService.getUserList();  
  40.     System.out.println();  
  41.     JSONObject result = new JSONObject();  
  42.     result.put("rows", users);  
  43.     System.out.println(result.toJSONString());  
  44.     return result.toJSONString();  
  45.     }  
  46.     @ResponseBody  
  47.     @RequestMapping(value="pageInfo",produces="html/text;charset=UTF-8")  
  48.     public  String pageInfo(@RequestParam int pageNumber,int pageSize,HttpServletResponse response) {  
  49.     response.setContentType("text/json");  
  50.     response.setCharacterEncoding("utf-8");  
  51.     List<User> users =userService.getUserList();  
  52.     int total = users.size();  
  53.     PageHelper.startPage(pageNumber,pageSize);  
  54.     List<User> pageInfo=userService.getUserList();  
  55.     JSONObject result = new JSONObject();  
  56.     result.put("rows",pageInfo);  
  57.     result.put("total",total);  
  58.     System.out.println(result.toJSONString());  
  59.     return result.toJSONString();  
  60.     }  
  61.     @ResponseBody  
  62.     @RequestMapping("/addUser")  
  63.     public String addUser(User user) {  
  64.     Date date = new Date();  
  65.     SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-mm-dd HH:mm:ss");  
  66.     String time = dateFormat.format(date);  
  67.     user.setCreated_at(time);  
  68.     user.setStates("1");  
  69.     System.out.println(user.getName());  
  70.     userService.addUser(user);  
  71.     System.out.println("success");  
  72.     JSONObject result = new JSONObject();  
  73.     result.put("state", "success");  
  74.     return result.toJSONString();  
  75.     }  
  76.     @ResponseBody  
  77.     @RequestMapping("/updateUser")  
  78.     public String updateUser(User user) {  
  79.     userService.updateUser(user);  
  80.     JSONObject result = new JSONObject();  
  81.     result.put("state", "success");  
  82.     return result.toJSONString();  
  83.     }  
  84.     @ResponseBody  
  85.     @RequestMapping("/deleteUser")  
  86.     public String deleteUser(HttpServletRequest request) {  
  87.     String[] list=request.getParameterValues("ids");  
  88.     System.out.println(list);  
  89.     for (int i = 0; i < list.length; i++) {  
  90.         String id = list[i];  
  91.         System.out.println(id);  
  92.         userService.deleteUser(id);  
  93.           
  94.     }  
  95.       
  96.     JSONObject result = new JSONObject();  
  97.     result.put("state", "success");  
  98.     return result.toJSONString();  
  99.     }  
  100. }  
UserMapper.xml

[html]  view plain  copy
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >  
  3. <mapper namespace="com.damionew.website.dao.back.UserDao">  
  4.     <select id="insert"  parameterType="string" resultType="User">  
  5.         insert into user(name,email) values("2","3")  
  6.     </select>  
  7.     <select id="getUserList"  parameterType="string" resultType="User">  
  8.         select * from user  
  9.     </select>  
  10.     <select id="addUser">  
  11.         insert into user(account,password,name,sex,phone,email,states,created_at)  
  12.         values  
  13.         (#{account},#{password},#{name},#{sex},#{phone},#{email},#{states},#{created_at})  
  14.     </select>  
  15.     <select id="updateUser">  
  16.         update user set account=#{account},password=#{password},name=#{name},sex=#{sex},phone=#{phone},  
  17.         email=#{email},states=#{states},created_at=#{created_at}  
  18.         where id = #{id}  
  19.     </select>  
  20.     <select id="deleteUser">  
  21.         delete from user where id = #{id}  
  22.     </select>  
  23. </mapper>  
posted @ 2018-03-20 08:52  Mr.zzz  阅读(74)  评论(0)  编辑  收藏  举报