spinner 从数据库读取数据并兑现二级联动

spinner 从数据库读取数据并实现二级联动。
这里主要实现了。省份和城市的二级关联。选择省份。二级对应的就是省份所有的城市

下面看代码；
        1.activity
        @Override
        protected void onCreate(Bundle savedInstanceState) {
                // TODO Auto-generated method stub
                super.onCreate(savedInstanceState);
                setContentView(R.layout.test_layout);
                this.mContext = this;
                Map<Integer,List> data = ProvinceDB.getProvince();//得到数据库数据
                provinceList = data.get(1);
                provinceData = data.get(0);

                ArrayAdapter provinceAdapter = new ArrayAdapter(mContext,android.R.layout.simple_spinner_item,provinceList);
                provinceAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); // 样式

                spProvince.setAdapter(provinceAdapter);
                spProvince.setOnItemSelectedListener(itemSelectedListener);

        }

        // 选择省份联动对应城市
        private OnItemSelectedListener itemSelectedListener = new OnItemSelectedListener() {
                @Override
                public void onItemSelected(AdapterView<?> parent, View view,
                                int position, long id) {
                        Spinner spProvince = (Spinner) parent;
                        String selProvince = (String) spProvince.getItemAtPosition(position);
                        ArrayAdapter cityAdapter = null;
                        Map<String,Integer> data = (Map)provinceData.get(position);//根据所选择的得到对应的省份id 然后得到城市
                        int pid = data.get(selProvince);//得到省份的id
                        List cityList = ProvinceDB.getCityByPid(pid);
                        cityAdapter = new ArrayAdapter(mContext,android.R.layout.simple_spinner_item,cityList);
                        cityAdapter
                                        .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
                        spCity.setAdapter(cityAdapter);
                        spCity.setOnItemSelectedListener(citySelectedListener);

                }

                @Override
                public void onNothingSelected(AdapterView<?> parent) {
                        // TODO Auto-generated method stub
                }
        };

        String selectedCity = null;
        private OnItemSelectedListener citySelectedListener = new OnItemSelectedListener() {
                @Override
                public void onItemSelected(AdapterView<?> parent, View view,
                                int position, long id) {
                        Spinner spCity = (Spinner) parent;
                        selectedCity = (String) spCity.getItemAtPosition(position);
                }

                @Override
                public void onNothingSelected(AdapterView<?> parent) {
                        // TODO Auto-generated method stub
                }
        };

        2.DB类查询数据

        public class ProvinceDB {
        public static Map<Integer,List> getProvince(){
                String sql = "select N_PROVID ,S_PROVNAME from dict_province ";
                SQLiteDatabase db = null;
                Cursor c = null;
                 Map<Integer,List> provinceData = new HashMap<Integer,List>();
                List provinceList = null;
                try{
                        db = DatabaseHelper.getDatabase();
                        c = db.rawQuery(sql, null);
                        List provinceList1 = new ArrayList();
                        List provinceList2 = new ArrayList();
                        while(c.moveToNext()){
                                Map provinceMap = new HashMap();
                                provinceMap.put(c.getString(1), c.getInt(0));
                                provinceList1.add(provinceMap);
                                provinceList2.add(c.getString(1));
                        }
                        provinceData.put(0, provinceList1);
                        provinceData.put(1, provinceList2);
                }catch(Exception e){
                        e.printStackTrace();
                }finally{
                        if(c!=null){
                                c.close();
                        }
                        if(db!=null){
                                db.close();
                        }
                }
                return provinceData;
        }

        public static List<String> getCityByPid(int id){
                String sql = "select S_CITYNAME from dict_city where N_PROVID= "+id;
                SQLiteDatabase db = null;
                Cursor c = null;
                List<String> cityList = null;
                try{
                        db = DatabaseHelper.getDatabase();
                        c = db.rawQuery(sql, null);
                        cityList = new ArrayList<String>();
                        while(c.moveToNext()){
                                cityList.add(c.getString(0));
                        }
                }catch(Exception ex){
                        ex.printStackTrace();
                }finally{
                        if(c!=null){
                                c.close();
                        }
                        if(db!=null){
                                db.close();
                        }
                }
                return cityList;

        }
}

3.test_layout.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
        android:layout_width="fill_parent" android:layout_height="fill_parent"
        android:orientation="vertical">

        <LinearLayout android:layout_width="fill_parent"
                android:layout_height="wrap_content">
                <Spinner android:id="@+id/sp_bslProvice" android:layout_width="wrap_content"
                        android:layout_height="wrap_content" android:layout_weight="1" />
                <Spinner android:id="@+id/sp_bslCity" android:layout_width="wrap_content"
                        android:layout_height="wrap_content" android:layout_weight="1" />
        </LinearLayout>

1 楼 chen8156603 2012-04-08

大哥，你数据库在哪里呀？

2 楼 hualikejava 2012-04-09

chen8156603 写道

大哥，你数据库在哪里呀？



drop table if exists [dict_city];
CREATE TABLE [dict_city] ([N_CITYID] int(10) DEFAULT ('0'), [S_CITYNAME] varchar(30), [N_PROVID] int(10), [S_STATE] varchar(1) DEFAULT (NULL));
insert into [dict_city] values(1000, '东城区', 10, '1');
insert into [dict_city] values(1001, '西城区', 10, '1');
insert into [dict_city] values(1002, '崇文区', 10, '1');
insert into [dict_city] values(1003, '宣武区', 10, '1');
insert into [dict_city] values(1004, '朝阳区 ', 10, '1');
insert into [dict_city] values(1005, '丰台区', 10, '1');
insert into [dict_city] values(1006, '石景山区', 10, '1');
insert into [dict_city] values(1007, '海淀区', 10, '1');
insert into [dict_city] values(1008, '门头沟区', 10, '1');
insert into [dict_city] values(1009, '房山区', 10, '1');
insert into [dict_city] values(1010, '通州区', 10, '1');
insert into [dict_city] values(1011, '顺义区 ', 10, '1');
insert into [dict_city] values(1012, '昌平区', 10, '1');
insert into [dict_city] values(1013, '大兴区', 10, '1');
insert into [dict_city] values(1014, '怀柔区', 10, '1');
insert into [dict_city] values(1015, '平谷区', 10, '1');
insert into [dict_city] values(1016, '密云县', 10, '1');
insert into [dict_city] values(1017, '延庆县', 10, '1');
insert into [dict_city] values(1018, '黄浦区 ', 11, '1');
insert into [dict_city] values(1019, '卢湾区', 11, '1');
insert into [dict_city] values(1020, '徐汇区', 11, '1');
insert into [dict_city] values(1021, '长宁区', 11, '1');
insert into [dict_city] values(1022, '静安区', 11, '1');
insert into [dict_city] values(1023, '普陀区', 11, '1');
insert into [dict_city] values(1024, '闸北区', 11, '1');
insert into [dict_city] values(1025, '虹口区 ', 11, '1');
insert into [dict_city] values(1026, '杨浦区', 11, '1');
insert into [dict_city] values(1027, '闵行区', 11, '1');
insert into [dict_city] values(1028, '宝山区', 11, '1');
insert into [dict_city] values(1029, '嘉定区', 11, '1');
insert into [dict_city] values(1030, '浦东新区', 11, '1');
insert into [dict_city] values(1031, '金山区', 11, '1');
insert into [dict_city] values(1032, '松江区 ', 11, '1');
insert into [dict_city] values(1033, '青浦区', 11, '1');
insert into [dict_city] values(1034, '南汇区', 11, '1');
insert into [dict_city] values(1035, '奉贤区', 11, '1');
insert into [dict_city] values(1036, '崇明县', 11, '1');
insert into [dict_city] values(1037, '和平区', 12, '1');
insert into [dict_city] values(1036, '崇明县', 11, '1');
insert into [dict_city] values(1037, '和平区', 12, '1');
insert into [dict_city] values(1036, '崇明县', 11, '1');
insert into [dict_city] values(1037, '和平区', 12, '1');
insert into [dict_city] values(1038, '河东区', 12, '1');
insert into [dict_city] values(1039, '河西区 ', 12, '1');
insert into [dict_city] values(1040, '南开区', 12, '1');
insert into [dict_city] values(1041, '河北区', 12, '1');
insert into [dict_city] values(1042, '红桥区', 12, '1');
insert into [dict_city] values(1043, '塘沽区', 12, '1');
insert into [dict_city] values(1044, '汉沽区', 12, '1');
insert into [dict_city] values(1045, '大港区', 12, '1');
insert into [dict_city] values(1046, '东丽区 ', 12, '1');
insert into [dict_city] values(1047, '西青区', 12, '1');
insert into [dict_city] values(1048, '津南区', 12, '1');
insert into [dict_city] values(1049, '北辰区', 12, '1');
insert into [dict_city] values(1050, '武清区', 12, '1');
insert into [dict_city] values(1051, '宝坻区', 12, '1');
insert into [dict_city] values(1052, '宁河县', 12, '1');
insert into [dict_city] values(1053, '静海县 ', 12, '1');
insert into [dict_city] values(1054, '蓟县', 12, '1');
insert into [dict_city] values(1055, '万州区', 13, '1');
insert into [dict_city] values(1056, '涪陵区', 13, '1');
insert into [dict_city] values(1057, '渝中区', 13, '1');
insert into [dict_city] values(1058, '大渡口区', 13, '1');
insert into [dict_city] values(1059, '江北区', 13, '1');
insert into [dict_city] values(1060, '沙坪坝区 ', 13, '1');
insert into [dict_city] values(1061, '九龙坡区', 13, '1');
insert into [dict_city] values(1062, '南岸区', 13, '1');
insert into [dict_city] values(1063, '北碚区', 13, '1');
insert into [dict_city] values(1064, '万盛区', 13, '1');
insert into [dict_city] values(1065, '双桥区', 13, '1');
insert into [dict_city] values(1066, '渝北区', 13, '1');
insert into [dict_city] values(1067, '巴南区 ', 13, '1');
insert into [dict_city] values(1068, '黔江区', 13, '1');
insert into [dict_city] values(1069, '长寿区', 13, '1');
insert into [dict_city] values(1070, '綦江县', 13, '1');
insert into [dict_city] values(1071, '潼南县', 13, '1');
insert into [dict_city] values(1072, '铜梁县', 13, '1');
insert into [dict_city] values(1073, '大足县', 13, '1');
insert into [dict_city] values(1074, '荣昌县 ', 13, '1');
insert into [dict_city] values(1075, '璧山县', 13, '1');
insert into [dict_city] values(1076, '梁平县', 13, '1');
insert into [dict_city] values(1077, '城口县', 13, '1');
insert into [dict_city] values(1078, '丰都县', 13, '1');
insert into [dict_city] values(1079, '垫江县', 13, '1');
insert into [dict_city] values(1080, '武隆县', 13, '1');
insert into [dict_city] values(1081, '忠县 ', 13, '1');
insert into [dict_city] values(1082, '开县', 13, '1');
insert into [dict_city] values(1083, '云阳县', 13, '1');
insert into [dict_city] values(1084, '奉节县', 13, '1');
insert into [dict_city] values(1085, '巫山县', 13, '1');
insert into [dict_city] values(1086, '巫溪县', 13, '1');
insert into [dict_city] values(1087, '石柱土家族自治县', 13, '1');
insert into [dict_city] values(1088, ' 秀山土家族苗族自治县', 13, '1');
insert into [dict_city] values(1089, '酉阳土家族苗族自治县', 13, '1');
insert into [dict_city] values(1090, '彭水苗族土家族自治县 ', 13, '1');
insert into [dict_city] values(1091, '江津市', 13, '1');
insert into [dict_city] values(1092, '合川市', 13, '1');
insert into [dict_city] values(1093, '永川市', 13, '1');
insert into [dict_city] values(1094, '南川市', 13, '1');
insert into [dict_city] values(1095, '石家庄', 14, '1');
insert into [dict_city] values(1096, '唐山', 14, '1');
insert into [dict_city] values(1097, '秦皇岛 ', 14, '1');
insert into [dict_city] values(1098, '邯郸', 14, '1');
insert into [dict_city] values(1099, '邢台', 14, '1');
insert into [dict_city] values(1100, '保定', 14, '1');
insert into [dict_city] values(1101, '张家口', 14, '1');
insert into [dict_city] values(1102, '承德', 14, '1');
insert into [dict_city] values(1103, '沧州', 14, '1');
insert into [dict_city] values(1071, '潼南县', 13, '1');
insert into [dict_city] values(1072, '铜梁县', 13, '1');
insert into [dict_city] values(1073, '大足县', 13, '1');
insert into [dict_city] values(1074, '荣昌县 ', 13, '1');
insert into [dict_city] values(1075, '璧山县', 13, '1');
insert into [dict_city] values(1076, '梁平县', 13, '1');
insert into [dict_city] values(1077, '城口县', 13, '1');
insert into [dict_city] values(1078, '丰都县', 13, '1');
insert into [dict_city] values(1079, '垫江县', 13, '1');
insert into [dict_city] values(1080, '武隆县', 13, '1');
insert into [dict_city] values(1081, '忠县 ', 13, '1');
insert into [dict_city] values(1082, '开县', 13, '1');
insert into [dict_city] values(1083, '云阳县', 13, '1');
insert into [dict_city] values(1084, '奉节县', 13, '1');
insert into [dict_city] values(1085, '巫山县', 13, '1');
insert into [dict_city] values(1086, '巫溪县', 13, '1');
insert into [dict_city] values(1087, '石柱土家族自治县', 13, '1');
insert into [dict_city] values(1088, ' 秀山土家族苗族自治县', 13, '1');
insert into [dict_city] values(1089, '酉阳土家族苗族自治县', 13, '1');
insert into [dict_city] values(1090, '彭水苗族土家族自治县 ', 13, '1');
insert into [dict_city] values(1091, '江津市', 13, '1');
insert into [dict_city] values(1092, '合川市', 13, '1');
insert into [dict_city] values(1093, '永川市', 13, '1');
insert into [dict_city] values(1094, '南川市', 13, '1');
insert into [dict_city] values(1095, '石家庄', 14, '1');
insert into [dict_city] values(1096, '唐山', 14, '1');
insert into [dict_city] values(1097, '秦皇岛 ', 14, '1');
insert into [dict_city] values(1098, '邯郸', 14, '1');
insert into [dict_city] values(1099, '邢台', 14, '1');
insert into [dict_city] values(1100, '保定', 14, '1');
insert into [dict_city] values(1101, '张家口', 14, '1');
insert into [dict_city] values(1102, '承德', 14, '1');
insert into [dict_city] values(1103, '沧州', 14, '1');
insert into [dict_city] values(1104, '廊坊 ', 14, '1');
insert into [dict_city] values(1105, '衡水', 14, '1');
insert into [dict_city] values(1106, '太原', 15, '1');
insert into [dict_city] values(1107, '大同', 15, '1');
insert into [dict_city] values(1108, '阳泉', 15, '1');
insert into [dict_city] values(1109, '长治', 15, '1');
insert into [dict_city] values(1110, '晋城', 15, '1');
insert into [dict_city] values(1111, '朔州 ', 15, '1');
insert into [dict_city] values(1112, '晋中', 15, '1');
insert into [dict_city] values(1113, '运城', 15, '1');
insert into [dict_city] values(1114, '忻州', 15, '1');
insert into [dict_city] values(1115, '临汾', 15, '1');
insert into [dict_city] values(1116, '吕梁', 15, '1');
insert into [dict_city] values(1117, '呼和浩特', 16, '1');
insert into [dict_city] values(1118, '包头 ', 16, '1');
insert into [dict_city] values(1119, '乌海', 16, '1');
insert into [dict_city] values(1120, '赤峰', 16, '1');
insert into [dict_city] values(1121, '通辽', 16, '1');
insert into [dict_city] values(1122, '鄂尔多斯', 16, '1');
insert into [dict_city] values(1123, '呼伦贝尔', 16, '1');
insert into [dict_city] values(1124, '乌兰察布', 16, '1');
insert into [dict_city] values(1125, '锡林郭勒盟', 16, '1');
insert into [dict_city] values(1126, '巴彦淖尔', 16, '1');
insert into [dict_city] values(1127, '阿拉善盟', 16, '1');
insert into [dict_city] values(1128, '兴安盟 ', 16, '1');
insert into [dict_city] values(1129, '沈阳', 17, '1');
insert into [dict_city] values(1130, '大连', 17, '1');
insert into [dict_city] values(1131, '鞍山', 17, '1');
insert into [dict_city] values(1132, '抚顺', 17, '1');
insert into [dict_city] values(1133, '本溪', 17, '1');
insert into [dict_city] values(1134, '丹东', 17, '1');
insert into [dict_city] values(1135, '锦州 ', 17, '1');
insert into [dict_city] values(1136, '葫芦岛', 17, '1');
insert into [dict_city] values(1137, '营口', 17, '1');
insert into [dict_city] values(1138, '盘锦', 17, '1');
insert into [dict_city] values(1139, '阜新', 17, '1');
insert into [dict_city] values(1140, '辽阳', 17, '1');
insert into [dict_city] values(1141, '铁岭', 17, '1');
insert into [dict_city] values(1142, '朝阳 ', 17, '1');
insert into [dict_city] values(1143, '长春', 18, '1');
insert into [dict_city] values(1144, '吉林', 18, '1');
insert into [dict_city] values(1145, '四平', 18, '1');
insert into [dict_city] values(1146, '辽源', 18, '1');
insert into [dict_city] values(1147, '通化', 18, '1');
insert into [dict_city] values(1148, '白山', 18, '1');
insert into [dict_city] values(1149, '* ', 18, '1');
insert into [dict_city] values(1150, '白城', 18, '1');
insert into [dict_city] values(1151, '延边朝鲜', 18, '1');
insert into [dict_city] values(1152, '哈尔滨', 19, '1');
insert into [dict_city] values(1153, '齐齐哈尔', 19, '1');
insert into [dict_city] values(1154, '鹤岗', 19, '1');
insert into [dict_city] values(1155, '双鸭山', 19, '1');
insert into [dict_city] values(1156, '鸡西 ', 19, '1');
insert into [dict_city] values(1157, '大庆', 19, '1');
insert into [dict_city] values(1158, '伊春', 19, '1');
insert into [dict_city] values(1159, '牡丹江', 19, '1');
insert into [dict_city] values(1160, '佳木斯', 19, '1');
insert into [dict_city] values(1161, '七台河', 19, '1');
insert into [dict_city] values(1162, '黑河', 19, '1');
insert into [dict_city] values(1163, '绥化 ', 19, '1');
insert into [dict_city] values(1164, '大兴安岭', 19, '1');
insert into [dict_city] values(1165, '南京', 20, '1');
insert into [dict_city] values(1166, '无锡', 20, '1');
insert into [dict_city] values(1167, '徐州', 20, '1');
insert into [dict_city] values(1168, '常州', 20, '1');
insert into [dict_city] values(1169, '苏州', 20, '1');
insert into [dict_city] values(1170, '南通 ', 20, '1');
insert into [dict_city] values(1171, '连云港', 20, '1');
insert into [dict_city] values(1172, '淮安', 20, '1');
insert into [dict_city] values(1173, '盐城', 20, '1');
insert into [dict_city] values(1174, '扬州', 20, '1');
insert into [dict_city] values(1175, '镇江', 20, '1');
insert into [dict_city] values(1176, '泰州', 20, '1');
insert into [dict_city] values(1177, '宿迁 ', 20, '1');
insert into [dict_city] values(1178, '杭州', 21, '1');
insert into [dict_city] values(1179, '宁波', 21, '1');
insert into [dict_city] values(1180, '温州', 21, '1');
insert into [dict_city] values(1181, '嘉兴', 21, '1');
insert into [dict_city] values(1182, '湖州', 21, '1');
insert into [dict_city] values(1183, '绍兴', 21, '1');
insert into [dict_city] values(1184, '金华 ', 21, '1');
insert into [dict_city] values(1185, '衢州', 21, '1');
insert into [dict_city] values(1186, '舟山', 21, '1');
insert into [dict_city] values(1187, '台州', 21, '1');
insert into [dict_city] values(1188, '丽水', 21, '1');
insert into [dict_city] values(1189, '合肥', 22, '1');
insert into [dict_city] values(1190, '芜湖', 22, '1');
insert into [dict_city] values(1191, '蚌埠 ', 22, '1');
insert into [dict_city] values(1192, '淮南', 22, '1');
insert into [dict_city] values(1193, '马鞍山', 22, '1');
insert into [dict_city] values(1194, '淮北', 22, '1');
insert into [dict_city] values(1195, '铜陵', 22, '1');
insert into [dict_city] values(1196, '安庆', 22, '1');
insert into [dict_city] values(1197, '黄山', 22, '1');
insert into [dict_city] values(1198, '滁州 ', 22, '1');
insert into [dict_city] values(1199, '阜阳', 22, '1');
insert into [dict_city] values(1200, '宿州', 22, '1');
insert into [dict_city] values(1201, '巢湖', 22, '1');
insert into [dict_city] values(1202, '六安', 22, '1');
insert into [dict_city] values(1203, '亳州', 22, '1');
insert into [dict_city] values(1204, '池州', 22, '1');
insert into [dict_city] values(1205, '宣城 ', 22, '1');
insert into [dict_city] values(1206, '福州', 23, '1');
insert into [dict_city] values(1207, '厦门', 23, '1');
insert into [dict_city] values(1208, '莆田', 23, '1');
insert into [dict_city] values(1209, '三明', 23, '1');
insert into [dict_city] values(1210, '泉州', 23, '1');
insert into [dict_city] values(1211, '漳州', 23, '1');
insert into [dict_city] values(1212, '南平 ', 23, '1');
insert into [dict_city] values(1213, '龙岩', 23, '1');
insert into [dict_city] values(1214, '宁德', 23, '1');
insert into [dict_city] values(1215, '南昌', 24, '1');
insert into [dict_city] values(1216, '景德镇', 24, '1');
insert into [dict_city] values(1217, '萍乡', 24, '1');
insert into [dict_city] values(1218, '新余', 24, '1');
insert into [dict_city] values(1219, '九江 ', 24, '1');
insert into [dict_city] values(1220, '鹰潭', 24, '1');
insert into [dict_city] values(1221, '赣州', 24, '1');
insert into [dict_city] values(1222, '吉安', 24, '1');
insert into [dict_city] values(1223, '宜春', 24, '1');
insert into [dict_city] values(1224, '抚州', 24, '1');
insert into [dict_city] values(1225, '上饶', 24, '1');
insert into [dict_city] values(1226, '济南 ', 25, '1');
insert into [dict_city] values(1227, '青岛', 25, '1');
insert into [dict_city] values(1228, '淄博', 25, '1');
insert into [dict_city] values(1229, '枣庄', 25, '1');
insert into [dict_city] values(1230, '东营', 25, '1');
insert into [dict_city] values(1231, '潍坊', 25, '1');
insert into [dict_city] values(1232, '烟台', 25, '1');
insert into [dict_city] values(1233, '威海 ', 25, '1');
insert into [dict_city] values(1234, '济宁', 25, '1');
insert into [dict_city] values(1235, '泰安', 25, '1');
insert into [dict_city] values(1236, '日照', 25, '1');
insert into [dict_city] values(1237, '莱芜', 25, '1');
insert into [dict_city] values(1238, '德州', 25, '1');
insert into [dict_city] values(1239, '临沂', 25, '1');
insert into [dict_city] values(1240, '聊城 ', 25, '1');
insert into [dict_city] values(1241, '滨州', 25, '1');
insert into [dict_city] values(1242, '菏泽', 25, '1');
insert into [dict_city] values(1243, '郑州', 26, '1');
insert into [dict_city] values(1244, '开封', 26, '1');
insert into [dict_city] values(1245, '洛阳', 26, '1');
insert into [dict_city] values(1246, '平顶山', 26, '1');
insert into [dict_city] values(1247, '焦作 ', 26, '1');
insert into [dict_city] values(1248, '鹤壁', 26, '1');
insert into [dict_city] values(1249, '新乡', 26, '1');
insert into [dict_city] values(1250, '安阳', 26, '1');
insert into [dict_city] values(1251, '濮阳', 26, '1');
insert into [dict_city] values(1252, '许昌', 26, '1');
insert into [dict_city] values(1253, '漯河', 26, '1');
insert into [dict_city] values(1254, '三门峡 ', 26, '1');
insert into [dict_city] values(1255, '南阳', 26, '1');
insert into [dict_city] values(1256, '商丘', 26, '1');
insert into [dict_city] values(1257, '信阳', 26, '1');
insert into [dict_city] values(1258, '周口', 26, '1');
insert into [dict_city] values(1259, '驻马店', 26, '1');
insert into [dict_city] values(1260, '济源', 26, '1');
insert into [dict_city] values(1261, '武汉 ', 27, '1');
insert into [dict_city] values(1262, '黄石', 27, '1');
insert into [dict_city] values(1263, '襄樊', 27, '1');
insert into [dict_city] values(1264, '十堰', 27, '1');
insert into [dict_city] values(1265, '荆州', 27, '1');
insert into [dict_city] values(1266, '宜昌', 27, '1');
insert into [dict_city] values(1267, '荆门', 27, '1');
insert into [dict_city] values(1268, '鄂州 ', 27, '1');
insert into [dict_city] values(1269, '孝感', 27, '1');
insert into [dict_city] values(1270, '黄冈', 27, '1');
insert into [dict_city] values(1271, '咸宁', 27, '1');
insert into [dict_city] values(1272, '随州', 27, '1');
insert into [dict_city] values(1273, '仙桃', 27, '1');
insert into [dict_city] values(1274, '天门', 27, '1');
insert into [dict_city] values(1275, '潜江 ', 27, '1');
insert into [dict_city] values(1276, '神农架', 27, '1');
insert into [dict_city] values(1277, '恩施土家', 27, '1');
insert into [dict_city] values(1278, '长沙', 28, '1');
insert into [dict_city] values(1279, '株洲', 28, '1');
insert into [dict_city] values(1280, '湘潭', 28, '1');
insert into [dict_city] values(1281, '衡阳', 28, '1');
insert into [dict_city] values(1282, '邵阳 ', 28, '1');
insert into [dict_city] values(1283, '岳阳', 28, '1');
insert into [dict_city] values(1284, '常德', 28, '1');
insert into [dict_city] values(1285, '张家界', 28, '1');
insert into [dict_city] values(1286, '益阳', 28, '1');
insert into [dict_city] values(1287, '郴州', 28, '1');
insert into [dict_city] values(1288, '怀化', 28, '1');
insert into [dict_city] values(1289, '娄底 ', 28, '1');
insert into [dict_city] values(1290, '湘西土家', 28, '1');
insert into [dict_city] values(1291, '永州', 28, '1');
insert into [dict_city] values(1292, '广州', 29, '1');
insert into [dict_city] values(1293, '深圳', 29, '1');
insert into [dict_city] values(1294, '珠海', 29, '1');
insert into [dict_city] values(1295, '汕头', 29, '1');
insert into [dict_city] values(1296, '韶关 ', 29, '1');
insert into [dict_city] values(1297, '佛山', 29, '1');
insert into [dict_city] values(1298, '江门', 29, '1');
insert into [dict_city] values(1299, '湛江', 29, '1');
insert into [dict_city] values(1300, '茂名', 29, '1');
insert into [dict_city] values(1301, '肇庆', 29, '1');
insert into [dict_city] values(1302, '惠州', 29, '1');
insert into [dict_city] values(1303, '梅州 ', 29, '1');
insert into [dict_city] values(1304, '汕尾', 29, '1');
insert into [dict_city] values(1305, '河源', 29, '1');
insert into [dict_city] values(1306, '阳江', 29, '1');
insert into [dict_city] values(1307, '清远', 29, '1');
insert into [dict_city] values(1308, '东莞', 29, '1');
insert into [dict_city] values(1309, '中山', 29, '1');
insert into [dict_city] values(1310, '潮州 ', 29, '1');
insert into [dict_city] values(1311, '揭阳', 29, '1');
insert into [dict_city] values(1312, '云浮', 29, '1');
insert into [dict_city] values(1313, '南宁', 30, '1');
insert into [dict_city] values(1314, '柳州', 30, '1');
insert into [dict_city] values(1315, '桂林', 30, '1');
insert into [dict_city] values(1316, '梧州', 30, '1');
insert into [dict_city] values(1317, '北海 ', 30, '1');
insert into [dict_city] values(1210, '泉州', 23, '1');
insert into [dict_city] values(1211, '漳州', 23, '1');
insert into [dict_city] values(1212, '南平 ', 23, '1');
insert into [dict_city] values(1213, '龙岩', 23, '1');
insert into [dict_city] values(1214, '宁德', 23, '1');
insert into [dict_city] values(1215, '南昌', 24, '1');
insert into [dict_city] values(1216, '景德镇', 24, '1');
insert into [dict_city] values(1217, '萍乡', 24, '1');
insert into [dict_city] values(1218, '新余', 24, '1');
insert into [dict_city] values(1219, '九江 ', 24, '1');
insert into [dict_city] values(1220, '鹰潭', 24, '1');
insert into [dict_city] values(1221, '赣州', 24, '1');
insert into [dict_city] values(1222, '吉安', 24, '1');
insert into [dict_city] values(1223, '宜春', 24, '1');
insert into [dict_city] values(1224, '抚州', 24, '1');
insert into [dict_city] values(1225, '上饶', 24, '1');
insert into [dict_city] values(1226, '济南 ', 25, '1');
insert into [dict_city] values(1227, '青岛', 25, '1');
insert into [dict_city] values(1228, '淄博', 25, '1');
insert into [dict_city] values(1229, '枣庄', 25, '1');
insert into [dict_city] values(1230, '东营', 25, '1');
insert into [dict_city] values(1231, '潍坊', 25, '1');
insert into [dict_city] values(1232, '烟台', 25, '1');
insert into [dict_city] values(1233, '威海 ', 25, '1');
insert into [dict_city] values(1234, '济宁', 25, '1');
insert into [dict_city] values(1235, '泰安', 25, '1');
insert into [dict_city] values(1236, '日照', 25, '1');
insert into [dict_city] values(1237, '莱芜', 25, '1');
insert into [dict_city] values(1238, '德州', 25, '1');
insert into [dict_city] values(1239, '临沂', 25, '1');
insert into [dict_city] values(1240, '聊城 ', 25, '1');
insert into [dict_city] values(1241, '滨州', 25, '1');
insert into [dict_city] values(1242, '菏泽', 25, '1');
insert into [dict_city] values(1243, '郑州', 26, '1');
insert into [dict_city] values(1244, '开封', 26, '1');
insert into [dict_city] values(1245, '洛阳', 26, '1');
insert into [dict_city] values(1246, '平顶山', 26, '1');
insert into [dict_city] values(1247, '焦作 ', 26, '1');
insert into [dict_city] values(1248, '鹤壁', 26, '1');
insert into [dict_city] values(1249, '新乡', 26, '1');
insert into [dict_city] values(1250, '安阳', 26, '1');
insert into [dict_city] values(1251, '濮阳', 26, '1');
insert into [dict_city] values(1252, '许昌', 26, '1');
insert into [dict_city] values(1253, '漯河', 26, '1');
insert into [dict_city] values(1254, '三门峡 ', 26, '1');
insert into [dict_city] values(1255, '南阳', 26, '1');
insert into [dict_city] values(1256, '商丘', 26, '1');
insert into [dict_city] values(1257, '信阳', 26, '1');
insert into [dict_city] values(1258, '周口', 26, '1');
insert into [dict_city] values(1259, '驻马店', 26, '1');
insert into [dict_city] values(1260, '济源', 26, '1');
insert into [dict_city] values(1261, '武汉 ', 27, '1');
insert into [dict_city] values(1262, '黄石', 27, '1');
insert into [dict_city] values(1263, '襄樊', 27, '1');
insert into [dict_city] values(1264, '十堰', 27, '1');
insert into [dict_city] values(1265, '荆州', 27, '1');
insert into [dict_city] values(1266, '宜昌', 27, '1');
insert into [dict_city] values(1267, '荆门', 27, '1');
insert into [dict_city] values(1268, '鄂州 ', 27, '1');
insert into [dict_city] values(1269, '孝感', 27, '1');
insert into [dict_city] values(1270, '黄冈', 27, '1');
insert into [dict_city] values(1271, '咸宁', 27, '1');
insert into [dict_city] values(1272, '随州', 27, '1');
insert into [dict_city] values(1273, '仙桃', 27, '1');
insert into [dict_city] values(1274, '天门', 27, '1');
insert into [dict_city] values(1275, '潜江 ', 27, '1');
insert into [dict_city] values(1276, '神农架', 27, '1');
insert into [dict_city] values(1277, '恩施土家', 27, '1');
insert into [dict_city] values(1278, '长沙', 28, '1');
insert into [dict_city] values(1279, '株洲', 28, '1');
insert into [dict_city] values(1280, '湘潭', 28, '1');
insert into [dict_city] values(1281, '衡阳', 28, '1');
insert into [dict_city] values(1282, '邵阳 ', 28, '1');
insert into [dict_city] values(1283, '岳阳', 28, '1');
insert into [dict_city] values(1284, '常德', 28, '1');
insert into [dict_city] values(1285, '张家界', 28, '1');
insert into [dict_city] values(1286, '益阳', 28, '1');
insert into [dict_city] values(1287, '郴州', 28, '1');
insert into [dict_city] values(1288, '怀化', 28, '1');
insert into [dict_city] values(1289, '娄底 ', 28, '1');
insert into [dict_city] values(1290, '湘西土家', 28, '1');
insert into [dict_city] values(1291, '永州', 28, '1');
insert into [dict_city] values(1292, '广州', 29, '1');
insert into [dict_city] values(1293, '深圳', 29, '1');
insert into [dict_city] values(1294, '珠海', 29, '1');
insert into [dict_city] values(1295, '汕头', 29, '1');
insert into [dict_city] values(1296, '韶关 ', 29, '1');
insert into [dict_city] values(1297, '佛山', 29, '1');
insert into [dict_city] values(1298, '江门', 29, '1');
insert into [dict_city] values(1299, '湛江', 29, '1');
insert into [dict_city] values(1300, '茂名', 29, '1');
insert into [dict_city] values(1301, '肇庆', 29, '1');
insert into [dict_city] values(1302, '惠州', 29, '1');
insert into [dict_city] values(1303, '梅州 ', 29, '1');
insert into [dict_city] values(1304, '汕尾', 29, '1');
insert into [dict_city] values(1305, '河源', 29, '1');
insert into [dict_city] values(1306, '阳江', 29, '1');
insert into [dict_city] values(1307, '清远', 29, '1');
insert into [dict_city] values(1308, '东莞', 29, '1');
insert into [dict_city] values(1309, '中山', 29, '1');
insert into [dict_city] values(1310, '潮州 ', 29, '1');
insert into [dict_city] values(1311, '揭阳', 29, '1');
insert into [dict_city] values(1312, '云浮', 29, '1');
insert into [dict_city] values(1313, '南宁', 30, '1');
insert into [dict_city] values(1314, '柳州', 30, '1');
insert into [dict_city] values(1315, '桂林', 30, '1');
insert into [dict_city] values(1316, '梧州', 30, '1');
insert into [dict_city] values(1317, '北海 ', 30, '1');
insert into [dict_city] values(1223, '宜春', 24, '1');
insert into [dict_city] values(1224, '抚州', 24, '1');
insert into [dict_city] values(1225, '上饶', 24, '1');
insert into [dict_city] values(1226, '济南 ', 25, '1');
insert into [dict_city] values(1227, '青岛', 25, '1');
insert into [dict_city] values(1228, '淄博', 25, '1');
insert into [dict_city] values(1229, '枣庄', 25, '1');
insert into [dict_city] values(1230, '东营', 25, '1');
insert into [dict_city] values(1231, '潍坊', 25, '1');
insert into [dict_city] values(1232, '烟台', 25, '1');
insert into [dict_city] values(1233, '威海 ', 25, '1');
insert into [dict_city] values(1234, '济宁', 25, '1');
insert into [dict_city] values(1235, '泰安', 25, '1');
insert into [dict_city] values(1236, '日照', 25, '1');
insert into [dict_city] values(1237, '莱芜', 25, '1');
insert into [dict_city] values(1238, '德州', 25, '1');
insert into [dict_city] values(1239, '临沂', 25, '1');
insert into [dict_city] values(1240, '聊城 ', 25, '1');
insert into [dict_city] values(1241, '滨州', 25, '1');
insert into [dict_city] values(1242, '菏泽', 25, '1');
insert into [dict_city] values(1243, '郑州', 26, '1');
insert into [dict_city] values(1244, '开封', 26, '1');
insert into [dict_city] values(1245, '洛阳', 26, '1');
insert into [dict_city] values(1246, '平顶山', 26, '1');
insert into [dict_city] values(1247, '焦作 ', 26, '1');
insert into [dict_city] values(1248, '鹤壁', 26, '1');
insert into [dict_city] values(1249, '新乡', 26, '1');
insert into [dict_city] values(1250, '安阳', 26, '1');
insert into [dict_city] values(1251, '濮阳', 26, '1');
insert into [dict_city] values(1252, '许昌', 26, '1');
insert into [dict_city] values(1253, '漯河', 26, '1');
insert into [dict_city] values(1254, '三门峡 ', 26, '1');
insert into [dict_city] values(1255, '南阳', 26, '1');
insert into [dict_city] values(1256, '商丘', 26, '1');
insert into [dict_city] values(1257, '信阳', 26, '1');
insert into [dict_city] values(1258, '周口', 26, '1');
insert into [dict_city] values(1259, '驻马店', 26, '1');
insert into [dict_city] values(1260, '济源', 26, '1');
insert into [dict_city] values(1261, '武汉 ', 27, '1');
insert into [dict_city] values(1262, '黄石', 27, '1');
insert into [dict_city] values(1263, '襄樊', 27, '1');
insert into [dict_city] values(1264, '十堰', 27, '1');
insert into [dict_city] values(1265, '荆州', 27, '1');
insert into [dict_city] values(1266, '宜昌', 27, '1');
insert into [dict_city] values(1267, '荆门', 27, '1');
insert into [dict_city] values(1268, '鄂州 ', 27, '1');
insert into [dict_city] values(1269, '孝感', 27, '1');
insert into [dict_city] values(1270, '黄冈', 27, '1');
insert into [dict_city] values(1271, '咸宁', 27, '1');
insert into [dict_city] values(1272, '随州', 27, '1');
insert into [dict_city] values(1273, '仙桃', 27, '1');
insert into [dict_city] values(1274, '天门', 27, '1');
insert into [dict_city] values(1275, '潜江 ', 27, '1');
insert into [dict_city] values(1276, '神农架', 27, '1');
insert into [dict_city] values(1277, '恩施土家', 27, '1');
insert into [dict_city] values(1278, '长沙', 28, '1');
insert into [dict_city] values(1279, '株洲', 28, '1');
insert into [dict_city] values(1280, '湘潭', 28, '1');
insert into [dict_city] values(1281, '衡阳', 28, '1');
insert into [dict_city] values(1282, '邵阳 ', 28, '1');
insert into [dict_city] values(1283, '岳阳', 28, '1');
insert into [dict_city] values(1284, '常德', 28, '1');
insert into [dict_city] values(1285, '张家界', 28, '1');
insert into [dict_city] values(1286, '益阳', 28, '1');
insert into [dict_city] values(1287, '郴州', 28, '1');
insert into [dict_city] values(1288, '怀化', 28, '1');
insert into [dict_city] values(1289, '娄底 ', 28, '1');
insert into [dict_city] values(1290, '湘西土家', 28, '1');
insert into [dict_city] values(1291, '永州', 28, '1');
insert into [dict_city] values(1292, '广州', 29, '1');
insert into [dict_city] values(1293, '深圳', 29, '1');
insert into [dict_city] values(1294, '珠海', 29, '1');
insert into [dict_city] values(1295, '汕头', 29, '1');
insert into [dict_city] values(1296, '韶关 ', 29, '1');
insert into [dict_city] values(1297, '佛山', 29, '1');
insert into [dict_city] values(1298, '江门', 29, '1');
insert into [dict_city] values(1299, '湛江', 29, '1');
insert into [dict_city] values(1300, '茂名', 29, '1');
insert into [dict_city] values(1301, '肇庆', 29, '1');
insert into [dict_city] values(1302, '惠州', 29, '1');
insert into [dict_city] values(1303, '梅州 ', 29, '1');
insert into [dict_city] values(1304, '汕尾', 29, '1');
insert into [dict_city] values(1305, '河源', 29, '1');
insert into [dict_city] values(1306, '阳江', 29, '1');
insert into [dict_city] values(1307, '清远', 29, '1');
insert into [dict_city] values(1308, '东莞', 29, '1');
insert into [dict_city] values(1309, '中山', 29, '1');
insert into [dict_city] values(1310, '潮州 ', 29, '1');
insert into [dict_city] values(1311, '揭阳', 29, '1');
insert into [dict_city] values(1312, '云浮', 29, '1');
insert into [dict_city] values(1313, '南宁', 30, '1');
insert into [dict_city] values(1314, '柳州', 30, '1');
insert into [dict_city] values(1315, '桂林', 30, '1');
insert into [dict_city] values(1316, '梧州', 30, '1');
insert into [dict_city] values(1317, '北海 ', 30, '1');
insert into [dict_city] values(1318, '防城港', 30, '1');
insert into [dict_city] values(1319, '钦州', 30, '1');
insert into [dict_city] values(1320, '贵港', 30, '1');
insert into [dict_city] values(1321, '玉林', 30, '1');
insert into [dict_city] values(1322, '百色', 30, '1');
insert into [dict_city] values(1323, '贺州', 30, '1');
insert into [dict_city] values(1324, '河池 ', 30, '1');
insert into [dict_city] values(1325, '来宾', 30, '1');
insert into [dict_city] values(1326, '崇左', 30, '1');
insert into [dict_city] values(1327, '海口', 31, '1');
insert into [dict_city] values(1328, '三亚', 31, '1');
insert into [dict_city] values(1329, '五指山', 31, '1');
insert into [dict_city] values(1330, '琼海', 31, '1');
insert into [dict_city] values(1331, '儋州 ', 31, '1');
insert into [dict_city] values(1332, '文昌', 31, '1');
insert into [dict_city] values(1333, '万宁', 31, '1');
insert into [dict_city] values(1334, '东方', 31, '1');
insert into [dict_city] values(1335, '澄迈', 31, '1');
insert into [dict_city] values(1336, '定安', 31, '1');
insert into [dict_city] values(1337, '屯昌', 31, '1');
insert into [dict_city] values(1338, '临高 ', 31, '1');
insert into [dict_city] values(1339, '白沙黎族', 31, '1');
insert into [dict_city] values(1340, '江黎族自', 31, '1');
insert into [dict_city] values(1341, '乐东黎族 ', 31, '1');
insert into [dict_city] values(1342, '陵水黎族', 31, '1');
insert into [dict_city] values(1343, '保亭黎族', 31, '1');
insert into [dict_city] values(1344, '琼中黎族 ', 31, '1');
insert into [dict_city] values(1345, '西沙群岛', 31, '1');
insert into [dict_city] values(1346, '南沙群岛', 31, '1');
insert into [dict_city] values(1347, '中沙群岛 ', 31, '1');
insert into [dict_city] values(1348, '成都', 32, '1');
insert into [dict_city] values(1349, '自贡', 32, '1');
insert into [dict_city] values(1350, '攀枝花', 32, '1');
insert into [dict_city] values(1351, '泸州', 32, '1');
insert into [dict_city] values(1352, '德阳', 32, '1');
insert into [dict_city] values(1353, '绵阳', 32, '1');
insert into [dict_city] values(1354, '广元 ', 32, '1');
insert into [dict_city] values(1355, '遂宁', 32, '1');
insert into [dict_city] values(1356, '内江', 32, '1');
insert into [dict_city] values(1357, '乐山', 32, '1');
insert into [dict_city] values(1358, '南充', 32, '1');
insert into [dict_city] values(1359, '宜宾', 32, '1');
insert into [dict_city] values(1360, '广安', 32, '1');
insert into [dict_city] values(1361, '达州 ', 32, '1');
insert into [dict_city] values(1362, '眉山', 32, '1');
insert into [dict_city] values(1363, '雅安', 32, '1');
insert into [dict_city] values(1364, '巴中', 32, '1');
insert into [dict_city] values(1365, '资阳', 32, '1');
insert into [dict_city] values(1366, '阿坝藏族', 32, '1');
insert into [dict_city] values(1367, '甘孜藏族', 32, '1');
insert into [dict_city] values(1368, '凉山彝族 ', 32, '1');
insert into [dict_city] values(1369, '贵阳', 33, '1');
insert into [dict_city] values(1370, '六盘水', 33, '1');
insert into [dict_city] values(1371, '遵义', 33, '1');
insert into [dict_city] values(1372, '安顺', 33, '1');
insert into [dict_city] values(1373, '铜仁', 33, '1');
insert into [dict_city] values(1374, '毕节', 33, '1');
insert into [dict_city] values(1375, '黔西南布 ', 33, '1');
insert into [dict_city] values(1376, '黔东南苗', 33, '1');
insert into [dict_city] values(1377, '黔南布依', 33, '1');
insert into [dict_city] values(1378, '昆明', 34, '1');
insert into [dict_city] values(1379, '曲靖', 34, '1');
insert into [dict_city] values(1380, '玉溪', 34, '1');
insert into [dict_city] values(1381, '保山', 34, '1');
insert into [dict_city] values(1382, '昭通 ', 34, '1');
insert into [dict_city] values(1383, '丽江', 34, '1');
insert into [dict_city] values(1384, '思茅', 34, '1');
insert into [dict_city] values(1385, '临沧', 34, '1');
insert into [dict_city] values(1386, '文山壮族', 34, '1');
insert into [dict_city] values(1387, '红河哈尼', 34, '1');
insert into [dict_city] values(1388, '西双版纳', 34, '1');
insert into [dict_city] values(1389, '楚雄彝族', 34, '1');
insert into [dict_city] values(1390, '大理白族', 34, '1');
insert into [dict_city] values(1391, '德宏傣族', 34, '1');
insert into [dict_city] values(1392, '怒江傈傈 ', 34, '1');
insert into [dict_city] values(1393, '迪庆藏族', 34, '1');
insert into [dict_city] values(1394, '拉萨', 35, '1');
insert into [dict_city] values(1395, '那曲', 35, '1');
insert into [dict_city] values(1396, '昌都', 35, '1');
insert into [dict_city] values(1397, '山南', 35, '1');
insert into [dict_city] values(1398, '日喀则', 35, '1');
insert into [dict_city] values(1399, '阿里 ', 35, '1');
insert into [dict_city] values(1400, '林芝', 35, '1');
insert into [dict_city] values(1401, '西安', 36, '1');
insert into [dict_city] values(1402, '铜川', 36, '1');
insert into [dict_city] values(1403, '宝鸡', 36, '1');
insert into [dict_city] values(1404, '咸阳', 36, '1');
insert into [dict_city] values(1405, '渭南', 36, '1');
insert into [dict_city] values(1406, '延安 ', 36, '1');
insert into [dict_city] values(1407, '汉中', 36, '1');
insert into [dict_city] values(1408, '榆林', 36, '1');
insert into [dict_city] values(1409, '安康', 36, '1');
insert into [dict_city] values(1410, '商洛', 36, '1');
insert into [dict_city] values(1411, '兰州', 37, '1');
insert into [dict_city] values(1412, '金昌', 37, '1');
insert into [dict_city] values(1413, '白银 ', 37, '1');
insert into [dict_city] values(1414, '天水', 37, '1');
insert into [dict_city] values(1415, '嘉峪关', 37, '1');
insert into [dict_city] values(1416, '武威', 37, '1');
insert into [dict_city] values(1417, '张掖', 37, '1');
insert into [dict_city] values(1418, '平凉', 37, '1');
insert into [dict_city] values(1419, '酒泉', 37, '1');
insert into [dict_city] values(1420, '庆阳 ', 37, '1');
insert into [dict_city] values(1421, '定西', 37, '1');
insert into [dict_city] values(1422, '陇南', 37, '1');
insert into [dict_city] values(1423, '临夏回族', 37, '1');
insert into [dict_city] values(1424, '甘南藏族', 37, '1');
insert into [dict_city] values(1425, '西宁', 38, '1');
insert into [dict_city] values(1426, '海东', 38, '1');
insert into [dict_city] values(1427, '海北藏族 ', 38, '1');
insert into [dict_city] values(1428, '黄南藏族', 38, '1');
insert into [dict_city] values(1429, '海南藏族', 38, '1');
insert into [dict_city] values(1430, '果洛藏族 ', 38, '1');
insert into [dict_city] values(1431, '玉树藏族', 38, '1');
insert into [dict_city] values(1432, '海西蒙古', 38, '1');
insert into [dict_city] values(1433, '银川', 39, '1');
insert into [dict_city] values(1434, '石嘴山', 39, '1');
insert into [dict_city] values(1435, '吴忠', 39, '1');
insert into [dict_city] values(1436, '固原', 39, '1');
insert into [dict_city] values(1437, '中卫 ', 39, '1');
insert into [dict_city] values(1438, '乌鲁木齐', 40, '1');
insert into [dict_city] values(1439, '克拉玛依', 40, '1');
insert into [dict_city] values(1440, '石河子', 40, '1');
insert into [dict_city] values(1441, '阿拉尔', 40, '1');
insert into [dict_city] values(1442, '图木舒克', 40, '1');
insert into [dict_city] values(1443, '五家渠', 40, '1');
insert into [dict_city] values(1444, '吐鲁番 ', 40, '1');
insert into [dict_city] values(1445, '哈密', 40, '1');
insert into [dict_city] values(1446, '和田', 40, '1');
insert into [dict_city] values(1447, '阿克苏', 40, '1');
insert into [dict_city] values(1448, '喀什', 40, '1');
insert into [dict_city] values(1449, '克孜勒苏', 40, '1');
insert into [dict_city] values(1450, '巴音郭楞', 40, '1');
insert into [dict_city] values(1451, '昌吉回族 ', 40, '1');
insert into [dict_city] values(1452, '博尔塔拉', 40, '1');
insert into [dict_city] values(1453, '伊犁哈萨', 40, '1');
insert into [dict_city] values(1454, '塔城', 40, '1');
insert into [dict_city] values(1455, '阿勒泰', 40, '1');
insert into [dict_city] values(1456, '台北', 43, '1');
insert into [dict_city] values(1457, '*', 43, '1');
insert into [dict_city] values(1458, '基隆 ', 43, '1');
insert into [dict_city] values(1459, '台中', 43, '1');
insert into [dict_city] values(1460, '台南', 43, '1');
insert into [dict_city] values(1461, '新竹', 43, '1');
insert into [dict_city] values(1462, '嘉义', 43, '1');
insert into [dict_city] values(1463, '台北县', 43, '1');
insert into [dict_city] values(1464, '宜兰县', 43, '1');
insert into [dict_city] values(1465, '新竹县 ', 43, '1');
insert into [dict_city] values(1466, '桃园县', 43, '1');
insert into [dict_city] values(1467, '苗栗县', 43, '1');
insert into [dict_city] values(1468, '台中县', 43, '1');
insert into [dict_city] values(1469, '彰化县', 43, '1');
insert into [dict_city] values(1470, '南投县', 43, '1');
insert into [dict_city] values(1471, '嘉义县', 43, '1');
insert into [dict_city] values(1472, '云林县 ', 43, '1');
insert into [dict_city] values(1473, '台南县', 43, '1');
insert into [dict_city] values(1474, '*县', 43, '1');
insert into [dict_city] values(1475, '屏东县', 43, '1');
insert into [dict_city] values(1476, '台东县', 43, '1');
insert into [dict_city] values(1477, '花莲县', 43, '1');
insert into [dict_city] values(1478, '澎湖县', 43, '1');

drop table if exists [dict_province];
CREATE TABLE [dict_province] ([N_PROVID] int(10) DEFAULT ('0'), [S_PROVNAME] varchar(30),  [S_TYPE] varchar(1), [S_STATE] varchar(1));
insert into [dict_province] values(1, '国外', '5', '1');
insert into [dict_province] values(10, '北京', '1', '1');
insert into [dict_province] values(11, '上海', '1', '1');
insert into [dict_province] values(12, '天津', '1', '1');
insert into [dict_province] values(13, '重庆', '1', '1');
insert into [dict_province] values(14, '河北', '2', '1');
insert into [dict_province] values(15, '山西', '2', '1');
insert into [dict_province] values(16, '内蒙古 ', '3', '1');
insert into [dict_province] values(17, '辽宁', '2', '1');
insert into [dict_province] values(18, '吉林', '2', '1');
insert into [dict_province] values(19, '黑龙江', '2', '1');
insert into [dict_province] values(20, '江苏', '2', '1');
insert into [dict_province] values(21, '浙江', '2', '1');
insert into [dict_province] values(22, '安徽', '2', '1');
insert into [dict_province] values(23, '福建', '2', '1');
insert into [dict_province] values(24, '江西', '2', '1');
insert into [dict_province] values(25, '山东', '2', '1');
insert into [dict_province] values(26, '河南', '2', '1');
insert into [dict_province] values(27, '湖北', '2', '1');
insert into [dict_province] values(28, '湖南', '2', '1');
insert into [dict_province] values(29, '广东', '2', '1');
insert into [dict_province] values(30, '广西', '3', '1');
insert into [dict_province] values(31, '海南', '2', '1');
insert into [dict_province] values(32, '四川', '2', '1');
insert into [dict_province] values(34, '云南', '2', '1');
insert into [dict_province] values(35, '*', '3', '1');
insert into [dict_province] values(36, '陕西', '2', '1');
insert into [dict_province] values(37, '甘肃', '2', '1');
insert into [dict_province] values(38, '青海', '2', '1');
insert into [dict_province] values(39, '宁夏', '3', '1');
insert into [dict_province] values(40, '*', '3', '1');
insert into [dict_province] values(41, '香港', '4', '1');
insert into [dict_province] values(42, '澳门', '4', '1');
insert into [dict_province] values(43, '*', '2', '1');

spinner 从数据库读取数据并兑现二级联动

相关推荐