Bootstrap4+MySQL前后端综合实训-Day07-PM【用户信息管理页面——功能展示(分页显示数据、添加用户、批量删除用户、编辑用户信息)、servlet项目代码整理汇总】

朴灿烈づ我的快乐病毒、 2022-12-23 11:24 63阅读 0赞

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

***目   录***

页面展示

分页显示数据

添加用户信息

(单个/批量)删除用户

编辑用户信息

user\_info数据表——数据展示

user\_manager.html

package com.newcapec.dao;

BaseDao.java

UserInfoDao.java

package com.newcapec.entity;

ResultData.java

UserInfoEntity.java

package com.newcapec.servlet;

AddUserServlet.java

DeleteUserServlet.java

LoginServlet.java

SelectUserByIdServlet.java

SelectUserByPageServlet.java

UpdateUserServlet.java

--------------------

# 页面展示 #

> ![20201125224522490.png][]   ![20201125224550293.png][]

## 分页显示数据 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70][]
> 
> ![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][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3][]
> 
> ![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][]

## 编辑用户信息 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 8][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 9][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 10][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 11][]

# user\_info数据表——数据展示 #

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 12][]

# user\_manager.html #

<!DOCTYPE html>
    <html>
    
    <head>
    	<meta charset="utf-8">
    	
    	<link rel="stylesheet" href="../bootstrap4/css/bootstrap.min.css">
    	<link rel="stylesheet" type="text/css" href="../font-awesome-4.7.0/css/font-awesome.min.css" />
    	<link href="../bootstrap-table/bootstrap-table.min.css" rel="stylesheet" />
    	
    	<script src="../jquery/jquery.min.js"></script>
    	
    	<script src="../js/popper.min.js"></script>
    	
    	<script src="../bootstrap4/js/bootstrap.min.js"></script>
    	<script src="../bootstrap-table/bootstrap-table.js"></script>
    	<script src="../bootstrap-table/locale/bootstrap-table-zh-CN.js"></script>
    	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    	<title>用户管理</title>
    	<script type="text/javascript">
    		function batchDelete() {
    			var rows = $('#userInfoTab').bootstrapTable('getSelections');
    			console.log(rows);
    			var userIds = new Array();
    			for (var i = 0; i < rows.length; i++) {
    				userIds.push(rows[i].userId);
    			}
    			console.log(userIds);
    			$.ajax({
    				type: "POST",
    				url: "../DeleteUserServlet",
    				data: { "userIds": userIds },
    				success: function (msg) {
    					if (msg.flag) {
    						alert("成功");
    						//刷新数据
    						$('#userInfoTab').bootstrapTable("refresh");
    					} else {
    						alert("失败");
    					}
    				}
    			});
    		}
    
    		function addUserInfo() {
    			var userName = $("#addUserName").val();
    			var userPwd = $("#addUserPwd").val();
    			var userdata = {
    				"userName": userName,
    				"userPwd": userPwd
    			};
    			$.ajax({
    				type: "POST",
    				url: "../AddUserServlet",
    				data: userdata,
    				success: function (msg) {
    					if (msg.flag) {
    						alert("成功");
    						//刷新数据
    						$('#userInfoTab').bootstrapTable("refresh");
    					} else {
    						alert("失败");
    					}
    					$("#addUserName").val("");
    					$("#addUserPwd").val("");
    				}
    			});
    		}
    
    		function edit(userId) {
    			console.log(userId);
    			//通过该ID获取数据
    			//通过ajax发起请求获取用户信息
    			$.ajax({
    				type: "get",
    				url: "../SelectUserByIdServlet",
    				data: { "userId": userId },
    				success: function (msg) {
    					console.log(msg);
    					//获取成功后填入参数展示模态框
    					$("input[name='userId']").val(msg.userId);
    					$("input[name='userName']").val(msg.userName);
    					$("input[name='userPwd']").val(msg.userPwd);
    					$("#updateUserInfo").modal('show');
    				}
    			});
    			//执行更新
    		}
    
    		function updateUserInfo() {
    			var userInfo = {
    				"userId": $("input[name='userId']").val(),
    				"userName": $("input[name='userName']").val(),
    				"userPwd": $("input[name='userPwd']").val()
    			};
    			$.ajax({
    				type: "post",
    				url: "../UpdateUserServlet",
    				data: userInfo,
    				success: function (msg) {
    					if (msg.flag) {
    						alert("成功");
    						//刷新数据
    						$('#userInfoTab').bootstrapTable("refresh");
    					} else {
    						alert("失败");
    					}
    					$("input[name='userId']").val("");
    					$("input[name='userName']").val("");
    					$("input[name='userPwd']").val("");
    				}
    			});
    		}
    	</script>
    </head>
    
    <body>
    	<div style="padding: 10px">
    		<div id="toolbar" style="display: flex;">
    			<button type="button" class="btn btn-info" data-toggle="modal" data-target="#addUserInfo"><i
    					class="fa fa-plus"></i> 添加</button>
    			<button type="button" class="btn btn-danger" onclick="batchDelete()"><i class="fa fa-minus"></i>
    				批量删除</button>
    			
    
    		</div>
    		<table id="userInfoTab" class="table table-hover table-bordered table-striped">
    
    		</table>
    
    		<div class="modal fade" id="updateUserInfo">
    			<div class="modal-dialog">
    				<div class="modal-content">
    
    					
    					<div class="modal-header bg-info">
    						<h4 class="modal-title">更新用户信息</h4>
    						<button type="button" class="close" data-dismiss="modal">×</button>
    					</div>
    
    					
    					<div class="modal-body">
    						<form>
    							<input type="hidden" name="userId" />
    							<div class="input-group mb-3">
    								<div class="input-group-prepend">
    									<span class="input-group-text"><i class="fa fa-user"></i></span>
    								</div>
    								<input type="text" name="userName" class="form-control" placeholder="Username">
    							</div>
    							<div class="input-group mb-3">
    								<div class="input-group-prepend">
    									<span class="input-group-text"><i class="fa fa-lock"></i></span>
    								</div>
    								<input type="password" name="userPwd" class="form-control" placeholder="userpwd">
    							</div>
    
    						</form>
    					</div>
    
    					
    					<div class="modal-footer">
    						<button type="button" class="btn btn-success" data-dismiss="modal"
    							onclick=updateUserInfo()>更新</button>
    						<button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
    					</div>
    
    				</div>
    			</div>
    		</div>
    		
    		<div class="modal fade" id="addUserInfo">
    			<div class="modal-dialog">
    				<div class="modal-content">
    
    					
    					<div class="modal-header bg-info">
    						<h4 class="modal-title">添加用户信息</h4>
    						<button type="button" class="close" data-dismiss="modal">×</button>
    					</div>
    
    					
    					<div class="modal-body">
    						<form>
    							<div class="input-group mb-3">
    								<div class="input-group-prepend">
    									<span class="input-group-text"><i class="fa fa-user"></i></span>
    								</div>
    								<input type="text" id="addUserName" class="form-control" placeholder="Username">
    							</div>
    							<div class="input-group mb-3">
    								<div class="input-group-prepend">
    									<span class="input-group-text"><i class="fa fa-lock"></i></span>
    								</div>
    								<input type="password" id="addUserPwd" class="form-control" placeholder="userpwd">
    							</div>
    
    						</form>
    					</div>
    
    					
    					<div class="modal-footer">
    						<button type="button" class="btn btn-success" data-dismiss="modal"
    							onclick=addUserInfo()>添加</button>
    						<button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
    					</div>
    
    				</div>
    			</div>
    		</div>
    	</div>
    
    	<script>
    		var icons = {
    			paginationSwitchDown: 'fa-caret-square-down',
    			paginationSwitchUp: 'fa-caret-square-up',
    			refresh: 'fa-refresh',
    			toggleOff: 'fa-toggle-off',
    			toggleOn: 'fa-toggle-on',
    			columns: 'fa-th-list',
    			fullscreen: 'fa-arrows-alt',
    			detailOpen: 'fa-plus',
    			detailClose: 'fa-minus'
    		};
    
    		//异步加载表格数据
    		$('#userInfoTab').bootstrapTable({
    			url: '../SelectAllServlet',         //请求后台的URL（*）
    			method: 'get',                      //请求方式（*）
    			toolbar: '#toolbar',                //工具按钮用哪个容器
    			striped: true,                      //是否显示行间隔色
    			cache: false,                       //是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）
    			pagination: true,                   //是否显示分页（*）
    			icons: icons,                       //重新定义图标 修复图标加载失败问题
    			queryParams: function (params) {
    				var temp = {   //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
    					limit: params.limit,   //页面大小
    					offset: params.offset  //页码
    					//userName: $("#userName").val()
    					//statu: $("#txt_search_statu").val()
    				};
    				return temp;
    			},
    			sidePagination: "server",           //分页方式：client客户端分页，server服务端分页（*）
    			pageNumber: 1,                       //初始化加载第一页，默认第一页
    			pageSize: 10,                       //每页的记录行数（*）
    			pageList: [10, 15, 20, 25],        //可供选择的每页的行数（*）
    			//search: true,                       //是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大
    			strictSearch: true,
    			showRefresh: true,                  //是否显示刷新按钮
    			clickToSelect: true,                //是否启用点击选中行
    			uniqueId: "userId",                     //每一行的唯一标识，一般为主键列
    			//showToggle:true,                    //是否显示详细视图和列表视图的切换按钮
    			//cardView: false,                    //是否显示详细视图
    			columns: [{
    				checkbox: true
    			}, {
    				field: 'userId',
    				title: '用户Id'
    			}, {
    				field: 'userName',
    				title: '用户名'
    			}, {
    				field: 'createTime',
    				title: '创建时间'
    			}, {
    				field: 'updateTime',
    				title: '更新时间'
    			}, {
    				field: 'userId',
    				title: '编辑',
    				formatter: function (value, row, index) {
    					var e = '<a class="btn btn-waring" href="#" mce_href="#" title="编辑" onclick="edit(\''
    						+ row.userId
    						+ '\')"><i class="fa fa-edit"></i>编辑</a> ';
    					return e;
    				}
    			}]
    		});
    	</script>
    </body>
    
    </html>

# package com.newcapec.dao; #

## BaseDao.java ##

package com.newcapec.dao;
    
    import java.sql.SQLException;
    import java.util.List;
    
    /**
     * JDBC在后期需要使用hibernate/mybatis优化
     * 
     * @author user
     *
     * @param <T>
     */
    public interface BaseDao<T> {
    	// public int insert(T t) throws ClassNotFoundException, SQLException;
    	
    	public boolean deleteById(int id) throws ClassNotFoundException, SQLException;
    
    	public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException;
    
    	public boolean update(T t) throws ClassNotFoundException, SQLException;
    
    	public T selectById(int id) throws ClassNotFoundException, SQLException;
    
    	public List<T> selectAll() throws ClassNotFoundException, SQLException;
    }

## UserInfoDao.java ##

package com.newcapec.dao;
    
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.ArrayList;
    import java.util.Date;
    import java.util.List;
    
    import com.newcapec.entity.UserInfoEntity;
    import com.newcapec.utils.DBUtils;
    
    public class UserInfoDao implements BaseDao<UserInfoEntity> {
    
    	public UserInfoEntity login(String userName, String userPwd) throws ClassNotFoundException, SQLException {
    		UserInfoEntity userInfoEntity = null;
    		Connection connection = DBUtils.openConn();
    		String sql = "select * from user_info where user_name = ? and user_pwd = ?";
    		PreparedStatement statement = connection.prepareStatement(sql);
    		statement.setString(1, userName);
    		statement.setString(2, userPwd);
    		ResultSet resultSet = statement.executeQuery();
    		while (resultSet.next()) {
    			int userId = resultSet.getInt("user_id");
    			Date createTime = resultSet.getTimestamp("create_time");
    			Date updateTime = resultSet.getTimestamp("update_time");
    			userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
    		}
    		resultSet.close();
    		statement.close();
    		connection.close();
    		return userInfoEntity;
    	}
    
    	public boolean insert(UserInfoEntity t) throws ClassNotFoundException, SQLException {
    		boolean flag = false;
    		// 获取与数据库的连接
    		Connection connection = DBUtils.openConn();
    		// ?表示占位符 可以解决sql注入的问题
    		String sql = "insert into user_info (user_name,user_pwd,create_time) values (?,?,now())";
    		PreparedStatement statement = connection.prepareStatement(sql);
    		statement.setString(1, t.getUserName());
    		statement.setString(2, t.getUserPwd());
    		// 执行sql语句
    		int count = statement.executeUpdate();
    		if (count > 0) {
    			flag = true;
    		}
    		statement.close();
    		connection.close();
    		return flag;
    	}
    
    	@Override
    	public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
    		boolean flag = false;
    		// 获取连接
    		Connection connection = DBUtils.openConn();
    		// sql语句
    		// String sql = "delete from user_info where user_id = ?";
    		String sql = "update user_info set status = 0 where user_id = ?";
    		// 预处理对象
    		PreparedStatement statement = connection.prepareStatement(sql);
    		// 添加参数
    		statement.setInt(1, id);
    		// 执行预处理对象
    		int count = statement.executeUpdate();
    		if (count > 0) {
    			flag = true;
    		}
    		statement.close();
    		connection.close();
    		return flag;
    	}
    
    	@Override
    	public boolean update(UserInfoEntity t) throws ClassNotFoundException, SQLException {
    		boolean flag = false;
    		// 获取连接
    		Connection connection = DBUtils.openConn();
    		// sql语句
    		String sql = "update user_info set user_name = ?,user_pwd = ? where user_id = ?";
    		// 预处理对象
    		PreparedStatement statement = connection.prepareStatement(sql);
    		// 添加参数
    		statement.setString(1, t.getUserName());
    		statement.setString(2, t.getUserPwd());
    		statement.setInt(3, t.getUserId());
    		// 执行预处理对象
    		int count = statement.executeUpdate();
    		if (count > 0) {
    			flag = true;
    		}
    		statement.close();
    		connection.close();
    		return flag;
    	}
    
    	@Override
    	public UserInfoEntity selectById(int id) throws ClassNotFoundException, SQLException {
    		UserInfoEntity userInfoEntity = null;
    		Connection connection = DBUtils.openConn();
    		String sql = "select * from user_info where user_id = ? and status = 1";
    		PreparedStatement statement = connection.prepareStatement(sql);
    		statement.setInt(1, id);
    		ResultSet resultSet = statement.executeQuery();
    		while (resultSet.next()) {
    			int userId = resultSet.getInt("user_id");
    			String userName = resultSet.getString("user_name");
    			String userPwd = resultSet.getString("user_pwd");
    			Date createTime = resultSet.getTimestamp("create_time");
    			Date updateTime = resultSet.getTimestamp("update_time");
    			userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
    		}
    		resultSet.close();
    		statement.close();
    		connection.close();
    		return userInfoEntity;
    	}
    
    	@Override
    	public List<UserInfoEntity> selectAll() throws ClassNotFoundException, SQLException {
    		List<UserInfoEntity> list = new ArrayList<>();
    		Connection connection = DBUtils.openConn();
    		String sql = "select * from user_info";
    		PreparedStatement statement = connection.prepareStatement(sql);
    		ResultSet resultSet = statement.executeQuery();
    		while (resultSet.next()) {
    			int userId = resultSet.getInt("user_id");
    			String userName = resultSet.getString("user_name");
    			String userPwd = resultSet.getString("user_pwd");
    			Date createTime = resultSet.getTimestamp("create_time");
    			Date updateTime = resultSet.getTimestamp("update_time");
    			UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
    			list.add(userInfoEntity);
    		}
    		resultSet.close();
    		statement.close();
    		connection.close();
    		return list;
    	}
    
    	public List<UserInfoEntity> selectByPage(int offset, int limit) throws ClassNotFoundException, SQLException {
    		List<UserInfoEntity> list = new ArrayList<>();
    		Connection connection = DBUtils.openConn();
    		String sql = "select * from user_info where status = 1 limit ?,?";
    		PreparedStatement statement = connection.prepareStatement(sql);
    		statement.setInt(1, offset);
    		statement.setInt(2, limit);
    		ResultSet resultSet = statement.executeQuery();
    		while (resultSet.next()) {
    			int userId = resultSet.getInt("user_id");
    			String userName = resultSet.getString("user_name");
    			String userPwd = resultSet.getString("user_pwd");
    			Date createTime = resultSet.getTimestamp("create_time");
    			Date updateTime = resultSet.getTimestamp("update_time");
    			UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
    			list.add(userInfoEntity);
    		}
    		resultSet.close();
    		statement.close();
    		connection.close();
    		return list;
    	}
    
    	public int selectCount() throws ClassNotFoundException, SQLException {
    		int count = 0;
    		Connection connection = DBUtils.openConn();
    		String sql = "SELECT COUNT(*) AS userCount FROM user_info where status = 1";
    		PreparedStatement statement = connection.prepareStatement(sql);
    		ResultSet resultSet = statement.executeQuery();
    		while (resultSet.next()) {
    			count = resultSet.getInt("userCount");
    		}
    		resultSet.close();
    		statement.close();
    		connection.close();
    		return count;
    	}
    
    	@Override
    	public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
    		boolean flag = false;
    		// 获取连接
    		Connection connection = DBUtils.openConn();
    		// sql语句
    		// String sql = "delete from user_info where user_id = ?";
    		String sql = "update user_info set status = 0 where user_id = ?";
    		// 预处理对象
    		PreparedStatement statement = connection.prepareStatement(sql);
    		// 添加参数
    		for (int id : ids) {
    			statement.setInt(1, id);
    			statement.addBatch();
    		}
    		int[] result = statement.executeBatch();
    		// 执行预处理对象
    		// int count = statement.executeUpdate();
    		if (result.length > 0) {
    			flag = true;
    		}
    		statement.close();
    		connection.close();
    		return flag;
    	}
    
    }

# package com.newcapec.entity; #

## ResultData.java ##

package com.newcapec.entity;
    
    public class ResultData<T> {
    
    	private int total;
    	private T rows;
    	private String code;
    
    	public ResultData() {
    		super();
    	}
    
    	public ResultData(int total, T rows, String code) {
    		super();
    		this.total = total;
    		this.rows = rows;
    		this.code = code;
    	}
    
    	public int getTotal() {
    		return total;
    	}
    
    	public void setTotal(int total) {
    		this.total = total;
    	}
    
    	public T getRows() {
    		return rows;
    	}
    
    	public void setRows(T rows) {
    		this.rows = rows;
    	}
    
    	public String getCode() {
    		return code;
    	}
    
    	public void setCode(String code) {
    		this.code = code;
    	}
    
    	@Override
    	public String toString() {
    		return "ResultData [total=" + total + ", rows=" + rows + ", code=" + code + "]";
    	}
    
    }

## UserInfoEntity.java ##

package com.newcapec.entity;
    
    import java.util.Date;
    
    import com.alibaba.fastjson.annotation.JSONField;
    
    public class UserInfoEntity {
    
    	private int userId;
    	private String userName;
    	private String userPwd;
    	@JSONField(format = "yyyy-MM-dd HH:mm:ss")
    	private Date createTime;
    	@JSONField(format = "yyyy-MM-dd HH:mm:ss")
    	private Date updateTime;
    
    	public UserInfoEntity() {
    	}
    
    	public UserInfoEntity(int userId, String userName, String userPwd) {
    		super();
    		this.userId = userId;
    		this.userName = userName;
    		this.userPwd = userPwd;
    	}
    
    	public UserInfoEntity(int userId, String userName, String userPwd, Date createTime, Date updateTime) {
    		super();
    		this.userId = userId;
    		this.userName = userName;
    		this.userPwd = userPwd;
    		this.createTime = createTime;
    		this.updateTime = updateTime;
    	}
    
    	public int getUserId() {
    		return userId;
    	}
    
    	public void setUserId(int userId) {
    		this.userId = userId;
    	}
    
    	public String getUserName() {
    		return userName;
    	}
    
    	public void setUserName(String userName) {
    		this.userName = userName;
    	}
    
    	public String getUserPwd() {
    		return userPwd;
    	}
    
    	public void setUserPwd(String userPwd) {
    		this.userPwd = userPwd;
    	}
    
    	public Date getCreateTime() {
    		return createTime;
    	}
    
    	public void setCreateTime(Date createTime) {
    		this.createTime = createTime;
    	}
    
    	public Date getUpdateTime() {
    		return updateTime;
    	}
    
    	public void setUpdateTime(Date updateTime) {
    		this.updateTime = updateTime;
    	}
    
    	@Override
    	public String toString() {
    		return "UserInfoEntity [userId=" + userId + ", userName=" + userName + ", userPwd=" + userPwd + ", createTime="
    				+ createTime + ", updateTime=" + updateTime + "]";
    	}
    
    }

# package com.newcapec.servlet; #

## AddUserServlet.java ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    import java.util.HashMap;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.alibaba.fastjson.JSON;
    import com.newcapec.dao.UserInfoDao;
    import com.newcapec.entity.UserInfoEntity;
    
    /**
     * Servlet implementation class AddUserServlet
     */
    @WebServlet(name = "/AddUserServlet", urlPatterns = "/AddUserServlet")
    public class AddUserServlet extends HttpServlet {
    
    	private static final long serialVersionUID = 1L;
    	private UserInfoDao userInfoDao = new UserInfoDao();
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public AddUserServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		response.getWriter().append("Served at: ").append(request.getContextPath());
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		request.setCharacterEncoding("utf-8");
    		response.setContentType("text/json;charset=utf-8");
    		String userName = request.getParameter("userName");
    		String userPwd = request.getParameter("userPwd");
    		UserInfoEntity userInfoEntity = new UserInfoEntity();
    		userInfoEntity.setUserName(userName);
    		userInfoEntity.setUserPwd(userPwd);
    		try {
    			boolean flag = userInfoDao.insert(userInfoEntity);
    			HashMap<String, Boolean> result = new HashMap<>();
    			result.put("flag", flag);
    			response.getWriter().write(JSON.toJSONString(result));
    		} catch (ClassNotFoundException | SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    
    }

## DeleteUserServlet.java ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    import java.util.Arrays;
    import java.util.HashMap;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.alibaba.fastjson.JSON;
    import com.newcapec.dao.UserInfoDao;
    
    /**
     * Servlet implementation class DeleteUserServlet
     */
    @WebServlet(name = "/DeleteUserServlet", urlPatterns = "/DeleteUserServlet")
    public class DeleteUserServlet extends HttpServlet {
    
    	private static final long serialVersionUID = 1L;
    	private UserInfoDao userInfoDao = new UserInfoDao();
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public DeleteUserServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		response.getWriter().append("Served at: ").append(request.getContextPath());
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// 此处可以使用过滤器批量处理
    		request.setCharacterEncoding("utf-8");
    		response.setContentType("text/json;charset=utf-8");
    		String[] userIds = request.getParameterValues("userIds[]");
    		// 使用userInfoDao执行批量删除
    		int[] ids = new int[userIds.length];
    		for (int i = 0; i < userIds.length; i++) {
    			ids[i] = Integer.valueOf(userIds[i]);
    		}
    		try {
    			boolean flag = userInfoDao.batchDeleteById(ids);
    			HashMap<String, Boolean> result = new HashMap<>();
    			result.put("flag", flag);
    			response.getWriter().write(JSON.toJSONString(result));
    		} catch (ClassNotFoundException | SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    
    }

## LoginServlet.java ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.newcapec.dao.UserInfoDao;
    import com.newcapec.entity.UserInfoEntity;
    
    /**
     * Servlet implementation class LoginServlet
     */
    @WebServlet(name = "/LoginServlet", urlPatterns = "/LoginServlet")
    public class LoginServlet extends HttpServlet {
    
    	private UserInfoDao userInfoDao = new UserInfoDao();
    	private static final long serialVersionUID = 1L;
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public LoginServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		response.getWriter().append("Served at: ").append(request.getContextPath());
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	// 注意：在正规开发中 登录密码需要加密
    	// 需要有验证码
    	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		request.setCharacterEncoding("UTF-8");
    		String userName = request.getParameter("userName");
    		String userPwd = request.getParameter("userPwd");
    		try {
    			UserInfoEntity userInfoEntity = userInfoDao.login(userName, userPwd);
    			if (userInfoEntity != null) {
    				// 登录成功
    				request.getSession().setAttribute("userInfo", userInfoEntity);
    				response.sendRedirect("index.html");
    			} else {
    				// 登录失败 重定向
    				response.sendRedirect("loginFailure.html");
    			}
    		} catch (ClassNotFoundException | SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    
    }

## SelectUserByIdServlet.java ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.alibaba.fastjson.JSON;
    import com.newcapec.dao.UserInfoDao;
    import com.newcapec.entity.UserInfoEntity;
    
    /**
     * Servlet implementation class SelectUserByIdServlet
     */
    @WebServlet(name = "/SelectUserByIdServlet", urlPatterns = "/SelectUserByIdServlet")
    public class SelectUserByIdServlet extends HttpServlet {
    
    	private static final long serialVersionUID = 1L;
    	private UserInfoDao userInfoDao = new UserInfoDao();
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public SelectUserByIdServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// 此处可以使用过滤器批量处理
    		request.setCharacterEncoding("utf-8");
    		response.setContentType("text/json;charset=utf-8");
    		int userId = Integer.parseInt(request.getParameter("userId"));
    		try {
    			UserInfoEntity userInfoEntity = userInfoDao.selectById(userId);
    			response.getWriter().write(JSON.toJSONString(userInfoEntity));
    		} catch (ClassNotFoundException | SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		doGet(request, response);
    	}
    
    }

## SelectUserByPageServlet.java ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    import java.util.HashMap;
    import java.util.List;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.alibaba.fastjson.JSON;
    import com.newcapec.dao.UserInfoDao;
    import com.newcapec.entity.ResultData;
    import com.newcapec.entity.UserInfoEntity;
    
    /**
     * Servlet implementation class SelectAllServlet
     */
    @WebServlet(name = "/SelectAllServlet", urlPatterns = "/SelectAllServlet")
    public class SelectUserByPageServlet extends HttpServlet {
    
    	private static final long serialVersionUID = 1L;
    	private UserInfoDao userInfoDao = new UserInfoDao();
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public SelectUserByPageServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		response.setCharacterEncoding("utf-8");
    		response.setContentType("text/json;charset=utf-8");
    		// 当前页码
    		// 页大小
    		int offset = Integer.parseInt(request.getParameter("offset"));
    		int limit = Integer.parseInt(request.getParameter("limit"));
    
    		// bootstrap-table插件需要后台传回total/rows
    		ResultData<List<UserInfoEntity>> data = new ResultData<>();
    		try {
    			data.setRows(userInfoDao.selectByPage(offset, limit));
    			data.setTotal(userInfoDao.selectCount());
    			response.getWriter().write(JSON.toJSONString(data));
    		} catch (ClassNotFoundException | SQLException e1) {
    			// TODO 自动生成的 catch 块
    			e1.printStackTrace();
    		}
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		doGet(request, response);
    	}
    
    }

## UpdateUserServlet.java ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    import java.util.HashMap;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.alibaba.fastjson.JSON;
    import com.newcapec.dao.UserInfoDao;
    import com.newcapec.entity.UserInfoEntity;
    
    /**
     * Servlet implementation class UpdateUserServlet
     */
    @WebServlet(name = "/UpdateUserServlet", urlPatterns = "/UpdateUserServlet")
    public class UpdateUserServlet extends HttpServlet {
    
    	private static final long serialVersionUID = 1L;
    	private UserInfoDao userInfoDao = new UserInfoDao();
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public UpdateUserServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		response.getWriter().append("Served at: ").append(request.getContextPath());
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		// 此处可以使用过滤器批量处理
    		request.setCharacterEncoding("utf-8");
    		response.setContentType("text/json;charset=utf-8");
    		int userId = Integer.parseInt(request.getParameter("userId"));
    		String userName = request.getParameter("userName");
    		String userPwd = request.getParameter("userPwd");
    		UserInfoEntity entity = new UserInfoEntity(userId, userName, userPwd);
    		try {
    			boolean flag = userInfoDao.update(entity);
    			HashMap<String, Boolean> result = new HashMap<>();
    			result.put("flag", flag);
    			response.getWriter().write(JSON.toJSONString(result));
    		} catch (ClassNotFoundException | SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    
    }

> 多谢观看~

[Bootstrap4_MySQL_10_ _]: https://blog.csdn.net/weixin_44949135/article/details/109722002
[20201125224522490.png]: https://img-blog.csdnimg.cn/20201125224522490.png
[20201125224550293.png]: /images/20221120/e1117e27acd143f699c5d24c3f6a6f1e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70]: /images/20221120/0b0be4b223394c97adbe2912d2d17e62.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1]: /images/20221120/45bb675f5133482ab47572e9a2f14b61.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201125230008656.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201125230021571.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201125230055319.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201125230345401.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20201125230401346.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20201125230419277.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20201125230512498.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20201125230542235.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20201125230555817.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20201125230611211.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20201125231201116.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70