📄 course_build.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ page import="java.sql.*" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>
<%!
ResultSet rs=null;
String sql="";
%>
<%
sql="select * from specialty";
rs=conn.executeQuery(sql);
%>
<script language="javascript">
subcat=new Array();
<%
int count=0;
while(rs.next()){
%>
subcat[<%= count %>]=new Array("<%= rs.getString("sp_id") %>","<%= rs.getString("sp_name") %>","<%= rs.getString("college_id") %>");
<%
count++;
}
conn.close();
%>
var one_count=<%= count %>;
function changlocation(id){
college_id=id;
document.form1.sp_id.length = 0;
document.form1.sp_id.options[0]=new Option("=====请选择=====","");
for(j=0;j<one_count;j++)
{
if(subcat[j][2]==college_id)
{
document.form1.sp_id.options[document.form1.sp_id.length]=new Option(subcat[j][1],subcat[j][0]);
}
}
}
</script>
<script language="javascript">
function formCheck(theForm)
{
if(theForm.college_id.value=="")
{
alert("请选择院系!");
theForm.college_id.focus();
return false;
}
if(theForm.grade_name.value=="")
{
alert("请选择年级!");
theForm.grade_name.focus();
return false;
}
if(theForm.sp_id.value=="")
{
alert("请选择专业!");
theForm.sp_id.focus();
return false;
}
}
</script>
<html>
<head>
<title>建立新的课表</title>
<link rel="stylesheet" href="../../public/style.css">
</head>
<body class="ss">
<a href="javascript:window.location.reload()" class="a">刷新</a>
<a href="javascript:history.back()" class="a">返回</a>
<hr></hr>
<center>
<h2>建立新的课表</h2>
<form action="course.jsp" method="post" name="form1" onsubmit="return formCheck(this)">
<table width="40%" border="0" cellspacing="0">
<tr>
<td width="40%">请选择学年：</td>
<td width="60%"><select name="year_id">
<%
ResultSet rs_g=null;
rs_g=conn.executeQuery("select * from year order by year_id DESC");
while(rs_g.next())
out.println("<option value="+rs_g.getString("year_id")+">"+rs_g.getString("year_name")+"</option>");
conn.close();
%></select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="40%">请选择院系:</td>
<td width="60%"><select name="college_id" onchange="changlocation(document.form1.college_id.options[document.form1.college_id.selectedIndex].value)">
<option value="" selected>=====请选择=====</option>
<%
ResultSet rs_c=null;
rs_c=conn.executeQuery("select * from college");
while(rs_c.next())
out.println("<option value="+rs_c.getString("college_id")+">"+rs_c.getString("college_name")+"</option>");
conn.close();
%>
</select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>请选择年级:</td>
<td><select name="grade_name">
<option value="" selected>=====请选择=====</option>
<%
ResultSet rs_nj=null;
rs_nj=conn.executeQuery("select * from grade");
while(rs_nj.next())
out.println("<option value="+rs_nj.getString("grade_name")+">"+rs_nj.getString("grade_name")+"</option>");
conn.close();
%>
</select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>请选择专业:</td>
<td><select name="sp_id">
<option value="" selected>=====请选择=====</option>
</select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>请选择班级:</td>
<td><select name="class_number_name">
<%
ResultSet rs_bj=null;
rs_bj=conn.executeQuery("select * from class_number");
while(rs_bj.next())
out.println("<option value="+rs_bj.getString("class_number_name")+">"+rs_bj.getString("class_number_name")+"</option>");
conn.close();
%>
</select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><div align="center"><input type="submit" value="添加"></input></div></td>
</tr>
</table>
</form>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -