📄 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 + -