我有一个在mySql中注册用户的代码,我希望它能够在创建用户之前检查用户是否已经存在
这就是我目前所拥有的
@EJB
private UserEJB userEJB;
private User user;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
// TODO Auto-generated method stub
String firstname = request.getParameter("fname");
String surname = request.getParameter("sname");
String email = request.getParameter("email");
String password = request.getParameter("password");
user = new User(firstname, surname, email, password);
CreateUser(user);
JOptionPane.showMessageDialog(null, "Thank You for Registering, Login to continue");
RequestDispatcher rsd = request.getRequestDispatcher("login.html");
rsd.forward(request, response);
}
}
public void CreateUser(User user){
userEJB.addUser(user);
}发布于 2019-09-09 19:45:22
您没有发布更多信息。因此,我将给你一个基本的想法来实现你需要的东西。
我将email作为唯一字段获取,因为两个用户不能有相同的电子邮件地址。因此,您的SQL查询应该是这样的。
SELECT * FROM users WHERE email = ? // Select all users belongs to the provided email和一个示例代码供您参考。
boolean isAvailable = false;
String email = request.getParameter("email"); // Get email from a form
String query = "SELECT * FROM users WHERE email = ?"; // Select all users belongs to the provided email
try {
PreparedStatement statement; // Using a preparedStatement to prevent SQL-Injection
ResultSet resultSet;
statement = connection.prepareStatement(query);
statement.setString(1, email);
resultSet = statement.executeQuery();
if(resultSet.next()) {
isAvailable = true;
} else {
isAvailable = false;
}
} catch (SQLException ex) {
ex.printStackTrace();
}因此,如果isAvailable提供true,则在您的情况下,用户已经是注册用户。但是,如果isAvailable提供false,则用户不在数据库中。
希望这对你有帮助。
https://stackoverflow.com/questions/57852983
复制相似问题