📄 batch_addbegin.jsp
字号:
<%/*
用途:选择课程excel报表
程序员:guoyehong
完成时间:
修改情况：
修改时间： 修改原因： 修改人：
*/ %>
<%@ page contentType="text/html;charset=gbk" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="批量添加课程信息";
String PrivME="00605";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%@ page import="java.sql.*,java.io.*" %>
<%@ page import="java.util.Vector"%>
<%@ page import="oracle.jdbc.driver.*"%>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>
<html>
<head>
<title>选择专业</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/style.css" rel="stylesheet" type="text/css">
</head>
<script language=javascript>
function chg()
{
var i, j;
// empty existing items
for (i = document.frm.appraise_id.options.length; i >= 0; i--)
{
document.frm.appraise_id.options[i] = null;
}
j = 0;
itemArray = appraise_options[document.frm.dep.selectedIndex];
// add new items
for (i = 0; i < itemArray.length; i++)
{
document.frm.appraise_id.options[j] = new Option(itemArray[i][0]);
if (itemArray[i][1] != null)
{
document.frm.appraise_id.options[j].value = itemArray[i][1];
}
j++;
}
// select first item (prompt) for sub list
document.frm.appraise_id.options[0].selected = true;
}
</script>
<%
com.dbConnection.MyResultSet rs;%>
<body topmargin=0 leftmargin=0 bgcolor=FFFFFF>
<br>
<form name=frm action=batch_add.jsp method=post>
<table width="60%" border="0" align=center cellpadding="2" cellspacing="1" bgcolor="3F6C61">
<tr class="t08_bgwhite_p2">
<td class="t12_14_bgE3EAE9" align=right>选择院系：</td><td>
<select name=dep onChange="chg()">
<%
Vector deps_v = new Vector();
String query="select id,name from lrn_dep_info order by id";
rs=work.executeQuery(query);
if (rs!=null)
{
while(rs!=null&&rs.next())
{
String dep_id=rs.getString("id");
String dep_name=rs.getString("name");
String sql = "select d.id as dep_id,d.name as dep_name,m.id as major_id,m.name as major_name from lrn_major_info m,lrn_dep_info d where d.id=m.dep_id and m.dep_id='"+dep_id+"' ";
if (work.countselect(sql) > 0)
{
out.print("<option value="+dep_id+">"+dep_name+"</option>");
deps_v.addElement(dep_id);
}
}
}
work.close(rs);%>
</select>
</td>
</tr>
<tr class="t08_bgwhite_p2">
<td class="t12_14_bgE3EAE9" align=right>选择专业：</td><td>
<script language="javascript">
appraise_options = new Array(
<%
Vector first_dep_appraise_names_v = new Vector();
Vector first_dep_appraise_ids_v = new Vector();
for(int i=0; i<deps_v.size(); i++)
{
%>
new Array(
<%
String sql="select d.id as dep_id,d.name as dep_name,m.id as major_id,m.name as major_name from lrn_major_info m,lrn_dep_info d where d.id=m.dep_id and m.dep_id='"+(String)deps_v.elementAt(i)+"'";
int appraiseindex = 0;
int count = work.countselect(sql);
String appraise_id="",appraise_name="";
com.dbConnection.MyResultSet RSapp = work.executeQuery(sql);
while(null != RSapp && RSapp.next())
{
appraise_name=RSapp.getString("major_name");
appraise_id=RSapp.getString("major_id");
if(i==0)
{
first_dep_appraise_names_v.addElement(appraise_name);
first_dep_appraise_ids_v.addElement(appraise_id);
}
if(appraiseindex < count -1)
{
%>
new Array("<%=appraise_name%>", "<%=appraise_id%>"),
<%
}
else
{
%>
new Array("<%=appraise_name%>", "<%=appraise_id%>")
<%
}
appraiseindex ++;
}
work.close(RSapp);
if(i < deps_v.size() - 1)
{
%>
),
<%
}
else
{
%>
)
<%
}
}
%>
);
</script>
<select name="appraise_id">
<%
for(int i=0; i<first_dep_appraise_names_v.size(); i++)
{
%>
<option value=<%=(String)first_dep_appraise_ids_v.elementAt(i)%>><%=(String)first_dep_appraise_names_v.elementAt(i)%></option>
<%
}
%>
</select>
</td>
</tr>
<tr class="t08_bgwhite_p2"><td colspan=2 class="t08_bgwhite_p2" align=center><input type=submit name="submit" value="下一步"></td></tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -