📄 userxiugai2.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>
<style type="text/css">
<!--
.style8 {font-family: "幼圆"; font-size: 18px; }
-->
</style>
</head>
<body>
<p>
<%//String id=new String(request.getParameter("id"));
String name=new String(request.getParameter("name"));
String password=new String(request.getParameter("password"));
String truename=new String(request.getParameter("xingming"));
String sex=new String(request.getParameter("xingbie"));
String age=new String(request.getParameter("nianling"));
String tel=new String(request.getParameter("dianhua"));
String email=new String(request.getParameter("email"));
String wenti=new String(request.getParameter("tishi"));
String daan=new String(request.getParameter("huida"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:d";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from zhuce where name='"+name+"'";
ResultSet rs=st.executeQuery(strSql);
if(!rs.next())
{out.print("信息不正确！！");
return;
}
else if(truename.equals("")||sex.equals("")||age.equals("")||tel.equals("")||email.equals("")||wenti.equals("")||daan.equals(""))
{
out.println("带*为必填项,请您重新填写,谢谢!<p><a href=xiugai2.jsp>返回注册页</a></p>");
return;
}
%>
<%Statement aa=con.createStatement();
String sql="update zhuce set password='"+password+"',truename='"+truename+"',sex='"+sex+"',age='"+age+"',tel='"+tel+"',email='"+email+"',wenti='"+wenti+"',daan='"+daan+"' where name='"+name+"'";
aa.executeUpdate(sql);
%>
</p>
<p align="center"><font color="#FF0000" size="+2" face="隶书">您的信息已经修改成功！</font></p>
<p align="center">您的信息为：</p>
<table width="60%" border="0" align="center" bgcolor="#E8E8FF">
<tr>
<td width="30%">
<p align="right">用户名：</td>
<td width="70%"><%out.print(rs.getString("name"));%></td>
</tr>
<tr>
<td width="30%">
<p align="right">密码：</td>
<td width="70%"><%out.print(rs.getString("password"));%></td>
</tr>
<tr>
<td width="30%">
<p align="right"> 真实姓名：</td>
<td width="70%"><%out.print(rs.getString("truename"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">性别：</td>
<td width="70%"><%out.print(rs.getString("sex"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">年龄：</td>
<td width="70%"><%out.print(rs.getString("age"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">电话：</td>
<td width="70%"><%out.print(rs.getString("tel"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">电子邮件：</td>
<td width="70%"><%out.print(rs.getString("email"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">提示问题：</td>
<td width="70%"><%out.print(rs.getString("wenti"));%></td>
</tr>
<tr>
<td width="30%"><p align="right">回答问题：</td>
<td width="70%"><%out.print(rs.getString("daan"));%></td>
</tr>
</table>
<p align="center"></a><a href="adxiugaishanchu.jsp">继续修改 </a></p>
<p align="center">
<%rs.close();
st.close();
aa.close();
%>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -