jsp网上注册系统

try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdb", "username", "password");
} catch (ClassNotFoundException | SQLException e) {
    e.printStackTrace();
}

function validateForm() {
    var x = document.forms["registrationForm"]["email"].value;
    if (x == "") {
        alert("Email must be filled out");
        return false;
    }
}

String email = request.getParameter("email");
if (email == null || email.isEmpty()) {
    // Handle error
}

String sql = "INSERT INTO users (username, password) VALUES (?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.executeUpdate();

String safeInput = ESAPI.encoder().encodeForHTML(userInput);

<form action="register.jsp" method="post">
    Username: <input type="text" name="username"><br>
    Password: <input type="password" name="password"><br>
    Email: <input type="text" name="email"><br>
    <input type="submit" value="Register">
</form>

<%@ page import="java.sql.*" %>
<%
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    String email = request.getParameter("email");
    
    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
        String sql = "INSERT INTO users (username, password, email) VALUES (?, ?, ?)";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, username);
        pstmt.setString(2, password);
        pstmt.setString(3, email);
        pstmt.executeUpdate();
        out.println("Registration successful!");
    } catch (Exception e) {
        out.println("Error: " + e.getMessage());
    }
%>