The
has recently been making a weather report module, first of all, we need to convert the client network IP into the city, then the city name to the corresponding city code, found the city code on the Internet, but need to deal with, looked at, there are more than 300 cities and corresponding city code, want to save to the database. Just want to do a data processing automatic generation of SQL statements tool, improve efficiency.
Municipality "Beijing", "Shanghai", "Tianjin", "Chongqing" "101010100", "101020100", "101030100", "101040100" Special Administrative Region "Hong Kong", "Macao" "101320101", "101330101" Heilongjiang "Harbin", "Qiqihar", "Mudanjiang", "Daqing", "Yichun", "Shuangyashan", "Hegang", "Jixi", "Jiamusi", "Qitaihe", "Heihe", "Suihua", "Daxing ' anling" "101050101", " 101050201 "," 101050301 "," 101050901 "," 101050801&q uot;, "101051301", "101051201", "101051101", "101050401", "
101051 002 "," 101050601 "," 101050501 "," 101050701 "Jilin" Changchun "," Yanji "," Jilin "," Bss "," Baicheng "," Siping "," Songyuan "," Liaoyuan "," Da-an "," Tonghua " "101060101", "101060301", "101060201", "101060901", "101060601&q uot;," 101060401 "," 101060801 "," 101060701 ","
101060603 "," 101060 501 "Liaoning" Shenyang "," Dalian "," Huludao "," Panjin "," Benxi "," Fushun "," Tieling "," Liaoyang "," Yingkou "," Fuxin "," Chaoyang "," Jinzhou "," Dandong "," Anshan " "101070101", "101070201", "101071401", "101071301", "101070501&q uot;," 101070401 "," 101071101 "," 101071001 "," 101070801 "," 101070 901 "," 101071201 "," 101070701 "," 101070601 "," 101070301 "Inner Mongolia" Hohhot "," Hulunbeier "," Xilin Hot "," Baotou "," Chifeng " , "Hailaer", "Wuhai", "Ordos", "Tongliao" "101080101", "101081000", "101080901","101080201", "101080601&q Uot", "101081001", "101080301", "101080701", "101080501" Hebei "Shijiazhuang", "Tangshan", "Zhangjiakou", "Langfang", "Xingtai", "Handan", "Cangzhou", "Hengshui", "Chengde", "Baoding", "Qinhuangdao" "101090101", "101090501", "101090301", "101090601", "101090901&q uot;," 101091001 " , "101090701", "101090801", "101090402", "101090 201", "101091101" Henan "Zhengzhou", "Kaifeng", "Luoyang", "Pingdingshan", "Jiaozuo", "Hebi", "Xinxiang", "Anyang",
"Puyang", "Xuchang", "Luohe", "Sanmenxia", "Nanyang", "Shangqiu", "Xinyang", "Zhoukou", "Zhumadian" "101180101", "101180801", "101180901", "101180501", "101181101&q Uot, "101181201", "101180301", "101180201", "101181301", "101180 401", "101181501", "101181701", "101180701", " 101181001 "," 1 01180601 "," 101181401 "," 101181601 "Shandong" Jinan "," Qingdao "," Zibo "," Weihai "," Qufu "," Linyi "," Yantai "," Zaozhuang "," Liaocheng "," Jining "," Heze ", "Taian", "Sunshine", "Dongying", "Dezhou", "Binzhou", "Laiwu", "Weifang" "101120101", "101120201", "101120301", "101121301", "101120710&q uot;," 10112
0901 "," 101120501 "," 101121401 "," 101121701 "," 101120 701 "," 101121001 "," 101120801 "," 101121501 "," 101121201 "," 1
01120401 "," 101121101 "," 101121601 "," 101120601 "Shanxi "Taiyuan", "Yangquan," Jincheng "," Jinzhong "," Linfen "," Yuncheng "," Changzhi "," Shuozhou "," Xinzhou "," Datong "," Luliang "" 101100101 "," 101100301 "," 101100601 "," 101100401 "," 101100 701&q Uot, "101100801", "101100501", "101100901", "101101001", "101100 201", "101101101" Jiangsu "Nanjing", "Suzhou", "Kunshan", " Nantong "," Taicang "," Wu County "," Xuzhou, "Yixing", "Zhenjiang", "Huai", "Changshu", "Yancheng", "Taizhou", "Wuxi", "Lianyungang", "Yangzhou", "Changzhou", "Suqian" "101190101", "101190401", "101190404" , "101190501", "101190408&q uot;," 101190406 "," 101190801 "," 101190203 "," 101190301 "," 101190 901 "," 101190402 "," 101190701 "," 101191201 "," 101190201 "," 1 01191001 "," 101190601 "," 101191101 "," 101191301 "Anhui" Hefei "," Chaohu "," Bengbu "," Anqing "," Liu'an "," Chuzhou "," Ma On Shan "," Fuyang "," Xuancheng "," Tongling "," Huaibei "," Wuhu "," Bozhou "," Suzhou "," Huainan "," Chizhou "" 101220101 "," 101221601 "," 101220201 "," 101220601 "," 10 1221501&q Uot;, "101221101", "101220501", "101220801", "101221401", "101221 301", "101221201", "101220301", "
101220901 "," 101220701 "," 1 01220401 "," 101221701 "Shaanxi" Xi ' an "," Hancheng "," Ankang "," Hanzhong "," Baoji "," Xianyang "," Yulin "," Weinan "," Shangluo "," Tongchuan "," Yanan " "101110101", "101110510", "101110701", "101110801 "," 101110901&q uot;, "101110200", "101110401", "101110501", "101110601", "101111 001", "101110300" Ningxia "Yinchuan", "
Guyuan "," Zhongwei "," Shizuishan "," Wuzhong "" 101170101 "," 101170401 "," 101170501 "," 101170201 "," 101170301&q uot; " Gansu "Lanzhou", "Silver", "Qingyang", "Jiuquan", "Tianshui", "Wuwei", "Zhangye", "Gannan", "Linxia", "Pingliang", "Dingxi", "Jinchang" "101160101", "101161301", "101160401", "10116080 1 "," 101160901&q uot;, "101160501", "101160701", "101050204", "101161101", "101160 301", "101160201", "101160601" green The sea "Xining", "Sea North", "Hercynian", "Huangnan", "Fruit Luo", "Yushu", "Haidong", "Hainan" "101150101", "101150801", "101150701", "101150301", "101150501&q UO t;, "101150601", "101150201", "101150401" Hubei "Wuhan", "Yichang", "Huanggang", "Enshi", "Jingzhou", "Shennongjia", "Shiyan", "Xianning", "Xiangyang", "Xiaogan", "Suizhou", "Huangshi", "Jing Door "," Ezhou "" 101200101 "," 101200901 "," 101200501 "," 101201001 "," 101200801&q uot;, "101201201", "101201101", "101200701
"," 101200201 "," 101200 401 "," 101201301 "," 101200601 "," 101201401 "," 101200301 "Hunan" Changsha "," Shaoyang "," Changde "," Chenzhou "," Jishou "," Zhuzhou "," Loudi "," Xiangtan "," Yiyang "," Yongzhou "," Yueyang "," Hengyang "," Huaihua "," Shaoshan "," Zhangjiajie "
"101250101", "101250901", "101250601", "101250501", "101251501&q uot;," 101250301 "," 101250801 "," 101250201 "," 101250701 "," 101251 401 "," 101251001 "," 101250401 "," 101251201 "," 101250202 "," 1 01251101 "Zhejiang" Hangzhou "," Huzhou "," Jinhua "," Ningbo " , "Lishui", "Shaoxing", "Quzhou", "Jiaxing", "Taizhou", "Zhoushan", "Wenzhou" "101210101", "101210201", "101210901", "101210401", "101210801&q uot;," 10121 0501 "," 101211001 "," 101210301 "," 101210601 "," 101211 101 "," 101210701 "Jiangxi" Nanchang "," Pingxiang "," Jiujiang "," Shangrao "," Fuzhou "," Ji "," Yingtan "," Yichun "," Xinyu "," Jingdezhen "," Ganzhou "" 101240101 "," 101240901 "," 101240201 "," 101240301 "," 101240401&q uot;, "101240601", "101241101 "," 101240501 "," 101241001 "," 101240 801 "," 101240701 "Fujian" Fuzhou "," Xiamen "," Longyan "," Nanping "," Ningde "," Putian "," Quanzhou "," sanming "," Zhangzhou "" 101230101 "," 101230201 "," 101230701 "," 101230901 "," 101230301&q uot;, "101230401", "101230501", "101230801", " 101230601 "Guizhou" Guiyang "," Anshun "," Chishui "," Zunyi "," Tongren "," Liupanshui "," Bijie "," Carey "," Duyun "" 101260101 "," 101260301 "," 101260208 "," 1012 60201 "," 101260601&q uot;, "101260801", "101260701 "," 101260501 "," 101260401 "Sichuan" Chengdu "," Luzhou, "Neijiang", "Liangshan", "Aba", "Bazhong", "Guangyuan", "Leshan", "Mianyang", "Deyang", "Panzhihua", "Yaan", "Yibin", "Zigong", "Ganzi State "," Dazhou "," Ziyang "," Guang "," Suining "," Meishan "," Nanchong "" 101270101 "," 101271001 "," 101271201 "," 101271601 "," 101271901&q uot;, "10127090 1 "," 101272101 "," 101271401 "," 101270401 "," 101272 001 "," 101270201 "," 101271701 "," 101271101 "," 101270301 "," 1 01271801 " , "101270601", "101271301", "101270801", "101270701", &q uot;101271501 "," 101270501 "Guangdong" Guangzhou "," Shenzhen "," Chaozhou "," Shaoguan "," Zhan Jiang "," Huizhou "," Qingyuan "," Dongguan "," Jiangmen "," Maoming "," Zhaoqing "," Shanwei "," Heyuan "," Jieyang "," Meizhou "," Zhongshan "," Deqing "," Yangjiang "," Yunfu "," Zhuhai "," Shantou "," Foshan "" 101280101 "," 101280601 "," 101281501 "," 101280201 "," 101281001&q uot;, "101280301", "101281301", "101281601", "101281101", "101282 001", " 101280901 "," 101282101 "," 101281201 "," 101281901 "," 1 01280401 "," 101281701 "," 101280905 "," 101281801 "," 101281401 ", &q uot;101280701 "," 101280501 "," 101280800 "Guangxi" Nanning "," Guilin "," Yangshuo "," Liuzhou "," Wuzhou "," Yulin "," guiping "," Hezhou "," Qinzhou "," Guigang "," Fangchenggang "," Baise "," "Beihai", "Hechi", "Guest", "Chongzuo" "101300101", "101300501","101300510", "101300301", "101300601&q uot;," 101300901 "," 101300802 "," 101300701 "," 101301101 "," 101300 801 "," 101301401 "," 101301001 "," 101301301 "," 101301201 "," 1 01300401 "," 101300201 "Yunnan" Kunming "," Baoshan "," Chuxiong "," Dehong "," Red River "," Lincang "," Nu River "," Qujing "," Simao "," Wenshan "," Yuxi "," Zhaotong "," Lijiang "," Dali "" 101290101 "," 101290501 "," 101290801 "," 101291501 "," 101290301&q uot;, "10
1291101 "," 101291201 "," 101290401 "," 101290901 "," 101290 601 "," 101290701 "," 101291001 "," 101291401 "," 101290201 "Hainan
"Haikou", "Sanya", "Zhanzhou", "Qiongshan", "Tong", "Wenchang" "101310101", "101310201", "101310205", "101310102", "101310222&q Uot;," "101310212" Xinjiang "Urumqi", "Altay", "Aksu", "Changji", "Hami", "Hotan", "Kashi", "Karamay", "Shihezi", "Tacheng", "Korla", "Turpan", "Yining" "101130101", "101131401", "101130801", "101130401", "101131201&q uot;," 101131301 "," 101130901 "," 101130201 "," 101130301 "," 101131 101 "," 101130601 "," 101130501 "," 101131001 "Tibet" Lhasa "," Ali "," Qamdo "," Qu "," Shigatse "," Shannan "," Linzhi "" 101140101 "," 101140701 "," 10 1140501 "," 101140601 "," 101140201&q uot;, "101140301 "," 101140401 "Taiwan" Taipei "," Kaohsiung "" 101340102 "," 101340201 "City Code