checkuserbean.java~11~

本软件简单的实现的对商店的管理

package eshop;
import java.util.*;
import java.sql.*;

public class CheckUserBean {
  private Connection conn;
  private boolean checkResult;

  public CheckUserBean() {
    this.checkResult=false;
  }

  public void setConn(Connection conn){
    this.conn=conn;
  }

  public boolean checkUser(String username,String password){
    try {
      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                            ResultSet.CONCUR_READ_ONLY);
      String sql = "SELECT * FROM Customers WHERE Username='" + username + "'";
      ResultSet rsLogin = stmt.executeQuery(sql);
      if(rsLogin.next()){
              response.sendRedirect("registerFailure.jsp");
      }else{
              String sql2="INSERT INTO Customers(Username,Password,Question,Answer) VALUES('"+username+"','"+password+"','"+question+"','"+answer+"')";
              stmt.executeUpdate(sql2);
              response.sendRedirect("registerOK.jsp");
      }

      rsLogin.close();
      stmt.close();
    }catch(SQLException e){
      e.printStackTrace();
    }
    return checkResult;
  }
}