所需阅读权限 1
[分享]用户登录验证的JSP完整程序
- [font=宋体]public String validateUser(String inputUserid, String inputPwd)
- throws SQLException
- {
- String returnString = null;
- String dbUserid = "userid"; // 数据库的用户名
- String dbPassword = "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 ;
- }[/font]
复制代码 |