📄 check.jsp~2~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage=""%><%@ page import="java.sql.*" %><html><head><title>认证码验证页面</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><META HTTP-EQUIV="Pragma" CONTENT="no-cache"><META HTTP-EQUIV="Cache-Control" CONTENT="no-cache"><META HTTP-EQUIV="Expires" CONTENT="0"></head><body><% 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 %><br>您输入的认证码为：<%= input %><br><font color=green>验证码输入相同，认证成功！</font><br><br>您输入的用户名为：<%= session.getAttribute("user_name") %><br>密码为：<%= session.getAttribute("pass_word") %><br><%String permit;String sql="select * from adm where name='"+user_name+"'and password='"+pass_word+"';"; Statement stmt=null; PreparedStatement pstmt=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //定义JDBC URL }catch (Exception e) { out.println(e.getMessage()); } try{ String url = "jdbc:odbc:s"; //得到与数据库的连接 Connection con = DriverManager.getConnection(url); //得到一个Statement对象 stmt = con.createStatement(); //执行SQL语句 System.out.print("SQL:" + sql); ResultSet rs = stmt.executeQuery(sql); ResultSetMetaData meta = rs.getMetaData(); if (rs.next()) { out.print("登陆成功"); //获得用户的权限 permit=rs.getString("permit"); if (permit.equals("1")) { response.sendRedirect("jsp8.jsp"); session.setAttribute("username",user_name); session.setAttribute("password",pass_word); } else { response.sendRedirect("jsp7.jsp"); session.setAttribute("username",user_name); session.setAttribute("password",pass_word); } } else { response.sendRedirect("jsp9.jsp"); } } catch (Exception e) {} %></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -