📄 xiugai3.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("main.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 zhuanye=codeToString(request.getParameter("zhuanye"));
if(zhuanye==null)
zhuanye="";
String gaoshu=codeToString(request.getParameter("gaoshu"));
if(gaoshu==null)
gaoshu="";
String Cyuyan=codeToString(request.getParameter("Cyuyan"));
if(Cyuyan==null)
Cyuyan="";
String JAVA=request.getParameter("JAVA");
if(JAVA==null)
JAVA="";
String JSP=codeToString(request.getParameter("JSP"));
if(JSP==null)
JSP="";
String English=codeToString(request.getParameter("English"));
if(English==null)
English="";
%>
<body background="1.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 student set name='"+name+"',sex='"+sex+"',zhuanye='"+zhuanye+"',chinese='"+chinese+"',maths='"+maths+"',physics='"+physics+"',chemistry='"+chemistry+"' where sno="+"'"+number+"'";
try
{
Connection con;
Statement sql;
ResultSet rs=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:student");
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></p>
<p></p>
<p></p>
<p align=center>
<a href='tianjia.jsp'>录入学生信息</a>|
<a href='shanchu.jsp'>删除学生信息</a>|
<a href='xiugai.jsp'>修改学生信息</a>
| <a href='main.jsp'>返回首页>></a>
</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -