signin.java

一个注册系统的源代码

package signup;

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

/**
 *
 * 本程序为帮助初学者了解Jsp/javabean　不建议商业用途　进一步使用请参考Struts框架
 *
 * J道版权所有　
 * J道(http://www.jdon.com)　Java的解决之道。
 *
 */



public class SignIn {

  private static BeansConstants CONST = BeansConstants.getInstance(); //常量集

  public boolean SignIn(String userid, String password) {
    boolean check = false;
    String sql =
        "SELECT userid,password FROM password WHERE userid=? AND password = PASSWORD(?)";
    try {
      Mysql mysql = new Mysql(sql);
      mysql.setString(1, userid);
      mysql.setString(2, password);
      ResultSet RS = mysql.executeQuery();
      if (RS.next()) {
        RS.close();
        RS = null;
        check = true;
        return check;
      }
      RS.close();
      RS = null;
      return check;
    }
    catch (Exception e) {
      e.printStackTrace();
      if (e instanceof SQLException) {
        return check;
      }
      else {
        return check;
      }
    }
  }

}