?? addclass.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");
if(dep==null){response.sendRedirect("login.jsp");}
String sql="select ID,DEPARTMENT,DATE from class",dep_id="";
SQLBean db = new SQLBean();
ResultSet rs = db.executeQuery(sql);
%>
</p>
<script language="javascript">
var onecount;
onecount=0;
subcat = new Array();
<%
int count = 0;
while(rs.next()){
%>
subcat[<%=count%>] = new Array("<%=rs.getString("DEPARTMENT")%>","<%=rs.getString("DATE").substring(0,4)%>","<%=rs.getString("ID")%>");
<%
count++;
}
%>
onecount=<%=count%>;
function changeValue()
{
var year = form1.entry.value;
var depid = form1.dep_id.value;
var i,j,t;j=0;
for(i=0;i<onecount;i++){
if(subcat[i][0]==depid&&subcat[i][1]==year){j++;}
}j++;
if(j<9){claid=year+depid+"0"+j;}
else{claid=year+depid+j;}
for(t=0;t<onecount;t++){
if(claid==subcat[t][2]){
j++;
if(j<9){claid=year+depid+"0"+j;}
else{claid=year+depid+j;}
}
}
document.form1.class_id.value=claid;
}
</script>
<body>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">新增班級</font></p>
<form name="form1" method="post" action="MyClassSvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<div align="center">
<table width="420" border="0" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="33%" bgcolor="#FFFFFF"><div align="right">入學年份</div></td>
<td width="67%" bgcolor="#FFFFFF">
<select name="entry" id="entry" 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_id" id="dep_id" size="1" onChange="changeValue()">
<option selected >選擇班級所在院系 </option>
<%
if(dep.equals("0000")){
sql = "select ID,NAME from department ";
}else{
sql = "select ID, NAME from department where ID='"+dep+"'";
}
rs = db.executeQuery(sql);
while(rs.next()){
dep_id=rs.getString("ID");%>
<option value="<%=dep_id%>"><%=rs.getString("NAME")%></option>
<%}%>
</select></td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">班級號</div></td>
<td bgcolor="#FFFFFF"><input type="text" name="class_id" id="class_id"></td>
</tr>
</table>
<p>
<input name="確定" type="submit" id="確定" value="提交">
</p>
</div>
</form>
<p> </p>
<p align="center"><a href="getClass.jsp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -