📄 ch5-61.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>
<%
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String age=request.getParameter("age");
String password=request.getParameter("password");
String tishi=request.getParameter("tishi");
String daan=request.getParameter("daan");
String xueli=request.getParameter("xueli");
String email=request.getParameter("email");
String mm;
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())
return;
else if(sex.equals("")||age.equals("")||password.equals("")||tishi.equals("")||daan.equals("")||xueli.equals("")||email.equals(""))
{ out.print("信息不能更改为空！");
return;}
%>
<%Statement aa=con.createStatement();
String sql="update user set 姓名='"+name+"',性别='"+sex+"',年龄='"+age+"',密码='"+password+"',密码提示='"+tishi+"',密码答案='"+daan+"',学历='"+xueli+"',Email='"+email+"' where 姓名='"+name+"'";
aa.executeUpdate(sql);
%>
<font color="#000000" size="+2" face="隶书">信息修改成功！</font>修改后的信息为：</p>
<table width="60%" border="0" align="center">
<tr>
<td width="30%"> <p align="right">姓名：</td>
<td width="70%">
<%out.print(rs.getString("姓名"));%>
</td>
</tr>
<tr>
<td width="30%"> <p align="right">性别：</td>
<td width="70%">
<%out.print(rs.getString("性别"));%>
</td>
</tr>
<tr>
<td width="30%"> <p align="right"> 年龄：</td>
<td width="70%">
<%out.print(rs.getString("年龄"));%>
</td>
</tr>
<tr>
<td width="30%"><p align="right">密码：</td>
<td width="70%">
<%out.print(rs.getString("密码"));%>
</td>
</tr>
<tr>
<td width="30%"><p align="right">密码提示：</td>
<td width="70%">
<%out.print(rs.getString("密码提示"));%>
</td>
</tr>
<tr>
<td><div align="right">密码答案：</div></td>
<td><%out.print(rs.getString("密码答案"));%></td>
</tr>
<tr>
<td><div align="right">学历：</div></td>
<td><%out.print(rs.getString("学历"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">E-mail：</td>
<td width="70%">
<%out.print(rs.getString("email"));%>
</td>
</tr>
</table>
<%
request.getSession(true);
mm=(String)session.getValue("ad");
if (mm =="admin")
{
out.print("<H2>修改完成，3 秒钟返回管理员页面，请查询</H2>");
response.setHeader("Refresh","3;URL=ch5-71.htm");
return;}
%>
<p align="left"><a href="index.htm" target="_top">返回主页</a> <a href="main.jsp">返回会员主页</a></p>
<p align="left"><a href="ch5-6.htm">返回修改</a></p>
<p>
<%rs.close();
st.close();
aa.close();
%>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -