package com.jdon.simpleregister;

import java.util.Properties;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * <p>Title: </p>
 * <p>Description:
 * 用戶登陸
 * </p>
 * <p>Copyright: Jdon.com Copyright (c) 2003</p>
 * <p>Company: 上海解道計算機技術有限公司</p>
 * @author banq
 * @version 1.0
 */
public class SignIn {

  private final static String sql =
      "SELECT userid,password FROM password WHERE userid=? AND password = PASSWORD(?)";

  private boolean auth = false;
  private String action = null;
  private String userid = null;
  private String password = null;

  public boolean isAuth()
    {
          return auth;
    }


  public String getAction() {
    return action;
  }

  public void setAction(String action) {
    this.action = action;
  }

  public String getUserid() {
    return userid;
  }

  public void setUserid(String userid) {
    this.userid = userid;
  }

  public String getPassword() {
    return password;
  }

  public void setPassword(String password) {
    this.password = password;
  }

  public boolean validate() {
    if (userid == null || userid.length() <= 0)
      return false;

    if (password == null || password.length() <= 0)
      return false;

    return true;
  }


  public boolean SignIn() {
    if (auth) return auth;
    Mysql mysql = new Mysql(sql);
    try {
      mysql.setString(1, userid);
      mysql.setString(2, password);
      ResultSet rs = mysql.executeQuery();
      if (rs.next()) {
        auth = true;
      }
    } catch (Exception e) {
      System.err.println(e);
    }
    finally {
      mysql.close();
      mysql = null;
    }
    return auth;
  }

}