public class SignIn {

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

  private String action = null;
  private String userid = null;
  private String password = null;

  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() {
    boolean check = false;
    Mysql mysql = new Mysql(sql);
    try {
      mysql.setString(1, userid);
      mysql.setString(2, password);
      ResultSet rs = mysql.executeQuery();
      if (rs.next()) {
        check = true;
      }
    } catch (Exception e) {
      System.err.println(e);
    }
    finally {
      mysql.close();
      mysql = null;
    }
    return check;
  }

}

public interface SignInIF {
  
  public boolean save();

}