Bootstrap4+MySQL前后端综合实训-Day06-PM【MD5加码-生成32位md5码、ResultData.java、分页查询用户数据、添加用户按钮的实现】

﹏ヽ暗。殇╰゛Y 2022-12-23 06:57 78阅读 0赞

【Bootstrap4前端框架+MySQL数据库】前后端综合实训【10天课程 博客汇总表 详细笔记】【附：实训所有代码】

目录

MD5加码 生成32位md5码

ResultData.java

分页查询用户数据

分页查询——user_manager.html

分页查询——UserInfoDao.java

分页查询——SelectUserByPageServlet.java

添加用户按钮的实现

添加用户——user_manager.html

添加用户——UserInfoDao.java

添加用户——AddUserServlet.java

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70

MD5加码 生成32位md5码

20201124222251173.png

  1. package com.newcapec.utils;
  3. import java.security.MessageDigest;
  5. public class MD5Utils {
  7.     /***
  8.      * MD5加码 生成32位md5码
  9.      */
  10.     public static String stringMD5(String inStr) {
  11.         MessageDigest md5 = null;
  12.         try {
  13.             md5 = MessageDigest.getInstance("MD5");
  14.         } catch (Exception e) {
  15.             System.out.println(e.toString());
  16.             e.printStackTrace();
  17.             return "";
  18.         }
  19.         char[] charArray = inStr.toCharArray();
  20.         byte[] byteArray = new byte[charArray.length];
  21.         for (int i = 0; i < charArray.length; i++)
  22.             byteArray[i] = (byte) charArray[i];
  23.         byte[] md5Bytes = md5.digest(byteArray);
  24.         StringBuffer hexValue = new StringBuffer();
  25.         for (int i = 0; i < md5Bytes.length; i++) {
  26.             int val = ((int) md5Bytes[i]) & 0xff;
  27.             if (val < 16)
  28.                 hexValue.append("0");
  29.             hexValue.append(Integer.toHexString(val));
  30.         }
  31.         return hexValue.toString();
  32.     }
  34.     /**
  35.      * 加密解密算法 执行一次加密，两次解密
  36.      */
  37.     public static String convertMD5(String inStr) {
  38.         char[] a = inStr.toCharArray();
  39.         for (int i = 0; i < a.length; i++) {
  40.             a[i] = (char) (a[i] ^ 't');
  41.         }
  42.         String s = new String(a);
  43.         return s;
  44.     }
  46.     // 测试主函数
  47.     public static void main(String args[]) {
  48.         String s = new String("1233");
  49.         System.out.println("原始：" + s);
  50.         System.out.println("MD5后：" + stringMD5(s));
  51.         System.out.println("加密的：" + convertMD5(s));
  52.         System.out.println("解密的：" + convertMD5(convertMD5(s)));
  53.     }
  55. }

ResultData.java

  1. package com.newcapec.entity;
  3. public class ResultData<T> {
  5.     private int total;
  6.     private T rows;
  7.     private String code;
  9.     public ResultData() {
  10.         super();
  11.     }
  13.     public ResultData(int total, T rows, String code) {
  14.         super();
  15.         this.total = total;
  16.         this.rows = rows;
  17.         this.code = code;
  18.     }
  20.     public int getTotal() {
  21.         return total;
  22.     }
  24.     public void setTotal(int total) {
  25.         this.total = total;
  26.     }
  28.     public T getRows() {
  29.         return rows;
  30.     }
  32.     public void setRows(T rows) {
  33.         this.rows = rows;
  34.     }
  36.     public String getCode() {
  37.         return code;
  38.     }
  40.     public void setCode(String code) {
  41.         this.code = code;
  42.     }
  44.     @Override
  45.     public String toString() {
  46.         return "ResultData [total=" + total + ", rows=" + rows + ", code=" + code + "]";
  47.     }
  49. }

分页查询用户数据

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2

分页查询——user_manager.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <title></title>
  7.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8.     <link rel="stylesheet" href="../bootstrap4/css/bootstrap.min.css">
  9.     <link rel="stylesheet" type="text/css" href="../font-awesome-4.7.0/css/font-awesome.min.css" />
  10.     <link href="../bootstrap-table/bootstrap-table.min.css" rel="stylesheet" />
  11.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  12.     <script src="../jquery/jquery.min.js"></script>
  13.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  14.     <script src="../js/popper.min.js"></script>
  15.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  16.     <script src="../bootstrap4/js/bootstrap.min.js"></script>
  17.     <script src="../bootstrap-table/bootstrap-table.js"></script>
  18.     <script src="../bootstrap-table/locale/bootstrap-table-zh-CN.js"></script>
  19.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  20.     <title>用户管理</title>
  21. </head>
  23. <body>
  24.     <div style="padding: 10px">
  25.         <div id="toolbar">
  26.             <button type="button" class="btn btn-info"><i class="fa fa-plus"></i> 添加</button>
  27.         </div>
  28.         <table id="userInfoTab" class="table table-hover table-bordered table-striped">
  29.         </table>
  30.     </div>
  32.     <script>
  33.         //异步加载表格数据
  34.         $('#userInfoTab').bootstrapTable({
  35.             url: '../SelectAllServlet',         //请求后台的URL（*）
  36.             method: 'get',                      //请求方式（*）
  37.             toolbar: '#toolbar',                //工具按钮用哪个容器
  38.             striped: true,                      //是否显示行间隔色
  39.             cache: false,                       //是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）
  40.             pagination: true,                   //是否显示分页（*）
  41.             queryParams: function (params) {
  42.                 var temp = {   //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
  43.                     limit: params.limit,   //页面大小
  44.                     offset: params.offset  //页码
  45.                     //departmentname: $("#txt_search_departmentname").val(),
  46.                     //statu: $("#txt_search_statu").val()
  47.                 };
  48.                 return temp;
  49.             },
  50.             sidePagination: "server",           //分页方式：client客户端分页，server服务端分页（*）
  51.             pageNumber: 1,                       //初始化加载第一页，默认第一页
  52.             pageSize: 10,                       //每页的记录行数（*）
  53.             pageList: [10, 15, 20, 25],        //可供选择的每页的行数（*）
  54.             search: true,                       //是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大
  55.             strictSearch: true,
  56.             //showRefresh: true,                  //是否显示刷新按钮
  57.             clickToSelect: true,                //是否启用点击选中行
  58.             uniqueId: "userId",                     //每一行的唯一标识，一般为主键列
  59.             //showToggle:true,                    //是否显示详细视图和列表视图的切换按钮
  60.             //cardView: false,                    //是否显示详细视图
  61.             columns: [{
  62.                 checkbox: true
  63.             }, {
  64.                 field: 'userId',
  65.                 title: '用户Id'
  66.             }, {
  67.                 field: 'userName',
  68.                 title: '用户名'
  69.             }, {
  70.                 field: 'createTime',
  71.                 title: '创建时间'
  72.             }, {
  73.                 field: 'updateTime',
  74.                 title: '更新时间'
  75.             }]
  76.         });
  77.     </script>
  78. </body>
  80. </html>

分页查询——UserInfoDao.java

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.Date;
  9. import java.util.List;
  11. import com.newcapec.entity.UserInfoEntity;
  12. import com.newcapec.utils.DBUtils;
  14. public class UserInfoDao implements BaseDao<UserInfoEntity> {
  16.     public UserInfoEntity login(String userName, String userPwd) throws ClassNotFoundException, SQLException {
  17.         UserInfoEntity userInfoEntity = null;
  18.         Connection connection = DBUtils.openConn();
  19.         String sql = "select * from user_info where user_name = ? and user_pwd = ?";
  20.         PreparedStatement statement = connection.prepareStatement(sql);
  21.         statement.setString(1, userName);
  22.         statement.setString(2, userPwd);
  23.         ResultSet resultSet = statement.executeQuery();
  24.         while (resultSet.next()) {
  25.             int userId = resultSet.getInt("user_id");
  26.             Date createTime = resultSet.getTimestamp("create_time");
  27.             Date updateTime = resultSet.getTimestamp("update_time");
  28.             userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  29.         }
  30.         resultSet.close();
  31.         statement.close();
  32.         connection.close();
  33.         return userInfoEntity;
  34.     }
  36.     @Override
  37.     public boolean insert(UserInfoEntity t) throws ClassNotFoundException, SQLException {
  38.         boolean flag = false;
  39.         // 获取与数据库的连接
  40.         Connection connection = DBUtils.openConn();
  41.         // ?表示占位符 可以解决sql注入的问题
  42.         String sql = "insert into user_info (user_name,user_pwd,create_time) values (?,?,now())";
  43.         PreparedStatement statement = connection.prepareStatement(sql);
  44.         statement.setString(1, t.getUserName());
  45.         statement.setString(2, t.getUserPwd());
  46.         // 执行sql语句
  47.         int count = statement.executeUpdate();
  48.         if (count > 0) {
  49.             flag = true;
  50.         }
  51.         statement.close();
  52.         connection.close();
  53.         return flag;
  54.     }
  56.     @Override
  57.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  58.         boolean flag = false;
  59.         // 获取连接
  60.         Connection connection = DBUtils.openConn();
  61.         // sql语句
  62.         String sql = "delete from user_info where user_id = ?";
  63.         // 预处理对象
  64.         PreparedStatement statement = connection.prepareStatement(sql);
  65.         // 添加参数
  66.         statement.setInt(1, id);
  67.         // 执行预处理对象
  68.         int count = statement.executeUpdate();
  69.         if (count > 0) {
  70.             flag = true;
  71.         }
  72.         statement.close();
  73.         connection.close();
  74.         return flag;
  75.     }
  77.     @Override
  78.     public boolean update(UserInfoEntity t) throws ClassNotFoundException, SQLException {
  79.         boolean flag = false;
  80.         // 获取连接
  81.         Connection connection = DBUtils.openConn();
  82.         // sql语句
  83.         String sql = "update user_info set user_name = ?,user_pwd = ? where user_id = ?";
  84.         // 预处理对象
  85.         PreparedStatement statement = connection.prepareStatement(sql);
  86.         // 添加参数
  87.         statement.setString(1, t.getUserName());
  88.         statement.setString(2, t.getUserPwd());
  89.         statement.setInt(3, t.getUserId());
  90.         // 执行预处理对象
  91.         int count = statement.executeUpdate();
  92.         if (count > 0) {
  93.             flag = true;
  94.         }
  95.         statement.close();
  96.         connection.close();
  97.         return flag;
  98.     }
  100.     @Override
  101.     public UserInfoEntity selectById(int id) throws ClassNotFoundException, SQLException {
  102.         UserInfoEntity userInfoEntity = null;
  103.         Connection connection = DBUtils.openConn();
  104.         String sql = "select * from user_info where user_id = ?";
  105.         PreparedStatement statement = connection.prepareStatement(sql);
  106.         statement.setInt(1, id);
  107.         ResultSet resultSet = statement.executeQuery();
  108.         while (resultSet.next()) {
  109.             int userId = resultSet.getInt("user_id");
  110.             String userName = resultSet.getString("user_name");
  111.             String userPwd = resultSet.getString("user_pwd");
  112.             Date createTime = resultSet.getTimestamp("create_time");
  113.             Date updateTime = resultSet.getTimestamp("update_time");
  114.             userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  115.         }
  116.         resultSet.close();
  117.         statement.close();
  118.         connection.close();
  119.         return userInfoEntity;
  120.     }
  122.     @Override
  123.     public List<UserInfoEntity> selectAll() throws ClassNotFoundException, SQLException {
  124.         List<UserInfoEntity> list = new ArrayList<>();
  125.         Connection connection = DBUtils.openConn();
  126.         String sql = "select * from user_info";
  127.         PreparedStatement statement = connection.prepareStatement(sql);
  128.         ResultSet resultSet = statement.executeQuery();
  129.         while (resultSet.next()) {
  130.             int userId = resultSet.getInt("user_id");
  131.             String userName = resultSet.getString("user_name");
  132.             String userPwd = resultSet.getString("user_pwd");
  133.             Date createTime = resultSet.getTimestamp("create_time");
  134.             Date updateTime = resultSet.getTimestamp("update_time");
  135.             UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  136.             list.add(userInfoEntity);
  137.         }
  138.         resultSet.close();
  139.         statement.close();
  140.         connection.close();
  141.         return list;
  142.     }
  144.     public List<UserInfoEntity> selectByPage(int offset, int limit) throws ClassNotFoundException, SQLException {
  145.         List<UserInfoEntity> list = new ArrayList<>();
  146.         Connection connection = DBUtils.openConn();
  147.         String sql = "select * from user_info  limit ?,?";
  148.         PreparedStatement statement = connection.prepareStatement(sql);
  149.         statement.setInt(1, offset);
  150.         statement.setInt(2, limit);
  151.         ResultSet resultSet = statement.executeQuery();
  152.         while (resultSet.next()) {
  153.             int userId = resultSet.getInt("user_id");
  154.             String userName = resultSet.getString("user_name");
  155.             String userPwd = resultSet.getString("user_pwd");
  156.             Date createTime = resultSet.getTimestamp("create_time");
  157.             Date updateTime = resultSet.getTimestamp("update_time");
  158.             UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  159.             list.add(userInfoEntity);
  160.         }
  161.         resultSet.close();
  162.         statement.close();
  163.         connection.close();
  164.         return list;
  165.     }
  167.     public int selectCount() throws ClassNotFoundException, SQLException {
  168.         int count = 0;
  169.         Connection connection = DBUtils.openConn();
  170.         String sql = "SELECT COUNT(*) AS userCount FROM user_info";
  171.         PreparedStatement statement = connection.prepareStatement(sql);
  172.         ResultSet resultSet = statement.executeQuery();
  173.         while (resultSet.next()) {
  174.             count = resultSet.getInt("userCount");
  175.         }
  176.         resultSet.close();
  177.         statement.close();
  178.         connection.close();
  179.         return count;
  180.     }
  182.     @Override
  183.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
  184.         boolean flag = false;
  185.         // 获取连接
  186.         Connection connection = DBUtils.openConn();
  187.         // sql语句
  188.         String sql = "delete from user_info where user_id = ?";
  189.         // 预处理对象
  190.         PreparedStatement statement = connection.prepareStatement(sql);
  191.         // 添加参数
  192.         for (int id : ids) {
  193.             statement.setInt(1, id);
  194.             statement.addBatch();
  195.         }
  196.         int[] result = statement.executeBatch();
  197.         // 执行预处理对象
  198.         // int count = statement.executeUpdate();
  199.         if (result.length > 0) {
  200.             flag = true;
  201.         }
  202.         statement.close();
  203.         connection.close();
  204.         return flag;
  205.     }
  206. }

分页查询——SelectUserByPageServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  6. import java.util.List;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.annotation.WebServlet;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  14. import com.alibaba.fastjson.JSON;
  15. import com.newcapec.dao.UserInfoDao;
  16. import com.newcapec.entity.ResultData;
  17. import com.newcapec.entity.UserInfoEntity;
  19. /**
  20.  * Servlet implementation class SelectAllServlet
  21.  */
  22. @WebServlet(name = "/SelectAllServlet", urlPatterns = "/SelectAllServlet")
  23. public class SelectUserByPageServlet extends HttpServlet {
  25.     private static final long serialVersionUID = 1L;
  26.     private UserInfoDao userInfoDao = new UserInfoDao();
  28.     /**
  29.      * @see HttpServlet#HttpServlet()
  30.      */
  31.     public SelectUserByPageServlet() {
  32.         super();
  33.         // TODO Auto-generated constructor stub
  34.     }
  36.     /**
  37.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  38.      *      response)
  39.      */
  40.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41.         response.setCharacterEncoding("utf-8");
  42.         response.setContentType("text/json;charset=utf-8");
  43.         // 当前页码
  44.         // 页大小
  45.         int offset = Integer.parseInt(request.getParameter("offset"));
  46.         int limit = Integer.parseInt(request.getParameter("limit"));
  47.         // bootstrap-table插件需要后台传回total/rows
  48.         ResultData<List<UserInfoEntity>> data = new ResultData<>();
  49.         try {
  50.             data.setRows(userInfoDao.selectByPage(offset, limit));
  51.             data.setTotal(userInfoDao.selectCount());
  52.             response.getWriter().write(JSON.toJSONString(data));
  53.         } catch (ClassNotFoundException | SQLException e1) {
  54.             // TODO 自动生成的 catch 块
  55.             e1.printStackTrace();
  56.         }
  57.     }
  59.     /**
  60.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  61.      *      response)
  62.      */
  63.     protected void doPost(HttpServletRequest request, HttpServletResponse response)    throws ServletException, IOException {
  64.         // TODO Auto-generated method stub
  65.         doGet(request, response);
  66.     }
  68. }

添加用户按钮的实现

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 6

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 7

添加用户——user_manager.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <title></title>
  7.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8.     <link rel="stylesheet" href="../bootstrap4/css/bootstrap.min.css">
  9.     <link rel="stylesheet" type="text/css" href="../font-awesome-4.7.0/css/font-awesome.min.css" />
  10.     <link href="../bootstrap-table/bootstrap-table.min.css" rel="stylesheet" />
  11.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  12.     <script src="../jquery/jquery.min.js"></script>
  13.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  14.     <script src="../js/popper.min.js"></script>
  15.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  16.     <script src="../bootstrap4/js/bootstrap.min.js"></script>
  17.     <script src="../bootstrap-table/bootstrap-table.js"></script>
  18.     <script src="../bootstrap-table/locale/bootstrap-table-zh-CN.js"></script>
  19.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  20.     <title>用户管理</title>
  21.     <script type="text/javascript">
  22.         function select() {
  23.             var rows = $('#userInfoTab').bootstrapTable('getSelections');
  24.             console.log(rows);
  25.         }
  26.         function addUserInfo() {
  27.             var userName = $("#addUserName").val();
  28.             var userPwd = $("#addUserPwd").val();
  29.             var userdata = {
  30.                 "userName": userName,
  31.                 "userPwd": userPwd
  32.             };
  33.             $.ajax({
  34.                 type: "POST",
  35.                 url: "../AddUserServlet",
  36.                 data: userdata,
  37.                 success: function (msg) {
  38.                     if (msg.flag) {
  39.                         alert("成功");
  40.                     } else {
  41.                         alert("失败");
  42.                     }
  43.                 }
  44.             });
  45.         }
  46.     </script>
  47. </head>
  49. <body>
  50.     <div style="padding: 10px">
  51.         <div id="toolbar" style="display: flex;">
  52.             <button type="button" class="btn btn-info" data-toggle="modal" data-target="#addUserInfo"><i class="fa fa-plus"></i> 添加</button>
  53.             <button type="button" class="btn btn-danger"><i class="fa fa-minus"></i> 批量删除</button>
  54.             <input type="text" placeholder="请输入用户名" id="userName" value="zhangsan" /><button class="btn btn-info" onclick='search()'><i class="fa fa-search"></i></button>
  55.         </div>
  56.         <table id="userInfoTab" class="table table-hover table-bordered table-striped">
  58.         </table>
  59.         <!-- 模态框 -->
  60.         <div class="modal fade" id="addUserInfo">
  61.             <div class="modal-dialog">
  62.                 <div class="modal-content">
  64.                     <!-- 模态框头部 -->
  65.                     <div class="modal-header bg-info">
  66.                         <h4 class="modal-title">添加用户信息</h4>
  67.                         <button type="button" class="close" data-dismiss="modal">×</button>
  68.                     </div>
  70.                     <!-- 模态框主体 -->
  71.                     <div class="modal-body">
  72.                         <form>
  73.                             <div class="input-group mb-3">
  74.                                 <div class="input-group-prepend">
  75.                                     <span class="input-group-text"><i class="fa fa-user"></i></span>
  76.                                 </div>
  77.                                 <input type="text" id="addUserName" class="form-control" placeholder="Username">
  78.                             </div>
  79.                             <div class="input-group mb-3">
  80.                                 <div class="input-group-prepend">
  81.                                     <span class="input-group-text"><i class="fa fa-lock"></i></span>
  82.                                 </div>
  83.                                 <input type="password" id="addUserPwd" class="form-control" placeholder="userpwd">
  84.                             </div>
  85.                         </form>
  86.                     </div>
  88.                     <!-- 模态框底部 -->
  89.                     <div class="modal-footer">
  90.                         <button type="button" class="btn btn-success" data-dismiss="modal" onclick=addUserInfo()>添加</button>
  91.                         <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
  92.                     </div>
  94.                 </div>
  95.             </div>
  96.         </div>
  97.     </div>
  99.     <script>
  100.         var icons = {
  101.             paginationSwitchDown: 'fa-caret-square-down',
  102.             paginationSwitchUp: 'fa-caret-square-up',
  103.             refresh: 'fa-refresh',
  104.             toggleOff: 'fa-toggle-off',
  105.             toggleOn: 'fa-toggle-on',
  106.             columns: 'fa-th-list',
  107.             fullscreen: 'fa-arrows-alt',
  108.             detailOpen: 'fa-plus',
  109.             detailClose: 'fa-minus'
  110.         };
  111.         //异步加载表格数据
  112.         $('#userInfoTab').bootstrapTable({
  113.             url: '../SelectAllServlet',         //请求后台的URL（*）
  114.             method: 'get',                      //请求方式（*）
  115.             toolbar: '#toolbar',                //工具按钮用哪个容器
  116.             striped: true,                      //是否显示行间隔色
  117.             cache: false,                       //是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）
  118.             pagination: true,                   //是否显示分页（*）
  119.             icons: icons,                       //重新定义图标 修复图标加载失败问题
  120.             queryParams: function (params) {
  121.                 var temp = {   //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
  122.                     limit: params.limit,   //页面大小
  123.                     offset: params.offset  //页码
  124.                     //userName: $("#userName").val()
  125.                     //statu: $("#txt_search_statu").val()
  126.                 };
  127.                 return temp;
  128.             },
  129.             sidePagination: "server",    //分页方式：client客户端分页，server服务端分页（*）
  130.             pageNumber: 1,               //初始化加载第一页，默认第一页
  131.             pageSize: 10,                //每页的记录行数（*）
  132.             pageList: [10, 15, 20, 25],  //可供选择的每页的行数（*）
  133.             //search: true,              //是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大
  134.             strictSearch: true,
  135.             showRefresh: true,           //是否显示刷新按钮
  136.             clickToSelect: true,         //是否启用点击选中行
  137.             uniqueId: "userId",          //每一行的唯一标识，一般为主键列
  138.             //showToggle:true,           //是否显示详细视图和列表视图的切换按钮
  139.             //cardView: false,           //是否显示详细视图
  140.             columns: [{
  141.                 checkbox: true
  142.             }, {
  143.                 field: 'userId',
  144.                 title: '用户Id'
  145.             }, {
  146.                 field: 'userName',
  147.                 title: '用户名'
  148.             }, {
  149.                 field: 'createTime',
  150.                 title: '创建时间'
  151.             }, {
  152.                 field: 'updateTime',
  153.                 title: '更新时间'
  154.             }, {
  155.                 field: 'userId',
  156.                 title: '编辑',
  157.                 formatter: function (value, row, index) {
  158.                     var e = '<a class="btn btn-waring" href="#" mce_href="#" title="编辑" onclick="edit(\''
  159.                         + row.id
  160.                         + '\')"><i class="fa fa-edit"></i></a> ';
  161.                     return e;
  162.                 }
  163.             }]
  164.         });
  165.     </script>
  166. </body>
  168. </html>

添加用户——UserInfoDao.java

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.Date;
  9. import java.util.List;
  11. import com.newcapec.entity.UserInfoEntity;
  12. import com.newcapec.utils.DBUtils;
  14. public class UserInfoDao implements BaseDao<UserInfoEntity> {
  16.     public UserInfoEntity login(String userName, String userPwd) throws ClassNotFoundException, SQLException {
  17.         UserInfoEntity userInfoEntity = null;
  18.         Connection connection = DBUtils.openConn();
  19.         String sql = "select * from user_info where user_name = ? and user_pwd = ?";
  20.         PreparedStatement statement = connection.prepareStatement(sql);
  21.         statement.setString(1, userName);
  22.         statement.setString(2, userPwd);
  23.         ResultSet resultSet = statement.executeQuery();
  24.         while (resultSet.next()) {
  25.             int userId = resultSet.getInt("user_id");
  26.             Date createTime = resultSet.getTimestamp("create_time");
  27.             Date updateTime = resultSet.getTimestamp("update_time");
  28.             userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  29.         }
  30.         resultSet.close();
  31.         statement.close();
  32.         connection.close();
  33.         return userInfoEntity;
  34.     }
  36.     @Override
  37.     public boolean insert(UserInfoEntity t) throws ClassNotFoundException, SQLException {
  38.         boolean flag = false;
  39.         // 获取与数据库的连接
  40.         Connection connection = DBUtils.openConn();
  41.         // ?表示占位符 可以解决sql注入的问题
  42.         String sql = "insert into user_info (user_name,user_pwd,create_time) values (?,?,now())";
  43.         PreparedStatement statement = connection.prepareStatement(sql);
  44.         statement.setString(1, t.getUserName());
  45.         statement.setString(2, t.getUserPwd());
  46.         // 执行sql语句
  47.         int count = statement.executeUpdate();
  48.         if (count > 0) {
  49.             flag = true;
  50.         }
  51.         statement.close();
  52.         connection.close();
  53.         return flag;
  54.     }
  56.     @Override
  57.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  58.         boolean flag = false;
  59.         // 获取连接
  60.         Connection connection = DBUtils.openConn();
  61.         // sql语句
  62.         String sql = "delete from user_info where user_id = ?";
  63.         // 预处理对象
  64.         PreparedStatement statement = connection.prepareStatement(sql);
  65.         // 添加参数
  66.         statement.setInt(1, id);
  67.         // 执行预处理对象
  68.         int count = statement.executeUpdate();
  69.         if (count > 0) {
  70.             flag = true;
  71.         }
  72.         statement.close();
  73.         connection.close();
  74.         return flag;
  75.     }
  77.     @Override
  78.     public boolean update(UserInfoEntity t) throws ClassNotFoundException, SQLException {
  79.         boolean flag = false;
  80.         // 获取连接
  81.         Connection connection = DBUtils.openConn();
  82.         // sql语句
  83.         String sql = "update user_info set user_name = ?,user_pwd = ? where user_id = ?";
  84.         // 预处理对象
  85.         PreparedStatement statement = connection.prepareStatement(sql);
  86.         // 添加参数
  87.         statement.setString(1, t.getUserName());
  88.         statement.setString(2, t.getUserPwd());
  89.         statement.setInt(3, t.getUserId());
  90.         // 执行预处理对象
  91.         int count = statement.executeUpdate();
  92.         if (count > 0) {
  93.             flag = true;
  94.         }
  95.         statement.close();
  96.         connection.close();
  97.         return flag;
  98.     }
  100.     @Override
  101.     public UserInfoEntity selectById(int id) throws ClassNotFoundException, SQLException {
  102.         UserInfoEntity userInfoEntity = null;
  103.         Connection connection = DBUtils.openConn();
  104.         String sql = "select * from user_info where user_id = ?";
  105.         PreparedStatement statement = connection.prepareStatement(sql);
  106.         statement.setInt(1, id);
  107.         ResultSet resultSet = statement.executeQuery();
  108.         while (resultSet.next()) {
  109.             int userId = resultSet.getInt("user_id");
  110.             String userName = resultSet.getString("user_name");
  111.             String userPwd = resultSet.getString("user_pwd");
  112.             Date createTime = resultSet.getTimestamp("create_time");
  113.             Date updateTime = resultSet.getTimestamp("update_time");
  114.             userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  115.         }
  116.         resultSet.close();
  117.         statement.close();
  118.         connection.close();
  119.         return userInfoEntity;
  120.     }
  122.     @Override
  123.     public List<UserInfoEntity> selectAll() throws ClassNotFoundException, SQLException {
  124.         List<UserInfoEntity> list = new ArrayList<>();
  125.         Connection connection = DBUtils.openConn();
  126.         String sql = "select * from user_info";
  127.         PreparedStatement statement = connection.prepareStatement(sql);
  128.         ResultSet resultSet = statement.executeQuery();
  129.         while (resultSet.next()) {
  130.             int userId = resultSet.getInt("user_id");
  131.             String userName = resultSet.getString("user_name");
  132.             String userPwd = resultSet.getString("user_pwd");
  133.             Date createTime = resultSet.getTimestamp("create_time");
  134.             Date updateTime = resultSet.getTimestamp("update_time");
  135.             UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  136.             list.add(userInfoEntity);
  137.         }
  138.         resultSet.close();
  139.         statement.close();
  140.         connection.close();
  141.         return list;
  142.     }
  144.     public List<UserInfoEntity> selectByPage(int offset, int limit) throws ClassNotFoundException, SQLException {
  145.         List<UserInfoEntity> list = new ArrayList<>();
  146.         Connection connection = DBUtils.openConn();
  147.         String sql = "select * from user_info  limit ?,?";
  148.         PreparedStatement statement = connection.prepareStatement(sql);
  149.         statement.setInt(1, offset);
  150.         statement.setInt(2, limit);
  151.         ResultSet resultSet = statement.executeQuery();
  152.         while (resultSet.next()) {
  153.             int userId = resultSet.getInt("user_id");
  154.             String userName = resultSet.getString("user_name");
  155.             String userPwd = resultSet.getString("user_pwd");
  156.             Date createTime = resultSet.getTimestamp("create_time");
  157.             Date updateTime = resultSet.getTimestamp("update_time");
  158.             UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  159.             list.add(userInfoEntity);
  160.         }
  161.         resultSet.close();
  162.         statement.close();
  163.         connection.close();
  164.         return list;
  165.     }
  167.     public int selectCount() throws ClassNotFoundException, SQLException {
  168.         int count = 0;
  169.         Connection connection = DBUtils.openConn();
  170.         String sql = "SELECT COUNT(*) AS userCount FROM user_info";
  171.         PreparedStatement statement = connection.prepareStatement(sql);
  172.         ResultSet resultSet = statement.executeQuery();
  173.         while (resultSet.next()) {
  174.             count = resultSet.getInt("userCount");
  175.         }
  176.         resultSet.close();
  177.         statement.close();
  178.         connection.close();
  179.         return count;
  180.     }
  182. }

添加用户——AddUserServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.UserInfoDao;
  15. import com.newcapec.entity.UserInfoEntity;
  17. /**
  18.  * Servlet implementation class AddUserServlet
  19.  */
  20. @WebServlet(name = "/AddUserServlet", urlPatterns = "/AddUserServlet")
  21. public class AddUserServlet extends HttpServlet {
  23.     private static final long serialVersionUID = 1L;
  24.     private UserInfoDao userInfoDao = new UserInfoDao();
  26.     /**
  27.      * @see HttpServlet#HttpServlet()
  28.      */
  29.     public AddUserServlet() {
  30.         super();
  31.         // TODO Auto-generated constructor stub
  32.     }
  34.     /**
  35.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  36.      *      response)
  37.      */
  38.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  39.             throws ServletException, IOException {
  40.         // TODO Auto-generated method stub
  41.         response.getWriter().append("Served at: ").append(request.getContextPath());
  42.     }
  44.     /**
  45.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  46.      *      response)
  47.      */
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  49.             throws ServletException, IOException {
  50.         request.setCharacterEncoding("utf-8");
  51.         response.setContentType("text/json;charset=utf-8");
  52.         String userName = request.getParameter("userName");
  53.         String userPwd = request.getParameter("userPwd");
  54.         UserInfoEntity userInfoEntity = new UserInfoEntity();
  55.         userInfoEntity.setUserName(userName);
  56.         userInfoEntity.setUserPwd(userPwd);
  57.         try {
  58.             boolean flag = userInfoDao.insert(userInfoEntity);
  59.             HashMap<String, Boolean> result = new HashMap<>();
  60.             result.put("flag", flag);
  61.             response.getWriter().write(JSON.toJSONString(result));
  62.         } catch (ClassNotFoundException | SQLException e) {
  63.             // TODO 自动生成的 catch 块
  64.             e.printStackTrace();
  65.         }
  66.     }
  68. }

有点难~

发表评论

表情：
评论列表 （有 0 条评论，78人围观）

还没有评论，来说两句吧...

相关阅读