?? addstudent.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ 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>
<p>
<%
String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String dep = (String)session.getAttribute("dep");
SQLBean db = new SQLBean();
String sql = "select * from class";
ResultSet rs = db.executeQuery(sql);
%>
</p>
<script language="javascript">
var onecount;
onecount=0;
subcat = new Array();
<%
int count = 0;
int sum = 0;
while(rs.next()){
%>
subcat[<%=count%>] = new Array("<%=rs.getString("DEPARTMENT")%>","<%=rs.getString("DATE").substring(0,4)%>","<%=rs.getString("ID")%>","<%=rs.getInt("COUNT")+rs.getInt("LEAVECOUNT")+1%>");
<%
count++;
}
rs.close();%>
onecount=<%=count%>;
function changeValue()
{
document.form1.classid.length = 1;
var year = form1.year.value;
var depid = form1.dep.value;
var i;
for(i=0;i<onecount;i++){
if(subcat[i][0]==depid && subcat[i][1]==year){
document.form1.classid.options[document.form1.classid.length] = new Option(subcat[i][2],subcat[i][2]);
}
}
}
function getStu_id(values){
var i,s;
for(i=0;i<onecount;i++){
if(subcat[i][2]==values){
if(subcat[i][3]<'9');
s=0+subcat[i][3];
}
}
form1.id.value=values+s;
}
</script>
<body>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">新增學生</font></p>
<form name="form1" method="post" action="StudentSvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<table width="420" height="50" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="33%" bgcolor="#FFFFFF"><div align="right">學生姓名 </div></td>
<td width="67%" bgcolor="#FFFFFF"><input name="name" type="text" id="name" ></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">密碼 </div></td>
<td bgcolor="#FFFFFF"><input name="password" type="password" id="password" maxlength="10" value="8888"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">性別 </div></td>
<td bgcolor="#FFFFFF"><input type="radio" name="sex" value="男" checked>
男
<input name="sex" type="radio" value="女">
女</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--){%>
<option value="<%=i%>"><%=i%></option>
<%}%>
</select> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">籍貫 </div></td>
<td bgcolor="#FFFFFF"><select name="jiguan" size="1" id="jiguan">
<option>黑龍江</option><option>吉林</option><option>遼寧</option>
<option>北京</option><option>天津</option><option>河北</option>
<option>內蒙古</option><option>河南</option><option>山西</option>
<option>陜西</option><option>山東</option><option>江蘇</option>
<option>浙江</option><option>上海</option><option>安徽</option>
<option>江西</option><option>湖北</option><option>湖南</option>
<option>甘肅</option><option>重慶</option><option>四川</option>
<option>青海</option><option>西藏</option><option>貴州</option>
<option>云南</option><option>廣東</option><option>廣西</option>
<option>海南</option><option>寧夏</option><option>新疆</option>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">入學年份</div></td>
<td bgcolor="#FFFFFF">
<select name="year" id="year" size="1">
<%java.util.Date date = new java.util.Date();
int i=date.getYear()+1900;
for(int j=i;j>i-5;j--){%>
<option value="<%=j%>"><%=j%></option>
<%}%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">學生所在系 </div></td>
<td bgcolor="#FFFFFF"><select name="dep" size="1" id="dep" onChange="changeValue()">
<option selected >請選擇院系 </option>
<% String query="";
if(dep.equals("0000")){
query = "select ID,NAME from department ";
}else{
query = "select ID,NAME from department where ID='"+dep+"'";
}
ResultSet rs1 = db.executeQuery(query);
while(rs1.next()){
String name = rs1.getString("NAME");
String id = rs1.getString("ID");%>
<option value="<%=id%>"><%=name%></option>
<%}rs1.close();%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">學生所在班級 </div></td>
<td bgcolor="#FFFFFF"><select name="classid" size="1" id="classid" onChange="getStu_id(this.value)">
<option selected >請選擇班級 </option>
</select> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">學號 </div></td>
<td bgcolor="#FFFFFF"><input name="id" id="id" type="text"></td>
</tr>
</table>
<p> </p>
<div align="center" class="warnFont"> 提 示: 初 始 密 碼 為 8888!!</div>
<p align="center">
<input type="submit" name="Submit" value="確定">
</p>
</form>
<div align="center"><a href="getStudent.jsp">返回 </a>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -