heck.jsp 用于测试是否成功: <%@ page contentType="text/html; charset=gb2312" language="java" errorPage=""%> <%@ page import="java.sql.*" %>
xml:namespace prefix = jsp />
<% String rand =(String)session.getAttribute("random"); String input =(String)session.getAttribute("input"); String user_name= (String)session.getAttribute("user_name"); String pass_word= (String)session.getAttribute("pass_word"); %>
系统产生的认证码为: <%= rand %>
您输入的认证码为: <%= input %>
验证码输入相同,认证成功! 您输入的用户名为: <%= session.getAttribute("user_name") %>
密码为: <%= session.getAttribute("pass_word") %>
<% String permit; ResultSet rs=null; String SqlString="select * from UserInfo where username='"+user_name+"'and password='"+pass_word+"'"; try { //设置连接 sqltest.setConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver", "jdbc:microsoft:
sqlserver://localhost:1433;DatabaseName=university", "admin","123456"); //设置 SQL 语句 sqltest.setQuerystatement(SqlString); //得到
查询结果 rs=sqltest.getResult(); if (rs.next()) { out.print("
登陆成功"); //获得用户的权限 permit=rs.getString("permit"); if (permit.equals("1")) { out.println(":你的权限是管理员组"); } else { out.println(":你的权限是用户组"); } } else { out.print("登陆失败,用户名或密码错"); } } catch(SQLException e1) {
out.print("SQL 异常!"); } %> 连接数据库的
Javabean: sqlbean.java package database; import java.sql.*; public class sqlbean { public String query_statement; public ResultSet resu
lt=null; public Connection conn; public void setQuerystatement(String query_statement) { this.query_statement=query_statement; } public void setConnection(String driverName ,String jdbcURL, String username,String passwd) throws Exception { Connection conn1; Class.forName(driverName); conn1=DriverManager.getConnection(jdbcURL, username, passwd); conn1.setAutoCommit(false); this.conn = conn1; } public ResultSet getResult() { try { PreparedStatement select_stm=conn.prepareStatement(query_statement, java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY) ; result=select_stm.executeQuery(); } catch(Exception e) { System.out.println(e); } return result; } }