当前位置导航:炫浪网>>网络学院>>编程开发>>JAVA教程>>Java进阶

用户登录的验证完整程序


  public String validateUser(String inputUserid, String inputPwd)
  throws SQLException{
  String returnString = null;
  String dbUserid = "userid"; // Your Database user id
  String dbPassword = "password" ; // Your Database password
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:myDriver",
  dbUserid ,dbPassword );
  Statement stmt = con.createStatement();
  String sql= "select USERID from USERTABLE where USERID = "" +
  inputUserid + "" and PASSWORD = "" + inputPwd +"" ;" ;
  ResultSet rs = stmt.executeQuery(sql);
  if (rs.next())
  {
  returnString = rs.getString("USERID");
  }
  stmt.close();
  con.close();
  return returnString ;
  }
相关内容
赞助商链接