📄 ch5-6.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">
<div align="center">
<%
String name=request.getParameter("name");
String password=request.getParameter("mima");
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+"' and 密码='"+password+"'";
ResultSet rs=st.executeQuery(strSql);
if (!rs.next())
{out.print("用户名或密码输入错误！");%>
</p>
<p align="center"><a href="ch5-6.htm">返回修改页面</a></p>
<p>
<%return;}
%>
</div>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="40" colspan="2" align="center" valign="top"><div align="left"><font color="#000000" size="4" face="幼圆"><strong>请修改信息内容</strong></font></div></td>
<td width="80"> </td>
</tr>
<tr>
<td width="64" height="341"> </td>
<td width="456" valign="top"><form name="form1" method="post" action="ch5-61.jsp">
<table width="100%" height="382" border="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="48" colspan="2" align="right" valign="middle">用户名：</td>
<td colspan="4" valign="middle"><%=name%>
<input name="name" type="hidden" id="name" value="<%=name%>"></td>
</tr>
<tr>
<td height="40" colspan="2" align="right" valign="middle">性别：</td>
<td colspan="4" valign="middle"><input name="sex" type="text" id="sex" value="<%out.print(rs.getString("性别"));%>"></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">年龄：</td>
<td colspan="4" valign="middle"> <input name="age" type="text" id="age" value="<%out.print(rs.getString("年龄"));%>"></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">密码：</td>
<td colspan="4" valign="middle"> <input name="password" type="text" id="password" value="<%out.print(rs.getString("密码"));%>"> </td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">密码提示：</td>
<td colspan="4" valign="middle"> <input name="tishi" type="text" id="tishi" value="<%out.print(rs.getString("密码提示"));%>"></td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">密码答案：</td>
<td colspan="4" valign="middle"><input name="daan" type="text" id="daan" value="<%out.print(rs.getString("密码答案"));%>"></td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">学历：</td>
<td colspan="4" valign="middle"><input name="xueli" type="text" id="xueli" value="<%out.print(rs.getString("学历"));%>"></td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">E-mail：</td>
<td colspan="4" valign="middle"> <input name="email" type="text" id="email" value="<%out.print(rs.getString("email"));%>"></td>
</tr>
<tr>
<td width="96" height="42"> </td>
<td colspan="2" valign="middle"> <input type="submit" name="Submit" value="修改"></td>
<td width="51"> </td>
<td width="49" valign="middle"> <input type="reset" name="Submit2" value="重填"></td>
<td width="201"> </td>
</tr>
<tr>
<td height="0"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="3"></td>
<td width="21"></td>
<td width="26"></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</form></td>
<td> </td>
</tr>
<tr>
<td height="50"> </td>
<td><div align="center"><a href="ch5-6.htm">返回修改</a> <a href="main.jsp">返回会员主页</a></div></td>
<td> </td>
</tr>
</table>
<%rs.close();
st.close();%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -