checkuser.java~27~

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

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

public class CheckUser {
  private Connection conn;
  private int checkResult;

  public CheckUser() {
    this.checkResult=0;
  }

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

  public boolean check(String username,String password){
    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()){
      this.checkResult=0;
    }else if(!password.equals(rsLogin.getString("Password"))){
      this.checkResult=0;
    }else{
      session.putValue("username",username);
      this.checkResult=1;
    }
    return checkResult;
    }
}