用户登录的验证完整程序
文章作者 100test 发表时间 2007:03:14 16:26:53
来源 100Test.Com百考试题网
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= "0select 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 .
}