首先，要实现如下图效果，
1、要理清思路：
先做出三个下拉菜单—-根据第一个下拉菜单的value值获取第二个下拉列表的内容，第三个同理。
2、用到的数据库表：Chinastates表
规律：根据国家级（中国）的areacode查询省级(如：北京) ; 根据省级的areacode查询市级（如：北京市辖）；根据市级的areacode查询区级（如东城区）
第一种方式：没有用到封装，数据读取较慢，可以看看原理，这样在第二种方式封装时就容易多了。
代码如下：
<!DOCTYPE html>
<html>
<head>
<meta charset=UTF-8>
<title></titl
2022-05-13 08:34:34
68KB
1
JS来实现三级联动，把文件解压后，运行index.html看效果即可，geo_copy.js可不用看，一个小修改后的副本而已
2022-05-10 15:22:38
48KB
1
简易的 layui 三级联动 使用只需要一行代码 封装到了layui模块 layui专用
2022-05-09 10:23:19
849KB
1
HTML5新手小案例，实现简单复选框里的三级联动菜单，新手代码，老鸟请跳过，简单易懂，没有过多的复杂的CSS，HTML5新手请笑纳。
2022-05-08 14:49:21
43KB
1
2021省市区三级联动SQL表
110000 北京 1 0
110100 北京市 2 110000
110101 东城区 3 110100
110102 西城区 3 110100
110105 朝阳区 3 110100
110106 丰台区 3 110100
110107 石景山区 3 110100
110108 海淀区 3 110100
110109 门头沟区 3 110100
110111 房山区 3 110100
110112 通州区 3 110100
110113 顺义区 3 110100
110114 昌平区 3 110100
110115 大兴区 3 110100
110116 怀柔区 3 110100
110117 平谷区 3 110100
110118 密云区 3 110100
110119 延庆区 3 110100
120000 天津 1 0
120100 天津市 2 120000
120101 和平区 3 120100
120102 河东区 3 120100
2022-05-06 18:10:36
115KB
数据库结构，id,pid(父id，省/洲的父id是国家id，城市父id是省id)，level(等级，1为国家，2为省/洲，3位城市), name(地区名), code(地区名缩写)
数据时qq国际版的xml文件，费了老大劲整理成的sql文件，另外这个是纯英文版的
2022-05-06 14:09:19
789KB
1
我是一个android新手，所以一切以简单起步。android的控件spinner,类似于一个下拉列表.如果您正在学习这个控件，需要实现基于这个控件的二级联动效果,不妨使用这个看看.
使用方法：用eclipse导入，假若报错，把平台改为android2.2,jdk1.6就可以了。
2022-05-05 12:15:51
44KB
1
spProvince = (Spinner)findViewById(R.id.spAddMettingAddressProvince);
spCity = (Spinner)findViewById(R.id.spAddMettingAddressCity);
ArrayAdapter aAdapter = ArrayAdapter.createFromResource(this, R.array.province, android.R.layout.simple_spinner_item);
aAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
spProvince.setAdapter(aAdapter);
spProvince.setOnItemSelectedListener(new OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView parent, View view,
int position, long id) {
Spinner spinner = (Spinner)parent;
String pro = (String)spinner.getItemAtPosition(position);
ArrayAdapter cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.city_default, android.R.layout.simple_spinner_item);
//new ArrayAdapter
// (MainActivity.this,android.R.layout.simple_spinner_item, cities);
//获取所在省含有哪些市(从资源数组文件中获取数据)
if(pro.equals("河北省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.hebei, android.R.layout.simple_spinner_item);
}else if(pro.equals("北京市")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.bj, android.R.layout.simple_spinner_item);
}else if(pro.equals("山西省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.shan1xi, android.R.layout.simple_spinner_item);
}else if(pro.equals("天津市")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.tianjing, android.R.layout.simple_spinner_item);
}else if(pro.equals("内蒙古")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.neimeng, android.R.layout.simple_spinner_item);
}else if(pro.equals("辽宁省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.liaoning, android.R.layout.simple_spinner_item);
}else if(pro.equals("吉林省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.jilin, android.R.layout.simple_spinner_item);
}else if(pro.equals("黑龙江省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.heilongjjiang, android.R.layout.simple_spinner_item);
}else if(pro.equals("上海市")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.shanghai, android.R.layout.simple_spinner_item);
}else if(pro.equals("江苏省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.jiangsu, android.R.layout.simple_spinner_item);
}else if(pro.equals("浙江省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.zhejiang, android.R.layout.simple_spinner_item);
}else if(pro.equals("安徽省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.anhui, android.R.layout.simple_spinner_item);
}else if(pro.equals("福建省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.fujian, android.R.layout.simple_spinner_item);
}else if(pro.equals("江西省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.jiangxi, android.R.layout.simple_spinner_item);
}else if(pro.equals("山东省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.shandong, android.R.layout.simple_spinner_item);
}else if(pro.equals("河南省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.henan, android.R.layout.simple_spinner_item);
}else if(pro.equals("湖北省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.hubei, android.R.layout.simple_spinner_item);
}else if(pro.equals("湖南省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.hunan, android.R.layout.simple_spinner_item);
}else if(pro.equals("广东省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.guangdong, android.R.layout.simple_spinner_item);
}else if(pro.equals("广西自治区")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.guangxi, android.R.layout.simple_spinner_item);
}else if(pro.equals("海南省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.hainan, android.R.layout.simple_spinner_item);
}else if(pro.equals("重庆市")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.chongqing, android.R.layout.simple_spinner_item);
}else if(pro.equals("四川省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.sichuan, android.R.layout.simple_spinner_item);
}else if(pro.equals("贵州省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.guzhou, android.R.layout.simple_spinner_item);
}else if(pro.equals("云南省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.yunan, android.R.layout.simple_spinner_item);
}else if(pro.equals("西藏自治区")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.xizang, android.R.layout.simple_spinner_item);
}else if(pro.equals("陕西省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.shan3xi, android.R.layout.simple_spinner_item);
}else if(pro.equals("甘肃省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.gansu, android.R.layout.simple_spinner_item);
}else if(pro.equals("青海省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.qinghai, android.R.layout.simple_spinner_item);
}else if(pro.equals("宁夏回族自治区")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.ningxia, android.R.layout.simple_spinner_item);
}else if(pro.equals("新疆维吾尔自治区")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.xinjiang, android.R.layout.simple_spinner_item);
}else if(pro.equals("香港特别行政区")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.xianggang, android.R.layout.simple_spinner_item);
}else if(pro.equals("澳门特别行政区")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.aomen, android.R.layout.simple_spinner_item);
}else if(pro.equals("台湾省")){
cityAdapter = ArrayAdapter.createFromResource
(MettingAddActivity.this, R.array.taiwan, android.R.layout.simple_spinner_item);
}
cityAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
//绑定数据到Spinner(City)上
spCity.setAdapter(cityAdapter);
}
@Override
public void onNothingSelected(AdapterView parent) {
}
});
2022-05-05 11:15:21
14KB
1