<SCRIPT language=JavaScript>
SubMenuinfo = new Array(
new Array(
new Array("工人", "工人"),
new Array("企事业负责人", "企事业负责人"),
new Array("职员", "职员"),
new Array("科技人员", "科技人员"),
new Array("律师", "律师"),
new Array("公务员", "公务员"),
new Array("农民", "农民"),
new Array("军人", "军人"),
new Array("医生", "医生"),
new Array("教师", "教师"),
new Array("商业人员", "商业人员"),
new Array("服务人员", "服务人员"),
new Array("文体人员", "文体人员"),
new Array("个体劳动者", "个体劳动者"),
new Array("无业人员", "无业人员"),
new Array("其他人员", "其他人员"),
new Array("学生", "学生")
),
new Array(
new Array("社团", "社团"),
new Array("部委", "部委"),
new Array("教育", "教育"),
new Array("科研", "科研"),
new Array("驻华机构", "驻华机构"),
new Array("国内公司", "国内公司"),
new Array("三资企业", "三资企业"),
new Array("信息服务", "信息服务"),
new Array("新闻机构", "新闻机构"),
new Array("外国商社", "外国商社"),
new Array("金融", "金融"),
new Array("政府机关", "政府机关"),
new Array("军事", "军事"),
new Array("其他", "其他")
),
new Array(
new Array("工人", "工人"),
new Array("企事业负责人", "企事业负责人"),
new Array("职员", "职员"),
new Array("科技人员", "科技人员"),
new Array("律师", "律师"),
new Array("公务员", "公务员"),
new Array("农民", "农民"),
new Array("军人", "军人"),
new Array("医生", "医生"),
new Array("教师", "教师"),
new Array("商业人员", "商业人员"),
new Array("服务人员", "服务人员"),
new Array("文体人员", "文体人员"),
new Array("个体劳动者", "个体劳动者"),
new Array("无业人员", "无业人员"),
new Array("其他人员","其他人员"),
new Array("学生", "学生")
),
//主分类3没有子分类,用null;
new Array(
new Array("工人", "工人"),
new Array("企事业负责人", "企事业负责人"),
new Array("职员", "职员"),
new Array("科技人员", "科技人员"),
new Array("律师", "律师"),
new Array("公务员", "公务员"),
new Array("农民","农民"),
new Array("军人", "军人"),
new Array("医生", "医生"),
new Array("教师", "教师"),
new Array("商业人员", "商业人员"),
new Array("服务人员", "服务人员"),
new Array("文体人员", "文体人员"),
new Array("个体劳动者", "个体劳动者"),
new Array("无业人员", "无业人员"),
new Array("其他人员", "其他人员"),
new Array("学生", "学生")
),
new Array(
new Array("社团", "社团"),
new Array("部委", "部委"),
new Array("教育", "教育"),
new Array("科研", "科研"),
new Array("驻华机构", "驻华机构"),
new Array("国内公司", "国内公司"),
new Array("三资企业", "三资企业"),
new Array("信息服务", "信息服务"),
new Array("新闻机构", "新闻机构"),
new Array("外国商社", "外国商社"),
new Array("金融", "金融"),
new Array("政府机关", "政府机关"),
new Array("军事","军事"),
new Array("其他", "其他")
),
new Array(
new Array("社团", "社团"),
new Array("部委", "部委"),
new Array("教育", "教育"),
new Array("科研", "科研"),
new Array("驻华机构", "驻华机构"),
new Array("国内公司", "国内公司"),
new Array("三资企业", "三资企业"),
new Array("信息服务", "信息服务"),
new Array("新闻机构", "新闻机构"),
new Array("外国商社", "外国商社"),
new Array("金融", "金融"),
new Array("政府机关", "政府机关"),
new Array("军事","军事"),
new Array("其他", "其他")
),
new Array(
new Array("社团", "社团"),
new Array("部委", "部委"),
new Array("教育", "教育"),
new Array("科研", "科研"),
new Array("驻华机构", "驻华机构"),
new Array("国内公司", "国内公司"),
new Array("三资企业", "三资企业"),
new Array("信息服务", "信息服务"),
new Array("新闻机构", "新闻机构"),
new Array("外国商社", "外国商社"),
new Array("金融", "金融"),
new Array("政府机关", "政府机关"),
new Array("军事","军事"),
new Array("其他", "其他")
)
);
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>
<%@ Language=VBScript codepage=936 %>
<% Option Explicit %>
<!-- 数据库结构 两个字段 provinceName(省名) cityName(城市名) -->
<!-- #include file="connection.asp" -->
<script language=javascript>
<%
dim RS
Set RS = Server.CreateObject("ADODB.Recordset")
RS.open "SELECT * FROM tableName ORDER BY provinceName DESC", Conn, 0, 1
dim provinceName '省名
dim provinceList '记录所有的省名, 最后输出到JS里组成省名数组
dim cityList '记录某个省的所有城市名, 最后输出到JS里组成城市名数组
dim cityIndex 'JS的city数组名与省名下拉框的索引对应
cityIndex = 1
do while not RS.eof
if isEmpty(provinceName) then
cityList = cityList & chr(34) & Trim(RS("cityName")) & chr(34) &","
provinceName = Trim(RS("provinceName"))
else
if provinceName<>Trim(RS("provinceName")) then
provinceList = provinceList & chr(34) & provinceName & chr(34) &","
if not isEmpty(cityList) then Response.write "var city"& cityIndex &_
" = ["& Left(cityList, Len(cityList)-1) &"];"& VBCrLf
'输出每个省所对应的城市名的列表并组成JS的数组, 数组形式参考下面的实例
cityIndex = cityIndex + 1
cityList = ""
end if
provinceName = Trim(RS("provinceName"))
cityList = cityList & chr(34) & Trim(RS("cityName")) & chr(34) &","
'将每个省里的所有城市名组成一串字串
end if
RS.movenext
loop
if not isEmpty(cityList) then
Response.write "var city"& cityIndex &" = ["& Left(cityList, Len(cityList)-1) &"];"& VBCrLf
end if
if not isEmpty(provinceName) then
provinceList = provinceList & chr(34) & provinceName & chr(34) &","
Response.write "var provinceName = ["& Left(provinceList, Len(provinceList)-1) &"];"
'输出省名字串并组成省名的JS数组, 形式见下实例
end if
RS.close : Set RS=nothing
Conn.close : Set Conn=nothing
%>
</script>
/* 若要直接看下拉框联动效果的话, 将这段被注释的代码起用, 且上面的那段ASP注释即可
var provinceName = ["浙江", "江苏", "安徽", "江西"];
var city1 = ["杭州", "宁波", "温州", "绍兴", "金华", "湖州"];
var city2 = ["南京", "苏州", "无锡", "常州", "镇江", "徐州"];
var city3 = ["合肥", "翕县", "黄山", "祁门", "休宁"];
var city4 = ["南昌", "九江", "赣州", "上饶", "新余", "景德镇"];
//你在ASP输出的页面里应该看到如上这般的JS数组, 能看到则表示成功
*/
function province()
{
var e = document.form1.province;
for (var i=0; i<provinceName.length; i++)
e.options.add(new Option(provinceName[i], provinceName[i]));
}
function cityName(n)
{
var e = document.form1.city;
e.options.length = 1;
if (n == 0) return;
var a = eval("city"+ n); //得到城市的数组名
for (var i=0; i<a.length; i++) e.options.add(new Option(a[i], a[i]));
}
window.attachEvent("onload", province); //初始时给省名下拉框赋内容
</script>