用户登录的验证完整程序

文章作者 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 .

}