?? addcourse.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>
<jsp:useBean id="course" scope="page" class="myBean.Course"/>
<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 cour_name="",cour_id="";
String sql="select ID,DEPARTMENT from course",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("ID")%>");
<%
count++;
}
%>
onecount=<%=count%>;
function changeValue()
{
var depid = form1.dep.value;
var i,j,t;j=1;
for(i=0;i<onecount;i++){
if(subcat[i][0]==depid){j++;}
}
if(j<9){courid=depid+"0"+j;}
else{courid=depid+j;}
for(t=0;t<onecount;t++){
if(courid==subcat[t][1]){
j++;
if(j<9){claid=year+depid+"0"+j;}
else{claid=year+depid+j;}
}
}
document.form1.id.value=courid;
}
</script>
<body bgcolor="#0099FF" text="#FFFFFF" link="#66FF00">
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">新增課程</font></p>
<form name="form1" method="post" action="CourseSvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<div align="center"></div>
<table width="420" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="37%" bgcolor="#FFFFFF"><div align="right">課程名</div></td>
<td width="63%" bgcolor="#FFFFFF"><input name="name" type="text" id="name"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">學分</div></td>
<td bgcolor="#FFFFFF"><select name="mark" size="1" id="mark">
<%
for(double i=0.5;i<=6;i=i+0.5){%>
<option><%=i%></option>
<%}%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">學時</div></td>
<td bgcolor="#FFFFFF"><input name="period" id="period" type="text"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">系別</div></td>
<td bgcolor="#FFFFFF"><select name="dep" size="1" id="dep" onChange="changeValue()">
<option>請選擇院系</option>
<% db = new SQLBean();
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()){
String name = rs.getString("NAME");
String id = rs.getString("ID");%>
<option value="<%=id%>"><%=name%></option>
<%}%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">課程號</div></td>
<td bgcolor="#FFFFFF"><input name="id" type="text" id="id"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">預修課</div></td>
<td bgcolor="#FFFFFF"><select name="prepare" size="1" id="prepare">
<option value="0">無預修課</option>
<%
rs=course.getPrepares();
while(rs.next()) {
cour_name=rs.getString("NAME");
cour_id=rs.getString("ID");
%>
<option value="<%=cour_id%>"><%=cour_name%></option>
<%}%>
</select> </td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">開課學期</div></td>
<td bgcolor="#FFFFFF"><select name="semester" size="1" id="semester">
<option>第一學期</option><option>第二學期</option>
<option>第三學期</option><option>第四學期</option>
<option>第五學期</option><option>第六學期</option>
<option>第七學期</option><option>第八學期</option>
</select> </td>
</tr>
</table>
<p align="center">
<input type="submit" name="Submit2" value="確定">
</p>
<p> </p>
</form>
<p align="center"><a href="getCourse.jsp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -