?? updatestu.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="myBeans.SQLBean" %>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>更新</title>
</head>
<body bgcolor="#0099FF" text="#FFFFFF" link="#33FF00">
<jsp:useBean id="stu" scope="request" class="myBean.Student"/>
<p>
<%
String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String stu_id=request.getParameter("id");
String stu_name=new String(request.getParameter("name").getBytes("ISO8859_1"));
String class_id=request.getParameter("classid");
String passWord=request.getParameter("password");
String age=request.getParameter("age");
String jiguan=new String(request.getParameter("jiguan").getBytes("ISO8859_1"));
String dep=request.getParameter("dep");
String sex=new String(request.getParameter("sex").getBytes("ISO8859_1"));
String entry=request.getParameter("entry");
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="方正舒體">更新學生</font></p>
<p align="center"> </p>
<form method="post" action="StudentSvlt">
<input type="hidden" name="action" value="update">
<input type="hidden" name="id" value="<%=stu_id%>">
<input type="hidden" name="classid" value="<%=class_id%>">
<input type="hidden" name="year" value="<%=entry%>">
<input type="hidden" name="dep" value="<%=dep%>">
<table width="360" height="50" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="48%" bgcolor="#FFFFFF"><div align="right">學號</div></td>
<td width="52%" bgcolor="#FFFFFF"><%=stu_id%></td>
</tr>
<tr>
<td width="48%" bgcolor="#FFFFFF"><div align="right">學生姓名</div></td>
<td width="52%" bgcolor="#FFFFFF"><input name="name" type="text" id="name" value="<%=stu_name%>" ></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">密碼</div></td>
<td bgcolor="#FFFFFF"><input name="password" type="text" id="password" maxlength="16" value="<%=passWord%>"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">年齡</div></td>
<td bgcolor="#FFFFFF"><select name="age" size="1" id="age">
<% for(int i=30;i>15;i--){
if(Integer.parseInt(age)==i){%>
<option value="<%=i%>"selected ><%=i%></option>
<%}else{%>
<option value="<%=i%>"><%=i%></option>
<%}%>
<%}%>
</select> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">學生所在系</div></td>
<% SQLBean db = new SQLBean();String depN="";
String sql = "select NAME from department where ID='"+dep+"'";
ResultSet rs = db.executeQuery(sql);
if(rs.next()){depN=rs.getString(1);}%>
<td bgcolor="#FFFFFF"><%=depN%></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">入學時間</div></td>
<td bgcolor="#FFFFFF"><%=entry%>
<%-- <select name="year" size="1" id="year">
<%
java.util.Date date = new java.util.Date();
int i=date.getYear()+1900;
for(int j=i;j>i-10;j--){
if(Integer.parseInt(entry)==j){%>
<option value="<%=j%>" selected ><%=j%></option>
<%}else{%>
<option value="<%=j%>"><%=j%></option>
<%}%>
<%}%>--%>
</select>
<select name="month" size="1" id="month">
<% for(int k=12;k>0;k--){%>
<option><%=k%></option>
<%}%>
</select> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">班級</div></td>
<td bgcolor="#FFFFFF"><%=class_id%></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">性別</div></td>
<td bgcolor="#FFFFFF">
<% if(sex.equals("男")){%>
<input name="sex" type="radio" value="男" checked >男
<input name="sex" type="radio" value="女">女
<%}else{%>
<input name="sex" type="radio" value="男">男
<input name="sex" type="radio" value="女" checked>女
<%}%> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">籍貫</div></td>
<td bgcolor="#FFFFFF"><select name="jiguan" size="1" id="jiguan">
<%String s = "";
String prov[]={"黑龍江","吉林","遼寧","北京","天津","河北","內蒙古","河南","山西","陜西","山東","上海","安徽","江西","湖北","湖南","甘肅","重慶","四川","青海","西藏","貴州","云南","廣東","廣西","海南","寧夏","新疆"};
for(int t=0;t<prov.length;t++){
s = prov[t];
if(s.equals(jiguan)){%>
<option value="<%=s%>"selected ><%=s%></option>
<%}else{%>
<option value="<%=s%>"><%=s%></option>
<%}
}%>
</select></td>
</tr>
</table>
<p align="center">
<input type="submit" name="Submit" value="提交">
</p>
</form>
<p> </p>
<p align="center"><a href="getStudent.jsp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -