📄 5.jsp~11~
字号:
<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%//防止直接输入URL访问页面,但是不能防止从其他的地方连接过来//加到JSP页面里面String ComeUrl ="";//取得上一级页面的RULComeUrl = request.getHeader("REFERER");if (ComeUrl == null) {response.sendRedirect("jsp2.jsp");out.print("<script>type='text/JavaScript'>alert('对不起，为了系统安全，请正确使用本系统！');</script>");}%><link href="2.css" rel="stylesheet" type="text/css" /><html><center><body> <div id="Header"></div><%!String file;%> <% String sql = "select * from adm;"; Statement stmt=null; PreparedStatement pstmt=null; ResultSet rs=null; //加载JDBC-ODBC桥驱动 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); //显示UPL和连接信息 System.out.print("URL:" + url); System.out.print("Connection:" + con); //得到一个Statement对象 stmt = con.createStatement(); //执行SQL语句 System.out.print("SQL:" + sql); ResultSet p = stmt.executeQuery(sql); ResultSetMetaData meta = p.getMetaData(); %><table width=1000 border=2 cellpadding=2 cellspacing=8 align="center" ><tr bgcolor=#6681D9 ><td height=20 colspan=8><div align=center><font SIZE="20" color="red">会员详细目录</font></td></tr><tr bgcolor=#D9E0F9 ><td align=center><font color="#309aff">会员帐号</font></td><td align=center><font color="#309aff">会员密码</font></td><td align=center><font color="#309aff">权限</font></td><td align=center><font color="#309aff">会员真实姓名</font></td><td align=center><font color="#309aff">电话</font></td><td align=center><font color="#309aff">密码提示问题</font></td><td align=center><font color="#309aff">密码提示答案</font></td></tr> <% while(p.next()) { out.print("<td align=center> "+p.getString("name")+"</td>"); out.print("<td align=center> "+p.getString("password")+"</td>"); out.print("<td align=center> "+p.getString("permit")+"</td>"); out.print("<td align=center> "+p.getString("userzhenshiname")+"</td>"); out.print("<td align=center> "+p.getString("tel")+"</td>"); out.print("<td align=center> "+p.getString("question")+"</td>"); out.print("<td align=center> "+p.getString("answer")+"</td></tr>"); } } catch (Exception e) {}%></table><a href="jsp1.jsp">返回申请教材</a><a href="jsp2.jsp">返回主页</a></body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -