标题: [分享]用户登录验证的JSP完整程序 [打印本页]

---

作者: magic    时间: 2004-6-30 09:38     标题: [分享]用户登录验证的JSP完整程序

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]

复制代码

---

欢迎光临 星星博客 (http://commerce.huhoo.net/)

Powered by Discuz! 7.0.0