JSP第七周作业 

package com.example.demo;

import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;

public class Register extends HttpServlet {
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException {
        response.setContentType("text/html");
        User user = new User(request.getParameter("uname"), request.getParameter("upwd"));
        int commited = UserDao.addUser(user);
        if (commited == 1)
            response.getWriter().write("注册成功");
        else
            response.getWriter().write("注册失败");
        response.getWriter().write("<a href='index.jsp'>返回主页</a>");
    }
}

　　User.java

package com.example.demo;

public class User
{
    int uid;
    String uname;
    String upwd;

    User(String uname, String upwd)
    {
        this.uname = uname;
        this.upwd = upwd;
    }
}

UserDao.java

package com.example.demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class UserDao {
    static
    {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    public static int addUser(User user)
    {
        try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/user", "root", "********");
            PreparedStatement ps = conn.prepareStatement("insert into usertable values(null, ?, ?)");
            ps.setString(1, user.uname);
            ps.setString(2, user.upwd);
            return ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return 0;
    }
}

　　register_page.jsp

<%@ page import="java.util.Random" %><%--
  Created by IntelliJ IDEA.
  User: Kengxxiao
  Date: 2021/4/19
  Time: 17:16
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>注册</title>
</head>
<body>
<form action="register" method="post">
    <p>账号：<label>
        <input type="text" name="username">
    </label></p>
    <p>密码：<label>
        <input type="password" name="password">
    </label></p>
    <input type="submit" value="注册">
</form>
<a href="index.jsp">返回登录</a>
</body>
</html>

 

posted @ 2021-04-19 17:42  Cieltec  阅读(92)  评论(0)    收藏  举报