www.pudn.com > Easy_Buy电子商务系统.rar > CheckUserBean.java

//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()){ 
        checkResult=false; 
      }else if(!password.equals(rsLogin.getString("Password"))){ 
        checkResult=false; 
      }else{ 
        checkResult = true; 
      } 
      rsLogin.close(); 
      stmt.close(); 
    }catch(SQLException e){ 
      e.printStackTrace(); 
    } 
    return checkResult; 
  } 
}