所需阅读权限 1[分享]用户登录验证的JSP完整程序

magic

1. [font=宋体]public String validateUser(String inputUserid, String inputPwd)
2. throws SQLException
3. {
4. String returnString = null;
5. String dbUserid = "userid"; // 数据库的用户名
6. String dbPassword = "password" ; //数据库的密码
7. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
8. Connection con = DriverManager.getConnection("jdbc:odbc:myDriver", dbUserid , dbPassword );
9. Statement stmt = con.createStatement();
10. String sql= "select USERID from USERTABLE where USERID = '" + inputUserid + "' and PASSWORD = '" + inputPwd +"' ;" ;
11. ResultSet rs = stmt.executeQuery(sql);
12. if (rs.next())
13. {
14. returnString = rs.getString("USERID");
15. }
16. stmt.close();
17. con.close();
18. return returnString ;
19. }[/font]

复制代码