📄 yonghuxiugai1.jsp
字号:
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户修改</title>
</head>
<body background="../image/Back057.gif">
<div align="center">
<%String id=request.getParameter("id");
String name=request.getParameter("name");
String password1=request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:g";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from zhuce where name='"+name+"'and password='"+password1+"'";//一定要连密码一起判断否则任何人都可以修改信息
ResultSet rs=st.executeQuery(strSql);//获取一个结果集，根据你输入的信息，会出现相应的结果，即你的信息资料
id=null;
name=null;
String password=null;
String truename=null;
String sex=null;
String age=null;
String tel=null;
String email=null;
String wenti=null;
String daan=null;
if (!rs.next())
{
out.print("密码不正确，请重新填写！<p><a href=yonghuxiugai.htm>返回修改页</a></p>");
return;}
else{
id=rs.getString(1);
name=rs.getString(2);
password=rs.getString(3);
truename=rs.getString(4);
sex=rs.getString(5);
age=rs.getString(6);
tel=rs.getString(7);
email=rs.getString(8);
wenti=rs.getString(9);
daan=rs.getString(10);
}
%>
</div>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td colspan="3" align="center" valign="top"><font color="#FF0000" size="6" face="华文彩云"> </font><font color="#FF0000" size="6" face="华文彩云"> </font></td>
</tr>
<tr>
<td colspan="3" align="center" valign="top"><font color="#FF0000" size="6" face="华文彩云"><strong>请修改下列信息</strong></font></td>
</tr>
<tr>
<td height="341" colspan="2"><form name="form1" method="post" action="yonghuxiugai2.jsp">
<table width="69%" height="397" border="0" align="center" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="19" colspan="2" align="right" valign="middle">用户名：</td>
<td colspan="4" valign="middle"><%=name%><input name="name" type="hidden" value="<%=name%>"></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="<%=password%>">
**</td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">真实姓名：</td>
<td colspan="4" valign="middle"> <input name="xingming" type="text" id="xingming" value="<%=truename%>">
**</td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">性别：</td>
<td colspan="4" valign="middle"> <input name="xingbie" type="text" id="xingbie" value="<%=sex%>">
**</td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">年龄：</td>
<td colspan="4" valign="middle"> <input name="nianling" type="text" id="nianling" value="<%=age%>">
**</td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">联系电话：</td>
<td colspan="4" valign="middle"><input name="dianhua" type="text" id="dianhua" value="<%=tel%>">
**</td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">电子邮箱：</td>
<td colspan="4" valign="middle"> <input name="email" type="text" id="email" value="<%=email%>">
**</td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">提示问题：</td>
<td colspan="4" valign="middle"> <input name="tishi" type="text" id="tishi" value="<%=wenti%>">
**</td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">回答问题：</td>
<td colspan="4" valign="middle"> <input name="huida" type="text" id="huida" value="<%=daan%>">
**</td>
</tr>
<tr>
<td width="40" height="42"> </td>
<td colspan="2" valign="middle"> <input type="submit" name="Submit" value="修改"></td>
<td width="34"> </td>
<td width="44" valign="middle"> <input type="reset" name="Submit2" value="重填"></td>
<td width="139"> </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="25"></td>
<td width="17"></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</form></td>
<td> </td>
</tr>
<tr>
<td width="80" height="50"> </td>
<td width="456"><div align="center"><a href="index.htm">返回主页</a></div></td>
<td> </td>
</tr>
</table>
<%rs.close();
st.close();%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -