📄 answer.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body background="images/bg1.gif">
<%
String answer;
answer=request.getParameter("answer");
String sql="select * from zhuce where answer='"+answer+"'";
ResultSet rs=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn=DriverManager.getConnection("jdbc:odbc:index"," "," ");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{String username=rs.getString(1);
String password=rs.getString(2);
String question=rs.getString(4);
if(question.equals(session.getValue("question3")))
{
%>
<table width="550" border="0" align="center">
<tr>
<td colspan="3" background="images/bg01.gif"><img src="images/index_top.gif" width="550" height="12"></td>
</tr>
<tr>
<td colspan="3" background="images/bg01.gif"><img src="images/tle_login.gif" width="550" height="100"></td>
</tr>
<tr>
<td colspan="3" background="images/bg_menu.gif"><font size="1"><img src="images/attention.gif" width="16" height="15"><font color="#CC6600" size="2" face="楷体_GB2312">您的密码已经找回，请牢记您的用户名和密码，重新登陆</font></font></td>
</tr>
<tr>
<td width="30%" background="images/bg01.gif">
<div align="right"></div></td>
<td width="40%" bgcolor="#FFFFFF"><img src="images/bul_or_tri1.gif" width="4" height="7"><font size="2">用户名：</font><%=username%></td>
<td width="30%" background="images/bg01.gif"> </td>
</tr>
<tr>
<td width="30%" background="images/bg01.gif">
<div align="right"></div></td>
<td width="40%" bgcolor="#FFFFFF"><img src="images/bul_or_tri1.gif" width="4" height="7"><font size="2">密 码：</font><%=password%></td>
<td width="30%" background="images/bg01.gif"> </td>
</tr>
<tr>
<td colspan="3" background="images/bg_menu.gif">
<div align="center"> </div></td>
</tr>
<tr>
<td width="30%" background="images/bg01.gif"> </td>
<td width="40%" bgcolor="#FFFFFF">
<div align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="20">
<param name="movie" value="button4.swf">
<param name="quality" value="high">
<param name="base" value=".">
<embed src="button4.swf" base="." quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="20" ></embed>
</object>
</div></td>
<td width="30%" background="images/bg01.gif"> </td>
</tr>
<tr background="images/bg01.gif">
<td width="30%"> </td>
<td width="40%"> </td>
<td width="30%"> </td>
</tr>
</table>
<% }
} stmt.close();
conn.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("数据没有写入");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -