java - 项目未将数据从 Java Web 应用程序插入数据库

Question

我已经为一个使用 JSP 和 java 的网站制作了一个注册表单，但我无法得到任何错误来解释为什么没有数据进入数据库

这是我的Java代码，旨在添加到数据库中

public class RegDatabaseConnector {
    public int registerUser(register register) throws ClassNotFoundException {
        String INSERT_USERS_SQL = "INSER INTO USERS" + 
        "(userid,username,firstname,lastname,password,email) VALUES " +
        "(?, ?, ?, ?, ?, ?)";
        
        int result = 0;
        
        Class.forName("com.mysql.jdbc.Driver");
        
        
        try (Connection conn = DriverManager.getConnection("jdbc:MYSQL://localhost:3306/projectdb", "root", "Not4U2no!");
                PreparedStatement preparedStatement = conn.prepareStatement(INSERT_USERS_SQL)) {
                preparedStatement.setInt(1,1);
                preparedStatement.setString(2, register.getUsername());
                preparedStatement.setString(3, register.getFirstName());
                preparedStatement.setString(4, register.getLastName());
                preparedStatement.setString(5, register.getPassword());
                preparedStatement.setString(6, register.getEmail());
                
                result = preparedStatement.executeUpdate();
        }catch (SQLException  e){
            printSQLException(e);
        }
        return result; 
        }
    
    private void printSQLException(SQLException ex){
        for (Throwable e: ex) {
            if (e instanceof SQLException) {
                e.printStackTrace(System.err);
                System.err.println("SQLState: " + ((SQLException) e).getSQLState());
                System.err.println("Error Code: " + ((SQLException) e).getErrorCode());
                System.err.println("Message: " + e.getMessage());
                Throwable t = ex.getCause();
                while (t != null) {
                    System.out.println("Cause: " + t);
                    t = t.getCause();
                }
            }
        }
    }
        
}

标签： javamysqljsp