<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<SCRIPT language=JavaScript>
SubMenuinfo = new Array(
new Array(
new Array("产品1-1", 39482304),
new Array("产品1-2", 34802389),
new Array("产品1-3", 39823498),
new Array("产品1-4", 87587343),
new Array("产品1-5", 68798735),
new Array("产品1-6", 98098509),
new Array("产品1-7", 49490583),
new Array("产品1-8", 32898334),
new Array("产品1-9", 92340934),
new Array("产品1-10", 34923409),
new Array("产品1-11", 59384093)
),
new Array(
new Array("产品2-1", 23840238),
new Array("产品2-2", 92390484),
new Array("产品2-3", 29048203),
new Array("产品2-4", 94098230),
new Array("产品2-5", 39234923),
new Array("产品2-6", 29345423),
new Array("产品2-7", 24890234),
new Array("产品2-8", 92349823)
),
null,
//主分类3没有子分类,用null;
new Array(
new Array("产品4-1", 20394802),
new Array("产品4-2", 34982039),
new Array("产品4-3", 92348902),
new Array("产品4-4", 98203894),
new Array("产品4-5", 98234902),
new Array("产品4-6", 52938409)
)
);
function fillSelectFromArray(selectCtrl, itemArray, goodPrompt, badPrompt, defaultItem) {
var i, j;
var prompt;
for (i = selectCtrl.options.length; i >= 0; i--) {
selectCtrl.options[i] = null;
}
prompt = (itemArray != null) ? goodPrompt : badPrompt;
if (prompt == null) {
j = 0;
}
else {
selectCtrl.options[0] = new Option(prompt);
j = 1;
}
if (itemArray != null) {
for (i = 0; i < itemArray.length; i++) {
selectCtrl.options[j] = new Option(itemArray[i][0]);
if (itemArray[i][1] != null) {
selectCtrl.options[j].value = itemArray[i][1];
}
j++;
}
selectCtrl.options[0].selected = true;
}
}
</SCRIPT>
</HEAD><BODY>
<form name="main" method="post" action="collect.asp" target="_blank">
<div align="center">
<select
onChange="fillSelectFromArray(this.form.SubMenu, ((this.selectedIndex == -1) ? null : SubMenuinfo[this.selectedIndex-1]));" name=MainMenu class="menu">
<option value=-1 selected>选择产品分类
<option value="分类1">产品分类1
<option value="分类2">产品分类2
<option value="分类3">产品分类3
<option value="分类4">产品分类4 </option>
</select>
<select size=1 name=SubMenu class="menu">
<option>---------------</option>
<option></option>
<option></option>
<option></option>
<option></option>
</select>
<input type="submit" value="Submit it" name="submit">
</div>
</form> </BODY>
</HTML>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<SCRIPT language=JavaScript>
SubMenuinfo = new Array(
new Array(
new Array("产品1-1", 39482304),
new Array("产品1-2", 34802389),
new Array("产品1-3", 39823498),
new Array("产品1-4", 87587343),
new Array("产品1-5", 68798735),
new Array("产品1-6", 98098509),
new Array("产品1-7", 49490583),
new Array("产品1-8", 32898334),
new Array("产品1-9", 92340934),
new Array("产品1-10", 34923409),
new Array("产品1-11", 59384093)
),
new Array(
new Array("产品2-1", 23840238),
new Array("产品2-2", 92390484),
new Array("产品2-3", 29048203),
new Array("产品2-4", 94098230),
new Array("产品2-5", 39234923),
new Array("产品2-6", 29345423),
new Array("产品2-7", 24890234),
new Array("产品2-8", 92349823)
),
null,
//主分类3没有子分类,用null;
new Array(
new Array("产品4-1", 20394802),
new Array("产品4-2", 34982039),
new Array("产品4-3", 92348902),
new Array("产品4-4", 98203894),
new Array("产品4-5", 98234902),
new Array("产品4-6", 52938409)
)
);
function fillSelectFromArray(selectCtrl, itemArray, goodPrompt, badPrompt, defaultItem) {
var i, j;
var prompt;
for (i = selectCtrl.options.length; i >= 0; i--) {
selectCtrl.options[i] = null;
}
prompt = (itemArray != null) ? goodPrompt : badPrompt;
if (prompt == null) {
j = 0;
}
else {
selectCtrl.options[0] = new Option(prompt);
j = 1;
}
if (itemArray != null) {
for (i = 0; i < itemArray.length; i++) {
selectCtrl.options[j] = new Option(itemArray[i][0]);
if (itemArray[i][1] != null) {
selectCtrl.options[j].value = itemArray[i][1];
}
j++;
}
selectCtrl.options[0].selected = true;
}
}
</SCRIPT>
</HEAD><BODY>
<form name="main" method="post" action="collect.asp" target="_blank">
<div align="center">
<select
onChange="fillSelectFromArray(this.form.SubMenu, ((this.selectedIndex == -1) ? null : SubMenuinfo[this.selectedIndex-1]));" name=MainMenu class="menu">
<option value=-1 selected>选择产品分类
<option value="分类1">产品分类1
<option value="分类2">产品分类2
<option value="分类3">产品分类3
<option value="分类4">产品分类4 </option>
</select>
<select size=1 name=SubMenu class="menu">
<option>---------------</option>
<option></option>
<option></option>
<option></option>
<option></option>
</select>
<input type="submit" value="Submit it" name="submit">
</div>
</form> </BODY>
</HTML>
如果select标记是在明细表中的。应该如何实现啊?
在第一个select标签中的onChange属性中加入方法如:onChange="checkData()"
然后把数据库的东西取下来。主动的放在第一个select,被动的放在第二个select。
然后主动的数据和被动的数据建立一下关系,即主动选择某个的时候被动的要出现什么。
用js实现。说到这里应该明白了吧。
两个select
点击A的时候,页面刷新,同时提交一个ID,
处理页面得到参数,把相应的数据取出来放到B中!!
两个select
点击A的时候,页面刷新,同时提交一个ID,
处理页面得到参数,把相应的数据取出来放到B中!!
--------------------他说的是要刷新页面的,不建议采用这种方法
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<jsp:useBean id="user" class="com.conn" scope="page"/>
<%
String las =request.getParameter("la");
String ars =request.getParameter("ar");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function yjchang(){
document.form2.la.value=document.form1.la.value;
document.form2.submit();
}
</script>
</head>
<body>
<form action="xx_add.jsp" method=post name="form2">
<input type="hidden" name="la" id="la" value="<%=las%>">
<input type="hidden" name="ar" id="ar" value="<%=ars%>">
</form><form name="form1" method="post" action="xx_add_do.jsp">
<br>
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" class="table1">
<tr>
<td width="16%" height="40" align="right">部门:</td>
<td height="40">
<select name="la" id="la" style="width:147" onChange="yjchang()">
<option></option>
<%
String la1=request.getParameter("la");
String la="";
ResultSet rs_la=null;
try{
rs_la=user.executeQuery("select branch_id,name from branch");
while(rs_la.next()){
la="";
if(rs_la.getString("branch_id").equals(la1)){
la="selected";
%>
<option value="<%=rs_la.getString("branch_id")%>" <%=la%>><%=rs_la.getString("name")%></option>
<%
}else{
la="";
%>
<option value="<%=rs_la.getString("branch_id")%>"><%=rs_la.getString("name")%></option>
<%}}
}catch( SQLException sqle ){}
catch( Exception e ){}
finally{
try{
user.getClose();
if (rs_la !=null){
rs_la.close();
rs_la=null;
}
}catch( SQLException sqle ){}
}
%>
</select>
</td>
<td height="40" align="right">员工:</td>
<td height="40">
<select name="ar" id="ar" style="width:147">
<option></option>
<%
if(las!=null){
String ar1=request.getParameter("ar");
String ar="";
ResultSet rs_area=null;
try{
rs_area=user.executeQuery("select ygid,name from hyj.area where branch_id='"+las+"'");
while(rs_area.next()){
ar="";
if(rs_area.getString("ygid").equals(ar1)){
ar="selected";
%>
<option value="<%=rs_area.getString("ygid")%>" <%=ar%>><%=rs_area.getString("name")%></option>
<%}else{%>
<option value="<%=rs_area.getString("ygid")%>"><%=rs_area.getString("name")%></option>
<%}}
}catch( SQLException sqle ){}
catch( Exception e ){}
finally{
try{
user.getClose();
if (rs_area !=null){
rs_area.close();
rs_area=null;
}
}catch( SQLException sqle ){}
}
%>
</select>
</td>
</tr>
<tr align="center">
<td height="40" colspan="4">
<input type="Submit" name="tj" value="提交" class="button">
<input type="reset" name="Submit" value="重置" class="button">
</td>
</tr>
</table>
</form>
</body>
</html>