📄 thexiugai2.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date"%>
<%@ page import="java.lang.*"%>
<%!
public String codeToString(String str)
{
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%
String account="",secret="";
if(session.isNew())
{
response.sendRedirect("login.jsp");
}
else
{ account=(String)session.getAttribute("account");
secret=(String)session.getAttribute("secret");
secret=codeToString(secret);
account=codeToString(account);
}
%>
<%
String number=null;
try
{
number=request.getParameter("number");
}
catch(Exception e)
{
}
%>
<html>
<head>
<title>用户修改程序</title>
</head>
<% //接受客护端提交的数据
String name=codeToString(request.getParameter("name"));
if(name==null)
name="";
String sex=codeToString(request.getParameter("sex"));
if(sex==null)
sex="";
String password=codeToString(request.getParameter("password"));
if(password==null)
password="";
String checkbox[]=request.getParameterValues("hobby");
String hobby="";
for(int i=0;i<checkbox.length;i++)
checkbox[i]=codeToString(checkbox[i])+"、";
for(int i=0;i<checkbox.length;i++)
hobby+=checkbox[i];
String zhuanye=codeToString(request.getParameter("zhuanye"));
if(zhuanye==null)
zhuanye="";
String y=codeToString(request.getParameter("year"));
String m=codeToString(request.getParameter("month"));
String d=codeToString(request.getParameter("day"));
String birthday=""+y+m+d;
if(birthday==null)
birthday="";
String telephone=request.getParameter("telephone");
if(telephone==null)
telephone="";
String geyan=codeToString(request.getParameter("geyan"));
if(geyan==null)
geyan="";
%>
<body background="background.jpg">
<table align="center">
<tr>
<td>
<%
Date date=new Date();
int year=1900+date.getYear();
int month=1+date.getMonth();
int day=12+date.getDay();
out.println("今天的日期为："+year+"年"+month+"月"+day+"日"+"<br>");
%>
<br>
</td></tr></table>
<%
String sqlString=null;
sqlString="update yonghu1 set name='"+name+"',password='"+password+"',hobby='"+hobby+"',zhuanye='"+zhuanye+"',birthday='"+birthday+"',telephone='"+telephone+"',geyan='"+geyan+"' where number="+"'"+number+"'";
try
{
Connection con;
Statement sql;
ResultSet rs=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:honghu");
sql=con.createStatement();
sql.executeUpdate(sqlString);
con.close();
}
catch(SQLException e)
{
out.print(e.toString());
}
%>
<center>
<table border=1 width=400>
<tr>
<td width="100%" align=center>修改用户资料程序</td>
</tr>
<tr>
<td width="100%" align=center>修改用户成功!</td>
</tr>
</table>
</center>
<br>
<p align=center>
<a href='selectgrjj.jsp'>查询学生信息</a>
<a href='insertgrjj.jsp'>录入学生信息</a>
<a href='deletegrjj1.jsp'>删除学生信息</a>
<a href='updategrjj1.jsp'>修改学生信息</a>
<a href="modifySecret.jsp">修改密码</a>
<a href='main.jsp'>返回首页</a>
</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -