?? addchange.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 type=request.getParameter("f");
String sql="select DEPARTMENT,DATE,ID from class",dep_id="";
SQLBean db = new SQLBean();
ResultSet rs = db.executeQuery(sql);
sql="select ID,CLASS_ID from student";
ResultSet rs1 = db.executeQuery(sql);
%>
</p>
<script language="javascript">
var onecount,twocount;
onecount=0; twocount=0;
subcat1 = new Array();
subcat2 = new Array();
<%
int count = 0,cnt = 0;
while(rs.next()){
%>
subcat1[<%=count%>] = new Array("<%=rs.getString("DEPARTMENT")%>","<%=rs.getString("DATE").substring(0,4)%>","<%=rs.getString("ID")%>");
<%
count++;
}
rs.close();%>
<%
while(rs1.next()){%>
subcat2[<%=cnt%>] = new Array("<%=rs1.getString("ID")%>","<%=rs1.getString("CLASS_ID")%>");
<% cnt++;
}
rs1.close();
%>
onecount=<%=count%>;
twocount=<%=cnt%>;
function changeValue()
{
document.form1.classid.length = 0;
var year = form1.entry.value;
var depid = form1.dep_id.value;
var i,j;j=0;
for(i=0;i<onecount;i++){
if(subcat1[i][0]==depid&&subcat1[i][1]==year){
document.form1.classid.options[document.form1.classid.length] = new Option(subcat1[i][2],subcat1[i][2]);
}
}
}
function getStu_id(){
document.form1.stu_id.length = 0;
var class_id = form1.classid.value;
var i;
for(i=0;i<twocount;i++){
if(subcat2[i][1]==class_id){
document.form1.stu_id.options[document.form1.stu_id.length] = new Option(subcat2[i][0],subcat2[i][0]);
}
}
}
</script>
<body>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">新增變動</font></p>
<form name="form1" method="post" action="ChangeSvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<div align="center">
<table width="51%" 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>選擇班級所在院系</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"><select name="classid" id="classid" size="1" onChange="getStu_id()">
<option selected >請選擇班級</option>
</select> </td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">學號</div></td>
<td bgcolor="#FFFFFF"><select name="stu_id" id="stu_id" size="1">
<option selected >請選擇學生</option>
</select> </td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">獎勵標準</div></td>
<td bgcolor="#FFFFFF"><select name="levels" id="levels" size="1">
<option selected >請選擇具體變動</option>
<%String table="";
if(type.equals("A")){
table="award_levels";
}else if(type.equals("P")){
table="punish_levels";
}else
table="change_code";
sql = "select * from "+table;
rs = db.executeQuery(sql);
while(rs.next()){%>
<option value="<%=rs.getString("CODE")%>"><%=rs.getString("DESCRIPTION")%></option>
<%}
java.text.SimpleDateFormat dformat=new java.text.SimpleDateFormat("yyyy-MM-dd");
String dateandtime=dformat.format(date); %>
</select> </td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">生效</div></td>
<td bgcolor="#FFFFFF">
<input type="radio" name="validate" id="validate" value="是" checked>是
<input type="radio" name="validate" id="validate" value="否">否</td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">備注</div></td>
<td bgcolor="#FFFFFF"><input type="Textarea" id="info" name="info"></td>
</tr>
<input type="hidden" name="record_time" id="record_time" value="<%=dateandtime%>">
</table>
<p>
<input name="確定" type="submit" id="確定" value="提交">
</p>
</div>
</form>
<p> </p>
<p align="center"><a href="getChange.jsp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -