JavaWeb 用户信息管理系统（Servlet+JSP+MySQL+JDBCTempleat+Duird+BeanUtilS+tomcat）

最新推荐文章于 2024-05-21 17:26:12 发布

weixin_51721994

最新推荐文章于 2024-05-21 17:26:12 发布

阅读量4.8k

点赞数 4

文章标签： java tomcat java-ee idea mysql

本文链接：https://blog.csdn.net/weixin_51721994/article/details/121795498

版权

1，功能

        1. 简单功能
                    1. 列表查询
                    2. 登录
                    3. 添加
                    4. 删除
                    5. 修改

       2. 复杂功能
                    1. 删除选中
                    2. 分页查询
                    3. 复杂条件查询

2,所需jar包

mysql数据库

druid连接池

JDBCTemplate

jstl标签库

BeanUtils

3，功能实现

1,创建数据库

create database login; -- 创建数据库
			use login; 			   -- 使用数据库
			create table user1(   -- 创建表
				id int primary key auto_increment,
				name varchar(20) not null,
				gender varchar(5),
				age int,
				address varchar(32),
				qq	varchar(20),
				email varchar(50),
                password varchar(32)
			);

2,Druid连接池

2.1，配置文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/login
username=root
password=wzl2001323
#初始化连接数量
initialSize=5
#最大连接数
maxActive=10
#最大等待时间
maxWait=3000

2.2, JDBC工具类

package util;
//jdbc工具类
import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JDBCUtils {
    //定义成员变量DataSource(连接池对象)
    private static DataSource ds;
    //在静态代码块中加载配置文件并获取连接池对象
    static {
        //1.加载配置文件
        Properties pro= new Properties();
        try {
            pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
            //2.获取Druid连接池对象
            ds= DruidDataSourceFactory.createDataSource(pro);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    //方法
    //1.获取链接对象
    public static Connection getConnection() throws SQLException {
        return ds.getConnection();
    }
    //2.释放资源
    //2.1没有使用ResultSet
    public static void close(Statement stmt,Connection conn){
        //调用该方法的重载方法关闭
        close(null,stmt,conn);
    }
    public static void close(ResultSet rs,Statement stmt,Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
        }
        if(conn!=null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
    //3.获取连接池的方法
    public static DataSource getDataSource(){
        return ds;
    }
}

3， web层

3,1jsp页面

1，list.jsp（用户信息展示页面）

<%--
  Created by IntelliJ IDEA.
  User: ASUS
  Date: 2021/12/3
  Time: 15:19
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>>
<!DOCTYPE html>
<!-- 网页使用的语言 -->
<html lang="zh-CN">
<head>
    <!-- 指定字符集 -->
    <meta charset="utf-8">
    <!-- 使用Edge最新的浏览器的渲染方式 -->
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- viewport视口：网页可以根据设置的宽度自动进行适配，在浏览器的内部虚拟一个容器，容器的宽度与设备的宽度相同。
    width: 默认宽度与设备的宽度相同
    initial-scale: 初始的缩放比，为1:1 -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>用户信息管理系统</title>

    <!-- 1. 导入CSS的全局样式 -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- 2. jQuery导入，建议使用1.9以上的版本 -->
    <script src="js/jquery-2.1.0.min.js"></script>
    <!-- 3. 导入bootstrap的js文件 -->
    <script src="js/bootstrap.min.js"></script>
    <style type="text/css">
        td, th {
            text-align: center;
        }
    </style>
    <script>
        /*删除提示*/
        function deleteUser(id){
            if(confirm("您确认要删除吗？")){
                location.href="${pageContext.request.contextPath}/deleteServlet?id="+id;
            }
        }
        /*删除选中，将选中元素的id发送*/
        window.onload=function (){
            /*给删除选中按钮添加单击事件*/
            document.getElementById("delSelected").onclick=function (){
                /*确定是否删除*/
                if(confirm("您确认要删除吗？")){
                    var flag=false;
                    /*判断是否没有选中任何数据*/
                    var cbs=document.getElementsByName("uid");
                    for(var i=0;i<cbs.length;i++){
                        if(cbs[i].checked){
                            flag=true;
                            break;
                        }
                    }
                    if(flag){
                        document.getElementById("form").submit();
                    }
                    else{
                        alert("请选中数据");
                    }
                }
            }
            /*实现首单选框全选功能*/
            document.getElementById("firstcb").onclick=function (){
                /*获取所有cb*/
                var cbs=document.getElementsByName("uid");
                /*遍历*/
                for(var i=0;i<cbs.length;i++){
                    /*设置当前cb状态与首cb一样*/
                    cbs[i].checked=this.checked;
                }
            }
        }
    </script>
</head>
<body>
<div class="container">
    <h3 style="text-align: center">用户信息列表</h3>
    <div  style="float: left">
        <form class="form-inline" action="${pageContext.request.contextPath}/findUserByPageServlet" method="post">
            <div class="form-group">
                <label for="exampleInputName2">姓名</label>
                <input type="text" class="form-control" name="name" value="${requestScope.condition.name[0]}" id="exampleInputName2">
            </div>
            <div class="form-group">
             <label for="exampleInputName3">籍贯</label>
                <input type="text" class="form-control" name="address" value="${requestScope.condition.address[0]}" id="exampleInputName3">
             </div>
            <div class="form-group">
                <label for="exampleInputEmail2">Email</label>
                <input type="email" class="form-control" name="email" value="${requestScope.condition.email[0]}" id="exampleInputEmail2">
             </div>
            <button type="submit" class="btn btn-default">查询</button>
        </form>
    </div>
    <div style="float: right;margin: 5px">
        <a class="btn btn-primary" href="add.jsp">添加联系人</a>
        <a class="btn btn-primary" href=javascript:void(0) id="delSelected">删除选中</a>
    </div>
    <form id="form" action="${pageContext.request.contextPath}/delSelectedServlet" method="post">
    <table border="1" class="table table-bordered table-hover">
        <tr class="success">
            <th><input type="checkbox" id="firstcb"></th>
            <th>编号</th>
            <th>姓名</th>
            <th>性别</th>
            <th>年龄</th>
            <th>籍贯</th>
            <th>QQ</th>
            <th>邮箱</th>
            <th>操作</th>
        </tr>
        <c:forEach items="${requestScope.pb.list}" var="user" varStatus="s">
            <tr>
                <td><input type="checkbox" name="uid" value="${user.id}"></td>
                <td>${s.count}</td>
                <td>${user.name}</td>
                <td>${user.gender}</td>
                <td>${user.age}</td>
                <td>${user.address}</td>
                <td>${user.qq}</td>
                <td>${user.email}</td>
                <td><a class="btn btn-default btn-sm"
                       href="${pageContext.request.contextPath}/findUserServlet?id=${user.id}">修改</a>
                    &nbsp;<a class="btn btn-default btn-sm" href="javascript:deleteUser(${user.id})">删除</a>
                </td>
            </tr>
        </c:forEach>
    </table>
    </form>
    <div>
        <nav aria-label="Page navigation">
            <ul class="pagination">
                <c:if test="${requestScope.pb.currentPage==1}">
                    <li class="disabled">
                </c:if>
                <c:if test="${requestScope.pb.currentPage!=1}">
                    <li>
                </c:if>
                    <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${requestScope.pb.currentPage-1}&rows=5&name=${requestScope.condition.name[0]}&address=${requestScope.condition.address[0]}&email=${requestScope.condition.email[0]}" aria-label="Previous">
                        <span aria-hidden="true">&laquo;</span>
                    </a>
                </li>
                <c:forEach begin="1" end="${requestScope.pb.totalPage}" var="i">
                    <c:if test="${requestScope.pb.currentPage==i}">
                <li class="active"><a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&name=${requestScope.condition.name[0]}"&address=${requestScope.condition.address[0]}&email=${requestScope.condition.email[0]}>${i}</a></li>
                    </c:if>
                    <c:if test="${requestScope.pb.currentPage!=i}">
                        <li><a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&name=${requestScope.condition.name[0]}&address=${requestScope.condition.address[0]}&email=${requestScope.condition.email[0]}">${i}</a></li>
                    </c:if>
                </c:forEach>
                    <c:if test="${requestScope.pb.currentPage == requestScope.pb.totalPage}">
                        <li class="disabled">
                    </c:if>
                    <c:if test="${requestScope.pb.currentPage!=requestScope.pb.totalPage}">
                        <li>
                    </c:if>
                    <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${requestScope.pb.currentPage+1}&rows=5&name=${requestScope.condition.name[0]}&address=${requestScope.condition.address[0]}&email=${requestScope.condition.email[0]}" aria-label="Next">
                        <span aria-hidden="true">&raquo;</span>
                    </a>
                </li>
                <span style="font-size: 25px;margin-left: 5px">
                    共${requestScope.pb.totalCount}条数据，共${requestScope.pb.totalPage}页
                </span>
            </ul>
        </nav>
    </div>
</div>
</body>
</html>

2，add.jsp（添加用户的界面）

<%@page contentType="text/html;charset=UTF-8" language="java" %>
<!-- HTML5文档-->
<!DOCTYPE html>
<!-- 网页使用的语言 -->
<html lang="zh-CN">
<head>
    <!-- 指定字符集 -->
    <meta charset="utf-8">
    <!-- 使用Edge最新的浏览器的渲染方式 -->
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- viewport视口：网页可以根据设置的宽度自动进行适配，在浏览器的内部虚拟一个容器，容器的宽度与设备的宽度相同。
    width: 默认宽度与设备的宽度相同
    initial-scale: 初始的缩放比，为1:1 -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>添加用户</title>

    <!-- 1. 导入CSS的全局样式 -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- 2. jQuery导入，建议使用1.9以上的版本 -->
    <script src="js/jquery-2.1.0.min.js"></script>
    <!-- 3. 导入bootstrap的js文件 -->
    <script src="js/bootstrap.min.js"></script>
    <script>
        window.onload=function (){
            document.getElementById("back").onclick=function (){
                location.href="${pageContext.request.contextPath}/findUserByPageServlet"
            }
        }
    </script>
</head>
<body>
<div class="container">
    <center><h3>添加联系人页面</h3></center>
    <form action="${pageContext.request.contextPath}/addUserServlet" method="post">
        <div class="form-group">
            <label for="name">姓名：</label>
            <input type="text" class="form-control" id="name" name="name" placeholder="请输入姓名">
        </div>

        <div class="form-group">
            <label>性别：</label>
            <input type="radio" name="gender" value="男" checked="checked"/>男
            <input type="radio" name="gender" value="女"/>女
        </div>

        <div class="form-group">
            <label for="age">年龄：</label>
            <input type="text" class="form-control" id="age" name="age" placeholder="请输入年龄">
        </div>

        <div class="form-group">
            <label for="address">籍贯：</label>
            <select name="address" class="form-control" id="address">
                <option value="西安">西安</option>
                <option value="潍坊">潍坊</option>
                <option value="榆林">榆林</option>
            </select>
        </div>

        <div class="form-group">
            <label for="qq">QQ：</label>
            <input type="text" class="form-control" id="qq" name="qq" placeholder="请输入QQ号码"/>
        </div>

        <div class="form-group">
            <label for="email">Email：</label>
            <input type="text" class="form-control" id="email" name="email" placeholder="请输入邮箱地址"/>
        </div>

        <div class="form-group" style="text-align: center">
            <input class="btn btn-primary" type="submit" value="提交" />
            <input class="btn btn-default" type="reset" value="重置" />
            <input class="btn btn-default" type="button" value="返回" id="back"/>
        </div>
    </form>
</div>
</body>
</html>

3.update.jsp（修改用信息界面）

<%@page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<!-- 网页使用的语言 -->
<html lang="zh-CN">
    <head>
        <!-- 指定字符集 -->
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>修改用户</title>

        <link href="css/bootstrap.min.css" rel="stylesheet">
        <script src="js/jquery-2.1.0.min.js"></script>
        <script src="js/bootstrap.min.js"></script>
        <script>
            window.onload=function (){
                document.getElementById("back").onclick=function (){
                    location.href="${pageContext.request.contextPath}/findUserByPageServlet"
                }
            }
        </script>
        
    </head>
    <body>
        <div class="container" style="width: 400px;">
        <h3 style="text-align: center;">修改联系人</h3>
        <form action="${pageContext.request.contextPath}/updateUserServlet" method="post">
          <div class="form-group">
            <label for="name">姓名：</label>
            <input type="text" class="form-control" id="name" name="name" value="${requestScope.user.name}" readonly="readonly" placeholder="请输入姓名" />
          </div>
           <%-- 隐藏域，提交id--%>
            <input type="hidden" name="id" value="${requestScope.user.id}">

          <div class="form-group">
            <label>性别：</label>
              <c:if test="${requestScope.user.gender=='男'}">
              <input type="radio" name="gender" value="男" checked />男
              <input type="radio" name="gender" value="女"  />女
              </c:if>
              <c:if test="${requestScope.user.gender=='女'}">
                  <input type="radio" name="gender" value="男"  />男
                  <input type="radio" name="gender" value="女" checked />女
              </c:if>
          </div>

          <div class="form-group">
            <label for="age">年龄：</label>
            <input type="text" class="form-control" id="age" value="${requestScope.user.age}" name="age" placeholder="请输入年龄" />
          </div>

          <div class="form-group">
            <label for="address">籍贯：</label>
             <select name="address" class="form-control"id="address">
                 <c:if test="${requestScope.user.address=='西安'}">
                <option value="西安" selected>西安</option>
                <option value="潍坊">潍坊</option>
                <option value="榆林">榆林</option>
                 </c:if>
                 <c:if test="${requestScope.user.address=='潍坊'}">
                     <option value="西安">西安</option>
                     <option value="潍坊" selected>潍坊</option>
                     <option value="榆林">榆林</option>
                 </c:if>
                 <c:if test="${requestScope.user.address=='榆林'}">
                     <option value="西安">西安</option>
                     <option value="潍坊">潍坊</option>
                     <option value="榆林" selected>榆林</option>
                 </c:if>
            </select>
          </div>

          <div class="form-group">
            <label for="qq">QQ：</label>
            <input type="text" class="form-control" id="qq" value="${requestScope.user.qq}" name="qq" placeholder="请输入QQ号码"/>
          </div>

          <div class="form-group">
            <label for="email">Email：</label>
            <input type="text" class="form-control" id="email" value="${requestScope.user.email}" name="email" placeholder="请输入邮箱地址"/>
          </div>

             <div class="form-group" style="text-align: center">
                <input class="btn btn-primary" type="submit" value="提交" />
                <input class="btn btn-default" type="reset" value="重置" />
                <input class="btn btn-default" type="button" value="返回" id="back"/>
             </div>
        </form>
        </div>
    </body>
</html>

4,login.jsp(用户登录界面)

<%--
  Created by IntelliJ IDEA.
  User: ASUS
  Date: 2021/12/4
  Time: 9:55
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="utf-8"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
    <meta name="viewport" content="width=device-width, initial-scale=1"/>
    <title>管理员登录</title>

    <!-- 1. 导入CSS的全局样式 -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- 2. jQuery导入，建议使用1.9以上的版本 -->
    <script src="js/jquery-2.1.0.min.js"></script>
    <!-- 3. 导入bootstrap的js文件 -->
    <script src="js/bootstrap.min.js"></script>
    <script type="text/javascript">
        //点击验证码切换图片
        function refreshCode(){
            //1，获取图片对象
            var vcode = document.getElementById("vcode");
            //2，实现点击切换(设置其src属性，加时间戳)
            vcode.src="${pageContext.request.contextPath}/checkCodeServlet?time="+new Date().getTime();
        }
    </script>
</head>
<body>
<div class="container" style="width: 400px;">
    <h3 style="text-align: center;">管理员登录</h3>
    <form action="${pageContext.request.contextPath}/loginServlet" method="post">
        <div class="form-group">
            <label for="user">用户名：</label>
            <input type="text" name="name" class="form-control" id="user" placeholder="请输入用户名"/>
        </div>

        <div class="form-group">
            <label for="password">密码：</label>
            <input type="password" name="password" class="form-control" id="password" placeholder="请输入密码"/>
        </div>

        <div class="form-inline">
            <label for="vcode">验证码：</label>
            <input type="text" name="verifycode" class="form-control" id="verifycode" placeholder="请输入验证码" style="width: 120px;"/>
            <a href="javascript:refreshCode()"><img src="${pageContext.request.contextPath}/checkCodeServlet" title="看不清点击刷新" id="vcode"/></a>
        </div>
        <hr/>
        <div class="form-group" style="text-align: center;">
            <input class="btn btn btn-primary" type="submit" value="登录">
        </div>
    </form>

    <!-- 出错显示的信息框 -->
    <div class="alert alert-warning alert-dismissible" role="alert">
        <button type="button" class="close" data-dismiss="alert" >
            <span>&times;</span></button>
        <strong>${requestScope.login_msg}</strong>
    </div>
</div>
</body>
</html>

5index.jsp (登录后跳转的页面)

<%--
  Created by IntelliJ IDEA.
  User: ASUS
  Date: 2021/12/2
  Time: 17:10
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
  <meta charset="utf-8"/>
  <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
  <meta name="viewport" content="width=device-width, initial-scale=1"/>
  <title>首页</title>

  <!-- 1. 导入CSS的全局样式 -->
  <link href="css/bootstrap.min.css" rel="stylesheet">
  <!-- 2. jQuery导入，建议使用1.9以上的版本 -->
  <script src="js/jquery-2.1.0.min.js"></script>
  <!-- 3. 导入bootstrap的js文件 -->
  <script src="js/bootstrap.min.js"></script>
  <script type="text/javascript">
  </script>
</head>
<body>
<div>
  ${sessionScope.user.name},欢迎您
</div>
<div align="center">
  <a
          href=${pageContext.request.contextPath}/findUserByPageServlet style="text-decoration:none;font-size:33px">查询所有用户信息
  </a>
</div>
</body>
</html>

3,2, servlet

1，分页查询

代码：

package web.servlet;

import domain.PageBean;
import domain.User;
import service.UserService;
import service.impl.UserServiceImpl;

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 java.io.IOException;
import java.util.Map;

@WebServlet("/findUserByPageServlet")
public class FindUserByPageServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1,设置字符编码集
        req.setCharacterEncoding("UTF-8");
        //6实现复杂查询
        //6.1获取请求条件参数
        Map<String, String[]> condition = req.getParameterMap();
        //2,获取请求参数(rows和currentPage)
        String rows = req.getParameter("rows");//每页显示的记录数
        String currentPage = req.getParameter("currentPage");//当前页码
        //3,调用service方法
        UserService service=new UserServiceImpl();
        PageBean<User> pb=service.findUserByPage(currentPage,rows,condition);
        //4,将PageBean存入request域,将条件存入request域
        req.setAttribute("pb",pb);
        req.setAttribute("condition",condition);
        //5,转发到list.jsp
        req.getRequestDispatcher("/list.jsp").forward(req,resp);
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

2.添加新用户

代码：

package web.servlet;

import domain.User;
import org.apache.commons.beanutils.BeanUtils;
import service.UserService;
import service.impl.UserServiceImpl;

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 java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

@WebServlet("/addUserServlet")
public class AddUserServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1,设置编码
        req.setCharacterEncoding("UTF-8");
        //2,获取请求参数
        Map<String, String[]> map = req.getParameterMap();
        //3,封装对象
        User user=new User();
        try {
            BeanUtils.populate(user,map);
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (InvocationTargetException e) {
            e.printStackTrace();
        }
        //4，调用Service保存
        UserService service=new UserServiceImpl();
        service.addUser(user);
        //5,跳转到userListServlet
        resp.sendRedirect(req.getContextPath()+"/findUserByPageServlet");
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

3.删除

package web.servlet;

import service.UserService;
import service.impl.UserServiceImpl;

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 java.io.IOException;

@WebServlet("/deleteServlet")
public class DeleteServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1.设置字符编码集
        req.setCharacterEncoding("UTF-8");
        //2，获取参数id
        String id=req.getParameter("id");
        //3，调用service方法删除
        UserService service=new UserServiceImpl();
        service.deleteUser(id);
        //4，跳转到userListServlet
        resp.sendRedirect(req.getContextPath()+"/findUserByPageServlet");
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

4，删除选中

代码

package web.servlet;

import service.UserService;
import service.impl.UserServiceImpl;

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 java.io.IOException;

@WebServlet("/delSelectedServlet")
public class DelSelectedServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1,设置字符编码
        req.setCharacterEncoding("UTF-8");
        //2,获取所有id
        String[] ids = req.getParameterValues("uid");
        //3,调用service
        UserService service=new UserServiceImpl();
        service.delSelectedUser(ids);
        //4,跳转页面
        resp.sendRedirect(req.getContextPath()+"/findUserByPageServlet");
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

5，登录

验证码

package web.servlet;

import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.util.Random;
import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * 验证码
 */
@WebServlet("/checkCodeServlet")
public class CheckCodeServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
		
		//服务器通知浏览器不要缓存
		response.setHeader("pragma","no-cache");
		response.setHeader("cache-control","no-cache");
		response.setHeader("expires","0");
		
		//在内存中创建一个长80，宽30的图片，默认黑色背景
		//参数一：长
		//参数二：宽
		//参数三：颜色
		int width = 80;
		int height = 30;
		BufferedImage image = new BufferedImage(width,height,BufferedImage.TYPE_INT_RGB);
		
		//获取画笔
		Graphics g = image.getGraphics();
		//设置画笔颜色为灰色
		g.setColor(Color.GRAY);
		//填充图片
		g.fillRect(0,0, width,height);
		
		//产生4个随机验证码，12Ey
		String checkCode = getCheckCode();
		//将验证码放入HttpSession中
		request.getSession().setAttribute("CHECKCODE_SERVER",checkCode);
		
		//设置画笔颜色为黄色
		g.setColor(Color.YELLOW);
		//设置字体的小大
		g.setFont(new Font("黑体",Font.BOLD,24));
		//向图片上写入验证码
		g.drawString(checkCode,15,25);
		
		//将内存中的图片输出到浏览器
		//参数一：图片对象
		//参数二：图片的格式，如PNG,JPG,GIF
		//参数三：图片输出到哪里去
		ImageIO.write(image,"PNG",response.getOutputStream());
	}
	/**
	 * 产生4位随机字符串 
	 */
	private String getCheckCode() {
		String base = "0123456789ABCDEFGabcdefg";
		int size = base.length();
		Random r = new Random();
		StringBuffer sb = new StringBuffer();
		for(int i=1;i<=4;i++){
			//产生0到size-1的随机值
			int index = r.nextInt(size);
			//在base字符串中获取下标为index的字符
			char c = base.charAt(index);
			//将c放入到StringBuffer中去
			sb.append(c);
		}
		return sb.toString();
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		this.doGet(request,response);
	}
}

package web.servlet;

import domain.User;
import org.apache.commons.beanutils.BeanUtils;
import service.UserService;
import service.impl.UserServiceImpl;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1,设置字符编码集
        req.setCharacterEncoding("UTF-8");
        //2，获取用户填写验证码，获取参数
        String verifycode=req.getParameter("verifycode");
        Map<String, String[]> map = req.getParameterMap();
        //3,判断验证码是否正确
        HttpSession session=req.getSession();
        String checkcode = (String)session.getAttribute("CHECKCODE_SERVER");
        //删除验证码，防止复用
        session.removeAttribute("CHECKCODE_SERVER");
        if(!checkcode.equalsIgnoreCase(verifycode)){
            //验证码不正确
            //提示信息
            req.setAttribute("login_msg","验证码错误");
            //跳转页面
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
            return;
        }
        //验证码正确
        //4,封装User对象
        User user=new User();
        try {
            BeanUtils.populate(user,map);
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (InvocationTargetException e) {
            e.printStackTrace();
        }
        //5,调用service查询
        UserService service=new UserServiceImpl();
        User loginUser=service.login(user);
        //6，判断是否登陆成功
        if(loginUser!=null){
            //登陆成功
            //将用户存入session
            session.setAttribute("user",loginUser);
            //跳转页面
            resp.sendRedirect(req.getContextPath()+"/index.jsp");
        }
        else{
            //登录失败
            req.setAttribute("login_msg","用户名或密码错误");
            //跳转到登录页面
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
        }
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

6，修改信息

1，数据回显

package web.servlet;

import domain.User;
import service.UserService;
import service.impl.UserServiceImpl;

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 java.io.IOException;

@WebServlet("/findUserServlet")
public class FindUserServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1,设置字符编码集
        req.setCharacterEncoding("UTF-8");
        //2,获取请求参数id
        String id=req.getParameter("id");
        //3,调用service方法查询
        UserService service=new UserServiceImpl();
        User user=service.findUserById(id);
        //4,转发到update.jsp
        req.setAttribute("user",user);
        req.getRequestDispatcher("/update.jsp").forward(req,resp);
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

2，修改

package web.servlet;

import domain.User;
import org.apache.commons.beanutils.BeanUtils;
import service.UserService;
import service.impl.UserServiceImpl;

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 java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

@WebServlet("/updateUserServlet")
public class UpdateUserServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1,设置字符编码集
        req.setCharacterEncoding("UTF-8");
        //2，获取请求参数集合
        Map<String, String[]> map = req.getParameterMap();
        //3,将参数封装成对象
        User user=new User();
        try {
            BeanUtils.populate(user,map);
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (InvocationTargetException e) {
            e.printStackTrace();
        }
        //4,调用Service修改
        UserService service=new UserServiceImpl();
        service.updateUser(user);
        //5，跳转到uerListServlet
        resp.sendRedirect(req.getContextPath()+"/findUserByPageServlet");
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }
}

4，service层业务逻辑层

UserService接口

package service;

import domain.PageBean;
import domain.User;

import java.util.List;
import java.util.Map;

/**
 * 用户管理的业务接口
 */
public interface UserService {
    /**
     * 查询所有用户信息
     * @return
     */
    public List<User> findAll();

    /**
     * 根据用户名和密码登录
     * @param user
     * @return
     */
    public User login(User user);

    /**
     * 添加新用户
     * @param user
     */
    public void addUser(User user);

    /**
     * 删除用户信息
     * @param id
     */
    public void deleteUser(String id);

    /**
     * 根据id查询用户信息
     * @param id
     * @return
     */
    public User findUserById(String id);

    /**
     * 修改用户信息的方法
     * @param user
     */
    public void updateUser(User user);

    /**
     *删除选中的用户
     * @param ids
     */
    public void delSelectedUser(String[] ids);

    /**
     * 分页查询User
     * @param _currentPage
     * @param _rows
     * @param condition
     * @return
     */
    public PageBean<User> findUserByPage(String _currentPage, String _rows, Map<String, String[]> condition);
}

实现类

package service.impl;

import dao.UserDao;
import dao.impl.UserDaoImpl;
import domain.PageBean;
import domain.User;
import service.UserService;

import java.util.List;
import java.util.Map;

public class UserServiceImpl implements UserService {
    private UserDao dao=new UserDaoImpl();
    @Override
    public List<User> findAll() {
        /**
         * 使用Dao完成查询
         */
        return dao.findAll();
    }

    @Override
    public void addUser(User user) {
        /**
         * 调用Dao完成添加
         */
       dao.add(user);
    }

    @Override
    public User login(User user) {
        /**
         * 调用Dao实现登录
         */
        return dao.findUserBynameAndPassword(user.getName(),user.getPassword());
    }

    @Override
    public void deleteUser(String id) {
        /**
         * 调用Dao完成删除
         */
        dao.delete(Integer.parseInt(id));
    }

    @Override
    public User findUserById(String id) {
        /**
         * 调用Dao方法完成查询
         */
        return dao.findById(Integer.parseInt(id));
    }

    @Override
    public void updateUser(User user) {
        /**
         * 调用Dao方法完成修改
         */
        dao.update(user);
    }

    @Override
    public void delSelectedUser(String[] ids) {
        /**
         * 调用Dao方法完成删除
         */
        if(ids!=null&&ids.length>0){
        for (String id:ids) {
            dao.delete(Integer.parseInt(id));
            }
        }
    }

    @Override
    public PageBean<User> findUserByPage(String _currentPage, String _rows, Map<String, String[]> condition) {
        /**
         * 调用Dao方法完成分页查询
         */
        //1，检查参数是否正确
        if (_currentPage==null||"".equals(_currentPage)){
            _currentPage="1";
        }
        if(_rows==null||"".equals(_rows)){
            _rows="5";
        }
        //2,创建空的PageBean对象
        PageBean<User> pb=new PageBean<User>();
        int currentPage=Integer.parseInt(_currentPage);
        int rows=Integer.parseInt(_rows);
        //判断currentPage是否小于0
        if(currentPage<=0){
            currentPage=1;
        }
        //3,调用Dao方法查询
        //3.1查询总记录数
        int totalCount=dao.findTotalCount(condition);
        //4.1计算总页码码数
        int totalPage=totalCount%rows==0?totalCount/rows:totalCount/rows+1;
        //判断currentPage是否大于最大页数
        if(currentPage>totalPage){
            currentPage=totalPage ;
        }
        //3.2查询用户信息
        //计算开始的记录索引
        int start=(currentPage-1)*rows;
        if(start<0){
            start=0;
        }
        List<User> list=dao.findUserByPage(start,rows,condition);
        //4，将数据封装到PageBean对象中
        pb.setCurrentPage(currentPage);
        pb.setList(list);
        pb.setRows(rows);
        pb.setTotalPage(totalPage);
        pb.setTotalCount(totalCount);
        return pb;
    }
}

5，Dao层（持久层）

UserDao接口

package dao;

import domain.User;

import java.util.List;
import java.util.Map;

/**
 * 用户操作的Dao
 */
public interface UserDao {
    /**
     * 查询所有记录的方法
     * @return
     */
    public List<User> findAll();

    /**
     *根据姓名和密码查询记录
     * @param name
     * @param password
     * @return
     */
    public User findUserBynameAndPassword(String name,String password);

    /**
     * 添加数据的方法
     * @param user
     */
    public void add(User user);

    /**
     * 删除数据的方法
     * @param id
     */
    public void delete(int id);

    /**
     * 根据id查询数据
     * @param id
     * @return
     */
    public User findById(int id);

    /**
     * 根据id修改用户信息
     * @param user
     */
    public void update(User user);

    /**
     * 查询表中总记录数
     * @return
     * @param condition (查询条件)
     */
    public int findTotalCount(Map<String, String[]> condition);

    /**
     * 分页查询
     * @param start
     * @param rows
     * @param condition (查询条件)
     * @return
     */
    public List<User> findUserByPage(int start, int rows, Map<String, String[]> condition);
}

实现类

package dao.impl;

import dao.UserDao;
import domain.User;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import util.JDBCUtils;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Set;

public class UserDaoImpl implements UserDao {
    //创建连接池对象
    private JdbcTemplate template= new JdbcTemplate(JDBCUtils.getDataSource());
    @Override
    /**
     * 查询所有记录的方法
     * @return
     */
    public List<User> findAll() {
        //使用JDBC操作数据库
        String sql="select * from user1";
        List<User> users = template.query(sql, new BeanPropertyRowMapper<User>(User.class));
        return users;
    }

    @Override
    /**
     *根据姓名和密码查询记录
     * @param name
     * @param password
     * @return
     */
    public User findUserBynameAndPassword(String name,String password){
        //使用JDBC操作数据库
        try {
            String sql="select * from user1 where name= ? and password= ?";
            User loginUser=template.queryForObject(sql,new BeanPropertyRowMapper<User>(User.class),name,password);
            return loginUser;
        } catch (DataAccessException e) {
            e.printStackTrace();
            return null;
        }
    }

    @Override
    /**
     * 添加数据的方法
     * @param user
     */
    public void add(User user) {
        String sql="insert into user1 values(null,?,?,?,?,?,?,null)";
        template.update(sql,user.getName(),user.getGender(),user.getAge(),user.getAddress(),user.getQq(),user.getEmail());
    }

    @Override
    /**
     * 删除数据的方法
     * @param id
     */
    public void delete(int id) {
        String sql="delete from user1 where id=?";
        template.update(sql,id);
    }

    @Override
    /**
     * 根据id查询数据
     * @param id
     * @return
     */
    public User findById(int id) {
        try {
            String sql="select * from user1 where id=?";
            User user = template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), id);
            return user;
        } catch (DataAccessException e) {
            e.printStackTrace();
            return null;
        }
    }

    @Override
    /**
     * 根据id修改用户信息
     * @param user
     */
    public void update(User user) {
        String sql="update user1 set name=?,gender=?,age=?,address=?,qq=?,email=? where id=?";
        template.update(sql,user.getName(),user.getGender(),user.getAge(),user.getAddress(),user.getQq(),user.getEmail(),user.getId());
    }

    @Override
    /**
     * 查询表中总记录数
     * @return
     */
    public int findTotalCount(Map<String, String[]> condition) {
        //1,定义模板初始化sql
        String sql="select count(*) from user1 where 1=1";
        StringBuilder sb=new StringBuilder(sql);
        //2,遍历map集合取出查询条件
        Set<String> keySet = condition.keySet();
        //创建list集合传参
        List<Object> params=new ArrayList<Object>();
        for (String key:keySet) {
            //2.2,判断key不是当前页码和每页显示行数
            if("currentPage".equals(key)||"rows".equals(key)){
                continue;
            }
            //2.2,取出条件
            String value=condition.get(key)[0];
            //2.3,判断value是否为空
            if(value!=null&&!"".equals(value)){
                //2.3.1将value拼接到sal中
                sb.append(" and "+key+" like ?");
                params.add("%"+value+"%");//将条件的值保存进集合
            }
        }
        return template.queryForObject(sb.toString(),Integer.class,params.toArray());

    }

    @Override
    /**
     * 分页查询表中数据
     */
    public List<User> findUserByPage(int start, int rows, Map<String, String[]> condition) {
        //1,定义初始化模板sql
        String sql="select * from user1 where 1=1";
        StringBuilder sb=new StringBuilder(sql);
        //2,遍历map集合取出查询条件
        Set<String> keySet = condition.keySet();
        //创建list集合传参
        List<Object> params=new ArrayList<Object>();
        for (String key:keySet) {
            //2.2,判断key不是当前页码和每页显示行数
            if("currentPage".equals(key)||"rows".equals(key)){
                continue;
            }
            //2.2,取出条件
            String value=condition.get(key)[0];
            //2.3,判断value是否为空
            if(value!=null&&!"".equals(value)) {
                //2.3.1将value拼接到sal中
                sb.append(" and " + key + " like ?");
                params.add("%"+value+"%");//将条件的值保存进集合
            }
        }
        //添加分页功能
        sb.append(" limit ?,? ");
        params.add(start);
        params.add(rows);
        List<User> list = template.query(sb.toString(), new BeanPropertyRowMapper<User>(User.class),params.toArray());
        return list;
    }
}

6，javaBean对象

1，user对象

package domain;

public class User {
    private int id;
    private String name;
    private String gender;
    private int age;
    private String address;
    private String qq;
    private String email;
    private String password;

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getQq() {
        return qq;
    }

    public void setQq(String qq) {
        this.qq = qq;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", gender='" + gender + '\'' +
                ", age=" + age +
                ", address='" + address + '\'' +
                ", qq='" + qq + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

2，page对象

package domain;

import java.util.List;

public class PageBean<T> {
    private int totalCount;//总记录数
    private int rows;//每页显示的记录数
    private int totalPage;//总页数
    private int currentPage;//当前页数
    private List<T>list;//每页的数据

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    public int getRows() {
        return rows;
    }

    public void setRows(int rows) {
        this.rows = rows;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getCurrentPage() {
        return currentPage;
    }

    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }

    public List<T> getList() {
        return list;
    }

    public void setList(List<T> list) {
        this.list = list;
    }

    @Override
    public String toString() {
        return "PageBean{" +
                "totalCount=" + totalCount +
                ", rows=" + rows +
                ", totalPage=" + totalPage +
                ", currentPage=" + currentPage +
                ", list=" + list +
                '}';
    }
}

weixin_51721994

关注

4
点赞
踩
39

收藏

觉得还不错? 一键收藏
2
评论
JavaWeb 用户信息管理系统（Servlet+JSP+MySQL+JDBCTempleat+Duird+BeanUtilS+tomcat）

1，功能1. 简单功能 1. 列表查询 2. 登录 3. 添加 4. 删除 5. 修改 2. 复杂功能 1. 删除选中 2. 分页查询 ...
复制链接

扫一扫