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

本文链接：https://blog.youkuaiyun.com/Lowsay/article/details/103386531

免费的天气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`,`