关注,我手头在着手解决一个动态二级下拉框与文本框联系的问题,还未完全解决,你先看看,大家共同讨论
E-mail:[email protected]<html>
<body>
<form name=inputfrm>
<input name="holderName">
<!--//初始化select1,n记录select1元素的个数-->
<select name="select1" style="width:90;background-color:white" onchange="checkselect1(this.selectedIndex);" >
<script language=javascript>
var temp=new Array();
</script>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString ="DSN=tapemanage_dsn;UID=sa;PWD=sa"
conn.open
set rs=Server.CreateObject("ADODB.Recordset")
Sql="select distinct department from user_table"
rs.open sql,conn
n=0
rs.movefirst
while not rs.eof
%>
<option><%=rs("department")%></option>
<script language=javascript>
temp[<%=n%>]="<%=rs("department")%>";
</script>
<%
n=n+1
rs.movenext
wend
rs.close
conn.close
%>
</select>
<!--初始化select2-->
<select name="select2" style="width:90;background-color:white" onClick="addvalue1()">
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString ="DSN=tapemanage_dsn;UID=sa;PWD=sa"
conn.open
set rs=Server.CreateObject("ADODB.Recordset")
Sql="select * from user_table where department='部门1'"
rs.open sql,conn
rs.movefirst
while not rs.eof
%>
<option><%=rs("userName")%></option>
<%
rs.movenext
wend
rs.close
conn.close
%>
</select>
<script language=javascript>
//定义数组
var arrkq=new Array();
for(i=0;i<<%=n%>;i++){
arrkq[i]=new Array();
}
for(i=0;i<<%=n%>;i++){
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString ="DSN=tapemanage_dsn;UID=sa;PWD=sa"
conn.open
set rs=Server.CreateObject("ADODB.Recordset")
Sql="select * from user_table where department='部门2'"%>
<%
rs.open sql,conn
m1=0
rs.movefirst
while not rs.eof
%>
arrkq[i][<%=m1%>]='<%=trim(rs("userName"))%>';
<%
m1=m1+1
rs.movenext
wend
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
}function checkselect1(n){
var obj=document.inputfrm.select2;
for (i=(obj.options.length-1);i>-1;i--)
{
obj.options.remove(i);
}
switch (n){
case 0:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,0,i);
}
break;
case 1:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,1,i);
}
break;
case 2:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,2,i);
}
break;
case 3:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,3,i);
}
break;
}
}
//将数组元素arrkq[n][i]转化为下拉框obj元素
function setoptions(obj,n,i)
{
var the_option= new Option(arrkq[n][i]);
obj.add(the_option);
}
//从第二个下拉框select2选择元素加入文本框holderName
function addvalue1(){
var obj=document.inputfrm.select2;
var lname=document.inputfrm .holderName;
lname.value=obj.options[obj.selectedIndex].text;
}
</script>
</form>
</body>
</html>
E-mail:[email protected]<html>
<body>
<form name=inputfrm>
<input name="holderName">
<!--//初始化select1,n记录select1元素的个数-->
<select name="select1" style="width:90;background-color:white" onchange="checkselect1(this.selectedIndex);" >
<script language=javascript>
var temp=new Array();
</script>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString ="DSN=tapemanage_dsn;UID=sa;PWD=sa"
conn.open
set rs=Server.CreateObject("ADODB.Recordset")
Sql="select distinct department from user_table"
rs.open sql,conn
n=0
rs.movefirst
while not rs.eof
%>
<option><%=rs("department")%></option>
<script language=javascript>
temp[<%=n%>]="<%=rs("department")%>";
</script>
<%
n=n+1
rs.movenext
wend
rs.close
conn.close
%>
</select>
<!--初始化select2-->
<select name="select2" style="width:90;background-color:white" onClick="addvalue1()">
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString ="DSN=tapemanage_dsn;UID=sa;PWD=sa"
conn.open
set rs=Server.CreateObject("ADODB.Recordset")
Sql="select * from user_table where department='部门1'"
rs.open sql,conn
rs.movefirst
while not rs.eof
%>
<option><%=rs("userName")%></option>
<%
rs.movenext
wend
rs.close
conn.close
%>
</select>
<script language=javascript>
//定义数组
var arrkq=new Array();
for(i=0;i<<%=n%>;i++){
arrkq[i]=new Array();
}
for(i=0;i<<%=n%>;i++){
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString ="DSN=tapemanage_dsn;UID=sa;PWD=sa"
conn.open
set rs=Server.CreateObject("ADODB.Recordset")
Sql="select * from user_table where department='部门2'"%>
<%
rs.open sql,conn
m1=0
rs.movefirst
while not rs.eof
%>
arrkq[i][<%=m1%>]='<%=trim(rs("userName"))%>';
<%
m1=m1+1
rs.movenext
wend
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
}function checkselect1(n){
var obj=document.inputfrm.select2;
for (i=(obj.options.length-1);i>-1;i--)
{
obj.options.remove(i);
}
switch (n){
case 0:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,0,i);
}
break;
case 1:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,1,i);
}
break;
case 2:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,2,i);
}
break;
case 3:
for (i=0;i<<%=m1%>;i++)
{
setoptions(obj,3,i);
}
break;
}
}
//将数组元素arrkq[n][i]转化为下拉框obj元素
function setoptions(obj,n,i)
{
var the_option= new Option(arrkq[n][i]);
obj.add(the_option);
}
//从第二个下拉框select2选择元素加入文本框holderName
function addvalue1(){
var obj=document.inputfrm.select2;
var lname=document.inputfrm .holderName;
lname.value=obj.options[obj.selectedIndex].text;
}
</script>
</form>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货