--省表 create table province( iAutoID int IDENTITY (1, 1) NOT NULL PRIMARY KEY, sName varchar(32) )--市表 create table city( iAutoID int IDENTITY (1, 1) NOT NULL PRIMARY KEY, sName varchar(32), iProvinceId int ) --省 insert into province(sName) values('安徽'); insert into province(sName) values('北京'); insert into province(sName) values('福建'); insert into province(sName) values('甘肃'); insert into province(sName) values('广东'); insert into province(sName) values('广西'); insert into province(sName) values('贵州'); insert into province(sName) values('海南'); insert into province(sName) values('河北'); insert into province(sName) values('河南'); insert into province(sName) values('黑龙江'); insert into province(sName) values('湖北'); insert into province(sName) values('湖南'); insert into province(sName) values('吉林'); insert into province(sName) values('江苏'); insert into province(sName) values('江西'); insert into province(sName) values('辽宁'); insert into province(sName) values('内蒙古'); insert into province(sName) values('宁夏'); insert into province(sName) values('青海'); insert into province(sName) values('山东'); insert into province(sName) values('山西'); insert into province(sName) values('陕西'); insert into province(sName) values('上海'); insert into province(sName) values('四川'); insert into province(sName) values('天津'); insert into province(sName) values('西藏'); insert into province(sName) values('新疆'); insert into province(sName) values('云南'); insert into province(sName) values('浙江'); insert into province(sName) values('重庆'); insert into province(sName) values('香港'); insert into province(sName) values('澳门'); insert into province(sName) values('台湾');
--市 insert into city(iProvinceId, sName) values(1,'安庆'); insert into city(iProvinceId, sName) values(1,'蚌埠'); insert into city(iProvinceId, sName) values(1,'巢湖'); insert into city(iProvinceId, sName) values(1,'池州'); insert into city(iProvinceId, sName) values(1,'滁州'); insert into city(iProvinceId, sName) values(1,'阜阳'); insert into city(iProvinceId, sName) values(1,'合肥'); insert into city(iProvinceId, sName) values(1,'淮北'); insert into city(iProvinceId, sName) values(1,'淮南'); insert into city(iProvinceId, sName) values(1,'黄山'); insert into city(iProvinceId, sName) values(1,'六安'); insert into city(iProvinceId, sName) values(1,'马鞍山'); insert into city(iProvinceId, sName) values(1,'宿州'); insert into city(iProvinceId, sName) values(1,'铜陵'); insert into city(iProvinceId, sName) values(1,'芜湖'); insert into city(iProvinceId, sName) values(1,'宣城'); insert into city(iProvinceId, sName) values(1,'亳州'); insert into city(iProvinceId, sName) values(2,'北京'); insert into city(iProvinceId, sName) values(3,'福州'); insert into city(iProvinceId, sName) values(3,'龙岩'); insert into city(iProvinceId, sName) values(3,'南平'); insert into city(iProvinceId, sName) values(3,'宁德'); insert into city(iProvinceId, sName) values(3,'莆田'); insert into city(iProvinceId, sName) values(3,'泉州'); insert into city(iProvinceId, sName) values(3,'三明'); insert into city(iProvinceId, sName) values(3,'厦门'); insert into city(iProvinceId, sName) values(3,'漳州'); insert into city(iProvinceId, sName) values(4,'白银'); insert into city(iProvinceId, sName) values(4,'定西'); insert into city(iProvinceId, sName) values(4,'甘南藏族自治州'); insert into city(iProvinceId, sName) values(4,'嘉峪关'); insert into city(iProvinceId, sName) values(4,'金昌'); insert into city(iProvinceId, sName) values(4,'酒泉'); insert into city(iProvinceId, sName) values(4,'兰州'); insert into city(iProvinceId, sName) values(4,'临夏回族自治州'); insert into city(iProvinceId, sName) values(4,'陇南'); insert into city(iProvinceId, sName) values(4,'平凉'); insert into city(iProvinceId, sName) values(4,'庆阳'); insert into city(iProvinceId, sName) values(4,'天水'); insert into city(iProvinceId, sName) values(4,'武威'); insert into city(iProvinceId, sName) values(4,'张掖'); insert into city(iProvinceId, sName) values(5,'潮州'); insert into city(iProvinceId, sName) values(5,'东莞'); insert into city(iProvinceId, sName) values(5,'佛山'); insert into city(iProvinceId, sName) values(5,'广州'); insert into city(iProvinceId, sName) values(5,'河源'); insert into city(iProvinceId, sName) values(5,'惠州'); insert into city(iProvinceId, sName) values(5,'江门'); insert into city(iProvinceId, sName) values(5,'揭阳'); insert into city(iProvinceId, sName) values(5,'茂名'); insert into city(iProvinceId, sName) values(5,'梅州'); insert into city(iProvinceId, sName) values(5,'清远'); insert into city(iProvinceId, sName) values(5,'汕头'); insert into city(iProvinceId, sName) values(5,'汕尾'); insert into city(iProvinceId, sName) values(5,'韶关'); insert into city(iProvinceId, sName) values(5,'深圳'); insert into city(iProvinceId, sName) values(5,'阳江'); insert into city(iProvinceId, sName) values(5,'云浮'); insert into city(iProvinceId, sName) values(5,'湛江'); insert into city(iProvinceId, sName) values(5,'肇庆'); insert into city(iProvinceId, sName) values(5,'中山'); insert into city(iProvinceId, sName) values(5,'珠海'); insert into city(iProvinceId, sName) values(6,'百色'); insert into city(iProvinceId, sName) values(6,'北海'); insert into city(iProvinceId, sName) values(6,'崇左'); insert into city(iProvinceId, sName) values(6,'防城港'); insert into city(iProvinceId, sName) values(6,'桂林'); insert into city(iProvinceId, sName) values(6,'贵港'); insert into city(iProvinceId, sName) values(6,'河池'); insert into city(iProvinceId, sName) values(6,'贺州'); insert into city(iProvinceId, sName) values(6,'来宾'); insert into city(iProvinceId, sName) values(6,'柳州'); insert into city(iProvinceId, sName) values(6,'南宁'); insert into city(iProvinceId, sName) values(6,'钦州'); insert into city(iProvinceId, sName) values(6,'梧州'); insert into city(iProvinceId, sName) values(6,'玉林'); insert into city(iProvinceId, sName) values(7,'安顺'); insert into city(iProvinceId, sName) values(7,'毕节'); insert into city(iProvinceId, sName) values(7,'贵阳'); insert into city(iProvinceId, sName) values(7,'六盘水'); insert into city(iProvinceId, sName) values(7,'黔东南苗族侗族自治州'); insert into city(iProvinceId, sName) values(7,'黔南布依族苗族自治州'); insert into city(iProvinceId, sName) values(7,'黔西南布依族苗族自治州'); insert into city(iProvinceId, sName) values(7,'铜仁'); insert into city(iProvinceId, sName) values(7,'遵义'); insert into city(iProvinceId, sName) values(8,'白沙黎族自治县'); insert into city(iProvinceId, sName) values(8,'保亭黎族苗族自治县'); insert into city(iProvinceId, sName) values(8,'昌江黎族自治县'); insert into city(iProvinceId, sName) values(8,'澄迈县'); insert into city(iProvinceId, sName) values(8,'定安县'); insert into city(iProvinceId, sName) values(8,'东方'); insert into city(iProvinceId, sName) values(8,'海口'); insert into city(iProvinceId, sName) values(8,'乐东黎族自治县'); insert into city(iProvinceId, sName) values(8,'临高县'); insert into city(iProvinceId, sName) values(8,'陵水黎族自治县'); insert into city(iProvinceId, sName) values(8,'琼海'); insert into city(iProvinceId, sName) values(8,'琼中黎族苗族自治县'); insert into city(iProvinceId, sName) values(8,'三亚'); insert into city(iProvinceId, sName) values(8,'屯昌县'); insert into city(iProvinceId, sName) values(8,'万宁'); insert into city(iProvinceId, sName) values(8,'文昌'); insert into city(iProvinceId, sName) values(8,'五指山'); insert into city(iProvinceId, sName) values(8,'儋州'); insert into city(iProvinceId, sName) values(9,'保定'); insert into city(iProvinceId, sName) values(9,'沧州'); insert into city(iProvinceId, sName) values(9,'承德'); insert into city(iProvinceId, sName) values(9,'邯郸'); insert into city(iProvinceId, sName) values(9,'衡水'); insert into city(iProvinceId, sName) values(9,'廊坊'); insert into city(iProvinceId, sName) values(9,'秦皇岛'); insert into city(iProvinceId, sName) values(9,'石家庄'); insert into city(iProvinceId, sName) values(9,'唐山'); insert into city(iProvinceId, sName) values(9,'邢台'); insert into city(iProvinceId, sName) values(9,'张家口'); insert into city(iProvinceId, sName) values(10,'安阳'); insert into city(iProvinceId, sName) values(10,'鹤壁'); insert into city(iProvinceId, sName) values(10,'济源'); insert into city(iProvinceId, sName) values(10,'焦作'); insert into city(iProvinceId, sName) values(10,'开封'); insert into city(iProvinceId, sName) values(10,'洛阳'); insert into city(iProvinceId, sName) values(10,'南阳'); insert into city(iProvinceId, sName) values(10,'平顶山'); insert into city(iProvinceId, sName) values(10,'三门峡'); insert into city(iProvinceId, sName) values(10,'商丘'); insert into city(iProvinceId, sName) values(10,'新乡'); insert into city(iProvinceId, sName) values(10,'信阳'); insert into city(iProvinceId, sName) values(10,'许昌'); insert into city(iProvinceId, sName) values(10,'郑州'); insert into city(iProvinceId, sName) values(10,'周口'); insert into city(iProvinceId, sName) values(10,'驻马店'); insert into city(iProvinceId, sName) values(10,'漯河'); insert into city(iProvinceId, sName) values(10,'濮阳');
insert into city(iProvinceId, sName) values(11,'大庆'); insert into city(iProvinceId, sName) values(11,'大兴安岭'); insert into city(iProvinceId, sName) values(11,'哈尔滨'); insert into city(iProvinceId, sName) values(11,'鹤岗'); insert into city(iProvinceId, sName) values(11,'黑河'); insert into city(iProvinceId, sName) values(11,'鸡西'); insert into city(iProvinceId, sName) values(11,'佳木斯'); insert into city(iProvinceId, sName) values(11,'牡丹江'); insert into city(iProvinceId, sName) values(11,'七台河'); insert into city(iProvinceId, sName) values(11,'齐齐哈尔'); insert into city(iProvinceId, sName) values(11,'双鸭山'); insert into city(iProvinceId, sName) values(11,'绥化'); insert into city(iProvinceId, sName) values(11,'伊春'); insert into city(iProvinceId, sName) values(12,'鄂州'); insert into city(iProvinceId, sName) values(12,'恩施土家族苗族自治州'); insert into city(iProvinceId, sName) values(12,'黄冈'); insert into city(iProvinceId, sName) values(12,'黄石'); insert into city(iProvinceId, sName) values(12,'荆门'); insert into city(iProvinceId, sName) values(12,'荆州'); insert into city(iProvinceId, sName) values(12,'潜江'); insert into city(iProvinceId, sName) values(12,'神农架林区'); insert into city(iProvinceId, sName) values(12,'十堰'); insert into city(iProvinceId, sName) values(12,'随州'); insert into city(iProvinceId, sName) values(12,'天门'); insert into city(iProvinceId, sName) values(12,'武汉'); insert into city(iProvinceId, sName) values(12,'仙桃'); insert into city(iProvinceId, sName) values(12,'咸宁'); insert into city(iProvinceId, sName) values(12,'襄樊'); insert into city(iProvinceId, sName) values(12,'孝感'); insert into city(iProvinceId, sName) values(12,'宜昌'); insert into city(iProvinceId, sName) values(13,'常德'); insert into city(iProvinceId, sName) values(13,'长沙'); insert into city(iProvinceId, sName) values(13,'郴州'); insert into city(iProvinceId, sName) values(13,'衡阳'); insert into city(iProvinceId, sName) values(13,'怀化'); insert into city(iProvinceId, sName) values(13,'娄底'); insert into city(iProvinceId, sName) values(13,'邵阳'); insert into city(iProvinceId, sName) values(13,'湘潭'); insert into city(iProvinceId, sName) values(13,'湘西土家族苗族自治州'); insert into city(iProvinceId, sName) values(13,'益阳'); insert into city(iProvinceId, sName) values(13,'永州'); insert into city(iProvinceId, sName) values(13,'岳阳'); insert into city(iProvinceId, sName) values(13,'张家界'); insert into city(iProvinceId, sName) values(13,'株洲'); insert into city(iProvinceId, sName) values(14,'白城'); insert into city(iProvinceId, sName) values(14,'白山'); insert into city(iProvinceId, sName) values(14,'长春'); insert into city(iProvinceId, sName) values(14,'吉林'); insert into city(iProvinceId, sName) values(14,'辽源'); insert into city(iProvinceId, sName) values(14,'四平'); insert into city(iProvinceId, sName) values(14,'松原'); insert into city(iProvinceId, sName) values(14,'通化'); insert into city(iProvinceId, sName) values(14,'延边朝鲜族自治州'); insert into city(iProvinceId, sName) values(15,'常州'); insert into city(iProvinceId, sName) values(15,'淮安'); insert into city(iProvinceId, sName) values(15,'连云港'); insert into city(iProvinceId, sName) values(15,'南京'); insert into city(iProvinceId, sName) values(15,'南通'); insert into city(iProvinceId, sName) values(15,'苏州'); insert into city(iProvinceId, sName) values(15,'宿迁'); insert into city(iProvinceId, sName) values(15,'泰州'); insert into city(iProvinceId, sName) values(15,'无锡'); insert into city(iProvinceId, sName) values(15,'徐州'); insert into city(iProvinceId, sName) values(15,'盐城'); insert into city(iProvinceId, sName) values(15,'扬州'); insert into city(iProvinceId, sName) values(15,'镇江'); insert into city(iProvinceId, sName) values(16,'抚州'); insert into city(iProvinceId, sName) values(16,'赣州'); insert into city(iProvinceId, sName) values(16,'吉安'); insert into city(iProvinceId, sName) values(16,'景德镇'); insert into city(iProvinceId, sName) values(16,'九江'); insert into city(iProvinceId, sName) values(16,'南昌'); insert into city(iProvinceId, sName) values(16,'萍乡'); insert into city(iProvinceId, sName) values(16,'上饶'); insert into city(iProvinceId, sName) values(16,'新余'); insert into city(iProvinceId, sName) values(16,'宜春'); insert into city(iProvinceId, sName) values(16,'鹰潭'); insert into city(iProvinceId, sName) values(17,'鞍山'); insert into city(iProvinceId, sName) values(17,'本溪'); insert into city(iProvinceId, sName) values(17,'朝阳'); insert into city(iProvinceId, sName) values(17,'大连'); insert into city(iProvinceId, sName) values(17,'丹东'); insert into city(iProvinceId, sName) values(17,'抚顺'); insert into city(iProvinceId, sName) values(17,'阜新'); insert into city(iProvinceId, sName) values(17,'葫芦岛'); insert into city(iProvinceId, sName) values(17,'锦州'); insert into city(iProvinceId, sName) values(17,'辽阳'); insert into city(iProvinceId, sName) values(17,'盘锦'); insert into city(iProvinceId, sName) values(17,'沈阳'); insert into city(iProvinceId, sName) values(17,'铁岭'); insert into city(iProvinceId, sName) values(17,'营口'); insert into city(iProvinceId, sName) values(18,'阿拉善盟'); insert into city(iProvinceId, sName) values(18,'巴彦淖尔盟'); insert into city(iProvinceId, sName) values(18,'包头'); insert into city(iProvinceId, sName) values(18,'赤峰'); insert into city(iProvinceId, sName) values(18,'鄂尔多斯'); insert into city(iProvinceId, sName) values(18,'呼和浩特'); insert into city(iProvinceId, sName) values(18,'呼伦贝尔'); insert into city(iProvinceId, sName) values(18,'通辽'); insert into city(iProvinceId, sName) values(18,'乌海'); insert into city(iProvinceId, sName) values(18,'乌兰察布盟'); insert into city(iProvinceId, sName) values(18,'锡林郭勒盟'); insert into city(iProvinceId, sName) values(18,'兴安盟'); insert into city(iProvinceId, sName) values(19,'固原'); insert into city(iProvinceId, sName) values(19,'石嘴山'); insert into city(iProvinceId, sName) values(19,'吴忠'); insert into city(iProvinceId, sName) values(19,'银川'); insert into city(iProvinceId, sName) values(20,'果洛藏族自治州'); insert into city(iProvinceId, sName) values(20,'海北藏族自治州'); insert into city(iProvinceId, sName) values(20,'海东'); insert into city(iProvinceId, sName) values(20,'海南藏族自治州'); insert into city(iProvinceId, sName) values(20,'海西蒙古族藏族自治州'); insert into city(iProvinceId, sName) values(20,'黄南藏族自治州'); insert into city(iProvinceId, sName) values(20,'西宁'); insert into city(iProvinceId, sName) values(20,'玉树藏族自治州');
直接简历数据 http://blog.programfan.com/article.asp?id=28128 xml 或者html或者webservice 复制到txt即能用 我写的省市二级互联 http://www.bingtai.cn/App_data/dataXml.rar
insert into city(iProvinceId, sName) values(21,'滨州'); insert into city(iProvinceId, sName) values(21,'德州'); insert into city(iProvinceId, sName) values(21,'东营'); insert into city(iProvinceId, sName) values(21,'菏泽'); insert into city(iProvinceId, sName) values(21,'济南'); insert into city(iProvinceId, sName) values(21,'济宁'); insert into city(iProvinceId, sName) values(21,'莱芜'); insert into city(iProvinceId, sName) values(21,'聊城'); insert into city(iProvinceId, sName) values(21,'临沂'); insert into city(iProvinceId, sName) values(21,'青岛'); insert into city(iProvinceId, sName) values(21,'日照'); insert into city(iProvinceId, sName) values(21,'泰安'); insert into city(iProvinceId, sName) values(21,'威海'); insert into city(iProvinceId, sName) values(21,'潍坊'); insert into city(iProvinceId, sName) values(21,'烟台'); insert into city(iProvinceId, sName) values(21,'枣庄'); insert into city(iProvinceId, sName) values(21,'淄博'); insert into city(iProvinceId, sName) values(22,'长治'); insert into city(iProvinceId, sName) values(22,'大同'); insert into city(iProvinceId, sName) values(22,'晋城'); insert into city(iProvinceId, sName) values(22,'晋中'); insert into city(iProvinceId, sName) values(22,'临汾'); insert into city(iProvinceId, sName) values(22,'吕梁'); insert into city(iProvinceId, sName) values(22,'朔州'); insert into city(iProvinceId, sName) values(22,'太原'); insert into city(iProvinceId, sName) values(22,'忻州'); insert into city(iProvinceId, sName) values(22,'阳泉'); insert into city(iProvinceId, sName) values(22,'运城'); insert into city(iProvinceId, sName) values(23,'安康'); insert into city(iProvinceId, sName) values(23,'宝鸡'); insert into city(iProvinceId, sName) values(23,'汉中'); insert into city(iProvinceId, sName) values(23,'商洛'); insert into city(iProvinceId, sName) values(23,'铜川'); insert into city(iProvinceId, sName) values(23,'渭南'); insert into city(iProvinceId, sName) values(23,'西安'); insert into city(iProvinceId, sName) values(23,'咸阳'); insert into city(iProvinceId, sName) values(23,'延安'); insert into city(iProvinceId, sName) values(23,'榆林'); insert into city(iProvinceId, sName) values(24,'上海'); insert into city(iProvinceId, sName) values(25,'阿坝藏族羌族自治州'); insert into city(iProvinceId, sName) values(25,'巴中'); insert into city(iProvinceId, sName) values(25,'成都'); insert into city(iProvinceId, sName) values(25,'达州'); insert into city(iProvinceId, sName) values(25,'德阳'); insert into city(iProvinceId, sName) values(25,'甘孜藏族自治州'); insert into city(iProvinceId, sName) values(25,'广安'); insert into city(iProvinceId, sName) values(25,'广元'); insert into city(iProvinceId, sName) values(25,'乐山'); insert into city(iProvinceId, sName) values(25,'凉山彝族自治州'); insert into city(iProvinceId, sName) values(25,'眉山'); insert into city(iProvinceId, sName) values(25,'绵阳'); insert into city(iProvinceId, sName) values(25,'南充'); insert into city(iProvinceId, sName) values(25,'内江'); insert into city(iProvinceId, sName) values(25,'攀枝花'); insert into city(iProvinceId, sName) values(25,'遂宁'); insert into city(iProvinceId, sName) values(25,'雅安'); insert into city(iProvinceId, sName) values(25,'宜宾'); insert into city(iProvinceId, sName) values(25,'资阳'); insert into city(iProvinceId, sName) values(25,'自贡'); insert into city(iProvinceId, sName) values(25,'泸州'); insert into city(iProvinceId, sName) values(26,'天津'); insert into city(iProvinceId, sName) values(27,'阿里'); insert into city(iProvinceId, sName) values(27,'昌都'); insert into city(iProvinceId, sName) values(27,'拉萨'); insert into city(iProvinceId, sName) values(27,'林芝'); insert into city(iProvinceId, sName) values(27,'那曲'); insert into city(iProvinceId, sName) values(27,'日喀则'); insert into city(iProvinceId, sName) values(27,'山南'); insert into city(iProvinceId, sName) values(28,'阿克苏'); insert into city(iProvinceId, sName) values(28,'阿拉尔'); insert into city(iProvinceId, sName) values(28,'巴音郭楞蒙古自治州'); insert into city(iProvinceId, sName) values(28,'博尔塔拉蒙古自治州'); insert into city(iProvinceId, sName) values(28,'昌吉回族自治州'); insert into city(iProvinceId, sName) values(28,'哈密'); insert into city(iProvinceId, sName) values(28,'和田'); insert into city(iProvinceId, sName) values(28,'喀什'); insert into city(iProvinceId, sName) values(28,'克拉玛依'); insert into city(iProvinceId, sName) values(28,'克孜勒苏柯尔克孜自治州'); insert into city(iProvinceId, sName) values(28,'石河子'); insert into city(iProvinceId, sName) values(28,'图木舒克'); insert into city(iProvinceId, sName) values(28,'吐鲁番'); insert into city(iProvinceId, sName) values(28,'乌鲁木齐'); insert into city(iProvinceId, sName) values(28,'五家渠'); insert into city(iProvinceId, sName) values(28,'伊犁哈萨克自治州'); insert into city(iProvinceId, sName) values(29,'保山'); insert into city(iProvinceId, sName) values(29,'楚雄彝族自治州'); insert into city(iProvinceId, sName) values(29,'大理白族自治州'); insert into city(iProvinceId, sName) values(29,'德宏傣族景颇族自治州'); insert into city(iProvinceId, sName) values(29,'迪庆藏族自治州'); insert into city(iProvinceId, sName) values(29,'红河哈尼族彝族自治州'); insert into city(iProvinceId, sName) values(29,'昆明'); insert into city(iProvinceId, sName) values(29,'丽江'); insert into city(iProvinceId, sName) values(29,'临沧'); insert into city(iProvinceId, sName) values(29,'怒江傈傈族自治州'); insert into city(iProvinceId, sName) values(29,'曲靖'); insert into city(iProvinceId, sName) values(29,'思茅'); insert into city(iProvinceId, sName) values(29,'文山壮族苗族自治州'); insert into city(iProvinceId, sName) values(29,'西双版纳傣族自治州'); insert into city(iProvinceId, sName) values(29,'玉溪'); insert into city(iProvinceId, sName) values(29,'昭通'); insert into city(iProvinceId, sName) values(30,'杭州'); insert into city(iProvinceId, sName) values(30,'湖州'); insert into city(iProvinceId, sName) values(30,'嘉兴'); insert into city(iProvinceId, sName) values(30,'金华'); insert into city(iProvinceId, sName) values(30,'丽水'); insert into city(iProvinceId, sName) values(30,'宁波'); insert into city(iProvinceId, sName) values(30,'绍兴'); insert into city(iProvinceId, sName) values(30,'台州'); insert into city(iProvinceId, sName) values(30,'温州'); insert into city(iProvinceId, sName) values(30,'舟山'); insert into city(iProvinceId, sName) values(30,'衢州'); insert into city(iProvinceId, sName) values(31,'重庆'); insert into city(iProvinceId, sName) values(32,'香港'); insert into city(iProvinceId, sName) values(33,'澳门'); insert into city(iProvinceId, sName) values(34,'台湾');全国省市表 将以上代码放入 Sql Server 查询分析器内直接执行即可生成两张表一张省表,一张市表, 其中City表内的 iProvinceId 字段与 Province 表内的 iAutoId 字段关连
看你要什么的了,xml的在 我的资源 里面可以下到;js的只要随便找个注册有下拉框的你看页面源代码里面就有js的省市数据;数据库的么楼上有 =======================================给你贴个js的吧<html> <head> <title>js省市2级联动</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <style> <!-- body { font-size: 14px } --> </style> </head> <body bgcolor=#FFFFFF alink=#333333 vlink=#333333 link=#333333 topmargin=0 leftmargin=0> <form action="" method=post name="creator" enctype="multipart/form-data"> <script language="javascript"> <!-- var where = new Array(35); function comefrom(loca,locacity) { this.loca = loca; this.locacity = locacity; } where[0]= new comefrom("请选择","请选择"); where[1] = new comefrom("北京","|东城|西城|崇文|宣武|朝阳|丰台|石景山|海淀|门头沟|房山|通州|顺义|昌平|大兴|平谷|怀柔|密云|延庆"); where[2] = new comefrom("上海","|黄浦|卢湾|徐汇|长宁|静安|普陀|闸北|虹口|杨浦|闵行|宝山|嘉定|浦东|金山|松江|青浦|南汇|奉贤|崇明"); where[3] = new comefrom("天津","|和平|东丽|河东|西青|河西|津南|南开|北辰|河北|武清|红挢|塘沽|汉沽|大港|宁河|静海|宝坻|蓟县"); where[4] = new comefrom("重庆","|万州|涪陵|渝中|大渡口|江北|沙坪坝|九龙坡|南岸|北碚|万盛|双挢|渝北|巴南|黔江|长寿|綦江|潼南|铜梁|大足|荣昌|壁山|梁平|城口|丰都|垫江|武隆|忠县|开县|云阳|奉节|巫山|巫溪|石柱|秀山|酉阳|彭水|江津|合川|永川|南川"); where[5] = new comefrom("河北","|石家庄|邯郸|邢台|保定|张家口|承德|廊坊|唐山|秦皇岛|沧州|衡水"); where[6] = new comefrom("山西","|太原|大同|阳泉|长治|晋城|朔州|吕梁|忻州|晋中|临汾|运城"); where[7] = new comefrom("内蒙古","|呼和浩特|包头|乌海|赤峰|呼伦贝尔盟|阿拉善盟|哲里木盟|兴安盟|乌兰察布盟|锡林郭勒盟|巴彦淖尔盟|伊克昭盟"); where[8] = new comefrom("辽宁","|沈阳|大连|鞍山|抚顺|本溪|丹东|锦州|营口|阜新|辽阳|盘锦|铁岭|朝阳|葫芦岛"); where[9] = new comefrom("吉林","|长春|吉林|四平|辽源|通化|白山|松原|白城|延边"); where[10] = new comefrom("黑龙江","|哈尔滨|齐齐哈尔|牡丹江|佳木斯|大庆|绥化|鹤岗|鸡西|黑河|双鸭山|伊春|七台河|大兴安岭"); where[11] = new comefrom("江苏","|南京|镇江|苏州|南通|扬州|盐城|徐州|连云港|常州|无锡|宿迁|泰州|淮安"); where[12] = new comefrom("浙江","|杭州|宁波|温州|嘉兴|湖州|绍兴|金华|衢州|舟山|台州|丽水"); where[13] = new comefrom("安徽","|合肥|芜湖|蚌埠|马鞍山|淮北|铜陵|安庆|黄山|滁州|宿州|池州|淮南|巢湖|阜阳|六安|宣城|亳州"); where[14] = new comefrom("福建","|福州|厦门|莆田|三明|泉州|漳州|南平|龙岩|宁德"); where[15] = new comefrom("江西","|南昌市|景德镇|九江|鹰潭|萍乡|新馀|赣州|吉安|宜春|抚州|上饶"); where[16] = new comefrom("山东","|济南|青岛|淄博|枣庄|东营|烟台|潍坊|济宁|泰安|威海|日照|莱芜|临沂|德州|聊城|滨州|菏泽"); where[17] = new comefrom("河南","|郑州|开封|洛阳|平顶山|安阳|鹤壁|新乡|焦作|濮阳|许昌|漯河|三门峡|南阳|商丘|信阳|周口|驻马店|济源"); where[18] = new comefrom("湖北","|武汉|宜昌|荆州|襄樊|黄石|荆门|黄冈|十堰|恩施|潜江|天门|仙桃|随州|咸宁|孝感|鄂州"); where[19] = new comefrom("湖南","|长沙|常德|株洲|湘潭|衡阳|岳阳|邵阳|益阳|娄底|怀化|郴州|永州|湘西|张家界"); where[20] = new comefrom("广东","|广州|深圳|珠海|汕头|东莞|中山|佛山|韶关|江门|湛江|茂名|肇庆|惠州|梅州|汕尾|河源|阳江|清远|潮州|揭阳|云浮"); where[21] = new comefrom("广西","|南宁|柳州|桂林|梧州|北海|防城港|钦州|贵港|玉林|南宁地区|柳州地区|贺州|百色|河池"); where[22] = new comefrom("海南","|海口|三亚"); where[23] = new comefrom("四川","|成都|绵阳|德阳|自贡|攀枝花|广元|内江|乐山|南充|宜宾|广安|达川|雅安|眉山|甘孜|凉山|泸州"); where[24] = new comefrom("贵州","|贵阳|六盘水|遵义|安顺|铜仁|黔西南|毕节|黔东南|黔南"); where[25] = new comefrom("云南","|昆明|大理|曲靖|玉溪|昭通|楚雄|红河|文山|思茅|西双版纳|保山|德宏|丽江|怒江|迪庆|临沧"); where[26] = new comefrom("西藏","|拉萨|日喀则|山南|林芝|昌都|阿里|那曲"); where[27] = new comefrom("陕西","|西安|宝鸡|咸阳|铜川|渭南|延安|榆林|汉中|安康|商洛"); where[28] = new comefrom("甘肃","|兰州|嘉峪关|金昌|白银|天水|酒泉|张掖|武威|定西|陇南|平凉|庆阳|临夏|甘南"); where[29] = new comefrom("宁夏","|银川|石嘴山|吴忠|固原"); where[30] = new comefrom("青海","|西宁|海东|海南|海北|黄南|玉树|果洛|海西"); where[31] = new comefrom("新疆","|乌鲁木齐|石河子|克拉玛依|伊犁|巴音郭勒|昌吉|克孜勒苏柯尔克孜|博尔塔拉|吐鲁番|哈密|喀什|和田|阿克苏"); where[32] = new comefrom("香港",""); where[33] = new comefrom("澳门",""); where[34] = new comefrom("台湾","|台北|高雄|台中|台南|屏东|南投|云林|新竹|彰化|苗栗|嘉义|花莲|桃园|宜兰|基隆|台东|金门|马祖|澎湖"); where[35] = new comefrom("其它","|北美洲|南美洲|亚洲|非洲|欧洲|大洋洲"); function select() { with(document.creator.province) { var loca2 = options[selectedIndex].value; } for(i = 0;i < where.length;i ++) { if (where[i].loca == loca2) { loca3 = (where[i].locacity).split("|"); for(j = 0;j < loca3.length;j++) { with(document.creator.city) { length = loca3.length; options[j].text = loca3[j]; options[j].value = loca3[j]; var loca4=options[selectedIndex].value;}} break; }} document.creator.newlocation.value=loca2+loca4; } function init() { with(document.creator.province) { length = where.length; for(k=0;k<where.length;k++) { options[k].text = where[k].loca; options[k].value = where[k].loca; } options[selectedIndex].text = where[0].loca; options[selectedIndex].value = where[0].loca; } with(document.creator.city) { loca3 = (where[0].locacity).split("|"); length = loca3.length; for(l=0;l<length;l++) { options[l].text = loca3[l]; options[l].value = loca3[l]; } options[selectedIndex].text = loca3[0]; options[selectedIndex].value = loca3[0]; }} --> </script> <body onload="init()"> <font color=#000000><b>来自:</b> 省份 <select name="province" onChange = "select()"></select> 城市 <select name="city" onChange = "select()"></select>
create table province(
iAutoID int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
sName varchar(32)
)--市表
create table city(
iAutoID int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
sName varchar(32),
iProvinceId int
)
--省
insert into province(sName) values('安徽');
insert into province(sName) values('北京');
insert into province(sName) values('福建');
insert into province(sName) values('甘肃');
insert into province(sName) values('广东');
insert into province(sName) values('广西');
insert into province(sName) values('贵州');
insert into province(sName) values('海南');
insert into province(sName) values('河北');
insert into province(sName) values('河南');
insert into province(sName) values('黑龙江');
insert into province(sName) values('湖北');
insert into province(sName) values('湖南');
insert into province(sName) values('吉林');
insert into province(sName) values('江苏');
insert into province(sName) values('江西');
insert into province(sName) values('辽宁');
insert into province(sName) values('内蒙古');
insert into province(sName) values('宁夏');
insert into province(sName) values('青海');
insert into province(sName) values('山东');
insert into province(sName) values('山西');
insert into province(sName) values('陕西');
insert into province(sName) values('上海');
insert into province(sName) values('四川');
insert into province(sName) values('天津');
insert into province(sName) values('西藏');
insert into province(sName) values('新疆');
insert into province(sName) values('云南');
insert into province(sName) values('浙江');
insert into province(sName) values('重庆');
insert into province(sName) values('香港');
insert into province(sName) values('澳门');
insert into province(sName) values('台湾');
--市
insert into city(iProvinceId, sName) values(1,'安庆');
insert into city(iProvinceId, sName) values(1,'蚌埠');
insert into city(iProvinceId, sName) values(1,'巢湖');
insert into city(iProvinceId, sName) values(1,'池州');
insert into city(iProvinceId, sName) values(1,'滁州');
insert into city(iProvinceId, sName) values(1,'阜阳');
insert into city(iProvinceId, sName) values(1,'合肥');
insert into city(iProvinceId, sName) values(1,'淮北');
insert into city(iProvinceId, sName) values(1,'淮南');
insert into city(iProvinceId, sName) values(1,'黄山');
insert into city(iProvinceId, sName) values(1,'六安');
insert into city(iProvinceId, sName) values(1,'马鞍山');
insert into city(iProvinceId, sName) values(1,'宿州');
insert into city(iProvinceId, sName) values(1,'铜陵');
insert into city(iProvinceId, sName) values(1,'芜湖');
insert into city(iProvinceId, sName) values(1,'宣城');
insert into city(iProvinceId, sName) values(1,'亳州');
insert into city(iProvinceId, sName) values(2,'北京');
insert into city(iProvinceId, sName) values(3,'福州');
insert into city(iProvinceId, sName) values(3,'龙岩');
insert into city(iProvinceId, sName) values(3,'南平');
insert into city(iProvinceId, sName) values(3,'宁德');
insert into city(iProvinceId, sName) values(3,'莆田');
insert into city(iProvinceId, sName) values(3,'泉州');
insert into city(iProvinceId, sName) values(3,'三明');
insert into city(iProvinceId, sName) values(3,'厦门');
insert into city(iProvinceId, sName) values(3,'漳州');
insert into city(iProvinceId, sName) values(4,'白银');
insert into city(iProvinceId, sName) values(4,'定西');
insert into city(iProvinceId, sName) values(4,'甘南藏族自治州');
insert into city(iProvinceId, sName) values(4,'嘉峪关');
insert into city(iProvinceId, sName) values(4,'金昌');
insert into city(iProvinceId, sName) values(4,'酒泉');
insert into city(iProvinceId, sName) values(4,'兰州');
insert into city(iProvinceId, sName) values(4,'临夏回族自治州');
insert into city(iProvinceId, sName) values(4,'陇南');
insert into city(iProvinceId, sName) values(4,'平凉');
insert into city(iProvinceId, sName) values(4,'庆阳');
insert into city(iProvinceId, sName) values(4,'天水');
insert into city(iProvinceId, sName) values(4,'武威');
insert into city(iProvinceId, sName) values(4,'张掖');
insert into city(iProvinceId, sName) values(5,'潮州');
insert into city(iProvinceId, sName) values(5,'东莞');
insert into city(iProvinceId, sName) values(5,'佛山');
insert into city(iProvinceId, sName) values(5,'广州');
insert into city(iProvinceId, sName) values(5,'河源');
insert into city(iProvinceId, sName) values(5,'惠州');
insert into city(iProvinceId, sName) values(5,'江门');
insert into city(iProvinceId, sName) values(5,'揭阳');
insert into city(iProvinceId, sName) values(5,'茂名');
insert into city(iProvinceId, sName) values(5,'梅州');
insert into city(iProvinceId, sName) values(5,'清远');
insert into city(iProvinceId, sName) values(5,'汕头');
insert into city(iProvinceId, sName) values(5,'汕尾');
insert into city(iProvinceId, sName) values(5,'韶关');
insert into city(iProvinceId, sName) values(5,'深圳');
insert into city(iProvinceId, sName) values(5,'阳江');
insert into city(iProvinceId, sName) values(5,'云浮');
insert into city(iProvinceId, sName) values(5,'湛江');
insert into city(iProvinceId, sName) values(5,'肇庆');
insert into city(iProvinceId, sName) values(5,'中山');
insert into city(iProvinceId, sName) values(5,'珠海');
insert into city(iProvinceId, sName) values(6,'百色');
insert into city(iProvinceId, sName) values(6,'北海');
insert into city(iProvinceId, sName) values(6,'崇左');
insert into city(iProvinceId, sName) values(6,'防城港');
insert into city(iProvinceId, sName) values(6,'桂林');
insert into city(iProvinceId, sName) values(6,'贵港');
insert into city(iProvinceId, sName) values(6,'河池');
insert into city(iProvinceId, sName) values(6,'贺州');
insert into city(iProvinceId, sName) values(6,'来宾');
insert into city(iProvinceId, sName) values(6,'柳州');
insert into city(iProvinceId, sName) values(6,'南宁');
insert into city(iProvinceId, sName) values(6,'钦州');
insert into city(iProvinceId, sName) values(6,'梧州');
insert into city(iProvinceId, sName) values(6,'玉林');
insert into city(iProvinceId, sName) values(7,'安顺');
insert into city(iProvinceId, sName) values(7,'毕节');
insert into city(iProvinceId, sName) values(7,'贵阳');
insert into city(iProvinceId, sName) values(7,'六盘水');
insert into city(iProvinceId, sName) values(7,'黔东南苗族侗族自治州');
insert into city(iProvinceId, sName) values(7,'黔南布依族苗族自治州');
insert into city(iProvinceId, sName) values(7,'黔西南布依族苗族自治州');
insert into city(iProvinceId, sName) values(7,'铜仁');
insert into city(iProvinceId, sName) values(7,'遵义');
insert into city(iProvinceId, sName) values(8,'白沙黎族自治县');
insert into city(iProvinceId, sName) values(8,'保亭黎族苗族自治县');
insert into city(iProvinceId, sName) values(8,'昌江黎族自治县');
insert into city(iProvinceId, sName) values(8,'澄迈县');
insert into city(iProvinceId, sName) values(8,'定安县');
insert into city(iProvinceId, sName) values(8,'东方');
insert into city(iProvinceId, sName) values(8,'海口');
insert into city(iProvinceId, sName) values(8,'乐东黎族自治县');
insert into city(iProvinceId, sName) values(8,'临高县');
insert into city(iProvinceId, sName) values(8,'陵水黎族自治县');
insert into city(iProvinceId, sName) values(8,'琼海');
insert into city(iProvinceId, sName) values(8,'琼中黎族苗族自治县');
insert into city(iProvinceId, sName) values(8,'三亚');
insert into city(iProvinceId, sName) values(8,'屯昌县');
insert into city(iProvinceId, sName) values(8,'万宁');
insert into city(iProvinceId, sName) values(8,'文昌');
insert into city(iProvinceId, sName) values(8,'五指山');
insert into city(iProvinceId, sName) values(8,'儋州');
insert into city(iProvinceId, sName) values(9,'保定');
insert into city(iProvinceId, sName) values(9,'沧州');
insert into city(iProvinceId, sName) values(9,'承德');
insert into city(iProvinceId, sName) values(9,'邯郸');
insert into city(iProvinceId, sName) values(9,'衡水');
insert into city(iProvinceId, sName) values(9,'廊坊');
insert into city(iProvinceId, sName) values(9,'秦皇岛');
insert into city(iProvinceId, sName) values(9,'石家庄');
insert into city(iProvinceId, sName) values(9,'唐山');
insert into city(iProvinceId, sName) values(9,'邢台');
insert into city(iProvinceId, sName) values(9,'张家口');
insert into city(iProvinceId, sName) values(10,'安阳');
insert into city(iProvinceId, sName) values(10,'鹤壁');
insert into city(iProvinceId, sName) values(10,'济源');
insert into city(iProvinceId, sName) values(10,'焦作');
insert into city(iProvinceId, sName) values(10,'开封');
insert into city(iProvinceId, sName) values(10,'洛阳');
insert into city(iProvinceId, sName) values(10,'南阳');
insert into city(iProvinceId, sName) values(10,'平顶山');
insert into city(iProvinceId, sName) values(10,'三门峡');
insert into city(iProvinceId, sName) values(10,'商丘');
insert into city(iProvinceId, sName) values(10,'新乡');
insert into city(iProvinceId, sName) values(10,'信阳');
insert into city(iProvinceId, sName) values(10,'许昌');
insert into city(iProvinceId, sName) values(10,'郑州');
insert into city(iProvinceId, sName) values(10,'周口');
insert into city(iProvinceId, sName) values(10,'驻马店');
insert into city(iProvinceId, sName) values(10,'漯河');
insert into city(iProvinceId, sName) values(10,'濮阳');
insert into city(iProvinceId, sName) values(11,'大庆');
insert into city(iProvinceId, sName) values(11,'大兴安岭');
insert into city(iProvinceId, sName) values(11,'哈尔滨');
insert into city(iProvinceId, sName) values(11,'鹤岗');
insert into city(iProvinceId, sName) values(11,'黑河');
insert into city(iProvinceId, sName) values(11,'鸡西');
insert into city(iProvinceId, sName) values(11,'佳木斯');
insert into city(iProvinceId, sName) values(11,'牡丹江');
insert into city(iProvinceId, sName) values(11,'七台河');
insert into city(iProvinceId, sName) values(11,'齐齐哈尔');
insert into city(iProvinceId, sName) values(11,'双鸭山');
insert into city(iProvinceId, sName) values(11,'绥化');
insert into city(iProvinceId, sName) values(11,'伊春');
insert into city(iProvinceId, sName) values(12,'鄂州');
insert into city(iProvinceId, sName) values(12,'恩施土家族苗族自治州');
insert into city(iProvinceId, sName) values(12,'黄冈');
insert into city(iProvinceId, sName) values(12,'黄石');
insert into city(iProvinceId, sName) values(12,'荆门');
insert into city(iProvinceId, sName) values(12,'荆州');
insert into city(iProvinceId, sName) values(12,'潜江');
insert into city(iProvinceId, sName) values(12,'神农架林区');
insert into city(iProvinceId, sName) values(12,'十堰');
insert into city(iProvinceId, sName) values(12,'随州');
insert into city(iProvinceId, sName) values(12,'天门');
insert into city(iProvinceId, sName) values(12,'武汉');
insert into city(iProvinceId, sName) values(12,'仙桃');
insert into city(iProvinceId, sName) values(12,'咸宁');
insert into city(iProvinceId, sName) values(12,'襄樊');
insert into city(iProvinceId, sName) values(12,'孝感');
insert into city(iProvinceId, sName) values(12,'宜昌');
insert into city(iProvinceId, sName) values(13,'常德');
insert into city(iProvinceId, sName) values(13,'长沙');
insert into city(iProvinceId, sName) values(13,'郴州');
insert into city(iProvinceId, sName) values(13,'衡阳');
insert into city(iProvinceId, sName) values(13,'怀化');
insert into city(iProvinceId, sName) values(13,'娄底');
insert into city(iProvinceId, sName) values(13,'邵阳');
insert into city(iProvinceId, sName) values(13,'湘潭');
insert into city(iProvinceId, sName) values(13,'湘西土家族苗族自治州');
insert into city(iProvinceId, sName) values(13,'益阳');
insert into city(iProvinceId, sName) values(13,'永州');
insert into city(iProvinceId, sName) values(13,'岳阳');
insert into city(iProvinceId, sName) values(13,'张家界');
insert into city(iProvinceId, sName) values(13,'株洲');
insert into city(iProvinceId, sName) values(14,'白城');
insert into city(iProvinceId, sName) values(14,'白山');
insert into city(iProvinceId, sName) values(14,'长春');
insert into city(iProvinceId, sName) values(14,'吉林');
insert into city(iProvinceId, sName) values(14,'辽源');
insert into city(iProvinceId, sName) values(14,'四平');
insert into city(iProvinceId, sName) values(14,'松原');
insert into city(iProvinceId, sName) values(14,'通化');
insert into city(iProvinceId, sName) values(14,'延边朝鲜族自治州');
insert into city(iProvinceId, sName) values(15,'常州');
insert into city(iProvinceId, sName) values(15,'淮安');
insert into city(iProvinceId, sName) values(15,'连云港');
insert into city(iProvinceId, sName) values(15,'南京');
insert into city(iProvinceId, sName) values(15,'南通');
insert into city(iProvinceId, sName) values(15,'苏州');
insert into city(iProvinceId, sName) values(15,'宿迁');
insert into city(iProvinceId, sName) values(15,'泰州');
insert into city(iProvinceId, sName) values(15,'无锡');
insert into city(iProvinceId, sName) values(15,'徐州');
insert into city(iProvinceId, sName) values(15,'盐城');
insert into city(iProvinceId, sName) values(15,'扬州');
insert into city(iProvinceId, sName) values(15,'镇江');
insert into city(iProvinceId, sName) values(16,'抚州');
insert into city(iProvinceId, sName) values(16,'赣州');
insert into city(iProvinceId, sName) values(16,'吉安');
insert into city(iProvinceId, sName) values(16,'景德镇');
insert into city(iProvinceId, sName) values(16,'九江');
insert into city(iProvinceId, sName) values(16,'南昌');
insert into city(iProvinceId, sName) values(16,'萍乡');
insert into city(iProvinceId, sName) values(16,'上饶');
insert into city(iProvinceId, sName) values(16,'新余');
insert into city(iProvinceId, sName) values(16,'宜春');
insert into city(iProvinceId, sName) values(16,'鹰潭');
insert into city(iProvinceId, sName) values(17,'鞍山');
insert into city(iProvinceId, sName) values(17,'本溪');
insert into city(iProvinceId, sName) values(17,'朝阳');
insert into city(iProvinceId, sName) values(17,'大连');
insert into city(iProvinceId, sName) values(17,'丹东');
insert into city(iProvinceId, sName) values(17,'抚顺');
insert into city(iProvinceId, sName) values(17,'阜新');
insert into city(iProvinceId, sName) values(17,'葫芦岛');
insert into city(iProvinceId, sName) values(17,'锦州');
insert into city(iProvinceId, sName) values(17,'辽阳');
insert into city(iProvinceId, sName) values(17,'盘锦');
insert into city(iProvinceId, sName) values(17,'沈阳');
insert into city(iProvinceId, sName) values(17,'铁岭');
insert into city(iProvinceId, sName) values(17,'营口');
insert into city(iProvinceId, sName) values(18,'阿拉善盟');
insert into city(iProvinceId, sName) values(18,'巴彦淖尔盟');
insert into city(iProvinceId, sName) values(18,'包头');
insert into city(iProvinceId, sName) values(18,'赤峰');
insert into city(iProvinceId, sName) values(18,'鄂尔多斯');
insert into city(iProvinceId, sName) values(18,'呼和浩特');
insert into city(iProvinceId, sName) values(18,'呼伦贝尔');
insert into city(iProvinceId, sName) values(18,'通辽');
insert into city(iProvinceId, sName) values(18,'乌海');
insert into city(iProvinceId, sName) values(18,'乌兰察布盟');
insert into city(iProvinceId, sName) values(18,'锡林郭勒盟');
insert into city(iProvinceId, sName) values(18,'兴安盟');
insert into city(iProvinceId, sName) values(19,'固原');
insert into city(iProvinceId, sName) values(19,'石嘴山');
insert into city(iProvinceId, sName) values(19,'吴忠');
insert into city(iProvinceId, sName) values(19,'银川');
insert into city(iProvinceId, sName) values(20,'果洛藏族自治州');
insert into city(iProvinceId, sName) values(20,'海北藏族自治州');
insert into city(iProvinceId, sName) values(20,'海东');
insert into city(iProvinceId, sName) values(20,'海南藏族自治州');
insert into city(iProvinceId, sName) values(20,'海西蒙古族藏族自治州');
insert into city(iProvinceId, sName) values(20,'黄南藏族自治州');
insert into city(iProvinceId, sName) values(20,'西宁');
insert into city(iProvinceId, sName) values(20,'玉树藏族自治州');
http://blog.programfan.com/article.asp?id=28128
xml 或者html或者webservice 复制到txt即能用
我写的省市二级互联
http://www.bingtai.cn/App_data/dataXml.rar
insert into city(iProvinceId, sName) values(21,'德州');
insert into city(iProvinceId, sName) values(21,'东营');
insert into city(iProvinceId, sName) values(21,'菏泽');
insert into city(iProvinceId, sName) values(21,'济南');
insert into city(iProvinceId, sName) values(21,'济宁');
insert into city(iProvinceId, sName) values(21,'莱芜');
insert into city(iProvinceId, sName) values(21,'聊城');
insert into city(iProvinceId, sName) values(21,'临沂');
insert into city(iProvinceId, sName) values(21,'青岛');
insert into city(iProvinceId, sName) values(21,'日照');
insert into city(iProvinceId, sName) values(21,'泰安');
insert into city(iProvinceId, sName) values(21,'威海');
insert into city(iProvinceId, sName) values(21,'潍坊');
insert into city(iProvinceId, sName) values(21,'烟台');
insert into city(iProvinceId, sName) values(21,'枣庄');
insert into city(iProvinceId, sName) values(21,'淄博');
insert into city(iProvinceId, sName) values(22,'长治');
insert into city(iProvinceId, sName) values(22,'大同');
insert into city(iProvinceId, sName) values(22,'晋城');
insert into city(iProvinceId, sName) values(22,'晋中');
insert into city(iProvinceId, sName) values(22,'临汾');
insert into city(iProvinceId, sName) values(22,'吕梁');
insert into city(iProvinceId, sName) values(22,'朔州');
insert into city(iProvinceId, sName) values(22,'太原');
insert into city(iProvinceId, sName) values(22,'忻州');
insert into city(iProvinceId, sName) values(22,'阳泉');
insert into city(iProvinceId, sName) values(22,'运城');
insert into city(iProvinceId, sName) values(23,'安康');
insert into city(iProvinceId, sName) values(23,'宝鸡');
insert into city(iProvinceId, sName) values(23,'汉中');
insert into city(iProvinceId, sName) values(23,'商洛');
insert into city(iProvinceId, sName) values(23,'铜川');
insert into city(iProvinceId, sName) values(23,'渭南');
insert into city(iProvinceId, sName) values(23,'西安');
insert into city(iProvinceId, sName) values(23,'咸阳');
insert into city(iProvinceId, sName) values(23,'延安');
insert into city(iProvinceId, sName) values(23,'榆林');
insert into city(iProvinceId, sName) values(24,'上海');
insert into city(iProvinceId, sName) values(25,'阿坝藏族羌族自治州');
insert into city(iProvinceId, sName) values(25,'巴中');
insert into city(iProvinceId, sName) values(25,'成都');
insert into city(iProvinceId, sName) values(25,'达州');
insert into city(iProvinceId, sName) values(25,'德阳');
insert into city(iProvinceId, sName) values(25,'甘孜藏族自治州');
insert into city(iProvinceId, sName) values(25,'广安');
insert into city(iProvinceId, sName) values(25,'广元');
insert into city(iProvinceId, sName) values(25,'乐山');
insert into city(iProvinceId, sName) values(25,'凉山彝族自治州');
insert into city(iProvinceId, sName) values(25,'眉山');
insert into city(iProvinceId, sName) values(25,'绵阳');
insert into city(iProvinceId, sName) values(25,'南充');
insert into city(iProvinceId, sName) values(25,'内江');
insert into city(iProvinceId, sName) values(25,'攀枝花');
insert into city(iProvinceId, sName) values(25,'遂宁');
insert into city(iProvinceId, sName) values(25,'雅安');
insert into city(iProvinceId, sName) values(25,'宜宾');
insert into city(iProvinceId, sName) values(25,'资阳');
insert into city(iProvinceId, sName) values(25,'自贡');
insert into city(iProvinceId, sName) values(25,'泸州');
insert into city(iProvinceId, sName) values(26,'天津');
insert into city(iProvinceId, sName) values(27,'阿里');
insert into city(iProvinceId, sName) values(27,'昌都');
insert into city(iProvinceId, sName) values(27,'拉萨');
insert into city(iProvinceId, sName) values(27,'林芝');
insert into city(iProvinceId, sName) values(27,'那曲');
insert into city(iProvinceId, sName) values(27,'日喀则');
insert into city(iProvinceId, sName) values(27,'山南');
insert into city(iProvinceId, sName) values(28,'阿克苏');
insert into city(iProvinceId, sName) values(28,'阿拉尔');
insert into city(iProvinceId, sName) values(28,'巴音郭楞蒙古自治州');
insert into city(iProvinceId, sName) values(28,'博尔塔拉蒙古自治州');
insert into city(iProvinceId, sName) values(28,'昌吉回族自治州');
insert into city(iProvinceId, sName) values(28,'哈密');
insert into city(iProvinceId, sName) values(28,'和田');
insert into city(iProvinceId, sName) values(28,'喀什');
insert into city(iProvinceId, sName) values(28,'克拉玛依');
insert into city(iProvinceId, sName) values(28,'克孜勒苏柯尔克孜自治州');
insert into city(iProvinceId, sName) values(28,'石河子');
insert into city(iProvinceId, sName) values(28,'图木舒克');
insert into city(iProvinceId, sName) values(28,'吐鲁番');
insert into city(iProvinceId, sName) values(28,'乌鲁木齐');
insert into city(iProvinceId, sName) values(28,'五家渠');
insert into city(iProvinceId, sName) values(28,'伊犁哈萨克自治州');
insert into city(iProvinceId, sName) values(29,'保山');
insert into city(iProvinceId, sName) values(29,'楚雄彝族自治州');
insert into city(iProvinceId, sName) values(29,'大理白族自治州');
insert into city(iProvinceId, sName) values(29,'德宏傣族景颇族自治州');
insert into city(iProvinceId, sName) values(29,'迪庆藏族自治州');
insert into city(iProvinceId, sName) values(29,'红河哈尼族彝族自治州');
insert into city(iProvinceId, sName) values(29,'昆明');
insert into city(iProvinceId, sName) values(29,'丽江');
insert into city(iProvinceId, sName) values(29,'临沧');
insert into city(iProvinceId, sName) values(29,'怒江傈傈族自治州');
insert into city(iProvinceId, sName) values(29,'曲靖');
insert into city(iProvinceId, sName) values(29,'思茅');
insert into city(iProvinceId, sName) values(29,'文山壮族苗族自治州');
insert into city(iProvinceId, sName) values(29,'西双版纳傣族自治州');
insert into city(iProvinceId, sName) values(29,'玉溪');
insert into city(iProvinceId, sName) values(29,'昭通');
insert into city(iProvinceId, sName) values(30,'杭州');
insert into city(iProvinceId, sName) values(30,'湖州');
insert into city(iProvinceId, sName) values(30,'嘉兴');
insert into city(iProvinceId, sName) values(30,'金华');
insert into city(iProvinceId, sName) values(30,'丽水');
insert into city(iProvinceId, sName) values(30,'宁波');
insert into city(iProvinceId, sName) values(30,'绍兴');
insert into city(iProvinceId, sName) values(30,'台州');
insert into city(iProvinceId, sName) values(30,'温州');
insert into city(iProvinceId, sName) values(30,'舟山');
insert into city(iProvinceId, sName) values(30,'衢州');
insert into city(iProvinceId, sName) values(31,'重庆');
insert into city(iProvinceId, sName) values(32,'香港');
insert into city(iProvinceId, sName) values(33,'澳门');
insert into city(iProvinceId, sName) values(34,'台湾');全国省市表
将以上代码放入 Sql Server 查询分析器内直接执行即可生成两张表一张省表,一张市表,
其中City表内的 iProvinceId 字段与 Province 表内的 iAutoId 字段关连
=======================================给你贴个js的吧<html>
<head>
<title>js省市2级联动</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body { font-size: 14px }
-->
</style>
</head>
<body bgcolor=#FFFFFF alink=#333333 vlink=#333333 link=#333333 topmargin=0 leftmargin=0> <form action="" method=post name="creator" enctype="multipart/form-data"> <script language="javascript">
<!--
var where = new Array(35);
function comefrom(loca,locacity) { this.loca = loca; this.locacity = locacity; }
where[0]= new comefrom("请选择","请选择");
where[1] = new comefrom("北京","|东城|西城|崇文|宣武|朝阳|丰台|石景山|海淀|门头沟|房山|通州|顺义|昌平|大兴|平谷|怀柔|密云|延庆");
where[2] = new comefrom("上海","|黄浦|卢湾|徐汇|长宁|静安|普陀|闸北|虹口|杨浦|闵行|宝山|嘉定|浦东|金山|松江|青浦|南汇|奉贤|崇明");
where[3] = new comefrom("天津","|和平|东丽|河东|西青|河西|津南|南开|北辰|河北|武清|红挢|塘沽|汉沽|大港|宁河|静海|宝坻|蓟县");
where[4] = new comefrom("重庆","|万州|涪陵|渝中|大渡口|江北|沙坪坝|九龙坡|南岸|北碚|万盛|双挢|渝北|巴南|黔江|长寿|綦江|潼南|铜梁|大足|荣昌|壁山|梁平|城口|丰都|垫江|武隆|忠县|开县|云阳|奉节|巫山|巫溪|石柱|秀山|酉阳|彭水|江津|合川|永川|南川");
where[5] = new comefrom("河北","|石家庄|邯郸|邢台|保定|张家口|承德|廊坊|唐山|秦皇岛|沧州|衡水");
where[6] = new comefrom("山西","|太原|大同|阳泉|长治|晋城|朔州|吕梁|忻州|晋中|临汾|运城");
where[7] = new comefrom("内蒙古","|呼和浩特|包头|乌海|赤峰|呼伦贝尔盟|阿拉善盟|哲里木盟|兴安盟|乌兰察布盟|锡林郭勒盟|巴彦淖尔盟|伊克昭盟");
where[8] = new comefrom("辽宁","|沈阳|大连|鞍山|抚顺|本溪|丹东|锦州|营口|阜新|辽阳|盘锦|铁岭|朝阳|葫芦岛");
where[9] = new comefrom("吉林","|长春|吉林|四平|辽源|通化|白山|松原|白城|延边");
where[10] = new comefrom("黑龙江","|哈尔滨|齐齐哈尔|牡丹江|佳木斯|大庆|绥化|鹤岗|鸡西|黑河|双鸭山|伊春|七台河|大兴安岭");
where[11] = new comefrom("江苏","|南京|镇江|苏州|南通|扬州|盐城|徐州|连云港|常州|无锡|宿迁|泰州|淮安");
where[12] = new comefrom("浙江","|杭州|宁波|温州|嘉兴|湖州|绍兴|金华|衢州|舟山|台州|丽水");
where[13] = new comefrom("安徽","|合肥|芜湖|蚌埠|马鞍山|淮北|铜陵|安庆|黄山|滁州|宿州|池州|淮南|巢湖|阜阳|六安|宣城|亳州");
where[14] = new comefrom("福建","|福州|厦门|莆田|三明|泉州|漳州|南平|龙岩|宁德");
where[15] = new comefrom("江西","|南昌市|景德镇|九江|鹰潭|萍乡|新馀|赣州|吉安|宜春|抚州|上饶");
where[16] = new comefrom("山东","|济南|青岛|淄博|枣庄|东营|烟台|潍坊|济宁|泰安|威海|日照|莱芜|临沂|德州|聊城|滨州|菏泽");
where[17] = new comefrom("河南","|郑州|开封|洛阳|平顶山|安阳|鹤壁|新乡|焦作|濮阳|许昌|漯河|三门峡|南阳|商丘|信阳|周口|驻马店|济源");
where[18] = new comefrom("湖北","|武汉|宜昌|荆州|襄樊|黄石|荆门|黄冈|十堰|恩施|潜江|天门|仙桃|随州|咸宁|孝感|鄂州");
where[19] = new comefrom("湖南","|长沙|常德|株洲|湘潭|衡阳|岳阳|邵阳|益阳|娄底|怀化|郴州|永州|湘西|张家界");
where[20] = new comefrom("广东","|广州|深圳|珠海|汕头|东莞|中山|佛山|韶关|江门|湛江|茂名|肇庆|惠州|梅州|汕尾|河源|阳江|清远|潮州|揭阳|云浮");
where[21] = new comefrom("广西","|南宁|柳州|桂林|梧州|北海|防城港|钦州|贵港|玉林|南宁地区|柳州地区|贺州|百色|河池");
where[22] = new comefrom("海南","|海口|三亚");
where[23] = new comefrom("四川","|成都|绵阳|德阳|自贡|攀枝花|广元|内江|乐山|南充|宜宾|广安|达川|雅安|眉山|甘孜|凉山|泸州");
where[24] = new comefrom("贵州","|贵阳|六盘水|遵义|安顺|铜仁|黔西南|毕节|黔东南|黔南");
where[25] = new comefrom("云南","|昆明|大理|曲靖|玉溪|昭通|楚雄|红河|文山|思茅|西双版纳|保山|德宏|丽江|怒江|迪庆|临沧");
where[26] = new comefrom("西藏","|拉萨|日喀则|山南|林芝|昌都|阿里|那曲");
where[27] = new comefrom("陕西","|西安|宝鸡|咸阳|铜川|渭南|延安|榆林|汉中|安康|商洛");
where[28] = new comefrom("甘肃","|兰州|嘉峪关|金昌|白银|天水|酒泉|张掖|武威|定西|陇南|平凉|庆阳|临夏|甘南");
where[29] = new comefrom("宁夏","|银川|石嘴山|吴忠|固原");
where[30] = new comefrom("青海","|西宁|海东|海南|海北|黄南|玉树|果洛|海西");
where[31] = new comefrom("新疆","|乌鲁木齐|石河子|克拉玛依|伊犁|巴音郭勒|昌吉|克孜勒苏柯尔克孜|博尔塔拉|吐鲁番|哈密|喀什|和田|阿克苏");
where[32] = new comefrom("香港","");
where[33] = new comefrom("澳门","");
where[34] = new comefrom("台湾","|台北|高雄|台中|台南|屏东|南投|云林|新竹|彰化|苗栗|嘉义|花莲|桃园|宜兰|基隆|台东|金门|马祖|澎湖");
where[35] = new comefrom("其它","|北美洲|南美洲|亚洲|非洲|欧洲|大洋洲");
function select() {
with(document.creator.province) { var loca2 = options[selectedIndex].value; }
for(i = 0;i < where.length;i ++) {
if (where[i].loca == loca2) {
loca3 = (where[i].locacity).split("|");
for(j = 0;j < loca3.length;j++) { with(document.creator.city) { length = loca3.length; options[j].text = loca3[j]; options[j].value = loca3[j]; var loca4=options[selectedIndex].value;}}
break;
}}
document.creator.newlocation.value=loca2+loca4;
}
function init() {
with(document.creator.province) {
length = where.length;
for(k=0;k<where.length;k++) { options[k].text = where[k].loca; options[k].value = where[k].loca; }
options[selectedIndex].text = where[0].loca; options[selectedIndex].value = where[0].loca;
}
with(document.creator.city) {
loca3 = (where[0].locacity).split("|");
length = loca3.length;
for(l=0;l<length;l++) { options[l].text = loca3[l]; options[l].value = loca3[l]; }
options[selectedIndex].text = loca3[0]; options[selectedIndex].value = loca3[0];
}}
-->
</script>
<body onload="init()">
<font color=#000000><b>来自:</b>
省份 <select name="province" onChange = "select()"></select> 城市 <select name="city" onChange = "select()"></select>
我在 <input type=text name="newlocation" maxlength=12 size=12 style="font-weight: bold">
</form>