学生信息增删改查操作

最新推荐文章于 2022-11-22 08:54:50 发布

niugulumaotao

最新推荐文章于 2022-11-22 08:54:50 发布

阅读量986

点赞数 1

本文链接：https://blog.csdn.net/niugulumaotao/article/details/109248133

版权

编写一个注册页面index.jsp

<body>
<form action="register.jsp" method="post">
    用户名：<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>
</body>

注册成功提示页面

<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");
    Statement stmt = connection.createStatement();
    String sql = "inser into user(username,password,gender,age) valuse("+user.getUsername()+","+user.getPassword()+",1,20)";
    int count = stmt.executeUpdate(sql);
    if(count >0){
   
        out.print("注册成功");
    }else{
   
        out.print("注册失败");
    }
%>

编写登录页面

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>

<%
    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对象执行sql语句
    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.jsp

<%@ page import="java.sql.*" %>

<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">添加用户

最低0.47元/天解锁文章

niugulumaotao

关注

1
点赞
踩
13

收藏

觉得还不错? 一键收藏
3
评论
学生信息增删改查操作

编写一个注册页面index.jsp<body><form action="register.jsp" method="post"> 用户名：<input type="text" name="username"><br> 密码：<input type="text" name="password"><br> 性别：<input type="text" name="gender"><br>
复制链接

扫一扫