📄 zhaohui.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>
<style>
.button {
BORDER-RIGHT: #333333 1px ridge; PADDING-RIGHT: 1px; BORDER-TOP: #ffffff 1px ridge; PADDING-LEFT: 1px; FONT-SIZE: 9pt; PADDING-BOTTOM: 1px; BORDER-LEFT: #ffffff 1px ridge; CURSOR: hand; COLOR: #000000; PADDING-TOP: 1px; BORDER-BOTTOM: #000000 1px ridge; FONT-FAMILY: "宋体"; HEIGHT: 20px; BACKGROUND-COLOR: #f1f1f1
}
.INPUT {
BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; FONT-SIZE: 11px; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-LEFT: #cccccc 1px solid; WIDTH: 120px; COLOR: #666666; BORDER-BOTTOM: #cccccc 1px solid; FONT-FAMILY: Verdana,Geneva,Arial,Helvetica,sans-serif
}
.font {
FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: "Arial", "Helvetica", "sans-serif"
}
</style>
<body background="images/bg1.gif">
<%!
String username1;
%>
<%
username1=request.getParameter("username1");
String sql="select * from zhuce where username='"+username1+"'";
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 question=rs.getString(4);
request.getSession(true);
session.putValue("question3",question);
%>
<table width="550" border="0" align="center">
<tr>
<td colspan="3"><img src="images/index_top.gif" width="550" height="12"></td>
</tr>
<tr>
<td colspan="3"><img src="images/tle_login.gif" width="550" height="100"></td>
</tr>
<tr>
<td colspan="3" background="images/bg_menu.gif"><font color="#CC6600" size="1"><img src="images/attention.gif" width="16" height="15"><font size="2">请输入您的密码回答问题：</font></font></td>
</tr>
<tr>
<td width="19%" background="images/bg01.gif"> </td>
<td width="41%" rowspan="2" bgcolor="#FFFFFF"><font size="2">提示问题</font><font size="1">：</font>
<%=question%> <%} stmt.close();
conn.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("数据没有写入");
}
%> <form name="form1" method="post" action="answer.jsp">
<p><font size="2">回 答</font><font size="1">：</font>
<input name="answer" type="text" id="answer2" class="input">
</p>
<p align="center">
<input type="submit" name="Submit" value="提交" class="button">
</p>
</form>
</td>
<td width="40%" background="images/bg01.gif"> </td>
</tr>
<tr>
<td height="57" background="images/bg01.gif"> </td>
<td background="images/bg01.gif"> </td>
</tr>
<tr background="images/bg01.gif">
<td colspan="3"> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -