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>
