📄 thexiugai.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date"%>
<%!
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>
<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>");
%>
</td></tr></table>
<center>
<%
String sqlString="select * from grjj where number="+"'"+number+"'";
try
{
Connection con;
Statement sql;
ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:yonghu");
sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
rs.next();
%>
<table border=1 width="600">
<tr>
<td colspan="2" align="center">修改用户的资料程序</td>
</tr>
<form action="thexiugai2.jsp" method="post" onsubmit="return on_submit()" name="form1">
<input type="hidden" value="<%=number%>" name="number">
<tr>
<td width="25%">姓名：</td>
<td width="75%"><input type="text" name="name" value="<%=rs.getString("name")%>"></td>
</tr>
<tr>
<td>学号:</td>
<td><input type="text" name="number" value="<%=rs.getString("number")%>"></td>
</tr>
<tr>
<td>性别：</td>
<td>
<% if((rs.getString("sex")).equals("男"))
{%>
<input type="radio" name="sex" value="男" checked>男
<input type="radio" name="sex" value="女">女
<%}
if((rs.getString("sex")).equals("女"))
{%>
<input type="radio" name="sex" value="男">男
<input type="radio" name="sex" value="女" checked>女
<%}%>
</td>
</tr>
<tr>
<td>密码：</td>
<td><input type="password" name="password" value="<%=rs.getString("password")%>"></td>
</tr>
</tr>
<td>确认密码：</td>
<td><input type="password" name="repassword">
</tr>
<tr>
<td>爱好：</td>
<td><input type="checkbox" name="hobby" value="旅游" checked="ok">旅游
<input type="checkbox" name="hobby" value="逛街">逛街
<input type="checkbox" name="hobby" value="听音乐">听音乐
<input type="checkbox" name="hobby" value="睡觉">睡觉
<br>
<input type="checkbox" name="hobby" value="上网">上网
<input type="checkbox" name="hobby" value="玩游戏">玩游戏
<input type="checkbox" name="hobby" value="打篮球">打篮球
<input type="checkbox" name="hobby" value="踢足球">踢足球
<br>
<input type="checkbox" name="hobby" value="聊天">聊天
</td>
</tr>
<tr>
<td>专业：</td>
<td><Select name="zhuanye">
<option selected value="网络集成">网络集成
<option value="高级编程"> 高级编程
<option value="软件集成">软件集成
<option value="小型机">小型机
</Select></td>
</tr>
<tr>
<td>生日：</td>
<td><select name="year" >
<% for(int y=1960;y<=2006;y++)
{%>
<option value=<%out.print(y);%>><%out.print(y);%><%}%></select>年
<select name="month" >
<% for(int m=1;m<=12;m++)
{%>
<option value=<%out.print(m);%>><%out.print(m);%><%}%></select>月
<select name="day" >
<% for(int d=1;d<=31;d++)
{%>
<option value=<%out.print(d);%>><%out.print(d);%><%}%></select>日</td>
</tr>
<tr>
<td>电话:</td>
<td><input type="text" name="telephone" value="<%=rs.getString("telephone")%>"></td>
</tr>
<tr>
<td>格言：</td>
<td><TextArea name="geyan" rows="10" cols=60></TextArea></td>
</tr>
<br>
<tr>
<td colspan=2 align=center><input type="submit" value="提交"><input type="reset" value="重输"></td>
</tr>
</form>
</table>
<% con.close();
}
catch(SQLException el)
{out.print("SQL异常!");}
%>
<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>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -