2020-10-23

最新推荐文章于 2020-11-24 11:40:03 发布

箴孞

最新推荐文章于 2020-11-24 11:40:03 发布

阅读量177

点赞数

本文链接：https://blog.csdn.net/M201819101016/article/details/109238710

版权

这是一个简单的Java Web应用程序，实现了用户注册和登录的功能。注册页面包含用户名、密码、性别和年龄字段，并通过POST方法将数据提交到`register.jsp`进行数据库插入操作。登录页面接收用户名和密码，验证后跳转到个人中心。个人中心可以查看、添加、编辑和删除用户信息。所有交互使用了JDBC进行数据库操作，并依赖于Bootstrap库进行页面样式设计。

摘要由CSDN通过智能技术生成

注册页面
index

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>注册页面</title>

    <link rel="stylesheet" href="css/bootstrap.css">

    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>
    <style>
        .container{
            width: 20%;
            height: 20%;
            margin-top: 10%;
        }
    </style>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <form method="post" action="register.jsp">
                用户名:<input type="text" name="username"><br>
                密码: <input type="text" name="password"><br>
                性别: <input type="text" name="gender"><br>
                年龄: <input type="text" name="age"><br>
                <button type="submit">注册</button>
            </form>
        </div>
    </div>
</div>
</body>
</html>

userbean

package com.media.bean;

public class UserBean {
    private int id;
    private String username;
    private String password;
    private int gender;
    private int age;
    private int status;

    public int getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

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

    public int getGender() {
        return gender;
    }

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

    public int getAge() {
        return age;
    }

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

    public int getStatus() {
        return status;
    }

    public void setStatus(int status) {
        this.status = status;
    }
}

<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    UserBean user = new UserBean();
    user.setUsername(request.getParameter("username"));
    user.setPassword(request.getParameter("password"));
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://127.0.0.1:3306/book?user=root&password=root";
    Connection connection = DriverManager.getConnection(url);
    Statement stmt = connection.createStatement();
    String sql = "insert into user (username,password,gender,age) values('"+user.getUsername()+"','"+user.getPassword()+"',1,23)";

    int count = stmt.executeUpdate(sql);
    if(count == 0 ){
        out.print("注册失败");
    }else{
        out.print("注册成功");
    }
%>
</body>
</html>

在这里插入图片描述

登陆页面
login

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>登陆页面</title>

    <link rel="stylesheet" href="css/bootstrap.css">

    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>
    <style>
        .container{
            width: 20%;
            height: 20%;
            margin-top: 10%;
        }
    </style>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <form role="form" method="post" action="index.jsp">
                <h3 style="text-align: center"登录></h3>
                <div class="form-group">
                    <label for="exampleInputEmail1">用户名：</label><input name="username" class="form-control" id="exampleInputEmail1" type="text" />
                </div>
                <div class="form-group">
                    <label for="exampleInputPassword1">密码：</label><input name="password" class="form-control" id="exampleInputPassword1" type="password" />
                </div>
                <button class="btn btn-default" type="submit">提交</button>
            </form>
        </div>
    </div>
</div>
</body>
</html>

index

<%
  request.setCharacterEncoding("utf-8");
  String username = request.getParameter("username");
  String password = request.getParameter("password");

  Class.forName("com.mysql.jdbc.Driver");

  String url = "jdbc:mysql://localhost:3306/book";
  Connection connection = DriverManager.getConnection(url,"root","root");

  //sql模板
  String sql = "select * from user where username = ? and password = ?";

  PreparedStatement ps = connection.prepareStatement(sql);

  ps.setString(1,username);
  ps.setString(2,password);

  ResultSet rs = ps.executeQuery();

  if (rs.next()){
    //表示登录成功
    session.setAttribute("username","username");
    response.sendRedirect("home.jsp");
  }else{
    //表示登录未成功
    out.print("登录失败，3秒之后跳转登陆页面");
    response.setHeader("refresh","3;url=login.jsp");
  }
%>

在这里插入图片描述

home

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>个人中心</title>
    <%--引入css文件和js文件--%>
    <link rel="stylesheet" href="css/bootstrap.css">

    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>
    <style>
        .container{
            margin-top:20px;
        }
    </style>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <h3 style="text-align: center">欢迎来到个人主页！</h3>
            <a href="#modal-container-addUser" role="button" class="btn" data-toggle="modal">添加用户</a>
            <table class="table table-striped">
                <thead>
                <th>ID</th>
                <th>用户名</th>
                <th>性别</th>
                <th>年龄</th>
                <th>操作</th>
                </thead>
                <tbody>

                    <%
    if (session.getAttribute("username") == null) {
        //表示尚未登陆
        out.print("你尚未登陆，3秒之后跳转登陆页面");
        response.setHeader("refresh", "3;nur=logjin.jsp");
    }else {
        Class.forName("com.mysql.jdbc.Driver");

        //建立数据库连接
        String url = "jdbc:mysql://localhost:3306/book";//数据库连接地址
        Connection connection = DriverManager.getConnection(url, "root", "root");

        //stmt.executeUpdate()执行增删改的驱动
        String sql = "select * from user ";
        PreparedStatement ps = connection.prepareStatement(sql);

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            out.print("<td>"+rs.getInt("id")+"</td>"
                    +"<td>"+rs.getString("username") +"</td>"
                    +"<td>"+rs.getString("gender") +"</td>"
                    +"<td>"+ rs.getString("age") +"</td>"
                    +"<td><a href='delete.jsp?id="+rs.getInt("id")+"'>删除</a>"
                    +"&nbsp;<a href='edit.jsp?id="+rs.getInt("id")+"'>编辑</a></td>");
            out.print("</tr>");
        }
    }
%>
            </table>
            </table>
            <div class="modal fade" id="modal-container-addUser" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h4 class="modal-title" id="myModalLabel">添加用户</h4>
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                        </div>
                        <form role="form" method="post" action="add.jsp">
                            <div class="modal-body">
                                <div class="form-group">
                                    <label>用户名:</label><input type="text" name="username" class="form-control" />
                                </div>
                                <div class="form-group">
                                    <label>密码:</label><input type="password" name="password" class="form-control" />
                                </div>
                                <div class="form-group">
                                    <label>性别:</label><input type="text" name="gender" class="form-control" />
                                </div>
                                <div class="form-group">
                                    <label>年龄:</label><input type="text" name="age" class="form-control" />
                                </div>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
                                <button type="submit" class="btn btn-primary">添加</button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</body>
</html>

在这里插入图片描述

add

<jsp:useBean id="user" class="com.media.bean.UserBean"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>

<%
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/book";
    Connection connection = DriverManager.getConnection(url,"root","root");

    String sql = "insert into user (username,password,gender,age) value (?,?,?,?)";
    PreparedStatement ps = connection.prepareStatement(sql);

    ps.setString(1,user.getUsername());
    ps.setString(2,user.getPassword());
    ps.setInt(3,user.getGender());
    ps.setInt(4,user.getAge());

    int count = ps.executeUpdate();
    if(count > 0){
        out.print("添加成功");
    }else{
        out.print("添加失败");
    }
    response.setHeader("refresh","3;url=home.jsp");
%>

在这里插入图片描述

delete

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    Class.forName("com.mysql.jdbc.Driver");

    //建立数据库连接
    String url = "jdbc:mysql://localhost:3306/book";//数据库连接地址
    Connection connection = DriverManager.getConnection(url, "root", "root");
    String sql = "delete from user where id = ?";
    PreparedStatement ps = connection.prepareStatement(sql);

    int id = Integer.parseInt(request.getParameter("id"));

    ps.setInt(1,id);

    int count = ps.executeUpdate();

    if (count >0){
        out.print("删除成功");
    }else{
        out.print("删除失败");
    }
%>

在这里插入图片描述

edit

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>编辑页面</title>

    <link rel="stylesheet" href="css/bootstrap.css">

    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>

    <style>
        .container{
            width: 50%;
            margin-top:20px;
        }
    </style>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <h3 style="text-align: center">编辑页面</h3>
            <form method="post" action="update.jsp">

                <%
                    int id = Integer.parseInt(request.getParameter("id"));

                    //加载驱动
                    Class.forName("com.mysql.jdbc.Driver");

                    //建立数据库连接
                    String url = "jdbc:mysql://localhost:3306/book";//数据库连接地址
                    Connection connection = DriverManager.getConnection(url, "root", "root");

                    //stmt.executeUpdate()执行增删改的驱动
                    String sql = "select * from user where id=?";
                    PreparedStatement ps = connection.prepareStatement(sql);

                    ps.setInt(1,id);

                    ResultSet rs = ps.executeQuery();

                    while (rs.next()){
                        out.print("<input type='hidden' name='id' value="+rs.getString("id")+">");
                        out.print("用户名:<input type='text' class='form-control' name='username' value="+rs.getString("username")+"><br>");
                        out.print("密码:<input type='text' class='form-control' name='password' value="+rs.getString("password")+"><br>");
                        out.print("性别:<input type='text' class='form-control' name='gender' value="+rs.getString("gender")+"><br>");
                        out.print("年龄:<input type='text' class='form-control' name='age' value="+rs.getString("age")+"><br>");
                    }
                %>
                <button type="submit" style="width: 100%" class="btn btn-info">提交</button>
            </form>
        </div>
    </div>
</div>
</body>
</html>

update

<jsp:useBean id="user" class="com.media.bean.UserBean"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/book";
    Connection connection = DriverManager.getConnection(url, "root", "root");
    String sql = "update user set username = ?, password = ?,gender = ?,age = ? where id = ?";
    PreparedStatement ps = connection.prepareStatement(sql);

    ps.setString(1,user.getUsername());
    ps.setString(2,user.getUsername());
    ps.setInt(3,user.getGender());
    ps.setInt(4,user.getAge());
    ps.setInt(5,user.getId());

    int count = ps.executeUpdate();

    if (count >0){
        out.print("修改成功");
    }else{
        out.print("修改失败");
    }
%>