- 浏览: 784827 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (386)
- Linux (36)
- Tomcat (6)
- windows (8)
- Apache (10)
- Java (25)
- jquery (7)
- Jquery 插件 (3)
- Oracle (5)
- Oracle SQL (68)
- Spring (15)
- 开发工具 (6)
- Struts (20)
- js (14)
- Project Code (2)
- Project Code Tomcat (1)
- libset (1)
- JSP (8)
- arithmetic (2)
- 浏览器 (1)
- extjs (3)
- 学习网站 (5)
- 生活情感 (0)
- 电话号码算法 (3)
- 快捷键 (1)
- 转载 (1)
- Dos命令 (2)
- services (1)
- Resources (1)
- 行业积累 (3)
- 项目积累 (3)
- Web (3)
- 文档 (1)
- JavaEE (2)
- JSF (3)
- http (3)
- JS窗口 (1)
- Html (4)
- Flex (1)
- 资讯 (2)
- 项目规范 (1)
- Struts s:property textarea中默认值用 (1)
- Quartz 2.0.2 (12)
- 1天有多少毫秒 (1)
- 专题 (1)
- intellij idea 10 CD-KEY (1)
- restlet (4)
- Mail (1)
- Excel (3)
- Menu (1)
- Big Data技术综述 (1)
- Quart 1 (1)
- nosql (1)
- linux远程 (1)
- jdk (5)
- wind7 (1)
- 虚拟人 (0)
- 虚拟机 (1)
- 终端 (1)
- Ubuntu (16)
- Myeclipse (2)
- Wmware (1)
- eclipse (2)
- css (2)
- csv (1)
- 开源 (1)
- plsql (2)
- cassandra (4)
- maven (1)
- hadoop (2)
- mysql (1)
- spring security (1)
- tools (1)
- jdbc (2)
- exception (2)
- 硬盘数据备份 (1)
- dwr (1)
- svn (1)
- PowerDesigner15使用时的十五个问题 (1)
- tomcat 项目发部路径 (1)
- js 暂停执行 (1)
- jquery jqgrid 格式化数据显示 (1)
- js 代码模板 (1)
- strutss2 直接跳转到jsp页面 (1)
- servlet (1)
- jdbc spring (1)
- js学习网站 (1)
- 自学考试 (2)
- hibernate (2)
- eos (1)
- c (4)
- 黑马 (2)
- 大数据 (2)
- 实战云大数据案例分享 (0)
- Spark (2)
- Flink (1)
最新评论
-
coosummer:
推荐使用http://buttoncssgenerator.c ...
jquery button 漂亮 -
thinktothings:
Array_06 写道你好,我是一名刚毕业学生,我以后就是做J ...
如何转型架构师 -
thinktothings:
软考,考有职业资格证,有系统的知识体系学习
如何转型架构师 -
Array_06:
你好,我是一名刚毕业学生,我以后就是做Java的架构师,那请问 ...
如何转型架构师 -
beykery:
你这也太复杂了。。。。jsf2不应该是这样的。。。。
JSF2.0的一个简单Demo
数据库
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(); }
- CascadingSelect2.zip (2.9 MB)
- 下载次数: 317
发表评论
-
json ajax
2012-11-22 09:19 936/* *个体演员-内地 通过备案号查找 个体 ... -
Form Plugin API
2012-11-21 23:38 1090Form Plugin API http://www. ... -
jquery请求后台返回map格式的json数据,key名带点
2012-10-31 08:37 1168jquery请求后台返回map格式的json数据,key ... -
jquery清空表单数据
2012-10-18 11:43 1332jquery清空表单数据 (包括文本框,多文本框,和复 ... -
csv解析
2012-06-05 11:01 1067http://jsgt.org/lib/jquery/plug ... -
jquery button 漂亮
2011-03-04 12:02 4227http://gaojiewyh.iteye.com/blog ...
相关推荐
"4级级联菜单JQUERY+JSON版"是一个利用JavaScript库jQuery和数据格式JSON实现的多级联动菜单的示例。这个项目主要展示了如何在现代浏览器(如Chrome、Firefox、Opera以及IE11)中创建一个可扩展且功能丰富的四级菜单...
JSON(JavaScript Object Notation)是一种轻量级的数据交换格式,易于人阅读和编写,同时也易于机器解析和生成。在Web开发中,JSON常用于在客户端和服务器之间传递数据。jQuery是一个快速、简洁的JavaScript库,它...
网页应用中,多个select之间级联刷新是很常见的一个需求,本插件充份运用jquery强大的脚本功能,并运用json实现数据交互,实现了select无限级联的功能,接口调用简洁,刷新功能配置灵活,参数强大, 支持select元素...
总结来说,使用jQuery实现ajax二级级联查询涉及的关键技术包括:jQuery的`$.ajax()`方法用于异步请求,XML作为数据传输格式,以及jQuery的DOM操作方法来处理响应数据。这个过程提高了用户体验,减少了不必要的页面...
3. **JSON**:JSON(JavaScript Object Notation)是一种轻量级的数据交换格式,易于人阅读和编写,同时也易于机器解析和生成。在本示例中,服务器返回的城市数据是以JSON格式,方便前端解析并填充到城市下拉列表中...
在"ajax_struts_jquery_json级联菜单"的场景中,我们将看到如何利用这四种技术协同工作来创建这样的功能。 首先,Struts框架在后台处理业务逻辑。当用户在前端选择了一个父级菜单项后,Struts Action会接收到这个...
在本场景中,jQuery被用来创建一个高效且用户体验良好的城市三级级联下拉菜单。 首先,我们需要理解jQuery的基本用法。jQuery的核心是选择器(Selectors),它们允许我们高效地定位页面上的HTML元素。例如,`$("#id...
本教程将聚焦于一个特定的应用场景——利用jQuery制作简单二级联动效果。这种效果通常应用于下拉菜单或者选择框,当用户在一个选择框中选择一个选项时,另一个选择框会根据用户的选择动态更新其内容。 在...
首先,"jquery省市区三级级联"涉及到的主要技术是jQuery和JavaScript。jQuery是一个流行的JavaScript库,它简化了DOM操作、事件处理和Ajax交互等任务,使得JavaScript编程更为便捷。在这个项目中,jQuery用于处理...
JSON(JavaScript Object Notation)是一种轻量级的数据交换格式,易于人阅读和编写,同时也易于机器解析和生成。jQuery的`$.getJSON()`函数可以方便地从服务器获取JSON数据。例如: ```javascript $.getJSON('data...
月日两级联动,本人纯手打,亲测好用,结构清晰明了,JQuery直接调用就可以,但是没有考虑闰年
Ajax级联操作通常涉及多个下拉列表,当用户在第一个列表中选择一项时,通过Ajax请求获取与之相关的第二级列表数据,更新第二个列表。在这个案例中,"cityJson"可能是城市数据的JSON文件,包含各个城市的ID和名称。当...
使用jquery和json制作省市级联下拉菜单,是同学们学习jquery的绝好范例,要知道,使用jquery从后台往前台传递包含对象的list集合通常是要解析为json对象,这是个很好的例子,希望对同学们有所帮助。该范例包含json...
收到JSON响应后,遍历数据并构建第二级下拉列表的`<option>`标签,最后将它们插入到`#level2Select`中。 ### 5. Struts1.2框架 Struts1.2是一个基于MVC(Model-View-Controller)模式的Java Web应用框架。在这个...
总结来说,这个项目结合了前端的jQuery交互与后端的MySQL数据获取,通过Servlet作为桥梁,实现了动态加载的二级级联菜单。这个过程中,前端和后端的紧密协作是关键,以确保用户体验流畅且数据实时更新。
jQuery城市级联插件是一种基于JavaScript库jQuery实现的交互式下拉菜单组件,主要用于处理多级联动选择,例如在网站上实现省、市、区的三级联动选择效果。这种插件能够提供用户友好的界面,使得用户在选择地理位置时...
在Java Web开发中,二级级联下拉菜单是一种常见的用户界面元素,用于提供层次结构的选择。这个场景中,我们利用数据库存储数据,并通过后端处理逻辑动态生成这些下拉菜单。下面将详细介绍如何使用MySQL数据库来实现...
"jQuery实现级联地区选择"这个主题就是关于如何利用jQuery库来创建一个动态联动的省份-城市选择器。这个实例包含了JSP(JavaServer Pages)、JavaScript和CSS三个主要部分,旨在提供一种高效、用户友好的选择体验。 ...