这是jsp文件
<%@ page language="java" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<jsp:useBean id="fdepa" class="edu.hrbeu.cstcmis.dao.FirstDepartment"></jsp:useBean>
<jsp:useBean id="sdepa" class="edu.hrbeu.cstcmis.dao.SecondDepartment"></jsp:useBean>
<jsp:useBean id="an" class="edu.hrbeu.cstcmis.dao.Annual"></jsp:useBean>
<jsp:useBean id="cn" class="edu.hrbeu.cstcmis.dao.CourseName"></jsp:useBean>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>My JSP 'relation.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script type="text/javascript" language="javascript">
var depaf=new Array();
<%
ResultSet depaf_rs=fdepa.FirstDepartmentAllQuery("select * from first_depa");
while(depaf_rs.next()){
%>
depaf[<%=depaf_rs.getInt(1)%>]=<%=depaf_rs.getString(2)%>;
<%
ResultSet depas_rs=sdepa.SecondDepartmentAllQuery("select * from second_depa where depaf_id="+depaf_rs.getInt(1));
while(depas_rs.next()){
%>
depas[<%=depaf_rs.getInt(1)%>][<%=depas_rs.getInt(1)%>]=<%=depas_rs.getString(3)%>;
<%
}
}
%>
function showSubmenu(name){
if(name=="teacherName"){
document.getElementById("teacherName").style.display="";
document.getElementById("courseName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("annualName").style.display="none";
}
if(name=="courseName"){
document.getElementById("courseName").style.display="";
document.getElementById("teacherName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("annualName").style.display="none";
}
if(name=="department"){
showThreeSubmenu();
document.getElementById("teacherName").style.display="none";
document.getElementById("courseName").style.display="none";
document.getElementById("annualName").style.display="none";
}
if(name=="annualName"){
document.getElementById("annualName").style.display="";
document.getElementById("teacherName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("courseName").style.display="none";
}
}
function showThreeSubmenu(){
document.getElementById("secondDepa").style.display="";
var str="<select id='firstDep'>";
for(i=1;i<depaf.length+1;i++){
str+="<option value='i'>depaf[i]</option>";
}
str+="</select>";
document.getElementById("secondDepa").innerHTML=str;
showSecondDepa();
}
function showSecondDepa(){
document.getElementById("secondDepa").style.display="";
int i=parseInt(document.getElementById("firstDep"));
var str="<select id='secondDep'>";
for(j=1;j<depas[i].length+1;j++){
str+="<option value='j'>depas[i][j]</option>";
}
str+="</select>";
document.getElementById("secondDepa").innerHtml=str;
}
</script>
</head> <body>
<form name="form1" method="post" action="4.jsp">
<table>
<tr>
<td id="add" style="display: none">
<select>
<option value="and">并且</option>
<option value="or">或者</option>
</select>
</td>
<td>
<select id="main" name="main" onChange="showSubmenu(this.value);">
<option value="teacherName">
教师姓名
</option>
<option value="courseName">
课程名称
</option>
<option value="department">
部门
</option>
<option value="annualName">
课程年度
</option>
</select>
</td>
<td id="relation">
<select id="relationsel">
<option value="=">=</option>
<option value="lt"><</option>
<option value="gt">></option>
<option value="not">
<>
</option>
<option value="like">
like
</option>
</select>
</td>
<td id="firstDepa" style="display: none"></td>
<td id="secondDepa" style="display: none"></td>
<td id="teacherName" style="display: none">
<input name="teacherName" id="teaName" type="text" maxlength="20" />
</td>
<td id="courseName" style="display: none">
<select id="courseName">
<%
ResultSet co_na_rs = cn
.CourseNameAllQuery("select * from course_name");
while (co_na_rs.next()) {
%>
<option value="<%=co_na_rs.getString(2)%>"><%=co_na_rs.getString(2)%></option>
<%
}
%>
</select>
</td>
<td id="annualName" style="display: none">
<select id="annualName">
<%
ResultSet an_rs = an.AnnualAllQuery("select * from annual");
while (an_rs.next()) {
%>
<option value="<%=an_rs.getString(2)%>"><%=an_rs.getString(2)%></option>
<%
}
%>
</select>
</td>
<td>
<input type="button" value="添加" />
</td>
</tr>
<tr>
<td colspan="4">
<textarea rows="10" cols="50" id="text" name="text"></textarea>
</td>
</tr>
</table>
</form>
</body></html>
<%@ page language="java" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<jsp:useBean id="fdepa" class="edu.hrbeu.cstcmis.dao.FirstDepartment"></jsp:useBean>
<jsp:useBean id="sdepa" class="edu.hrbeu.cstcmis.dao.SecondDepartment"></jsp:useBean>
<jsp:useBean id="an" class="edu.hrbeu.cstcmis.dao.Annual"></jsp:useBean>
<jsp:useBean id="cn" class="edu.hrbeu.cstcmis.dao.CourseName"></jsp:useBean>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>My JSP 'relation.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script type="text/javascript" language="javascript">
var depaf=new Array();
<%
ResultSet depaf_rs=fdepa.FirstDepartmentAllQuery("select * from first_depa");
while(depaf_rs.next()){
%>
depaf[<%=depaf_rs.getInt(1)%>]=<%=depaf_rs.getString(2)%>;
<%
ResultSet depas_rs=sdepa.SecondDepartmentAllQuery("select * from second_depa where depaf_id="+depaf_rs.getInt(1));
while(depas_rs.next()){
%>
depas[<%=depaf_rs.getInt(1)%>][<%=depas_rs.getInt(1)%>]=<%=depas_rs.getString(3)%>;
<%
}
}
%>
function showSubmenu(name){
if(name=="teacherName"){
document.getElementById("teacherName").style.display="";
document.getElementById("courseName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("annualName").style.display="none";
}
if(name=="courseName"){
document.getElementById("courseName").style.display="";
document.getElementById("teacherName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("annualName").style.display="none";
}
if(name=="department"){
showThreeSubmenu();
document.getElementById("teacherName").style.display="none";
document.getElementById("courseName").style.display="none";
document.getElementById("annualName").style.display="none";
}
if(name=="annualName"){
document.getElementById("annualName").style.display="";
document.getElementById("teacherName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("courseName").style.display="none";
}
}
function showThreeSubmenu(){
document.getElementById("secondDepa").style.display="";
var str="<select id='firstDep'>";
for(i=1;i<depaf.length+1;i++){
str+="<option value='i'>depaf[i]</option>";
}
str+="</select>";
document.getElementById("secondDepa").innerHTML=str;
showSecondDepa();
}
function showSecondDepa(){
document.getElementById("secondDepa").style.display="";
int i=parseInt(document.getElementById("firstDep"));
var str="<select id='secondDep'>";
for(j=1;j<depas[i].length+1;j++){
str+="<option value='j'>depas[i][j]</option>";
}
str+="</select>";
document.getElementById("secondDepa").innerHtml=str;
}
</script>
</head> <body>
<form name="form1" method="post" action="4.jsp">
<table>
<tr>
<td id="add" style="display: none">
<select>
<option value="and">并且</option>
<option value="or">或者</option>
</select>
</td>
<td>
<select id="main" name="main" onChange="showSubmenu(this.value);">
<option value="teacherName">
教师姓名
</option>
<option value="courseName">
课程名称
</option>
<option value="department">
部门
</option>
<option value="annualName">
课程年度
</option>
</select>
</td>
<td id="relation">
<select id="relationsel">
<option value="=">=</option>
<option value="lt"><</option>
<option value="gt">></option>
<option value="not">
<>
</option>
<option value="like">
like
</option>
</select>
</td>
<td id="firstDepa" style="display: none"></td>
<td id="secondDepa" style="display: none"></td>
<td id="teacherName" style="display: none">
<input name="teacherName" id="teaName" type="text" maxlength="20" />
</td>
<td id="courseName" style="display: none">
<select id="courseName">
<%
ResultSet co_na_rs = cn
.CourseNameAllQuery("select * from course_name");
while (co_na_rs.next()) {
%>
<option value="<%=co_na_rs.getString(2)%>"><%=co_na_rs.getString(2)%></option>
<%
}
%>
</select>
</td>
<td id="annualName" style="display: none">
<select id="annualName">
<%
ResultSet an_rs = an.AnnualAllQuery("select * from annual");
while (an_rs.next()) {
%>
<option value="<%=an_rs.getString(2)%>"><%=an_rs.getString(2)%></option>
<%
}
%>
</select>
</td>
<td>
<input type="button" value="添加" />
</td>
</tr>
<tr>
<td colspan="4">
<textarea rows="10" cols="50" id="text" name="text"></textarea>
</td>
</tr>
</table>
</form>
</body></html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="http://localhost:8080/cstcmis/"> <title> My JSP 'relation.jsp' starting page </title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script type="text/javascript" language="javascript">
var depaf=new Array(); depaf[1]="院直机关"; depaf[1][1]="院领导"; depaf[1][2]="综合办公室"; depaf[1][3]="教务办公室"; depaf[1][4]="学生工作办公室"; depaf[1][5]="科技工作办公室"; function showSubmenu(name){
if(name=="teacherName"){
document.getElementById("teacherName").style.display="";
document.getElementById("courseName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("annualName").style.display="none";
}
if(name=="courseName"){
document.getElementById("courseName").style.display="";
document.getElementById("teacherName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("annualName").style.display="none";
}
if(name=="department"){
showThreeSubmenu();
document.getElementById("teacherName").style.display="none";
document.getElementById("courseName").style.display="none";
document.getElementById("annualName").style.display="none";
}
if(name=="annualName"){
document.getElementById("annualName").style.display="";
document.getElementById("teacherName").style.display="none";
document.getElementById("firstDepa").style.display="none"
document.getElementById("secondDepa").style.display="none"
document.getElementById("courseName").style.display="none";
}
}
function showThreeSubmenu(){
document.getElementById("secondDepa").style.display="";
var str=" <select id='firstDep'> ";
for(i=1;i <depaf.length+1;i++){
str+=" <option value='i'> depaf[i] </option> ";
}
str+=" </select> ";
document.getElementById("secondDepa").innerHTML=str;
showSecondDepa();
}
function showSecondDepa(){
document.getElementById("secondDepa").style.display="";
var i=parseInt(document.getElementById("firstDep"));
var str=" <select id='secondDep'> ";
for(j=1;j <depaf[i].length+1;j++){
str+=" <option value='j'> depaf[i][j] </option> ";
}
str+=" </select> ";
document.getElementById("secondDepa").innerHtml=str;
} </script>
</head> <body>
<form name="form1" method="post" action="4.jsp">
<table>
<tr>
<td id="add" style="display: none">
<select>
<option value="and"> 并且 </option>
<option value="or"> 或者 </option>
</select>
</td>
<td>
<select id="main" name="main" onChange="showSubmenu(this.value);">
<option value="teacherName">
教师姓名
</option>
<option value="courseName">
课程名称
</option>
<option value="department">
部门
</option>
<option value="annualName">
课程年度
</option>
</select>
</td>
<td id="relation">
<select id="relationsel">
<option value="=">
=
</option>
<option value="lt">
<
</option>
<option value="gt">
>
</option>
<option value="not">
<>
</option>
<option value="like">
like
</option>
</select>
</td>
<td id="firstDepa" style="display: none"> </td>
<td id="secondDepa" style="display: none"> </td>
<td id="teacherName" style="display: none">
<input name="teacherName" id="teaName" type="text" maxlength="20" />
</td>
<td id="courseName" style="display: none">
<select id="courseName"> <option value="vhdl"> vhdl </option> <option value="算法"> 算法 </option> </select>
</td>
<td id="annualName" style="display: none">
<select id="annualName"> <option value="2005-2006"> 2005-2006 </option> <option value="2006-2007"> 2006-2007 </option> </select>
</td>
<td>
<input type="button" value="添加" />
</td>
</tr>
<tr>
<td colspan="4">
<textarea rows="10" cols="50" id="text" name="text"> </textarea>
</td>
</tr>
</table>
</form>
</body> </html>