省市县三级联动菜单，JS全国省市县(区)联动，怎样连接到数据库啊？
2024-05-05 14:29
1. 省市县三级联动菜单，JS全国省市县(区)联动，怎样连接到数据库啊？
给你一些思路： 1、省市县的数据写到数据库中。每条数据会有一个父ID（上级ID）。 2、在页面上省变动后，查询市的数据以省的ID作为条件，县也一样，以市 的ID为条件。 第二种方法， 由于全国的这些基本上是固定的，一般变动比较少，这可以把这个数据写到JS里面，通过JS来实现。这个加载会快一些。这些数据可以到国家统计局的网站去下载。
2. 省市县三级联动
三次加载 var temp = 3; var s = new Array(temp); var first = 0; function init(){ for (var i = 0; i --请选择省份-- --请选择市区-- --请选择城市-- init(); 上面的是这个代码你拿回去看看，我已经测过了，也给其他需要的人看看。有问题可以问，分记得给我，代码我可是发了2个小时写和调的。谢谢
麻烦采纳，谢谢!
3. 省市区 地址联动 数据怎么创建
1、在做这个小项目前的准备工作：
1.1、分析：
由于省、市、县城（区）这些数据是存储到了MySQL数据库中的，我们要通过后台servlet获取数据库中的数据，然后再通过转发或者重定向的方式将数据呈现到前台页面中。
1.2、需要导入的jar包有:
mysql驱动包：mysql-connector-Java-5.1.7-bin.jar
c3p0数据库连接池：c3p0-0.9.2.1.jar、mysql-connector-java-5.1.7-bin.jar（c3p0依赖包）
前台c标签（需要通过遍历的方式呈现——c:forEach）：jstl-1.0.2.jar、standard-1.0.1.jar（jstl依赖包）
将集合或者数组转换成json数据格式（Jackson包）：jackson-annotations-2.2.1.jar、jackson-core-2.2.1.jar、jackson-databind-2.2.1.jar
前台页面需要用到jQuery，故还需要导入jquery-1.7.2.js库文件
1.3、该小项目用到的技术：
jdbc的知识、servlet的知识、jquery的知识、Ajax的知识（局部刷新）、标签的知识、EL表达式的知识、JSP的知识
2、开发过程：
2.1、准备数据源
创建一个数据库，命名为thereaction并创建三个表——province（省）、city（市）、county（县/区）
2.2后台开发
创建三个Javabean分别是Province、City、County。（由于太过简单，这里就不粘代码了）
创建Java类和c3p0连接池实现与数据库的连接：DAO.java(实现获取数据库数据的功能)、jdbctools.java（实现获取数据库连接、释放连接的功能）、c3p0-config.xml
jdbctools.java代码如下：
[java] view plain copy
package com.xiaojie.dao;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class Jdbctools {
private static DataSource ds=null;
//数据库连接池应只被初始化一次
static{
ds=new ComboPooledDataSource("helloc3p0");
}
//获取数据库连接
public static Connection getConnection() throws ClassNotFoundException, SQLException, IOException{
return ds.getConnection();
}
public static void shifanglianjie(Connection ct, PreparedStatement ps,ResultSet rs) {
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(ct!=null){
try {
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
DAO.java的代码如下
[java] view plain copy
package com.xiaojie.dao;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.xiaojie.beans.City;
import com.xiaojie.beans.County;
import com.xiaojie.beans.Province;
public class DAO {
public List getprovince(String sql ,Object...args) throws ClassNotFoundException, SQLException, IOException{
List provinces=new ArrayList();
//准备去查数据库
Connection ct=null;
ct=Jdbctools.getConnection();
System.out.println("获取到数据库的连接了");
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
provinces.add(new Province(rs.getInt("province_id"),rs.getString("province_name")));
}
Jdbctools.shifanglianjie(ct, ps, rs);
return provinces;
}
public List getcity(String sql ,Object...args) throws SQLException, ClassNotFoundException, IOException{
List cities=new ArrayList();
//准备去查数据库
Jdbctools jt=new Jdbctools();
Connection ct=null;
ct=jt.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
cities.add(new City(rs.getInt("city_id"),rs.getString("city_name")));
}
jt.shifanglianjie(ct, ps, rs);
return cities;
}
public List getcounty(String sql,Object...args ) throws SQLException, ClassNotFoundException, IOException{
List counties=new ArrayList();
//准备去查数据库
Jdbctools jt=new Jdbctools();
Connection ct=null;
ct=jt.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
counties.add(new County(rs.getInt("county_id"),rs.getString("county_name")));
}
jt.shifanglianjie(ct, ps, rs);
return counties;
}
}
c3p0-config.xml的代码如下：
[html] view plain copy
root
com.mysql.jdbc.Driver
jdbc:mysql:///thereaction
5
5
5
10
20
5
创建servlet.java 文件
[java] view plain copy
package com.xiaojie.servlet;
import java.io.IOException;
import java.lang.reflect.Method;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.xiaojie.beans.City;
import com.xiaojie.beans.County;
import com.xiaojie.beans.Province;
import com.xiaojie.dao.DAO;
/**
* Servlet implementation class ThreeactiondServlet
*/
@WebServlet("/threeactiondServlet")
public class ThreeactiondServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String methodname=request.getParameter("method");
try {
Method method=getClass().getDeclaredMethod(methodname,HttpServletRequest.class,HttpServletResponse.class);
method.invoke(this, request,response);//调用各自的方法
} catch (Exception e) {
e.printStackTrace();
}
}
private DAO dao=new DAO();
protected void province(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
System.out.println("province的servlet进入了");
String sql="select province_id,province_name from province";
List provinces=dao.getprovince(sql);
request.setAttribute("provinces", provinces);
System.out.println(provinces);
//注意：这里不能用重定向的形式，因为我们好不容易在request请求域中存储了省的信息，目的是在前台页面中能够从请求域中获取到我们存在数据库中的值
//故这里只能用转发的方式
request.getRequestDispatcher("/index2.jsp").forward(request, response);
}
protected void city(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
System.out.println("city的servlet进入了");
String province_id=request.getParameter("province_id");
String sql="select city_id,city_name from city where province_id=?";
List cities=dao.getcity(sql,Integer.parseInt(province_id));
ObjectMapper mapper=new ObjectMapper();
String result=mapper.writeValueAsString(cities);
System.out.println(result);
response.setContentType("text/javascript");
response.getWriter().print(result);
}
protected void county(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
System.out.println("county的servlet进入了");
String city_id=request.getParameter("city_id");
String sql="select county_id,county_name from county where city_id=?";
List counties=dao.getcounty(sql,Integer.parseInt(city_id));
ObjectMapper mapper=new ObjectMapper();
String result=mapper.writeValueAsString(counties);
System.out.println(result);
response.setContentType("text/javascript");
response.getWriter().print(result);
}
}
4. 如何实现省市区三级联动的效果
1、在做这个小项目前的准备工作：
1.1、分析：
由于省、市、县城（区）这些数据是存储到了MySQL数据库中的，我们要通过后台servlet获取数据库中的数据，然后再通过转发或者重定向的方式将数据呈现到前台页面中。
1.2、需要导入的jar包有:
mysql驱动包：mysql-connector-Java-5.1.7-bin.jar
c3p0数据库连接池：c3p0-0.9.2.1.jar、mysql-connector-java-5.1.7-bin.jar（c3p0依赖包）
前台c标签（需要通过遍历的方式呈现——c:forEach）：jstl-1.0.2.jar、standard-1.0.1.jar（jstl依赖包）
将集合或者数组转换成json数据格式（Jackson包）：jackson-annotations-2.2.1.jar、jackson-core-2.2.1.jar、jackson-databind-2.2.1.jar
前台页面需要用到jQuery，故还需要导入jquery-1.7.2.js库文件
1.3、该小项目用到的技术：
jdbc的知识、servlet的知识、jquery的知识、Ajax的知识（局部刷新）、标签的知识、EL表达式的知识、JSP的知识
2、开发过程：
2.1、准备数据源
创建一个数据库，命名为thereaction并创建三个表——province（省）、city（市）、county（县/区）
2.2后台开发
创建三个Javabean分别是Province、City、County。（由于太过简单，这里就不粘代码了）
创建Java类和c3p0连接池实现与数据库的连接：DAO.java(实现获取数据库数据的功能)、jdbctools.java（实现获取数据库连接、释放连接的功能）、c3p0-config.xml
jdbctools.java代码如下：
[java] view plain copy
package com.xiaojie.dao;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class Jdbctools {
private static DataSource ds=null;
//数据库连接池应只被初始化一次
static{
ds=new ComboPooledDataSource("helloc3p0");
}
//获取数据库连接
public static Connection getConnection() throws ClassNotFoundException, SQLException, IOException{
return ds.getConnection();
}
public static void shifanglianjie(Connection ct, PreparedStatement ps,ResultSet rs) {
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(ct!=null){
try {
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
DAO.java的代码如下
[java] view plain copy
package com.xiaojie.dao;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.xiaojie.beans.City;
import com.xiaojie.beans.County;
import com.xiaojie.beans.Province;
public class DAO {
public List getprovince(String sql ,Object...args) throws ClassNotFoundException, SQLException, IOException{
List provinces=new ArrayList();
//准备去查数据库
Connection ct=null;
ct=Jdbctools.getConnection();
System.out.println("获取到数据库的连接了");
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
provinces.add(new Province(rs.getInt("province_id"),rs.getString("province_name")));
}
Jdbctools.shifanglianjie(ct, ps, rs);
return provinces;
}
public List getcity(String sql ,Object...args) throws SQLException, ClassNotFoundException, IOException{
List cities=new ArrayList();
//准备去查数据库
Jdbctools jt=new Jdbctools();
Connection ct=null;
ct=jt.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
cities.add(new City(rs.getInt("city_id"),rs.getString("city_name")));
}
jt.shifanglianjie(ct, ps, rs);
return cities;
}
public List getcounty(String sql,Object...args ) throws SQLException, ClassNotFoundException, IOException{
List counties=new ArrayList();
//准备去查数据库
Jdbctools jt=new Jdbctools();
Connection ct=null;
ct=jt.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
counties.add(new County(rs.getInt("county_id"),rs.getString("county_name")));
}
jt.shifanglianjie(ct, ps, rs);
return counties;
}
}
c3p0-config.xml的代码如下：
[html] view plain copy
root
com.mysql.jdbc.Driver
jdbc:mysql:///thereaction
5
5
5
10
20
5
创建servlet.java 文件
[java] view plain copy
package com.xiaojie.servlet;
import java.io.IOException;
import java.lang.reflect.Method;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.xiaojie.beans.City;
import com.xiaojie.beans.County;
import com.xiaojie.beans.Province;
import com.xiaojie.dao.DAO;
/**
* Servlet implementation class ThreeactiondServlet
*/
@WebServlet("/threeactiondServlet")
public class ThreeactiondServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String methodname=request.getParameter("method");
try {
Method method=getClass().getDeclaredMethod(methodname,HttpServletRequest.class,HttpServletResponse.class);
method.invoke(this, request,response);//调用各自的方法
} catch (Exception e) {
e.printStackTrace();
}
}
private DAO dao=new DAO();
protected void province(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
System.out.println("province的servlet进入了");
String sql="select province_id,province_name from province";
List provinces=dao.getprovince(sql);
request.setAttribute("provinces", provinces);
System.out.println(provinces);
//注意：这里不能用重定向的形式，因为我们好不容易在request请求域中存储了省的信息，目的是在前台页面中能够从请求域中获取到我们存在数据库中的值
//故这里只能用转发的方式
request.getRequestDispatcher("/index2.jsp").forward(request, response);
}
protected void city(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
System.out.println("city的servlet进入了");
String province_id=request.getParameter("province_id");
String sql="select city_id,city_name from city where province_id=?";
List cities=dao.getcity(sql,Integer.parseInt(province_id));
ObjectMapper mapper=new ObjectMapper();
String result=mapper.writeValueAsString(cities);
System.out.println(result);
response.setContentType("text/javascript");
response.getWriter().print(result);
}
protected void county(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException {
System.out.println("county的servlet进入了");
String city_id=request.getParameter("city_id");
String sql="select county_id,county_name from county where city_id=?";
List counties=dao.getcounty(sql,Integer.parseInt(city_id));
ObjectMapper mapper=new ObjectMapper();
String result=mapper.writeValueAsString(counties);
System.out.println(result);
response.setContentType("text/javascript");
response.getWriter().print(result);
}
}
5. js高手帮忙省市县三级联动
省市县关联菜单
body,select
{
font-size:9pt;
font-family:Verdana;
}
a
{
color:red;
text-decoration:none;
}
a:hover{
text-decoration:underline;
}
<!--
function Dsy()
{
this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
if(typeof(this.Items[id]) == "undefined") return false;
return true;
}
function change(v){
var str="0";
for(i=0;i<v;i++){ str+=("_"+(document.getElementById(s[i]).selectedIndex-1));};
var ss=document.getElementById(s[v]);
with(ss){
length = 0;
options[0]=new Option(opt0[v],opt0[v]);
if(v && document.getElementById(s[v-1]).selectedIndex>0 || !v)
{
if(dsy.Exists(str)){
ar = dsy.Items[str];
for(i=0;i<ar.length;i++)options[length]=new Option(ar[i],ar[i]);
if(v)options[1].selected = true;
}
}
if(++v<s.length){change(v);}
}
}
var dsy = new Dsy();
dsy.add("0",["安徽","北京","福建","甘肃","广东","广西","贵州","海南","河北","河南","黑龙江","湖北","湖南","吉林","江苏","江西","辽宁","内蒙古","宁夏","青海","山东","山西","陕西","上海","四川","天津","西藏","新疆","云南","浙江","重庆"]);
dsy.add("0_0",["安庆","蚌埠","巢湖","池州","滁州","阜阳","合肥","淮北","淮南","黄山","六安","马鞍山","宿州","铜陵","芜湖","宣城","亳州"]);
dsy.add("0_0_0",["安庆市","怀宁县","潜山县","宿松县","太湖县","桐城市","望江县","岳西县","枞阳县"]);
dsy.add("0_0_1",["蚌埠市","固镇县","怀远县","五河县"]);
dsy.add("0_0_2",["巢湖市","含山县","和县","庐江县","无为县"]);
dsy.add("0_0_3",["池州市","东至县","青阳县","石台县"]);
dsy.add("0_0_4",["滁州市","定远县","凤阳县","来安县","明光市","全椒县","天长市"]);
dsy.add("0_0_5",["阜南县","阜阳市","界首市","临泉县","太和县","颖上县"]);
dsy.add("0_0_6",["长丰县","肥东县","肥西县"]);
dsy.add("0_0_7",["淮北市","濉溪县"]);
dsy.add("0_0_8",["凤台县","淮南市"]);
dsy.add("0_0_9",["黄山市","祁门县","休宁县","歙县","黟县"]);
dsy.add("0_0_10",["霍邱县","霍山县","金寨县","六安市","寿县","舒城县"]);
dsy.add("0_0_11",["当涂县","马鞍山市"]);
dsy.add("0_0_12",["灵璧县","宿州市","萧县","泗县","砀山县"]);
dsy.add("0_0_13",["铜陵市","铜陵县"]);
dsy.add("0_0_14",["繁昌县","南陵县","芜湖市","芜湖县"]);
dsy.add("0_0_15",["广德县","绩溪县","郎溪县","宁国市","宣城市","泾县","旌德县"]);
dsy.add("0_0_16",["利辛县","蒙城县","涡阳县","亳州市"]);
dsy.add("0_1",["北京"]);
dsy.add("0_1_0",["北京市","密云县","延庆县"]);
dsy.add("0_2",["福州","龙岩","南平","宁德","莆田","泉州","三明","厦门","漳州"]);
dsy.add("0_2_0",["长乐市","福清市","福州市","连江县","罗源县","闽侯县","闽清县","平潭县","永泰县"]);
dsy.add("0_2_1",["长汀县","连城县","龙岩市","上杭县","武平县","永定县","漳平市"]);
dsy.add("0_2_2",["光泽县","建阳市","建瓯市","南平市","浦城县","邵武市","顺昌县","松溪县","武夷山市","政和县"]);
dsy.add("0_2_3",["福安市","福鼎市","古田县","宁德市","屏南县","寿宁县","霞浦县","周宁县","柘荣县"]);
dsy.add("0_2_4",["莆田市","仙游县"]);
dsy.add("0_2_5",["安溪县","德化县","惠安县","金门县","晋江市","南安市","泉州市","石狮市","永春县"]);
dsy.add("0_2_6",["大田县","建宁县","将乐县","明溪县","宁化县","清流县","三明市","沙县","泰宁县","永安市","尤溪县"]);
dsy.add("0_2_7",["厦门市"]);
dsy.add("0_2_8",["长泰县","东山县","华安县","龙海市","南靖县","平和县","云霄县","漳浦县","漳州市","诏安县"]);
dsy.add("0_3",["白银","定西","甘南藏族自治州","嘉峪关","金昌","酒泉","兰州","临夏回族自治州","陇南","平凉","庆阳","天水","武威","张掖"]);
dsy.add("0_3_0",["白银市","会宁县","景泰县","靖远县"]);
dsy.add("0_3_1",["定西县","临洮县","陇西县","通渭县","渭源县","漳县","岷县"]);
dsy.add("0_3_2",["迭部县","合作市","临潭县","碌曲县","玛曲县","夏河县","舟曲县","卓尼县"]);
dsy.add("0_3_3",["嘉峪关市"]);
dsy.add("0_3_4",["金昌市","永昌县"]);
dsy.add("0_3_5",["阿克塞哈萨克族自治县","安西县","敦煌市","金塔县","酒泉市","肃北蒙古族自治县","玉门市"]);
dsy.add("0_3_6",["皋兰县","兰州市","永登县","榆中县"]);
dsy.add("0_3_7",["东乡族自治县","广河县","和政县","积石山保安族东乡族撒拉族自治县","康乐县","临夏市","临夏县","永靖县"]);
dsy.add("0_3_8",["成县","徽县","康县","礼县","两当县","文县","武都县","西和县","宕昌县"]);
dsy.add("0_3_9",["崇信县","华亭县","静宁县","灵台县","平凉市","庄浪县","泾川县"]);
dsy.add("0_3_10",["合水县","华池县","环县","宁县","庆城县","庆阳市","镇原县","正宁县"]);
dsy.add("0_3_11",["甘谷县","秦安县","清水县","天水市","武山县","张家川回族自治县"]);
dsy.add("0_3_12",["古浪县","民勤县","天祝藏族自治县","武威市"]);
dsy.add("0_3_13",["高台县","临泽县","民乐县","山丹县","肃南裕固族自治县","张掖市"]);
dsy.add("0_4",["潮州","东莞","佛山","广州","河源","惠州","江门","揭阳","茂名","梅州","清远","汕头","汕尾","韶关","深圳","阳江","云浮","湛江","肇庆","中山","珠海"]);
dsy.add("0_4_0",["潮安县","潮州市","饶平县"]);
dsy.add("0_4_1",["东莞市"]);
dsy.add("0_4_2",["佛山市"]);
dsy.add("0_4_3",["从化市","广州市","增城市"]);
dsy.add("0_4_4",["东源县","和平县","河源市","连平县","龙川县","紫金县"]);
dsy.add("0_4_5",["博罗县","惠东县","惠阳市","惠州市","龙门县"]);
dsy.add("0_4_6",["恩平市","鹤山市","江门市","开平市","台山市"]);
dsy.add("0_4_7",["惠来县","揭东县","揭西县","揭阳市","普宁市"]);
dsy.add("0_4_8",["电白县","高州市","化州市","茂名市","信宜市"]);
dsy.add("0_4_9",["大埔县","丰顺县","蕉岭县","梅县","梅州市","平远县","五华县","兴宁市"]);
dsy.add("0_4_10",["佛冈县","连南瑶族自治县","连山壮族瑶族自治县","连州市","清新县","清远市","阳山县","英德市"]);
dsy.add("0_4_11",["潮阳市","澄海市","南澳县","汕头市"]);
dsy.add("0_4_12",["海丰县","陆丰市","陆河县","汕尾市"]);
dsy.add("0_4_13",["乐昌市","南雄市","曲江县","仁化县","乳源瑶族自治县","韶关市","始兴县","翁源县","新丰县"]);
dsy.add("0_4_14",["深圳市"]);
dsy.add("0_4_15",["阳春市","阳东县","阳江市","阳西县"]);
dsy.add("0_4_16",["罗定市","新兴县","郁南县","云安县","云浮市"]);
dsy.add("0_4_17",["雷州市","廉江市","遂溪县","吴川市","徐闻县","湛江市"]);
dsy.add("0_4_18",["德庆县","封开县","高要市","广宁县","怀集县","四会市","肇庆市"]);
dsy.add("0_4_19",["中山市"]);
dsy.add("0_4_20",["珠海市"]);
dsy.add("0_5",["百色","北海","崇左","防城港","桂林","贵港","河池","贺州","来宾","柳州","南宁","钦州","梧州","玉林"]);
dsy.add("0_5_0",["百色市","德保县","靖西县","乐业县","凌云县","隆林各族自治县","那坡县","平果县","田东县","田林县","田阳县","西林县"]);
dsy.add("0_5_1",["北海市","合浦县"]);
dsy.add("0_5_2",["崇左市","大新县","扶绥县","龙州县","宁明县","凭祥市","天等县"]);
dsy.add("0_5_3",["东兴市","防城港市","上思县"]);
dsy.add("0_5_4",["恭城瑶族自治县","灌阳县","桂林市","荔浦县","临桂县","灵川县","龙胜各族自治县","平乐县","全州县","兴安县","阳朔县","永福县","资源县"]);
dsy.add("0_5_5",["桂平市","贵港市","平南县"]);
dsy.add("0_5_6",["巴马瑶族自治县","大化瑶族自治县","东兰县","都安瑶族自治县","凤山县","河池市","环江毛南族自治县","罗城仡佬族自治县","南丹县","天峨县","宜州市"]);
dsy.add("0_5_7",["富川瑶族自治县","贺州市","昭平县","钟山县"]);
dsy.add("0_5_8",["合山市","金秀瑶族自治县","来宾市","武宣县","象州县","忻城县"]);
dsy.add("0_5_9",["柳城县","柳江县","柳州市","鹿寨县","融安县","融水苗族自治县","三江侗族自治县"]);
dsy.add("0_5_10",["宾阳县","横县","隆安县","马山县","南宁市","上林县","武鸣县","邕宁县"]);
dsy.add("0_5_11",["灵山县","浦北县","钦州市"]);
dsy.add("0_5_12",["苍梧县","蒙山县","藤县","梧州市","岑溪市"]);
dsy.add("0_5_13",["北流市","博白县","陆川县","容县","兴业县","玉林市"]);
dsy.add("0_6",["安顺","毕节","贵阳","六盘水","黔东南苗族侗族自治州","黔南布依族苗族自治州","黔西南布依族苗族自治州","铜仁","遵义"]);
dsy.add("0_6_0",["安顺市","关岭布依族苗族自治县","平坝县","普定县","镇宁布依族苗族自治县","紫云苗族布依族自治县"]);
dsy.add("0_6_1",["毕节市","大方县","赫章县","金沙县","纳雍县","黔西县","威宁彝族回族苗族自治县","织金县"]);
dsy.add("0_6_2",["贵阳市","开阳县","清镇市","息烽县","修文县"]);
dsy.add("0_6_3",["六盘水市","六枝特区","盘县","水城县"]);
dsy.add("0_6_4",["从江县","丹寨县","黄平县","剑河县","锦屏县","凯里市","雷山县","黎平县","麻江县","三穗县","施秉县","台江县","天柱县","镇远县","岑巩县","榕江县"]);
dsy.add("0_6_5",["长顺县","都匀市","独山县","福泉市","贵定县","惠水县","荔波县","龙里县","罗甸县","平塘县","三都水族自治县","瓮安县"]);
dsy.add("0_6_6",["安龙县","册亨县","普安县","晴隆县","望谟县","兴仁县","兴义市","贞丰县"]);
dsy.add("0_6_7",["德江县","江口县","石阡县","思南县","松桃苗族自治县","铜仁市","万山特区","沿河土家族自治县","印江土家族苗族自治县","玉屏侗族自治县"]);
dsy.add("0_6_8",["赤水市","道真仡佬族苗族自治县","凤冈县","仁怀市","绥阳县","桐梓县","务川仡佬族苗族自治县","习水县","余庆县","正安县","遵义市","遵义县","湄潭县"]);
dsy.add("0_7",["白沙黎族自治县","保亭黎族苗族自治县","昌江黎族自治县","澄迈县","定安县","东方","海口","乐东黎族自治县","临高县","陵水黎族自治县","琼海","琼中黎族苗族自治县","三亚","屯昌县","万宁","文昌","五指山","儋州"]);
dsy.add("0_7_0",["白沙黎族自治县"]);
dsy.add("0_7_1",["保亭黎族苗族自治县"]);
dsy.add("0_7_2",["昌江黎族自治县"]);
dsy.add("0_7_3",["澄迈县"]);
dsy.add("0_7_4",["定安县"]);
dsy.add("0_7_5",["东方市"]);
dsy.add("0_7_6",["海口市"]);
dsy.add("0_7_7",["乐东黎族自治县"]);
dsy.add("0_7_8",["临高县"]);
dsy.add("0_7_9",["陵水黎族自治县"]);
dsy.add("0_7_10",["琼海市"]);
dsy.add("0_7_11",["琼中黎族苗族自治县"]);
dsy.add("0_7_12",["三亚市"]);
dsy.add("0_7_13",["屯昌县"]);
dsy.add("0_7_14",["万宁市"]);
dsy.add("0_7_15",["文昌市"]);
dsy.add("0_7_16",["五指山市"]);
dsy.add("0_7_17",["儋州市"]);
dsy.add("0_8",["保定","沧州","承德","邯郸","衡水","廊坊","秦皇岛","石家庄","唐山","邢台","张家口"]);
dsy.add("0_8_0",["安国市","安新县","保定市","博野县","定兴县","定州市","阜平县","高碑店市","高阳县","满城县","清苑县","曲阳县","容城县","顺平县","唐县","望都县","雄县","徐水县","易县","涞水县","涞源县","涿州市","蠡县"]);
dsy.add("0_8_1",["泊头市","沧县","沧州市","东光县","海兴县","河间市","黄骅市","孟村回族自治县","南皮县","青县","任丘市","肃宁县","吴桥县","献县","盐山县"]);
dsy.add("0_8_2",["承德市","承德县","丰宁满族自治县","宽城满族自治县","隆化县","滦平县","平泉县","围场满族蒙古族自治县","兴隆县"]);
dsy.add("0_8_3",["成安县","磁县","大名县","肥乡县","馆陶县","广平县","邯郸市","邯郸县","鸡泽县","临漳县","邱县","曲周县","涉县","魏县","武安市","永年县"]);
dsy.add("0_8_4",["安平县","阜城县","故城县","衡水市","冀州市","景县","饶阳县","深州市","武强县","武邑县","枣强县"]);
dsy.add("0_8_5",["霸州市","大厂回族自治县","大城县","固安县","廊坊市","三河市","文安县","香河县","永清县"]);
dsy.add("0_8_6",["昌黎县","抚宁县","卢龙县","秦皇岛市","青龙满族自治县"]);
dsy.add("0_8_7",["高邑县","晋州市","井陉县","灵寿县","鹿泉市","平山县","深泽县","石家庄市","无极县","辛集市","新乐市","行唐县","元氏县","赞皇县","赵县","正定县","藁城市","栾城县"]);
dsy.add("0_8_8",["乐亭县","滦南县","滦县","迁安市","迁西县","唐海县","唐山市","玉田县","遵化市"]);
dsy.add("0_8_9",["柏乡县","广宗县","巨鹿县","临城县","临西县","隆尧县","南宫市","南和县","内丘县","宁晋县","平乡县","清河县","任县","沙河市","威县","新河县","邢台市","邢台县"]);
dsy.add("0_8_10",["赤城县","崇礼县","沽源县","怀安县","怀来县","康保县","尚义县","万全县","蔚县","宣化县","阳原县","张北县","张家口市","涿鹿县"]);
dsy.add("0_9",["安阳","鹤壁","济源","焦作","开封","洛阳","南阳","平顶山","三门峡","商丘","新乡","信阳","许昌","郑州","周口","驻马店","漯河","濮阳"]);
dsy.add("0_9_0",["安阳市","安阳县","滑县","林州市","内黄县","汤阴县"]);
dsy.add("0_9_1",["","鹤壁市","浚县","淇县"]);
dsy.add("0_9_2",["济源市"]);
dsy.add("0_9_3",["博爱县","焦作市","孟州市","沁阳市","温县","武陟县","修武县"]);
dsy.add("0_9_4",["开封市","开封县","兰考县","通许县","尉氏县","杞县"]);
dsy.add("0_9_5",["洛宁县","洛阳市","孟津县","汝阳县","新安县","伊川县","宜阳县","偃师市","嵩县","栾川县"]);
dsy.add("0_9_6",["邓州市","方城县","南阳市","南召县","内乡县","社旗县","唐河县","桐柏县","西峡县","新野县","镇平县","淅川县"]);
dsy.add("0_9_7",["宝丰县","鲁山县","平顶山市","汝州市","舞钢市","叶县","郏县"]);
dsy.add("0_9_8",["灵宝市","卢氏县","三门峡市","陕县","义马市","渑池县"]);
dsy.add("0_9_9",["民权县","宁陵县","商丘市","夏邑县","永城市","虞城县","柘城县","睢县"]);
dsy.add("0_9_10",["长垣县","封丘县","辉县市","获嘉县","卫辉市","新乡市","新乡县","延津县","原阳县"]);
dsy.add("0_9_11",["固始县","光山县","淮滨县","罗山县","商城县","息县","新县","信阳市","潢川县"]);
dsy.add("0_9_12",["长葛市","襄城县","许昌市","许昌县","禹州市","鄢陵县"]);
dsy.add("0_9_13",["登封市","巩义市","新密市","新郑市","郑州市","中牟县","荥阳市"]);
dsy.add("0_9_14",["郸城县","扶沟县","淮阳县","鹿邑县","商水县","沈丘县","太康县","西华县","项城市","周口市"]);
dsy.add("0_9_15",["泌阳县","平舆县","确山县","汝南县","上蔡县","遂平县","西平县","新蔡县","正阳县","驻马店市"]);
dsy.add("0_9_16",["临颍县","舞阳县","郾城县","漯河市"]);
dsy.add("0_9_17",["范县","南乐县","清丰县","台前县","濮阳市","濮阳县"]);
dsy.add("0_10",["大庆","大兴安岭","哈尔滨","鹤岗","黑河","鸡西","佳木斯","牡丹江","七台河","齐齐哈尔","双鸭山","绥化","伊春"]);
dsy.add("0_10_0",["大庆市","杜尔伯特蒙古族自治县","林甸县","肇源县","肇州县"]);
dsy.add("0_10_1",["呼玛县","漠河县","塔河县"]);
dsy.add("0_10_2",["阿城市","巴彦县","宾县","方正县","哈尔滨市","呼兰县","木兰县","尚志市","双城市","通河县","五常市","延寿县","依兰县"]);
dsy.add("0_10_3",["鹤岗市","萝北县","绥滨县"]);
dsy.add("0_10_4",["北安市","黑河市","嫩江县","孙吴县","五大连池市","逊克县"]);
dsy.add("0_10_5",["虎林市","鸡东县","鸡西市","密山市"]);
dsy.add("0_10_6",["抚远县","富锦市","佳木斯市","汤原县","同江市","桦川县","桦南县"]);
dsy.add("0_10_7",["东宁县","海林市","林口县","牡丹江市","穆棱市","宁安市","绥芬河市"]);
dsy.add("0_10_8",["勃利县","七台河市"]);
dsy.add("0_10_9",["拜泉县","富裕县","甘南县","克东县","克山县","龙江县","齐齐哈尔市","泰来县","依安县","讷河市"]);
dsy.add("0_10_10",["宝清县","集贤县","饶河县","双鸭山市","友谊县"]);
dsy.add("0_10_11",["安达市","海伦市","兰西县","明水县","青冈县","庆安县","绥化市","绥棱县","望奎县","肇东市"]);
dsy.add("0_10_12",["嘉荫县","铁力市","伊春市"]);
dsy.add("0_11",["鄂州","恩施土家族苗族自治州","黄冈","黄石","荆门","荆州","潜江","神农架林区","十堰","随州","天门","武汉","仙桃","咸宁","襄樊","孝感","宜昌"]);
dsy.add("0_11_0",["鄂州市"]);
dsy.add("0_11_1",["巴东县","恩施市","鹤峰县","建始县","来凤县","利川市","咸丰县","宣恩县"]);
dsy.add("0_11_2",["红安县","黄冈市","黄梅县","罗田县","麻城市","团风县","武穴市","英山县","蕲春县","浠水县"]);
dsy.add("0_11_3",["大冶市","黄石市","阳新县"]);
dsy.add("0_11_4",["荆门市","京山县","沙洋县","钟祥市"]);
dsy.add("0_11_5",["公安县","洪湖市","监利县","江陵县","荆州市","石首市","松滋市"]);
dsy.add("0_11_6",["潜江市"]);
dsy.add("0_11_7",["神农架林区"]);
dsy.add("0_11_8",["丹江口市","房县","十堰市","郧西县","郧县","竹山县","竹溪县"]);
dsy.add("0_11_9",["广水市","随州市"]);
dsy.add("0_11_10",["天门市"]);
dsy.add("0_11_11",["武汉市"]);
dsy.add("0_11_12",["仙桃市"]);
dsy.add("0_11_13",["赤壁市","崇阳县","嘉鱼县","通城县","通山县","咸宁市"]);
dsy.add("0_11_14",["保康县","谷城县","老河口市","南漳县","襄樊市","宜城市","枣阳市"]);
dsy.add("0_11_15",["安陆市","大悟县","汉川市","孝昌县","孝感市","应城市","云梦县"]);
dsy.add("0_11_16",["长阳土家族自治县","当阳市","五峰土家族自治县","兴山县","宜昌市","宜都市","远安县","枝江市","秭归县"]);
dsy.add("0_12",["常德","长沙","郴州","衡阳","怀化","娄底","邵阳","湘潭","湘西土家族苗族自治州","益阳","永州","岳阳","张家界","株洲"]);
dsy.add("0_12_0",["安乡县","常德市","汉寿县","津市市","临澧县","石门县","桃源县","澧县"]);
dsy.add("0_12_1",["长沙市","长沙县","宁乡县","望城县","浏阳市"]);
dsy.add("0_12_2",["安仁县","郴州市","桂东县","桂阳县","嘉禾县","临武县","汝城县","宜章县","永兴县","资兴市"]);
dsy.add("0_12_3",["常宁市","衡东县","衡南县","衡山县","衡阳市","衡阳县","祁东县","耒阳市"]);
dsy.add("0_12_4",["辰溪县","洪江市","怀化市","会同县","靖州苗族侗族自治县","麻阳苗族自治县","通道侗族自治县","新晃侗族自治县","中方县","芷江侗族自治县","沅陵县","溆浦县"]);
dsy.add("0_12_5",["冷水江市","涟源市","娄底市","双峰县","新化县"]);
dsy.add("0_12_6",["城步苗族自治县","洞口县","隆回县","邵东县","邵阳市","邵阳县","绥宁县","武冈市","新宁县","新邵县"]);
dsy.add("0_12_7",["韶山市","湘潭市","湘潭县","湘乡市"]);
dsy.add("0_12_8",["保靖县","凤凰县","古丈县","花垣县","吉首市","龙山县","永顺县","泸溪县"]);
dsy.add("0_12_9",["安化县","南县","桃江县","益阳市","沅江市"]);
dsy.add("0_12_10",["道县","东安县","江华瑶族自治县","江永县","蓝山县","宁远县","祁阳县","双牌县","新田县","永州市"]);
dsy.add("0_12_11",["华容县","临湘市","平江县","湘阴县","岳阳市","岳阳县","汨罗市"]);
dsy.add("0_12_12",["慈利县","桑植县","张家界市"]);
dsy.add("0_12_13",["茶陵县","炎陵县","株洲市","株洲县","攸县","醴陵市"]);
dsy.add("0_13",["白城","白山","长春","吉林","辽源","四平","松原","通化","延边朝鲜族自治州"]);
dsy.add("0_13_0",["白城市","大安市","通榆县","镇赉县","洮南市"]);
dsy.add("0_13_1",["白山市","长白朝鲜族自治县","抚松县","江源县","靖宇县","临江市"]);
dsy.add("0_13_2",["长春市","德惠市","九台市","农安县","榆树市"]);
dsy.add("0_13_3",["吉林市","磐石市","舒兰市","永吉县","桦甸市","蛟河市"]);
dsy.add("0_13_4",["东丰县","东辽县","辽源市"]);
dsy.add("0_13_5",["公主岭市","梨树县","双辽市","四平市","伊通满族自治县"]);
dsy.add("0_13_6",["长岭县","扶余县","乾安县","前郭尔罗斯蒙古族自治县","松原市"]);
dsy.add("0_13_7",["辉南县","集安市","柳河县","梅河口市","通化市","通化县"]);
dsy.add("0_13_8",["安图县","敦化市","和龙市","龙井市","图们市","汪清县","延吉市","珲春市"]);
dsy.add("0_14",["常州","淮安","连云港","南京","南通","苏州","宿迁","泰州","无锡","徐州","盐城","扬州","镇江"]);
dsy.add("0_14_0",["常州市","金坛市","溧阳市"]);
dsy.add("0_14_1",["洪泽县","淮安市","金湖县","涟水县","盱眙县"]);
dsy.add("0_14_2",["东海县","赣榆县","灌南县","灌云县","连云港市"]);
dsy.add("0_14_3",["高淳县","南京市","溧水县"]);
dsy.add("0_14_4",["海安县","海门市","南通市","启东市","如东县","如皋市","通州市"]);
dsy.add("0_14_5",["常熟市","昆山市","苏州市","太仓市","吴江市","张家港市"]);
dsy.add("0_14_6",["宿迁市","宿豫县","沭阳县","泗洪县","泗阳县"]);
dsy.add("0_14_7",["姜堰市","靖江市","泰兴市","泰州市","兴化市"]);
dsy.add("0_14_8",["江阴市","无锡市","宜兴市"]);
dsy.add("0_14_9",["丰县","沛县","铜山县","新沂市","徐州市","邳州市","睢宁县"]);
dsy.add("0_14_10",["滨海县","大丰市","东台市","阜宁县","建湖县","射阳县","响水县","盐城市","盐都县"]);
dsy.add("0_14_11",["宝应县","高邮市","江都市","扬州市","仪征市"]);
dsy.add("0_14_12",["丹阳市","句容市","扬中市","镇江市"]);
dsy.add("0_15",["抚州","赣州","吉安","景德镇","九江","南昌","萍乡","上饶","新余","宜春","鹰潭"]);
dsy.add("0_15_0",["崇仁县","东乡县","抚州市","广昌县","金溪县","乐安县","黎川县","南城县","南丰县","宜黄县","资溪县"]);
dsy.add("0_15_1",["安远县","崇义县","大余县","定南县","赣县","赣州市","会昌县","龙南县","南康市","宁都县","全南县","瑞金市","上犹县","石城县","信丰县","兴国县","寻乌县","于都县"]);
dsy.add("0_15_2",["安福县","吉安市","吉安县","吉水县","井冈山市","遂川县","泰和县","万安县","峡江县","新干县","永丰县","永新县"]);
dsy.add("0_15_3",["浮梁县","景德镇市","乐平市"]);
dsy.add("0_15_4",["德安县","都昌县","湖口县","九江市","九江县","彭泽县","瑞昌市","武宁县","星子县","修水县","永修县"]);
dsy.add("0_15_5",["安义县","进贤县","南昌市","南昌县","新建县"]);
dsy.add("0_15_6",["莲花县","芦溪县","萍乡市","上栗县"]);
dsy.add("0_15_7",["波阳县","德兴市","广丰县","横峰县","铅山县","上饶市","上饶县","万年县","余干县","玉山县","弋阳县","婺源县"]);
dsy.add("0_15_8",["分宜县","新余市"]);
dsy.add("0_15_9",["丰城市","奉新县","高安市","靖安县","上高县","铜鼓县","万载县","宜春市","宜丰县","樟树市"]);
dsy.add("0_15_10",["贵溪市","鹰潭市","余江县"]);
dsy.add("0_16",["鞍山","本溪","朝阳","大连","丹东","抚顺","阜新","葫芦岛","锦州","辽阳","盘锦","沈阳","铁岭","营口"]);
dsy.add("0_16_0",["鞍山市","海城市","台安县","岫岩满族自治县"]);
dsy.add("0_16_1",["本溪满族自治县","本溪市","桓仁满族自治县"]);
dsy.add("0_16_2",["北票市","朝阳市
6. c# 做省市县联动
这是我自己做的一个WINFORM下面的天气预报查询的部分代码，详细的话到http://hi.baidu.com/feiyangqingyun/blog/item/1f679b09505ea3c73bc763a2.html下载源码。
private void init()
{
string[] s ={"北京市","上海市","天津市","重庆市","香港","澳门","台湾省",
"云南省","内蒙古","吉林省","四川省","宁夏","安徽省","山东省","山西省",
"广东省","广西省","新疆","江苏省","江西省","河北省","河南省","浙江省",
"海南省","湖北省","湖南省","甘肃省","福建省","西藏","贵州省","辽宁省",
"陕西省","青海省","黑龙江省"};
for (int i = 0; i < s.Length; i++)
{
tscboxPro.Items.Add(s[i]);
}
tscboxPro.SelectedIndex = 0;
}
private void tscboxPro_SelectedIndexChanged(object sender, EventArgs e)
{
tscboxCity.Items.Clear();//清空原来的地区值
switch (tscboxPro.Text.Trim())
{
case "北京市": changeCity(1); break;
case "上海市": changeCity(2); break;
case "天津市": changeCity(3); break;
case "重庆市": changeCity(4); break;
case "香港": changeCity(5); break;
case "澳门": changeCity(6); break;
case "台湾省": changeCity(7); break;
case "云南省": changeCity(8); break;
case "内蒙古": changeCity(9); break;
case "吉林省": changeCity(10); break;
case "四川省": changeCity(11); break;
case "宁夏": changeCity(12); break;
case "安徽省": changeCity(13); break;
case "山东省": changeCity(14); break;
case "山西省": changeCity(15); break;
case "广东省": changeCity(16); break;
case "广西省": changeCity(17); break;
case "新疆": changeCity(18); break;
case "江苏省": changeCity(19); break;
case "江西省": changeCity(20); break;
case "河北省": changeCity(21); break;
case "河南省": changeCity(22); break;
case "浙江省": changeCity(23); break;
case "海南省": changeCity(24); break;
case "湖北省": changeCity(25); break;
case "湖南省": changeCity(26); break;
case "甘肃省": changeCity(27); break;
case "福建省": changeCity(28); break;
case "西藏": changeCity(29); break;
case "贵州省": changeCity(30); break;
case "辽宁省": changeCity(31); break;
case "陕西省": changeCity(32); break;
case "青海省": changeCity(33); break;
case "黑龙江省": changeCity(34); break;
}
}
private void changeCity(int i)
{
//定义字符串保存各省份自治区直辖市地区
string[] s1 ={ "北京市" };//北京市
string[] s2 ={ "上海市" };//上海市
string[] s3 ={ "天津市", "塘沽区" };//天津市
string[] s4 ={ "奉节区", "重庆市", "涪陵区" };//重庆市
string[] s5 ={ "香港" };//香港
string[] s6 ={ "澳门" };//澳门
string[] s7 ={ "台北市" };//台湾省
string[] s8 ={"昭通市","丽江市","曲靖市","保山市","大理州","楚雄州","昆明市","瑞丽市",
"玉溪市","临沧市","思茅市","红河州","文山市","西双版纳州","德宏州","怒江州","迪庆州"};//云南省
string[] s9 ={"呼伦贝尔市","兴安盟","锡林郭勒盟","巴彦淖尔","包头市","呼和浩特市",
"锡林浩特市","通辽市","赤峰市","乌海市","鄂尔多斯","乌兰察布市"};//内蒙古
string[] s10 ={ "辽源市", "通化市", "白城市", "松原市", "长春市", "吉林市", "桦甸市", "延边州", "集安市", "白山市", "四平市" };//吉林省
string[] s11 ={"甘孜州","阿坝州","成都市","绵阳市","雅安市","峨眉山市","乐山市","宜宾市","巴中市","达州市","遂宁市",
"南充市","沪州市","自贡市","攀枝花市","德阳市","广元市","内江市","广安市","眉山市","资阳市","凉山州"};//四川省
string[] s12 ={ "石嘴山市", "银川市", "吴忠市", "固原市" };//宁夏回族自治区
string[] s13 ={"淮南市","马鞍山市","淮北市","铜陵市","滁州市","巢湖市","池州市","宜城市",
"毫州市","宿州市","阜阳市","六安市","蚌埠市","合肥市","芜湖市","安庆市","黄山市"};//安徽省
string[] s14 ={"德州市","滨州市","烟台市","聊城市","济南市","泰安市","淄博市","潍坊市","青岛市",
"济宁市","日照市","泰山市","枣庄市","东营市","威海市","莱芜市","临沂市","菏泽市"};//山东省
string[] s15 ={ "长治市", "晋中市", "朔州市", "大同市", "吕梁市", "忻州市", "太原市",
"阳泉市", "临汾市", "运城市", "晋城市", "五台山市" };//山西省
string[] s16 ={ "南雄市", "韶关市", "清远市", "梅州市", "肇庆市", "广州市", "河源市",
"汕头市", "深圳市", "汕尾市", "湛江市", "阳江市", "茂名市", "佛冈市", "梅县市",
"电白市","高要市","珠海市","佛山市","江门市","东莞市","中山市","潮州市","揭阳市","云浮市" };//广东省
string[] s17 ={ "桂林市", "河池市", "柳州市", "百色市", "贵港市", "梧州市", "南宁市",
"钦州市", "北海市", "防城港市", "玉林市", "贺州市", "来宾市", "崇左市" };//广西省
string[] s18 ={ "昌吉州", "克孜勒苏柯尔克孜自治州", "伊犁州", "阿拉尔市", "克拉玛依市",
"博尔塔拉州", "乌鲁木齐市", "吐鲁番市", "阿克苏市", "石河子市", "喀什市", "和田市", "哈密市", "奇台市"};//新疆维吾尔自治区
string[] s19 ={ "无锡市", "苏州市", "盱眙市", "赣榆市", "东台市", "高邮市", "镇江市",
"泰州市", "宿迁市", "徐州市", "连云港市", "淮安市", "南京市", "扬州市", "盐城市", "南通市", "常州市"};//江苏省
string[] s20 ={ "庐山市", "玉山市", "贵溪市", "广昌市", "萍乡市", "新余市", "宜春市",
"赣州市", "九江市", "景德镇市", "南昌市", "鹰潭市", "上饶市", "抚州市" };//江西省
string[] s21 ={ "邯郸市", "衡水市", "石家庄市", "邢台市", "张家口市", "承德市",
"秦皇岛市", "廊坊市", "唐山市", "保定市", "沧州市" };//河北省
string[] s22 ={ "安阳市", "三门峡市", "郑州市", "南阳市", "周口店市", "驻马店市", "信阳市",
"开封市", "洛阳市", "平顶山市", "焦作市", "鹤壁市", "新乡市", "濮阳市", "许昌市", "漯河市", "商丘市", "济源市" };//河南省
string[] s23 ={ "湖州市", "嵊州市", "平湖市", "石浦市", "宁海市", "洞头市", "舟山市", "杭州市",
"嘉兴市", "定海市", "金华市", "绍兴市", "宁波市", "衢州市", "丽水市", "台州市", "温州市" };//浙江省
string[] s24 ={ "海口市", "三亚市", "屯昌市", "琼海市", "儋州市", "文昌市", "万宁市", "东方市",
"澄迈市", "定安市", "临高市", "白沙黎族自治县", "乐东黎族自治县", "乐东黎族自治县", "乐东黎族自治县", "琼中黎族苗族自治县" };//海南省
string[] s25 ={ "襄樊市", "荆门市", "黄冈市", "恩施市", "武汉市", "黄石市", "鄂州市",
"孝感市", "咸宁市", "随州市", "仙桃市", "天门市", "潜江市", "神农架市" };//湖北省
string[] s26 ={ "张家界市", "岳阳市", "怀化市", "长沙市", "邵阳市", "益阳市", "郴州市",
"桑植市", "沅陵市", "南充市", "株洲市", "湘潭市", "衡阳市", "娄底市", "常德市"};//湖南省
string[] s27 ={ "张掖市", "金昌市", "武威市", "兰州市", "白银市", "定西市", "平凉市",
"庆阳市", "甘南市", "临夏市", "天水市", "嘉峪关市", "酒泉市", "陇南市市" };//甘肃省
string[] s28 ={ "莆田市", "浦城市", "南平市", "宁德市", "福州市", "龙岩市", "三明市", "泉州市", "漳州市", "厦门市" };//福建省
string[] s29 ={ "那曲地区", "日喀则地区", "拉萨市", "山南地区", "阿里地区", "昌都地区", "林芝地区" };//西藏
string[] s30 ={ "毕节市", "遵义市", "铜仁市", "安顺市", "贵阳市", "黔西南州", "六盘水市", };//贵州省
string[] s31 ={ "葫芦岛市", "盘锦市", "辽阳市", "铁岭市", "阜新市", "朝阳市", "锦州市",
"鞍山市", "沈阳市", "本溪市", "抚顺市", "营口市", "丹东市", "瓦房店市", "大连市" };//辽宁省
string[] s32 ={ "榆林市市", "延安市", "西安市", "渭南市", "汉中市", "商洛市", "安康市", "铜川市", "宝鸡市", "咸阳市" };//陕西省
string[] s33 ={ "海北州", "海南州", "西宁州", "玉树州", "黄南州", "果洛州", "海西州", "海东州" };//青海省
string[] s34 ={ "大兴安岭地区", "黑河市", "齐齐哈尔市", "绥化市", "鹤岗市", "佳木斯市", "伊春市", "双鸭山市",
"哈尔滨市", "鸡西市", "漠河市", "大庆市", "七台河市", "牡丹江市", "绥芬河市"};//黑龙江省
//根据传递过来的值添加对应省份地区
switch (i)
{
case 1:
for (int j = 0; j < s1.Length; j++)
{
tscboxCity.Items.Add(s1[j]);
}
break;
case 2:
for (int j = 0; j < s2.Length; j++)
{
tscboxCity.Items.Add(s2[j]);
}
break;
case 3:
for (int j = 0; j < s3.Length; j++)
{
tscboxCity.Items.Add(s3[j]);
}
break;
case 4:
for (int j = 0; j < s4.Length; j++)
{
tscboxCity.Items.Add(s4[j]);
}
break;
case 5:
for (int j = 0; j < s5.Length; j++)
{
tscboxCity.Items.Add(s5[j]);
}
break;
case 6:
for (int j = 0; j < s6.Length; j++)
{
tscboxCity.Items.Add(s6[j]);
}
break;
case 7:
for (int j = 0; j < s7.Length; j++)
{
tscboxCity.Items.Add(s7[j]);
}
break;
case 8:
for (int j = 0; j < s8.Length; j++)
{
tscboxCity.Items.Add(s8[j]);
}
break;
case 9:
for (int j = 0; j < s9.Length; j++)
{
tscboxCity.Items.Add(s9[j]);
}
break;
case 10:
for (int j = 0; j < s10.Length; j++)
{
tscboxCity.Items.Add(s10[j]);
}
break;
case 11:
for (int j = 0; j < s11.Length; j++)
{
tscboxCity.Items.Add(s11[j]);
}
break;
case 12:
for (int j = 0; j < s12.Length; j++)
{
tscboxCity.Items.Add(s12[j]);
}
break;
case 13:
for (int j = 0; j < s13.Length; j++)
{
tscboxCity.Items.Add(s13[j]);
}
break;
case 14:
for (int j = 0; j < s14.Length; j++)
{
tscboxCity.Items.Add(s14[j]);
}
break;
case 15:
for (int j = 0; j < s15.Length; j++)
{
tscboxCity.Items.Add(s15[j]);
}
break;
case 16:
for (int j = 0; j < s16.Length; j++)
{
tscboxCity.Items.Add(s16[j]);
}
break;
case 17:
for (int j = 0; j < s17.Length; j++)
{
tscboxCity.Items.Add(s17[j]);
}
break;
case 18:
for (int j = 0; j < s18.Length; j++)
{
tscboxCity.Items.Add(s18[j]);
}
break;
case 19:
for (int j = 0; j < s19.Length; j++)
{
tscboxCity.Items.Add(s19[j]);
}
break;
case 20:
for (int j = 0; j < s20.Length; j++)
{
tscboxCity.Items.Add(s20[j]);
}
break;
case 21:
for (int j = 0; j < s21.Length; j++)
{
tscboxCity.Items.Add(s21[j]);
}
break;
case 22:
for (int j = 0; j < s22.Length; j++)
{
tscboxCity.Items.Add(s22[j]);
}
break;
case 23:
for (int j = 0; j < s23.Length; j++)
{
tscboxCity.Items.Add(s23[j]);
}
break;
case 24:
for (int j = 0; j < s24.Length; j++)
{
tscboxCity.Items.Add(s24[j]);
}
break;
case 25:
for (int j = 0; j < s25.Length; j++)
{
tscboxCity.Items.Add(s25[j]);
}
break;
case 26:
for (int j = 0; j < s26.Length; j++)
{
tscboxCity.Items.Add(s26[j]);
}
break;
case 27:
for (int j = 0; j < s27.Length; j++)
{
tscboxCity.Items.Add(s27[j]);
}
break;
case 28:
for (int j = 0; j < s28.Length; j++)
{
tscboxCity.Items.Add(s28[j]);
}
break;
case 29:
for (int j = 0; j < s29.Length; j++)
{
tscboxCity.Items.Add(s29[j]);
}
break;
case 30:
for (int j = 0; j < s30.Length; j++)
{
tscboxCity.Items.Add(s30[j]);
}
break;
case 31:
for (int j = 0; j < s31.Length; j++)
{
tscboxCity.Items.Add(s31[j]);
}
break;
case 32:
for (int j = 0; j < s32.Length; j++)
{
tscboxCity.Items.Add(s32[j]);
}
break;
case 33:
for (int j = 0; j < s33.Length; j++)
{
tscboxCity.Items.Add(s33[j]);
}
break;
case 34:
for (int j = 0; j < s34.Length; j++)
{
tscboxCity.Items.Add(s34[j]);
}
break;
}
tscboxCity.SelectedIndex = 0;
}
数据库查询效率执行速度太慢，这种方法代码是多，但效率高！
7. 淘宝的这个js省市县区联动菜单是怎么做的
写个程序就可以了啊。
8. 求全国最新省市县的三级联动数据库。
http://www.zhujiangroad.com/program/SQL/73943.html 这个应该能帮助到你！
最新文章
热门文章
推荐阅读