📄 ch5-3.jsp
字号:
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>找回密码</title>
</head>
<body bgcolor="#FFFFCC">
<p> </p>
<p align="center">
<%
String name=request.getParameter("name");
String password=request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:ch5";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from user where 姓名='"+name+"'";
ResultSet rs=st.executeQuery(strSql);
if(!rs.next())
{out.print("输入的用户名不正确!");
out.print("<a href=ch5-3.htm>返回</a>");
return;}
%>
</p>
<form name="form1" method="post" action="ch5-31.jsp">
<table width="58%" height="135" border="0" align="left" cellspacing="0" bgcolor="#FFFFCC">
<!--DWLayoutTable-->
<tr>
<td height="18"> </td>
<td width="278"> </td>
</tr>
<tr>
<td><div align="right">密码提示问题:</div></td>
<td> <%out.print(rs.getString("密码提示"));%> <input name="name" type="hidden" value="<%out.print(rs.getString("姓名"));%>"></td>
</tr>
<tr>
<td height="76" align="center" valign="middle"> <div align="left"></div>
<div align="right">请输入答案:</div></td>
<td><input type="text" name="answer"></td>
</tr>
<tr>
<td height="23" align="center" valign="middle"> </td>
<td valign="top"><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form>
<p> </p>
<p>
<%rs.close();
st.close();%>
</p>
<p align="center"><font size="5" face="Kai"></font></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -