怎么用java实现点省份的菜单里的辽宁选项,城市的菜单里就列出锦州、沈阳。 http://www.haodazx.com/InfoList.asp?jType=2Exmple 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 抄给你<%'三级下拉框连动 ' '数据库: 'location '表1 loaction 所在地表 ' 字段 ' loactionid (主键) ' loactionname 名字 '表2 district 所在的地区表 ' 字段 ' locationid (主键) ' districtid ' districtname '表3 village 所在的县区表 ' 字段 ' districtid (主键) ' villageid ' villagename %><html> <head> <title>List</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <% dim conn dim rs dim sql dim count dim rs1 dim sql1 dim rs2 dim sql2 dim count2 set conn=server.createobject("adodb.connection")conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=R:\staff\program_test.mdb;"sql = "select * from district order by locationid asc" set rs = conn.execute(sql) %> <script language = "JavaScript"> var onecount; onecount=0; subcat = new Array(); <% count = 0 do while not rs.eof %> subcat[<%=count%>] = new Array("<%= trim(rs("districtname"))%>","<%= trim(rs("locationid"))%>","<%= trim(rs("districtid"))%>"); <% count = count + 1 rs.movenext loop rs.close set rs=nothing %> onecount=<%=count%>; function changelocation(locationid) { document.myform.smalllocation.length = 0; var locationid=locationid; var i; document.myform.smalllocation.options[0] = new Option('==所选城市的地区==',''); for (i=0;i < onecount; i++) { if (subcat[i][1] == locationid) { document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]); } } } </script> <%sql2 = "select * from village order by districtid asc" set rs2 = conn.execute(sql2) %> <script language = "JavaScript"> var onecount2; onecount2=0; subcat2 = new Array(); <% count2 = 0 do while not rs2.eof %> subcat2[<%=count2%>] = new Array("<%= trim(rs2("villagename"))%>","<%= trim(rs2("districtid"))%>","<%= trim(rs2("villageid"))%>"); <% count2 = count2 + 1 rs2.movenext loop rs2.close set rs2=nothing %> onecount2=<%=count2%>; function changelocation2(villageid) { document.myform.village.length = 0; var villageid=villageid; var j; document.myform.village.options[0] = new Option('==所选地区的县区==',''); for (j=0;j < onecount2; j++) { if (subcat2[j][1] == villageid) { document.myform.village.options[document.myform.village.length] = new Option(subcat2[j][0], subcat2[j][2]); } } } </script> </head> <body oncontextmenu="return false"><form name="myform" method="post"> 题目:<input type="text" name="T2" size="20"><br/> 来源:<input type="text" name="T3" size="20"><br/> 分类:<select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)" size="1"> <option selected>请选择你所在的省份</option> <% sql1 = "select * from location order by locationname asc" set rs1 = conn.Execute (sql1) do while not rs1.eof %> <option value="<%=trim(rs1("locationid"))%>"><%=trim(rs1("locationname"))%></option> <% rs1.movenext loop rs1.close set rs1 = nothing conn.Close set conn = nothing %> </select> <select name="smalllocation" onChange="changelocation2(document.myform.smalllocation.options[document.myform.smalllocation.selectedIndex].value)"> <option selected value="">==所有地区==</option> </select> <select name="village" size="1"> <option selected>==所有县区==</option> </select> <br/> 关键词:<input type="text" name="T4" size="20"><br/> 内容:<textarea rows="9" name="S1" cols="51"></textarea> </form> </body> </html> <body><h2>实际应用中XML文件可以放在外部文件中,IE6测试通过</h2><xml id="doc"><data> <province name="广东"> <city>广州</city> <city>深圳</city> <city>汕头</city> </province> <province name="吉林"> <city>长春</city> <city>四平</city> <city>吉林</city> <city>白城</city> </province> <province name="河南"> <city>郑州</city> <city>洛阳</city> <city>开封</city> <city>安阳</city> </province></data></xml><select id=prov onchange="docity()"><option value="0">--- 请选择省份 ---</option></select><select id=city></select><script language="JavaScript">function init(){ var v1 = doc.getElementsByTagName("province"); for(var i =0; i<v1.length;i++){ var e = document.createElement("OPTION"); e.innerText = e.value = v1[i].getAttribute("name"); prov.appendChild(e); }}function docity(){ var sf = prov.value; var str="//province[@name='"+sf+"']"; var v = doc.selectSingleNode(str); if(!v){ alert("没有符合条件的记录!");return;} city.innerHTML = ""; var v1 = v.selectNodes("city") for(var i =0; i<v1.length;i++){ var e = document.createElement("OPTION"); e.innerText = e.value = v1[i].text; city.appendChild(e); }}init();</script> 用java实现?你想用applet还是想前后台跑来跑去啊? 下。。js?<html><head><title>sel Bar</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><form name="form" method="post" action=""><body bgcolor="#FFFFFF" text="#000000"><table cellspacing="0" cellpadding="0" class="hang2"> <tr> <td> <div align="center">一级目录</div> </td> <td> <div align="center">二级目录</div> </td> </tr> <tr> <td> <div align="center"> <select name="s_1" onchange="changeSub(s_2,this[this.selectedIndex].THE_ID)"> <option selected THE_ID='0'>请选择</option> <option value='矽肺' THE_ID='1'>矽肺</option> </select> </div> </td> <td> <select name="s_2" > <option selected THE_ID='0'>--请选择职业病类别--</option> </select> </td> </tr></table><SCRIPT LANGUAGE="JavaScript"><!-- var COLUMNS=new Array(); var HaveAnyThing=""; //Add Item function addItem(mObj) { mObj.length=0; arrLng=COLUMNS.length; for(i=0;i<arrLng;i++) { getVal=COLUMNS[i].split("|"); mOpt=new Option(); mOpt.value=getVal[0]; mOpt.text=getVal[0]; mOpt.THE_ID=getVal[1]; mObj.options.add(mOpt); } }//end of Function function changeSub(mObj,THEID) { COLUMNS=new Array(); switch(THEID) { case "0": COLUMNS[0]="--请选择职业病类别--|"; break; case "1": COLUMNS[0]="0+|0+"; COLUMNS[1]="1|1"; COLUMNS[2]="2|2"; COLUMNS[3]="3|3"; break; default: HaveAnyThing="NOTHING"; break; } if(HaveAnyThing!="NOTHING") { addItem(mObj); HaveAnyThing=""; } else { mObj.length=0; alert(HaveAnyThing+THEID); HaveAnyThing="";//添加进去 } }//--></SCRIPT> <input align ="right" type="button" name="Submit" value="取消" onclick="jJavaScript:alert(asdf)"></body></form></html> <form name=form1><select name=sheng onchange="cityName(this.value)"> <option value="">请选择省名</option></select><select name=city> <option value="">请选择城名</option></select></form><script language=javascript>var cityouterHTML = document.form1.city.outerHTML.substr(0, document.form1.city.outerHTML.length-9);function sheng(){ var shengName = ["浙江", "江苏", "安徽", "江西"]; //这些数据可以从数据库中取得 var e = document.form1.sheng; var s = e.outerHTML.substr(0, e.outerHTML.length-9) + "\r\n"; for (var i=0; i<shengName.length; i++){ s += "<option value='"+ shengName[i] +"'>"+ shengName[i] +"</option>\r\n";} s += "</select>"; e.outerHTML = s;} sheng();function cityName(val){ var 浙江 = ["杭州", "宁波", "温州", "绍兴", "金华", "湖州"]; var 江苏 = ["南京", "苏州", "无锡", "常州", "镇江", "徐州"]; var 安徽 = ["合肥", "翕县", "黄山", "祁门", "休宁"]; var 江西 = ["南昌", "九江", "赣州", "上饶", "新余", "景德镇"]; //这些数据可以从数据库中取得 var e = document.form1.city; var s = cityouterHTML; if (val == "") {s += "</select>"; e.outerHTML = s; return;} var a = eval(val); for (var i=0; i<a.length; i++) { s += "<option value='"+ a[i] +"'>"+ a[i] +"</option>\r\n"; } s += "</select>"; e.outerHTML = s;}</script> 我有“学号”姓名“,如何使用SQL语句实现输入”学号“,在姓名栏自动显示该学号对应的姓名? js 中2进制 位运算问题 在线等结果,JS返回值问题 有没有高手帮我看看 IE7下面有js profiler工具吗?大家推荐下!谢谢! 剪切可以改成ff兼容吗? navigator.mimeTypes.length为什么会是0 ? 如何将多个一维数组重新格式化为一个多维数组 关于动态插入 脚本 急!myeclipse中错把项目导入另一个项目,原项目被覆盖,怎么恢复原来的web项目 請問怎樣抓去回車值 insertCell()的问题? 高分求判断日期格式的正则表达式。(up有分)
'三级下拉框连动
'
'数据库:
'location
'表1 loaction 所在地表
' 字段
' loactionid (主键)
' loactionname 名字
'表2 district 所在的地区表
' 字段
' locationid (主键)
' districtid
' districtname
'表3 village 所在的县区表
' 字段
' districtid (主键)
' villageid
' villagename
%>
<html>
<head>
<title>List</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
dim conn
dim rs
dim sql
dim count
dim rs1
dim sql1
dim rs2
dim sql2
dim count2 set conn=server.createobject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=R:\staff\program_test.mdb;"
sql = "select * from district order by locationid asc"
set rs = conn.execute(sql) %>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("districtname"))%>","<%= trim(rs("locationid"))%>","<%= trim(rs("districtid"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
set rs=nothing
%>
onecount=<%=count%>; function changelocation(locationid)
{
document.myform.smalllocation.length = 0; var locationid=locationid;
var i;
document.myform.smalllocation.options[0] = new Option('==所选城市的地区==','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
}
} }
</script>
<%sql2 = "select * from village order by districtid asc"
set rs2 = conn.execute(sql2)
%>
<script language = "JavaScript">
var onecount2;
onecount2=0;
subcat2 = new Array();
<%
count2 = 0
do while not rs2.eof
%>
subcat2[<%=count2%>] = new Array("<%= trim(rs2("villagename"))%>","<%= trim(rs2("districtid"))%>","<%= trim(rs2("villageid"))%>");
<%
count2 = count2 + 1
rs2.movenext
loop
rs2.close
set rs2=nothing
%>
onecount2=<%=count2%>; function changelocation2(villageid)
{
document.myform.village.length = 0; var villageid=villageid;
var j;
document.myform.village.options[0] = new Option('==所选地区的县区==','');
for (j=0;j < onecount2; j++)
{
if (subcat2[j][1] == villageid)
{
document.myform.village.options[document.myform.village.length] = new Option(subcat2[j][0], subcat2[j][2]);
}
} }
</script>
</head>
<body oncontextmenu="return false"><form name="myform" method="post">
题目:<input type="text" name="T2" size="20"><br/>
来源:<input type="text" name="T3" size="20"><br/>
分类:<select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)" size="1">
<option selected>请选择你所在的省份</option>
<%
sql1 = "select * from location order by locationname asc"
set rs1 = conn.Execute (sql1)
do while not rs1.eof
%>
<option value="<%=trim(rs1("locationid"))%>"><%=trim(rs1("locationname"))%></option>
<%
rs1.movenext
loop
rs1.close
set rs1 = nothing
conn.Close
set conn = nothing
%>
</select>
<select name="smalllocation" onChange="changelocation2(document.myform.smalllocation.options[document.myform.smalllocation.selectedIndex].value)">
<option selected value="">==所有地区==</option>
</select>
<select name="village" size="1">
<option selected>==所有县区==</option>
</select>
<br/>
关键词:<input type="text" name="T4" size="20"><br/>
内容:<textarea rows="9" name="S1" cols="51"></textarea>
</form>
</body>
</html>
<h2>实际应用中XML文件可以放在外部文件中,IE6测试通过</h2>
<xml id="doc">
<data>
<province name="广东">
<city>广州</city>
<city>深圳</city>
<city>汕头</city>
</province> <province name="吉林">
<city>长春</city>
<city>四平</city>
<city>吉林</city>
<city>白城</city>
</province> <province name="河南">
<city>郑州</city>
<city>洛阳</city>
<city>开封</city>
<city>安阳</city>
</province>
</data>
</xml>
<select id=prov onchange="docity()">
<option value="0">--- 请选择省份 ---</option>
</select>
<select id=city>
</select><script language="JavaScript">
function init(){
var v1 = doc.getElementsByTagName("province");
for(var i =0; i<v1.length;i++){
var e = document.createElement("OPTION");
e.innerText = e.value = v1[i].getAttribute("name");
prov.appendChild(e);
}
}
function docity(){
var sf = prov.value;
var str="//province[@name='"+sf+"']";
var v = doc.selectSingleNode(str);
if(!v){ alert("没有符合条件的记录!");return;}
city.innerHTML = "";
var v1 = v.selectNodes("city")
for(var i =0; i<v1.length;i++){
var e = document.createElement("OPTION");
e.innerText = e.value = v1[i].text;
city.appendChild(e);
}
}
init();
</script>
js?
<html>
<head>
<title>sel Bar</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<form name="form" method="post" action="">
<body bgcolor="#FFFFFF" text="#000000">
<table cellspacing="0" cellpadding="0" class="hang2">
<tr>
<td>
<div align="center">一级目录</div>
</td>
<td>
<div align="center">二级目录</div>
</td>
</tr>
<tr>
<td>
<div align="center">
<select name="s_1" onchange="changeSub(s_2,this[this.selectedIndex].THE_ID)">
<option selected THE_ID='0'>请选择</option>
<option value='矽肺' THE_ID='1'>矽肺</option>
</select>
</div>
</td>
<td>
<select name="s_2" >
<option selected THE_ID='0'>--请选择职业病类别--</option>
</select>
</td>
</tr>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
var COLUMNS=new Array();
var HaveAnyThing=""; //Add Item
function addItem(mObj)
{
mObj.length=0;
arrLng=COLUMNS.length;
for(i=0;i<arrLng;i++)
{
getVal=COLUMNS[i].split("|"); mOpt=new Option(); mOpt.value=getVal[0];
mOpt.text=getVal[0];
mOpt.THE_ID=getVal[1];
mObj.options.add(mOpt);
}
}//end of Function function changeSub(mObj,THEID)
{
COLUMNS=new Array();
switch(THEID)
{
case "0":
COLUMNS[0]="--请选择职业病类别--|";
break;
case "1":
COLUMNS[0]="0+|0+";
COLUMNS[1]="1|1";
COLUMNS[2]="2|2";
COLUMNS[3]="3|3";
break;
default:
HaveAnyThing="NOTHING";
break;
} if(HaveAnyThing!="NOTHING")
{
addItem(mObj);
HaveAnyThing="";
}
else
{
mObj.length=0;
alert(HaveAnyThing+THEID);
HaveAnyThing="";//添加进去 }
}
//-->
</SCRIPT> <input align ="right" type="button" name="Submit" value="取消" onclick="jJavaScript:alert(asdf)">
</body></form>
</html>
<option value="">请选择省名</option>
</select><select name=city>
<option value="">请选择城名</option>
</select></form><script language=javascript>
var cityouterHTML = document.form1.city.outerHTML.substr(0, document.form1.city.outerHTML.length-9);
function sheng()
{
var shengName = ["浙江", "江苏", "安徽", "江西"]; //这些数据可以从数据库中取得 var e = document.form1.sheng;
var s = e.outerHTML.substr(0, e.outerHTML.length-9) + "\r\n";
for (var i=0; i<shengName.length; i++){
s += "<option value='"+ shengName[i] +"'>"+ shengName[i] +"</option>\r\n";}
s += "</select>";
e.outerHTML = s;
} sheng();
function cityName(val)
{
var 浙江 = ["杭州", "宁波", "温州", "绍兴", "金华", "湖州"];
var 江苏 = ["南京", "苏州", "无锡", "常州", "镇江", "徐州"];
var 安徽 = ["合肥", "翕县", "黄山", "祁门", "休宁"];
var 江西 = ["南昌", "九江", "赣州", "上饶", "新余", "景德镇"];
//这些数据可以从数据库中取得 var e = document.form1.city;
var s = cityouterHTML;
if (val == "") {s += "</select>"; e.outerHTML = s; return;}
var a = eval(val);
for (var i=0; i<a.length; i++)
{
s += "<option value='"+ a[i] +"'>"+ a[i] +"</option>\r\n";
}
s += "</select>";
e.outerHTML = s;
}
</script>