级联 jquery json格式 二级级联

数据库

oracle

CREATE OR REPLACE FORCE VIEW  "CV_PROVINCE" ("VC2PROVINCENAME", "NUMPROVINCEGUID", "NUMPROVINCEORDERID")
AS
  SELECT DISTINCT vc2provincename,
    numprovinceguid,
    NUMPROVINCEORDERID
  FROM ct_city
  ORDER BY NUMPROVINCEORDERID ;

 

Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('安徽',486,1);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('北京',467,2);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('重庆',466,3);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('福建',477,4);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('甘肃',483,5);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('广东',487,6);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('广西',481,7);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('贵州',479,8);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('海南',469,9);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('河北',475,10);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('河南',462,11);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('黑龙江',482,12);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('湖北',473,13);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('湖南',474,14);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('吉林',465,15);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('江苏',476,16);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('江西',468,17);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('辽宁',464,18);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('内蒙古',478,19);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('宁夏',461,20);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('青海',489,21);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('山东',471,22);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('山西',472,23);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('陕西',488,24);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('上海',480,25);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('四川',470,26);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('天津',485,27);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('西藏',463,28);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('新疆',484,29);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('云南',460,30);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) values ('浙江',490,31);
Insert into CV_PROVINCE (VC2PROVINCENAME,NUMPROVINCEGUID,NUMPROVINCEORDERID) 

 表城市:

CREATE TABLE  "CT_CITY"
  (
    "VC2PROVINCENAME"    VARCHAR2(100 BYTE),
    "VC2CITYNAME"        VARCHAR2(100 BYTE),
    "NUMPROVINCEGUID"    NUMBER,
    "NUMCITYGUID"        NUMBER,
    "NUMPROVINCEORDERID" NUMBER,
    "VC2CITYCODE"        VARCHAR2(100 BYTE)
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
  (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
  )
  TABLESPACE "CTBS_STAT" ;

 

 

Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','宜宾',470,434,26,'yibin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','林芝',463,229,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','昌吉',484,391,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','库尔勒',484,346,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','吉安',468,406,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','萍乡',468,283,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','鞍山',464,411,18,'anshan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','青岛',471,145,22,'qingdao');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','吕梁',472,345,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','阳泉',472,309,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','拉萨',463,144,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','那曲',463,230,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','徐州',476,191,16,'xuzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','安康',488,441,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','奎屯',484,307,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','运城',472,149,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','阿坝',470,186,26,'aba');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','咸阳',488,136,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','合肥',486,322,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','宿州',486,123,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','芜湖',486,209,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','龙岩',477,419,4,'longyan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','临夏',483,210,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','广州',487,367,6,'guangzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','三明',477,289,4,'sanming');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','阳江',487,129,6,'yangjiang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','梅州',487,422,6,'meizhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','随州',473,177,13,'suizhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','三门峡',462,173,11,'sanmenxia');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','北海',481,213,7,'beigang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','七台河',482,178,12,'qitaihe');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','开封',462,172,11,'kaifeng');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','辽源',465,353,15,'liaoyuan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('移动漫游','移动漫游',11,11,32,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','台州',490,204,31,'taizhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('重庆','重庆',466,202,3,'chongqing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','曲靖',460,430,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('重庆','黔江',466,161,3,'qianjiang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('重庆','万州',466,321,3,'wanzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('联通漫游','联通漫游',12,12,33,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','广元',470,227,26,'guangyuan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','乐山',470,299,26,'leshan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','南充',470,432,26,'nanchong');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','塔城',484,234,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','温州',490,414,31,'quanzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','临沂',471,438,22,'linyi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','鹰潭',468,198,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','无锡',476,190,16,'wuxi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('宁夏','固原',461,454,20,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('宁夏','银川',461,455,20,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','济南',471,301,22,'jinan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','海东',489,412,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','巴彦浩特',478,404,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('海南','三亚',469,501,9,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','阿拉善左旗',478,500,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','清远',487,257,6,'qingyuan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','深圳',487,369,6,'shenzhen');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','潮州',487,254,6,'chaozhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','丽水',490,203,31,'lishui');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','湖州',490,360,31,'huzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','嘉兴',490,458,31,'jiaxing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','葫芦岛',464,313,18,'huludao');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','辽阳',464,314,18,'liaoyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','沈阳',464,445,18,'shenyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','大连',464,189,18,'dalian');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','盘锦',464,352,18,'panjin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','镇江',476,317,16,'zhenjiang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','常州',476,193,16,'changzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','泰州',476,276,16,'taizhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','苏州',476,239,16,'suzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','济宁',471,268,22,'jining');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','枣庄',471,183,22,'zaozhuan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','菏泽',471,142,22,'heze');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','滨州',471,312,22,'binzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','莱芜',471,342,22,'laiwu');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','梅河口',465,153,15,'meihekou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','珲春',465,351,15,'huichun');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','延吉',465,316,15,'yanji');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','遂宁',470,388,26,'suining');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','巴中',470,233,26,'bazhong');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','甘孜',470,297,26,'ganzi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','泸州',470,182,26,'luzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','达州',470,275,26,'dazhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','凉山',470,431,26,'liangshan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','百色',481,373,7,'baise');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','防城港',481,374,7,'fangchenggang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','河池',481,424,7,'hechi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','齐齐哈尔',482,266,12,'qiqihaer');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','伊春',482,222,12,'yichun');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','佳木斯',482,335,12,'jiamusi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','鸡西',482,384,12,'jixi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','鹤壁',462,332,11,'hebi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','许昌',462,382,11,'xuchang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','安阳',462,293,11,'anyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','漯河',462,171,11,'leihe');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','郑州',462,427,11,'zhengzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','平顶山',462,264,11,'pingdingshan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','襄樊',473,154,13,'xiangfan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','黄石',473,176,13,'huangshi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','江汉',473,223,13,'jianghan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','十堰',473,428,13,'shiyan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','怀化',474,195,14,'huahua');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','吉首',474,282,14,'jishou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('未知','未知',0,0,100,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','安庆',486,121,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','滁州',486,252,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','宣城',486,253,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','宁德',477,363,4,'ningde');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','汕头',487,168,6,'shantou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','漳州',477,255,4,'zhangzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','中山',487,371,6,'zhongshan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','河源',487,128,6,'heyuan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','承德',475,216,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','濮阳',462,219,11,'puyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','商丘',462,262,11,'shangqiu');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','珠海',487,372,6,'zhuhai');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','柳州',481,380,7,'liuzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','六盘水',479,379,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','黄冈',473,175,13,'huanggang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','荆门',473,224,13,'jingmen');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','淮安',476,281,16,'huaan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','鹤岗',482,221,12,'hegang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','长沙',474,447,14,'changsha');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','白山',465,350,15,'baishan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','丽江',460,225,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','怒江',460,429,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','西安',488,135,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','榆林',488,340,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','阿克苏',484,306,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','乌鲁木齐',484,393,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','昭通',460,435,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','上饶',468,452,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','抚顺',464,151,18,'fushun');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','东营',471,152,22,'dongying');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','太原',472,440,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','忻州',472,272,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','宿迁',476,240,16,'suqian');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('宁夏','石嘴山',461,158,20,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','内江',470,226,26,'reian');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','雅安',470,141,26,'yaan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','果洛',489,284,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','商洛',488,274,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','渭南',488,236,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','蚌埠',486,418,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','黄山',486,362,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','马鞍山',486,122,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','铜陵',486,208,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','福州',477,124,4,'fuzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','南平',477,164,4,'nanping');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','平凉',483,166,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','庆阳',483,421,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','张掖',483,167,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','汕尾',487,325,6,'shanwei');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','韶关',487,423,6,'shaoguan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','云浮',487,258,6,'yunfu');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','肇庆',487,130,6,'zhaoqing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','廊坊',475,217,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','石家庄',475,425,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','唐山',475,132,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','安顺',479,291,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','揭阳',487,212,6,'jieyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','茂名',487,368,6,'maoming');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','武汉',473,338,13,'wuhan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','桂林',481,259,7,'guilin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','凯里',479,378,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','兴义',479,215,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','双鸭山',482,296,12,'shangyashan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','孝感',473,243,13,'xiaogan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','焦作',462,333,11,'jiaozuo');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','信阳',462,263,11,'xinyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','哈尔滨',482,383,12,'haerbin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','黑河',482,334,12,'hehe');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','娄底',474,196,14,'loudi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','赣州',468,354,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','松原',465,446,15,'songyuan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','永州',474,248,14,'yongzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','迪庆',460,348,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','昆明',460,386,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','广安',470,298,26,'guangan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','自贡',470,143,26,'zigong');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','保山',460,347,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','玉溪',460,139,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','舟山',490,201,31,'zhoushan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','本溪',464,199,18,'benxi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','营口',464,278,18,'yingkou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','海拉尔',478,156,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','锡林浩特',478,319,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','德州',471,242,22,'dezhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','烟台',471,228,22,'yantai');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','大同',472,304,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','新余',468,246,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','南通',476,410,16,'nantong');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','版纳',460,273,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','楚雄',460,235,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('宁夏','中卫',461,160,20,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','德令哈',489,457,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','格尔木',489,249,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','共和',489,320,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','黄南',489,250,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','临河',478,245,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','佛山',487,324,6,'foshan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','池州',486,206,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','阜阳',486,207,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','陇南',483,126,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','白银',483,366,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','甘南',483,165,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','金昌武威',483,125,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','湛江',487,370,6,'zhanjiang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','钦州',481,375,7,'qinzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','沧州',475,261,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('海南','海口',469,328,9,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','都匀',479,214,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','南京',476,449,16,'nanjing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','宜昌',473,155,13,'yichang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','驻马店',462,220,11,'zhumadian');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','大兴安岭',482,134,12,'daxinganling');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','四平',465,192,15,'siping');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','成都',470,308,26,'chengdu');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','红河',460,396,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('天津','天津',485,302,27,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','博乐',484,390,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','克拉玛依',484,271,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','朝阳',464,359,18,'chaoyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','集宁',478,409,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','阿里',463,389,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','克州',484,146,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','临汾',472,232,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','盐城',476,401,16,'yancheng');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','绍兴',490,459,31,'shaoxing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','玉树',489,237,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','汉中',488,444,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','六安',486,323,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','厦门',477,127,4,'xiamen');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','衡水',475,330,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','秦皇岛',475,169,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','南宁',481,131,7,'nanning');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','梧州',481,326,7,'wuzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','江门',487,211,6,'jiangmen');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','遵义',479,260,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','咸宁',473,277,13,'xianning');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','周口',462,294,11,'zhoukou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','大庆',482,174,12,'daqing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','益阳',474,197,14,'yiyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','抚州',468,448,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','通化',465,315,15,'tonghua');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','常德',474,355,14,'changde');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','白城',465,349,15,'baicheng');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','临沧',460,180,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','金华',490,416,31,'jinhua');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','资阳',470,341,26,'ziyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','景德镇',468,356,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','阜新',464,398,18,'fuxin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','泰安',471,443,22,'taian');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','长治',472,184,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','朔州',472,147,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','大理',460,394,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','喀什',484,270,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','眉山',470,339,26,'meishan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','晋中',472,231,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('宁夏','吴忠',461,159,20,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','日照',471,310,22,'rizhao');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','铜川',488,188,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','莆田',477,285,4,'putian');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','定西',483,420,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','惠州',487,256,6,'huizhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','牡丹江',482,385,12,'mudanjiang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('黑龙江','绥化',482,336,12,'suhua');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','恩施',473,295,13,'enshi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','连云港',476,244,16,'lianyungang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','荆州',473,265,13,'jingzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','湘潭',474,357,14,'xi');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','杭州',490,300,31,'hangzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','文山',460,138,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('上海','上海',480,433,25,'shanghai');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','攀枝花',470,140,26,'panzhihua');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','昌都',463,436,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','日喀则',463,305,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','石河子',484,392,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','衢州',490,361,31,'qúzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','潢川',462,426,11,'huangzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','九江',468,194,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','赤峰',478,280,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','呼和浩特',478,318,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','潍坊',471,179,22,'weifang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','淄博',471,303,22,'zibo');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('西藏','山南',463,437,28,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','伊犁',484,148,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','哈密',484,185,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','和田',484,439,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','包头',478,279,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','通辽',478,157,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','乌海',478,453,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广东','东莞',487,365,6,'dongguan');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','巢湖',486,251,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','酒泉嘉峪关',483,287,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','保定',475,329,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','南阳',462,331,11,'nanyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','新乡',462,133,11,'xinxiang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','邵阳',474,451,14,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','株洲',474,397,14,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','长春',465,238,15,'changchun');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('浙江','宁波',490,417,31,'ningbo');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('重庆','涪陵',466,415,3,'peiling');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','南昌',468,450,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','丹东',464,241,18,'dandong');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','铁岭',464,402,18,'tieling');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','乌兰浩特',478,247,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','聊城',471,269,22,'liaocheng');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山西','晋城',472,344,23,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江西','宜春',468,358,17,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('江苏','扬州',476,403,16,'yangzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','西宁',489,150,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','宝鸡',488,442,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('陕西','延安',488,137,24,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('山东','威海',471,311,22,'weihai');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','绵阳',470,181,26,'mianyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','阿勒泰',484,343,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('内蒙古','鄂尔多斯',478,405,19,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('新疆','吐鲁番',484,187,29,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('辽宁','锦州',464,400,18,'jinzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('青海','海晏',489,200,21,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('北京','北京',467,163,2,'beijing');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','兰州',483,364,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','淮北',486,162,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('安徽','淮南',486,205,1,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('甘肃','天水',483,288,5,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('福建','泉州',477,286,4,'quanzhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('广西','玉林',481,290,7,'yulin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','毕节',479,376,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','邢台',475,170,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','邯郸',475,292,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河南','洛阳',462,381,11,'luoyang');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('河北','张家口',475,218,10,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','贵阳',479,377,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('贵州','铜仁',479,327,8,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖北','鄂州',473,337,13,'ezhou');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','郴州',474,407,14,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','衡阳',474,408,14,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('吉林','吉林',465,399,15,'jilin');
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','岳阳',474,456,14,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('湖南','张家界',474,413,14,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','德宏',460,395,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('云南','思茅',460,267,30,null);
Insert into CT_CITY (VC2PROVINCENAME,VC2CITYNAME,NUMPROVINCEGUID,NUMCITYGUID,NUMPROVINCEORDERID,VC2CITYCODE) values ('四川','德阳',470,387,26,'deyang');

 

jsp页面

 

<script type="text/javascript" src="jquery/jquery-1.3.2.js"></script>
<script type="text/javascript" src="jquery/jQuery.FillOptions.js"></script>

<script type="text/javascript" src="jquery/jQuery.CascadingSelect.js"></script>

 

<body>
<select id="provinces_id"></select>
<select id="citys_id"></select>
</body>

 

<script type="text/javascript">
   $(function(){
	   //加载省
	   $("#provinces_id").FillOptions(    
	             "CascdingSelect",    
	             {    
		             datatype:"json",    
		             textfield:"pronviceName",    
		             valuefiled:"pronviceId",    
		             selectedindex:0,//填充并选中第1项    
		             keepold:true//填充并且保留原有项    
	             }    
		);
		$("#provinces_id").AddOption("请选择省份：","-1",true,0);//最上端插入一个文本为“请选择省份“，值为”-1“的列表项，并且是选中状态
		$("#citys_id").AddOption("请选择城市：","-1",true,0); 
               //级联
		$("#provinces_id").CascadingSelect(    
		            $("#citys_id"),//需要联动的下拉列表框，必须    
		            "CascdingSelect",    
		            {datatype:"json",textfield:"cityName",valuefiled:"cityId",parameter:"pronviceId"},//通过设置parameter:”p”这个参数会生成一个"handler1.ashx?p=xxx”这样的地址来做ajax请求    
		            function(){//完成联动后执行    
		                 //log.info("测试");    
		            }    
		 );       
	});
 
	
</script>

 

 

后台:

省输出格式

[{"pronviceId":486,"pronviceName":"安徽"},{"pronviceId":467,"pronviceName":"北京"},{"pronviceId":466,"pronviceName":"重庆"},{"pronviceId":477,"pronviceName":"福建"},{"pronviceId":483,"pronviceName":"甘肃"},{"pronviceId":487,"pronviceName":"广东"},{"pronviceId":481,"pronviceName":"广西"},{"pronviceId":479,"pronviceName":"贵州"},{"pronviceId":469,"pronviceName":"海南"},{"pronviceId":475,"pronviceName":"河北"},{"pronviceId":462,"pronviceName":"河南"},{"pronviceId":482,"pronviceName":"黑龙江"},{"pronviceId":473,"pronviceName":"湖北"},{"pronviceId":474,"pronviceName":"湖南"},{"pronviceId":465,"pronviceName":"吉林"},{"pronviceId":476,"pronviceName":"江苏"},{"pronviceId":468,"pronviceName":"江西"},{"pronviceId":464,"pronviceName":"辽宁"},{"pronviceId":478,"pronviceName":"内蒙古"},{"pronviceId":461,"pronviceName":"宁夏"},{"pronviceId":489,"pronviceName":"青海"},{"pronviceId":471,"pronviceName":"山东"},{"pronviceId":472,"pronviceName":"山西"},{"pronviceId":488,"pronviceName":"陕西"},{"pronviceId":480,"pronviceName":"上海"},{"pronviceId":470,"pronviceName":"四川"},{"pronviceId":485,"pronviceName":"天津"},{"pronviceId":463,"pronviceName":"西藏"},{"pronviceId":484,"pronviceName":"新疆"},{"pronviceId":460,"pronviceName":"云南"},{"pronviceId":490,"pronviceName":"浙江"},{"pronviceId":11,"pronviceName":"移动漫游"},{"pronviceId":12,"pronviceName":"联通漫游"},{"pronviceId":0,"pronviceName":"未知"}]

 市输出式:

[{"cityId":202,"cityName":"重庆"},{"cityId":161,"cityName":"黔江"},{"cityId":321,"cityName":"万州"},{"cityId":415,"cityName":"涪陵"}]

 

后台Servlet

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;
import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import com.tht.dao.CascadingDao;
import com.tht.vo.City;
import com.tht.vo.Province;

 

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String pronviceId=request.getParameter("pronviceId");
		
		CascadingDao cascadingDao=new CascadingDao();
		String result="";
		if(pronviceId!=null && pronviceId!=""){
			JSONArray cityListJSON=new JSONArray();
			List<City> cityList=cascadingDao.getCityList(Integer.valueOf(pronviceId));
			
			for(City city:cityList){
				JSONObject cityJSON=new JSONObject();
				cityJSON.put("cityId", city.getNumcityguid());
				cityJSON.put("cityName", city.getVc2cityname());
				cityListJSON.add(cityJSON);
			}
			result=cityListJSON.toString();
		}else{
			JSONArray provinceListJSON=new JSONArray();
			List<Province> provinceList =cascadingDao.getProvinceList();
			
			for(Province v:provinceList){
				JSONObject province=new JSONObject();
				province.put("pronviceId", v.getNumprovinceguid());
				province.put("pronviceName", v.getVc2provincename());
				provinceListJSON.add(province);
			}
			result=provinceListJSON.toString();
		}
		
		
		response.setCharacterEncoding("utf-8");   
		PrintWriter pw=response.getWriter();
		response.setCharacterEncoding("utf-8");   
		pw.write(result);
		logger.info(result);
		pw.flush();
		pw.close();
	}