checkuser.java~32~

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

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 int check(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()) {
        this.checkResult = 0;
      }
      else if (!password.equals(rsLogin.getString("Password"))) {
        this.checkResult = 0;
      }
      else {
        this.checkResult = 1;
      }
      return checkResult;
    }c

  }
}