免费的天气API相关应用（附中国城市代码检索）

免费的天气API相关应用（附中国城市代码检索）

序言

天气预报，在如今信息化的时代好像没那么多人关注了。但是往往在一些后台管理系统中，还会穿插着天气的相关信息。那么如何去实现天气预报的功能呢？在市面上会有一些收费的天气接口，接口文档繁杂。也有一些免费的接口，但是需要自己收集城市编码。今天给大家带来的是国家气象局提供的接口，搭配博主自己整合好的城市编码，写出一个属于自己的天气预报小功能。

环境

SpringBoot+ MySQL5.7

中国的城市编码集及相关检索功能

1.首先，我们需要在数据库中创建一张city表。用于存储我们的城市编码。表结构如下：

2.在数据库建表成功之后，我们在数据库导入数据：

INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (1,'北京','北京','101010100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (2,'北京','朝阳','101010300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (3,'北京','顺义','101010400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (4,'北京','怀柔','101010500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (5,'北京','通州','101010600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (6,'北京','昌平','101010700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (7,'北京','延庆','101010800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (8,'北京','丰台','101010900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (9,'北京','石景山','101011000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (10,'北京','大兴','101011100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (11,'北京','房山','101011200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (12,'北京','密云','101011300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (13,'北京','门头沟','101011400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (14,'北京','平谷','101011500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (15,'北京','八达岭','101011600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (16,'北京','佛爷顶','101011700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (17,'北京','汤河口','101011800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (18,'北京','密云上甸子','101011900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (19,'北京','斋堂','101012000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (20,'北京','霞云岭','101012100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (21,'北京','北京城区','101012200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (22,'北京','海淀','101010200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (23,'天津市','天津','101030100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (24,'天津市','宝坻','101030300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (25,'天津市','东丽','101030400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (26,'天津市','西青','101030500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (27,'天津市','北辰','101030600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (28,'天津市','蓟县','101031400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (29,'天津市','汉沽','101030800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (30,'天津市','静海','101030900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (31,'天津市','津南','101031000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (32,'天津市','塘沽','101031100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (33,'天津市','大港','101031200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (34,'天津市','武清','101030200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (35,'天津市','宁河','101030700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (36,'上海','上海','101020100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (37,'上海','宝山','101020300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (38,'上海','嘉定','101020500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (39,'上海','南汇','101020600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (40,'上海','浦东','101021300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (41,'上海','青浦','101020800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (42,'上海','松江','101020900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (43,'上海','奉贤','101021000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (44,'上海','崇明','101021100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (45,'上海','徐家汇','101021200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (46,'上海','闵行','101020200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (47,'上海','金山','101020700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (48,'河北','石家庄','101090101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (49,'河北','张家口','101090301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (50,'河北','承德','101090402');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (51,'河北','唐山','101090501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (52,'河北','秦皇岛','101091101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (53,'河北','沧州','101090701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (54,'河北','衡水','101090801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (55,'河北','邢台','101090901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (56,'河北','邯郸','101091001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (57,'河北','保定','101090201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (58,'河北','廊坊','101090601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (59,'河南','郑州','101180101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (60,'河南','新乡','101180301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (61,'河南','许昌','101180401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (62,'河南','平顶山','101180501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (63,'河南','信阳','101180601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (64,'河南','南阳','101180701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (65,'河南','开封','101180801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (66,'河南','洛阳','101180901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (67,'河南','商丘','101181001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (68,'河南','焦作','101181101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (69,'河南','鹤壁','101181201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (70,'河南','濮阳','101181301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (71,'河南','周口','101181401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (72,'河南','漯河','101181501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (73,'河南','驻马店','101181601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (74,'河南','三门峡','101181701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (75,'河南','济源','101181801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (76,'河南','安阳','101180201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (77,'安徽','合肥','101220101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (78,'安徽','芜湖','101220301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (79,'安徽','淮南','101220401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (80,'安徽','马鞍山','101220501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (81,'安徽','安庆','101220601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (82,'安徽','宿州','101220701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (83,'安徽','阜阳','101220801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (84,'安徽','亳州','101220901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (85,'安徽','黄山','101221001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (86,'安徽','滁州','101221101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (87,'安徽','淮北','101221201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (88,'安徽','铜陵','101221301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (89,'安徽','宣城','101221401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (90,'安徽','六安','101221501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (91,'安徽','巢湖','101221601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (92,'安徽','池州','101221701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (93,'安徽','蚌埠','101220201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (94,'浙江','杭州','101210101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (95,'浙江','舟山','101211101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (96,'浙江','湖州','101210201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (97,'浙江','嘉兴','101210301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (98,'浙江','金华','101210901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (99,'浙江','绍兴','101210501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (100,'浙江','台州','101210601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (101,'浙江','温州','101210701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (102,'浙江','丽水','101210801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (103,'浙江','衢州','101211001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (104,'浙江','宁波','101210401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (105,'重庆','重庆','101040100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (106,'重庆','合川','101040300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (107,'重庆','南川','101040400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (108,'重庆','江津','101040500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (109,'重庆','万盛','101040600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (110,'重庆','渝北','101040700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (111,'重庆','北碚','101040800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (112,'重庆','巴南','101040900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (113,'重庆','长寿','101041000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (114,'重庆','黔江','101041100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (115,'重庆','万州天城','101041200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (116,'重庆','万州龙宝','101041300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (117,'重庆','涪陵','101041400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (118,'重庆','开县','101041500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (119,'重庆','城口','101041600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (120,'重庆','云阳','101041700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (121,'重庆','巫溪','101041800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (122,'重庆','奉节','101041900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (123,'重庆','巫山','101042000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (124,'重庆','潼南','101042100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (125,'重庆','垫江','101042200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (126,'重庆','梁平','101042300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (127,'重庆','忠县','101042400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (128,'重庆','石柱','101042500');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (129,'重庆','大足','101042600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (130,'重庆','荣昌','101042700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (131,'重庆','铜梁','101042800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (132,'重庆','璧山','101042900');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (133,'重庆','丰都','101043000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (134,'重庆','武隆','101043100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (135,'重庆','彭水','101043200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (136,'重庆','綦江','101043300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (137,'重庆','酉阳','101043400');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (138,'重庆','秀山','101043600');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (139,'重庆','沙坪坝','101043700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (140,'重庆','永川','101040200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (141,'福建','福州','101230101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (142,'福建','泉州','101230501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (143,'福建','漳州','101230601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (144,'福建','龙岩','101230701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (145,'福建','晋江','101230509');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (146,'福建','南平','101230901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (147,'福建','厦门','101230201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (148,'福建','宁德','101230301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (149,'福建','莆田','101230401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (150,'福建','三明','101230801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (151,'甘肃','兰州','101160101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (152,'甘肃','平凉','101160301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (153,'甘肃','庆阳','101160401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (154,'甘肃','武威','101160501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (155,'甘肃','金昌','101160601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (156,'甘肃','嘉峪关','101161401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (157,'甘肃','酒泉','101160801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (158,'甘肃','天水','101160901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (159,'甘肃','武都','101161001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (160,'甘肃','临夏','101161101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (161,'甘肃','合作','101161201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (162,'甘肃','白银','101161301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (163,'甘肃','定西','101160201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (164,'甘肃','张掖','101160701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (165,'广东','广州','101280101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (166,'广东','惠州','101280301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (167,'广东','梅州','101280401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (168,'广东','汕头','101280501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (169,'广东','深圳','101280601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (170,'广东','珠海','101280701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (171,'广东','佛山','101280800');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (172,'广东','肇庆','101280901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (173,'广东','湛江','101281001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (174,'广东','江门','101281101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (175,'广东','河源','101281201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (176,'广东','清远','101281301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (177,'广东','云浮','101281401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (178,'广东','潮州','101281501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (179,'广东','东莞','101281601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (180,'广东','中山','101281701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (181,'广东','阳江','101281801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (182,'广东','揭阳','101281901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (183,'广东','茂名','101282001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (184,'广东','汕尾','101282101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (185,'广东','韶关','101280201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (186,'广西','南宁','101300101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (187,'广西','柳州','101300301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (188,'广西','来宾','101300401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (189,'广西','桂林','101300501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (190,'广西','梧州','101300601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (191,'广西','防城港','101301401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (192,'广西','贵港','101300801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (193,'广西','玉林','101300901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (194,'广西','百色','101301001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (195,'广西','钦州','101301101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (196,'广西','河池','101301201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (197,'广西','北海','101301301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (198,'广西','崇左','101300201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (199,'广西','贺州','101300701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (200,'贵州','贵阳','101260101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (201,'贵州','安顺','101260301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (202,'贵州','都匀','101260401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (203,'贵州','兴义','101260906');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (204,'贵州','铜仁','101260601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (205,'贵州','毕节','101260701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (206,'贵州','六盘水','101260801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (207,'贵州','遵义','101260201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (208,'贵州','凯里','101260501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (209,'云南','昆明','101290101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (210,'云南','红河','101290301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (211,'云南','文山','101290601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (212,'云南','玉溪','101290701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (213,'云南','楚雄','101290801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (214,'云南','普洱','101290901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (215,'云南','昭通','101291001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (216,'云南','临沧','101291101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (217,'云南','怒江','101291201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (218,'云南','香格里拉','101291301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (219,'云南','丽江','101291401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (220,'云南','德宏','101291501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (221,'云南','景洪','101291601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (222,'云南','大理','101290201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (223,'云南','曲靖','101290401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (224,'云南','保山','101290501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (225,'内蒙古','呼和浩特','101080101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (226,'内蒙古','乌海','101080301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (227,'内蒙古','集宁','101080401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (228,'内蒙古','通辽','101080501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (229,'内蒙古','阿拉善左旗','101081201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (230,'内蒙古','鄂尔多斯','101080701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (231,'内蒙古','临河','101080801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (232,'内蒙古','锡林浩特','101080901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (233,'内蒙古','呼伦贝尔','101081000');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (234,'内蒙古','乌兰浩特','101081101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (235,'内蒙古','包头','101080201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (236,'内蒙古','赤峰','101080601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (237,'江西','南昌','101240101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (238,'江西','上饶','101240301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (239,'江西','抚州','101240401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (240,'江西','宜春','101240501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (241,'江西','鹰潭','101241101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (242,'江西','赣州','101240701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (243,'江西','景德镇','101240801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (244,'江西','萍乡','101240901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (245,'江西','新余','101241001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (246,'江西','九江','101240201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (247,'江西','吉安','101240601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (248,'湖北','武汉','101200101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (249,'湖北','黄冈','101200501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (250,'湖北','荆州','101200801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (251,'湖北','宜昌','101200901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (252,'湖北','恩施','101201001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (253,'湖北','十堰','101201101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (254,'湖北','神农架','101201201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (255,'湖北','随州','101201301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (256,'湖北','荆门','101201401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (257,'湖北','天门','101201501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (258,'湖北','仙桃','101201601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (259,'湖北','潜江','101201701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (260,'湖北','襄樊','101200201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (261,'湖北','鄂州','101200301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (262,'湖北','孝感','101200401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (263,'湖北','黄石','101200601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (264,'湖北','咸宁','101200701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (265,'四川','成都','101270101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (266,'四川','自贡','101270301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (267,'四川','绵阳','101270401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (268,'四川','南充','101270501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (269,'四川','达州','101270601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (270,'四川','遂宁','101270701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (271,'四川','广安','101270801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (272,'四川','巴中','101270901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (273,'四川','泸州','101271001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (274,'四川','宜宾','101271101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (275,'四川','内江','101271201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (276,'四川','资阳','101271301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (277,'四川','乐山','101271401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (278,'四川','眉山','101271501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (279,'四川','凉山','101271601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (280,'四川','雅安','101271701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (281,'四川','甘孜','101271801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (282,'四川','阿坝','101271901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (283,'四川','德阳','101272001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (284,'四川','广元','101272101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (285,'四川','攀枝花','101270201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (286,'宁夏','银川','101170101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (287,'宁夏','中卫','101170501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (288,'宁夏','固原','101170401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (289,'宁夏','石嘴山','101170201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (290,'宁夏','吴忠','101170301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (291,'青海省','西宁','101150101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (292,'青海省','黄南','101150301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (293,'青海省','海北','101150801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (294,'青海省','果洛','101150501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (295,'青海省','玉树','101150601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (296,'青海省','海西','101150701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (297,'青海省','海东','101150201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (298,'青海省','海南','101150401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (299,'山东','济南','101120101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (300,'山东','潍坊','101120601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (301,'山东','临沂','101120901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (302,'山东','菏泽','101121001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (303,'山东','滨州','101121101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (304,'山东','东营','101121201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (305,'山东','威海','101121301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (306,'山东','枣庄','101121401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (307,'山东','日照','101121501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (308,'山东','莱芜','101121601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (309,'山东','聊城','101121701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (310,'山东','青岛','101120201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (311,'山东','淄博','101120301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (312,'山东','德州','101120401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (313,'山东','烟台','101120501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (314,'山东','济宁','101120701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (315,'山东','泰安','101120801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (316,'陕西省','西安','101110101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (317,'陕西省','延安','101110300');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (318,'陕西省','榆林','101110401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (319,'陕西省','铜川','101111001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (320,'陕西省','商洛','101110601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (321,'陕西省','安康','101110701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (322,'陕西省','汉中','101110801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (323,'陕西省','宝鸡','101110901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (324,'陕西省','咸阳','101110200');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (325,'陕西省','渭南','101110501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (326,'山西','太原','101100101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (327,'山西','临汾','101100701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (328,'山西','运城','101100801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (329,'山西','朔州','101100901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (330,'山西','忻州','101101001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (331,'山西','长治','101100501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (332,'山西','大同','101100201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (333,'山西','阳泉','101100301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (334,'山西','晋中','101100401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (335,'山西','晋城','101100601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (336,'山西','吕梁','101101100');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (337,'新疆','乌鲁木齐','101130101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (338,'新疆','石河子','101130301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (339,'新疆','昌吉','101130401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (340,'新疆','吐鲁番','101130501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (341,'新疆','库尔勒','101130601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (342,'新疆','阿拉尔','101130701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (343,'新疆','阿克苏','101130801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (344,'新疆','喀什','101130901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (345,'新疆','伊宁','101131001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (346,'新疆','塔城','101131101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (347,'新疆','哈密','101131201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (348,'新疆','和田','101131301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (349,'新疆','阿勒泰','101131401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (350,'新疆','阿图什','101131501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (351,'新疆','博乐','101131601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (352,'新疆','克拉玛依','101130201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (353,'西藏','拉萨','101140101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (354,'西藏','山南','101140301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (355,'西藏','阿里','101140701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (356,'西藏','昌都','101140501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (357,'西藏','那曲','101140601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (358,'西藏','日喀则','101140201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (359,'西藏','林芝','101140401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (360,'台湾','台北县','101340101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (361,'台湾','高雄','101340201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (362,'台湾','台中','101340401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (363,'海南省','海口','101310101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (364,'海南省','三亚','101310201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (365,'海南省','东方','101310202');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (366,'海南省','临高','101310203');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (367,'海南省','澄迈','101310204');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (368,'海南省','儋州','101310205');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (369,'海南省','昌江','101310206');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (370,'海南省','白沙','101310207');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (371,'海南省','琼中','101310208');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (372,'海南省','定安','101310209');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (373,'海南省','屯昌','101310210');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (374,'海南省','琼海','101310211');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (375,'海南省','文昌','101310212');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (376,'海南省','保亭','101310214');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (377,'海南省','万宁','101310215');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (378,'海南省','陵水','101310216');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (379,'海南省','西沙','101310217');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (380,'海南省','南沙岛','101310220');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (381,'海南省','乐东','101310221');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (382,'海南省','五指山','101310222');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (383,'海南省','琼山','101310102');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (384,'湖南','长沙','101250101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (385,'湖南','株洲','101250301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (386,'湖南','衡阳','101250401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (387,'湖南','郴州','101250501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (388,'湖南','常德','101250601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (389,'湖南','益阳','101250700');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (390,'湖南','娄底','101250801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (391,'湖南','邵阳','101250901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (392,'湖南','岳阳','101251001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (393,'湖南','张家界','101251101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (394,'湖南','怀化','101251201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (395,'湖南','黔阳','101251301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (396,'湖南','永州','101251401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (397,'湖南','吉首','101251501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (398,'湖南','湘潭','101250201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (399,'江苏','南京','101190101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (400,'江苏','镇江','101190301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (401,'江苏','苏州','101190401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (402,'江苏','南通','101190501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (403,'江苏','扬州','101190601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (404,'江苏','宿迁','101191301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (405,'江苏','徐州','101190801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (406,'江苏','淮安','101190901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (407,'江苏','连云港','101191001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (408,'江苏','常州','101191101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (409,'江苏','泰州','101191201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (410,'江苏','无锡','101190201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (411,'江苏','盐城','101190701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (412,'黑龙江','哈尔滨','101050101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (413,'黑龙江','牡丹江','101050301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (414,'黑龙江','佳木斯','101050401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (415,'黑龙江','绥化','101050501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (416,'黑龙江','黑河','101050601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (417,'黑龙江','双鸭山','101051301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (418,'黑龙江','伊春','101050801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (419,'黑龙江','大庆','101050901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (420,'黑龙江','七台河','101051002');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (421,'黑龙江','鸡西','101051101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (422,'黑龙江','鹤岗','101051201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (423,'黑龙江','齐齐哈尔','101050201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (424,'黑龙江','大兴安岭','101050701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (425,'吉林','长春','101060101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (426,'吉林','延吉','101060301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (427,'吉林','四平','101060401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (428,'吉林','白山','101060901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (429,'吉林','白城','101060601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (430,'吉林','辽源','101060701');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (431,'吉林','松原','101060801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (432,'吉林','吉林','101060201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (433,'吉林','通化','101060501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (434,'辽宁','沈阳','101070101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (435,'辽宁','鞍山','101070301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (436,'辽宁','抚顺','101070401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (437,'辽宁','本溪','101070501');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (438,'辽宁','丹东','101070601');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (439,'辽宁','葫芦岛','101071401');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (440,'辽宁','营口','101070801');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (441,'辽宁','阜新','101070901');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (442,'辽宁','辽阳','101071001');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (443,'辽宁','铁岭','101071101');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (444,'辽宁','朝阳','101071201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (445,'辽宁','盘锦','101071301');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (446,'辽宁','大连','101070201');
INSERT INTO `city` (`id`,`province`,`city`,`code`) VALUES (447,'辽宁','锦州','101070701');

3.执行完上面的SQL，我们就将中国城市编码导入数据库

4.模糊查询，找到需要的城市编码（此步可以按需要修改，也可修改成联级查询）

 @Resource
    private CityMapper cityMapper;

    public List<City> selectCity(String name){
        Example example = new Example(City.class);
        example.createCriteria().andLike("city","%"+name+"%");
        List<City> cities = cityMapper.selectByExample(example);
        return cities;
    }


@RequestMapping("/selectCity")
    public List<City> selectCity( String name){
        return  testService.selectCity(name);
    }

结果：

天气接口的应用

我们查询到自己需要的城市编码后，将城市编码拼接到气象局提供的接口后面，发送ajax请求后获得该地区未来七天的天气

http://t.weather.sojson.com/api/weather/city/{城市编码}

例：查询北京城区的天气 用上述接口可以查询到北京城区的城市编码为：101012200

http://t.weather.sojson.com/api/weather/city/101080201

结果：

{
    "message": "success感谢又拍云(upyun.com)提供CDN赞助",
    "status": 200,
    "date": "20191204",
    "time": "2019-12-04 11:29:02",
    "cityInfo": {
        "city": "包头市",
        "citykey": "101080201",
        "parent": "内蒙古",
        "updateTime": "11:03"
    },
    "data": {
        "shidu": "58%",
        "pm25": 38,
        "pm10": 70,
        "quality": "良",
        "wendu": "-7",
        "ganmao": "极少数敏感人群应减少户外活动",
        "forecast": [
            {
                "date": "04",
                "high": "高温 1℃",
                "low": "低温 -13℃",
                "ymd": "2019-12-04",
                "week": "星期三",
                "sunrise": "07:46",
                "sunset": "17:14",
                "aqi": 55,
                "fx": "北风",
                "fl": "3-4级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "05",
                "high": "高温 0℃",
                "low": "低温 -14℃",
                "ymd": "2019-12-05",
                "week": "星期四",
                "sunrise": "07:47",
                "sunset": "17:14",
                "aqi": 48,
                "fx": "西南风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "06",
                "high": "高温 1℃",
                "low": "低温 -13℃",
                "ymd": "2019-12-06",
                "week": "星期五",
                "sunrise": "07:48",
                "sunset": "17:13",
                "aqi": 43,
                "fx": "西风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "07",
                "high": "高温 2℃",
                "low": "低温 -13℃",
                "ymd": "2019-12-07",
                "week": "星期六",
                "sunrise": "07:49",
                "sunset": "17:13",
                "aqi": 59,
                "fx": "西南风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "08",
                "high": "高温 2℃",
                "low": "低温 -10℃",
                "ymd": "2019-12-08",
                "week": "星期日",
                "sunrise": "07:50",
                "sunset": "17:13",
                "aqi": 64,
                "fx": "西南风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "09",
                "high": "高温 0℃",
                "low": "低温 -9℃",
                "ymd": "2019-12-09",
                "week": "星期一",
                "sunrise": "07:51",
                "sunset": "17:13",
                "aqi": 55,
                "fx": "北风",
                "fl": "3-4级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "10",
                "high": "高温 -2℃",
                "low": "低温 -11℃",
                "ymd": "2019-12-10",
                "week": "星期二",
                "sunrise": "07:52",
                "sunset": "17:13",
                "fx": "北风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "11",
                "high": "高温 -1℃",
                "low": "低温 -9℃",
                "ymd": "2019-12-11",
                "week": "星期三",
                "sunrise": "07:53",
                "sunset": "17:13",
                "fx": "北风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "12",
                "high": "高温 0℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-12",
                "week": "星期四",
                "sunrise": "07:54",
                "sunset": "17:13",
                "fx": "西南风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "13",
                "high": "高温 0℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-13",
                "week": "星期五",
                "sunrise": "07:55",
                "sunset": "17:14",
                "fx": "北风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "14",
                "high": "高温 -1℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-14",
                "week": "星期六",
                "sunrise": "07:55",
                "sunset": "17:14",
                "fx": "西南风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "15",
                "high": "高温 -1℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-15",
                "week": "星期日",
                "sunrise": "07:56",
                "sunset": "17:14",
                "fx": "西南风",
                "fl": "<3级",
                "type": "多云",
                "notice": "阴晴之间，谨防紫外线侵扰"
            },
            {
                "date": "16",
                "high": "高温 -2℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-16",
                "week": "星期一",
                "sunrise": "07:57",
                "sunset": "17:14",
                "fx": "西北风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            },
            {
                "date": "17",
                "high": "高温 -2℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-17",
                "week": "星期二",
                "sunrise": "07:58",
                "sunset": "17:14",
                "fx": "西南风",
                "fl": "<3级",
                "type": "多云",
                "notice": "阴晴之间，谨防紫外线侵扰"
            },
            {
                "date": "18",
                "high": "高温 -3℃",
                "low": "低温 -8℃",
                "ymd": "2019-12-18",
                "week": "星期三",
                "sunrise": "07:58",
                "sunset": "17:15",
                "fx": "西风",
                "fl": "<3级",
                "type": "晴",
                "notice": "愿你拥有比阳光明媚的心情"
            }
        ],
        "yesterday": {
            "date": "03",
            "high": "高温 0℃",
            "low": "低温 -14℃",
            "ymd": "2019-12-03",
            "week": "星期二",
            "sunrise": "07:45",
            "sunset": "17:14",
            "aqi": 77,
            "fx": "西风",
            "fl": "3-4级",
            "type": "晴",
            "notice": "愿你拥有比阳光明媚的心情"
        }
    }
}

总结

看了上面的讲解，编写一个简单的天气预报功能是不是很容易。将请求到的数据渲染到页面上，天气预报的功能就完成了，赶紧试试吧。