1.兰州天气_兰州天气预报-兰州未来5天、7天、10天天气预报查询
2.处理数据批量生成sql插入语句
通用方法：发送0000到信息服务业务经营者的服务代码，可查询由该信息服务业务经营者提供的所有短信息服务定制情况及相应资费标准，并可以根据返回菜单进行选择退订。
通过手机发送00000到信息服务业务经营者的服务代码，一次性退订由该信息服务业务经营者提供的所有短信息服务业务
1、中国移动的移动电话用户：
有一种方法是发送00000到186201、186202、186203，需要发三次，分别退定全网短信、彩信、梦网服务。但是发短信是收费的。如果发送0000则是查询。
而以上方法只能退定全网业务，无法退定省内业务，所以必须继续下一步操作——拨打中国移动1860免费客户服务电话进行省内业务的人工退订。
如果为了省事，干脆直接拨打1860全部退订！
2、中国联通的移动电话用户
有一种方法是发送00000到5133，退定全网短信服务。但是发短信是收费的。如果发送114则是查询。
而以上方法只能退定全网业务，无法退定省内业务，所以必须继续下一步操作——拨打中国联通10010免费客户服务电话进行省内业务的人工退订。
如果为了省事，干脆直接拨打10010全部退订！
3、本地网无线接入电话（俗称“小灵通”）用户
发送0000到信息服务业务经营者的服务代码，可查询由该信息服务业务经营者提供的所有短信息服务定制情况及相应资费标准，并可以根据返回菜单进行选择退订。
拨打中国电信10000或者中国网通10060免费客户服务电话进行全部人工退订。
4、友情提醒：用户通过发送0000、00000或者114进行查询或退订，目前电信企业还向用户收取短信通信费。在短信息退订和查询方面，少数地区执行情况可能有所差异，详情请向当地电信企业的营业厅或客服电话进行咨询。
5、特别提醒：发送0000或00000到服务商代码，如果该服务商代码为点播业务号码，则可能按照点播业务进行收费，所以发送时要谨慎。建议用人工服务退订。如今年春节晚会2006号码下发的短信，2006不会收取订制业务包月费，而是按条收费的，用户回复任何内容包括0000都是按点播进行收费的。
6、备注：以上只是退订短信、彩信等服务，不包括运营商自己推行的一些业务，如彩铃、话费提醒等，退订此类业务请打电话退订。
兰州天气_兰州天气预报-兰州未来5天、7天、10天天气预报查询
1、吉林珲图们天气2、今天早上长白山下雪了吗3、墨迹天气的支持城市吉林珲图们天气
吉林图们天气预报
下辖乡镇（街道：凉水镇天气长安镇天气月宫街道天气石岘镇天气
08月31日(今天
中雨转小雨16～18℃
东风3级
空气优
09月01日(周四
小雨15～21℃
东风3-4级
空气优
09月02日(周五
小雨转阵雨17～25℃
东风3-4级
空气优
09月03日(周六
阵雨转小雨17～23℃
东风3-4级
空气优
09月04日(周日
小雨17～23℃
东风3-4级
空气优
09月05日(周一
小雨转多云18～22℃
东风1-2级
空气优
09月06日(周二
多云转小雨15～25℃
西风1-2级
空气优
今天早上长白山下雪了吗
没有。长白山脉是鸭绿江、松花江和图们江的发源地，是中国满族的发祥地和满族文化圣山，截止2022年9月3号，据查询天气预报显示，长白山早上没有下雪，只是温度有点低而已。
墨迹天气的支持城市
直辖市
北京北京朝阳通州昌平顺义怀柔大兴平谷密云延庆丰台*石景山*房山*门头沟*八达岭*佛爷顶*汤河口*密云上甸子*斋堂*霞云岭*海淀
天津天津宝坻武清宁河静海蓟县*东丽*西青*北辰汉沽*津南塘沽*大港
上海上海嘉定浦东金山松江青浦南汇奉贤崇明*宝山*徐家汇*闵行
重庆重庆黔江北碚巴南长寿合川永川江津南川綦江潼南铜梁大足荣昌璧山垫江武隆丰都城口梁平开县巫溪巫山奉节云阳忠县石柱秀山酉阳彭水*万盛*渝北*涪陵*沙坪坝*万州天城*万州龙宝
其他省份及城市
辽宁:
沈阳沈阳苏家屯新民辽中法库康平*新城子
大连大连旅顺金州瓦房店普兰店庄河长海*皮口
鞍山鞍山海城台安岫岩
抚顺抚顺清原*章党
本溪本溪本溪县桓仁*草河口
丹东丹东东港凤城宽甸*东沟
锦州锦州凌海北镇黑山义县*北宁
营口营口盖州大石桥
阜新阜新彰武
辽阳辽阳灯塔辽阳县
盘锦盘锦大洼盘山
铁岭铁岭开原西丰昌图
朝阳朝阳北票凌源建平喀左*羊山*建平县
葫芦岛葫芦岛兴城绥中建昌
吉林:
长春长春双阳九台榆树德惠农安
吉林吉林舒兰桦甸蛟河磐石永吉*烟筒山
四平四平公主岭双辽梨树伊通*孤家子
辽源辽源东丰
通化通化梅河口集安辉南通化县柳河
白山白山靖宇长白*东岗临江
白城白城洮南大安镇赉通榆
松原松原扶余长岭乾安前郭
延边延边延吉图们敦化龙井珲春和龙安图汪清*二道*松江*罗子沟
黑龙江:
哈尔滨哈尔滨呼兰双城尚志五常阿城依兰方正宾县巴彦木兰通河延寿
齐齐哈尔齐齐哈尔讷河龙江依安泰来甘南富裕克山克东拜泉
鸡西鸡西虎林密山鸡东
鹤岗鹤岗萝北绥滨
双鸭山双鸭山集贤宝清饶河
大庆大庆肇源肇州林甸*杜蒙
伊春伊春铁力嘉荫*乌伊岭*五营
佳木斯佳木斯同江富锦桦南桦川汤原抚远
七台河七台河勃利
牡丹江牡丹江穆棱绥芬河海林宁安东宁林口
黑河黑河北安五大连池嫩江逊克孙吴
绥化绥化安达肇东海伦望奎兰西青冈庆安明水绥棱
大兴安岭大兴安岭加格达奇呼玛塔河漠河*呼中*新林
河南:
郑州郑州新郑荥阳新密巩义登封中牟
开封开封杞县通许尉氏兰考
洛阳洛阳偃师孟津新安栾川嵩县汝阳宜阳洛宁伊川
平顶山平顶山舞钢汝州宝丰叶县鲁山郏县
焦作焦作沁阳孟州修武博爱武陟温县
鹤壁鹤壁浚县淇县
新乡新乡卫辉辉县获嘉原阳延津长垣封丘
安阳安阳林州汤阴内黄滑县
濮阳濮阳清丰南乐范县台前
许昌许昌禹州长葛鄢陵襄城
漯河漯河舞阳临颍
三门峡三门峡灵宝渑池卢氏
南阳南阳邓州南召方城镇平社旗唐河新野内乡西峡淅川桐柏
商丘商丘永城民权睢县宁陵柘城虞城夏邑
信阳信阳罗山光山新县商城固始潢川淮滨息县
周口周口项城扶沟西华商水沈丘郸城淮阳太康鹿邑
驻马店驻马店西平上蔡平舆正阳确山泌阳汝南遂平新蔡
济源济源
湖北:
武汉武汉黄陂新洲*江夏*蔡甸
黄石黄石大冶阳新
襄樊襄樊襄阳枣阳老河口宜城谷城保康南漳
十堰十堰郧县郧西竹山竹溪房县*丹江口
荆州石首洪湖松滋公安监利江陵荆州
宜昌宜昌宜都当阳枝江远安兴山秭归长阳五峰三峡*宜昌县*夷陵
荆门荆门京山钟祥
孝感孝感汉川安陆应城大悟云梦
黄冈黄冈麻城武穴红安罗田英山浠水蕲春黄梅
咸宁咸宁赤壁嘉鱼通城崇阳通山
随州随州广水
恩施恩施利川建始巴东宣恩咸丰来凤鹤峰
仙桃仙桃
潜江潜江
天门天门
神农架神农架
鄂州鄂州
湖南:
长沙长沙浏阳宁乡*马坡岭
株洲株洲醴陵攸县茶陵炎陵
湘潭湘潭湘乡*韶山
衡阳衡阳南岳耒阳常宁衡阳县衡南衡山衡东祁东
邵阳邵阳武冈邵东新邵邵阳县隆回洞口绥宁新宁城步
岳阳岳阳汨罗临湘华容湘阴平江
常德常德安乡汉寿临澧澧县桃源石门
张家界张家界慈利桑植
益阳益阳沅江南县桃江安化*赫山区
郴州郴州资兴桂阳宜章永兴嘉禾临武汝城桂东安仁
永州永州祁阳东安双牌道县江永宁远蓝山新田江华
怀化怀化沅陵辰溪溆浦会同麻阳新晃芷江靖州通道
娄底娄底冷水江涟源双峰新化*冷水滩
吉首吉首泸溪凤凰花垣保靖古丈永顺龙山
广西:
南宁南宁邕宁武鸣隆安马山上林宾阳横县*南宁城区
柳州柳州柳江柳城鹿寨融安融水三江
桂林桂林阳朔临桂灵川平乐兴安灌阳荔浦资源永福龙胜恭城*全州
梧州梧州岑溪苍梧藤县蒙山
北海北海合浦*涠洲岛
防城港防城上思*防城港*东兴
贺州贺县钟山昭平富川
来宾来宾象州武宣忻城金秀
贵港贵港桂平平南
玉林玉林北流容县陆川博白兴业
百色百色凌云平果西林乐业德保田林田阳靖西田东那坡隆林
河池河池宜州天峨凤山南丹东兰都安罗城巴马环江
钦州钦州灵山浦北
崇左崇左宁明扶绥龙州大新天等*凭祥
广东:
广州广州番禺花都增城从化
深圳深圳
珠海珠海斗门*黄茅洲
汕头汕头潮阳澄海南澳
韶关韶关曲江乐昌南雄始兴仁化翁源新丰乳源
佛山佛山顺德三水*南海
江门江门新会台山开平鹤山恩平上川岛
茂名茂名高州化州信宜电白
湛江湛江廉江雷州吴川遂溪徐闻
肇庆肇庆高要四会广宁怀集封开德庆
惠州惠州惠阳博罗惠东龙门
梅州梅州兴宁梅江区梅县区大埔丰顺五华平远蕉岭
汕尾汕尾陆丰海丰
河源河源紫金龙川连平和平
阳江阳江阳春
清远清远英德连州佛冈阳山连山连南
东莞东莞
中山中山
潮州潮州饶平
揭阳揭阳普宁揭西惠来
云浮云浮罗定新兴郁南
海南:
海口海口
琼山琼山
三亚三亚
文昌文昌
琼海琼海
万宁万宁
东方东方
五指山五指山
儋州儋州
临高临高
澄迈澄迈
定安定安
屯昌屯昌
昌江昌江
白沙白沙
琼中琼中
陵水陵水
保亭保亭
乐东乐东
西沙*西沙
南沙岛南沙岛
江苏:
南京南京浦口江宁六合溧水高淳*江浦
无锡无锡江阴宜兴
徐州徐州新沂邳州丰县沛县睢宁
常州常州金坛溧阳
苏州苏州常熟张家港昆山吴江太仓*吴县东山*吴县
南通南通启东如皋通州海门海安如东吕泗
连云港连云港赣榆东海灌云灌南*燕尾港*西连岛
淮安淮安楚州淮阴涟水洪泽盱眙金湖*淮阴县
盐城盐城盐都东台大丰响水滨海阜宁射阳建湖
扬州扬州仪征高邮江都宝应
镇江镇江丹徒丹阳扬中句容
泰州泰州兴化靖江泰兴姜堰
宿迁宿迁沭阳泗阳泗洪
浙江:
杭州杭州萧山余杭建德富阳临安桐庐淳安
台州台州椒江黄岩路桥临海温岭玉环天台仙居*三门*大陈*洪家
宁波宁波鄞州镇海余姚慈溪奉化宁海象山*北仑石浦*鄞县
温州温州瑞安乐清永嘉文成平阳泰顺洞头苍南
嘉兴嘉兴海宁平湖桐乡嘉善海盐
湖州湖州德清安吉长兴
绍兴绍兴诸暨上虞嵊州新昌
金华金华兰溪义乌东阳永康武义浦江磐安
衢州衢州江山常山开化龙游
舟山舟山定海普陀岱山嵊泗
丽水丽水龙泉青田缙云遂昌松阳云和庆元*景宁
江西:
南昌南昌南昌县新建安义进贤*莲塘
景德镇乐平景德镇
萍乡萍乡莲花
九江九江武宁修水永修德安星子都昌湖口彭泽庐山*瑞昌
新余新余分宜
鹰潭鹰潭贵溪余江
赣州赣州瑞金南康信丰大余上犹崇义安远龙南定南全南宁都于都兴国会昌寻乌石城
吉安吉安吉水峡江新干永丰遂川泰和万安安福永新*宁冈*井冈山*吉安县
宜春宜春丰城樟树高安奉新万载上高宜丰靖安铜鼓
抚州南城黎川南丰崇仁乐安宜黄金溪资溪东乡广昌*抚州
上饶上饶德兴上饶县广丰玉山铅山横峰弋阳余干波阳万年婺源*鄱阳
山东:
济南济南长清章丘平阴济阳商河
青岛青岛胶州即墨平度胶南莱西*崂山
淄博淄博周村博山淄川桓台高青沂源*临淄
枣庄枣庄薛城峄城台儿庄滕州
东营东营利津垦利广饶*河口
烟台烟台福山牟平龙口莱阳莱州蓬莱招远栖霞海阳长岛
潍坊潍坊青州诸城寿光安丘高密昌邑昌乐临朐
威海威海文登乳山荣成*石岛成山头
济宁济宁曲阜兖州邹城鱼台金乡嘉祥微山汶上泗水梁山
泰安泰安新泰肥城宁阳东平泰山
日照日照五莲莒县
莱芜莱芜
临沂临沂沂南郯城沂水苍山费县平邑莒南蒙阴临沭
德州德州乐陵禹城陵县宁津庆云临邑齐河平原夏津武城
聊城聊城临清阳谷莘县茌平东阿冠县高唐*朝城
滨州滨州惠民阳信无棣沾化博兴邹平
菏泽菏泽曹县单县成武巨野郓城鄄城定陶东明
安徽:
合肥合肥长丰肥西肥东
芜湖芜湖芜湖县南陵繁昌
蚌埠蚌埠怀远固镇五河
淮南淮南凤台
马鞍山马鞍山当涂
淮北淮北濉溪
铜陵铜陵
安庆安庆桐城宿松枞阳太湖怀宁岳西望江潜山
黄山黄山市*黄山区*黄山(景区屯溪休宁歙县祁门黟县
滁州滁州天长明光全椒来安定远凤阳
阜阳阜阳界首临泉颍上阜南太和
宿州宿州萧县泗县砀山灵璧
巢湖巢湖*和县*含山*庐江*无为
六安六安寿县霍山霍邱舒城金寨
亳州亳州利辛涡阳蒙城
池州池州东至石台青阳*九华山
宣城宣城宁国广德郎溪泾县旌德绩溪
福建:
福州福州福清长乐闽侯连江罗源闽清永泰平潭*福州郊区
厦门厦门同安
莆田莆田仙游*秀屿港
泉州泉州晋江南安安溪永春德化*崇武九仙山
漳州漳州龙海云霄漳浦诏安长泰东山南靖平和华安
南平南平邵武武夷山建瓯建阳顺昌浦城光泽松溪政和
龙岩龙岩漳平武平长汀永定连城上杭
三明三明永安明溪清流宁化大田尤溪沙县将乐泰宁建宁
宁德宁德福安福鼎霞浦古田屏南寿宁周宁柘荣
河北:
石家庄石家庄藁城辛集晋州新乐平山井陉栾城正定行唐灵寿高邑赵县赞皇深泽无极元氏
唐山唐山丰润丰南遵化迁安迁西滦南玉田唐海乐亭滦县
秦皇岛秦皇岛昌黎卢龙抚宁青龙*北戴河
邯郸邯郸永年曲周馆陶魏县成安大名涉县鸡泽邱县广平肥乡临漳磁县*武安*峰峰
邢台邢台南宫沙河柏乡任县清河宁晋威县隆尧临城广宗临西内邱平乡巨鹿新河南和
保定保定涿州定州安国高碑店满城阜平徐水唐县高阳容城涞源望都安新易县曲阳蠡县雄县*顺平
张家口张家口宣化康保张北阳原赤城沽源怀安怀来崇礼尚义蔚县涿鹿万全
承德承德承德县兴隆隆化平泉滦平丰宁围场宽城
沧州沧州泊头任丘黄骅河间青县献县东光海兴盐山肃宁南皮吴桥孟村*曹妃甸
廊坊廊坊霸州三河固安永清香河大城文安大厂
衡水衡水冀州深州饶阳枣强故城阜城安平武邑景县武强
山西:
太原太原太原古交区阳曲清徐娄烦*太原南郊*太原北郊
大同大同大同县天镇灵邱阳高左云广灵浑源
阳泉阳泉平定盂县
长治长治襄垣屯留平顺黎城壶关长子武乡沁县沁源*潞城
晋城晋城高平沁水陵川阳城
朔州朔州山阴应县右玉怀仁*平鲁
晋中晋中榆次介休榆社左权和顺昔阳寿阳太谷祁县平遥灵石
运城运城永济河津芮城临猗万荣新绛稷山闻喜夏县绛县平陆垣曲
忻州忻州原平定襄五台山代县繁峙宁武静乐神池五寨岢岚河曲保德偏关*五台县豆村
临汾临汾侯马霍州曲沃翼城襄汾洪洞古县安泽浮山吉县乡宁蒲县大宁永和隰县汾西
吕梁吕梁离石孝义汾阳文水中阳兴县临县方山柳林岚县交口交城石楼
内蒙古:
呼和浩特呼和浩特托克托武川和林格尔清水河土默特左旗*呼和浩特市郊区
包头包头固阳达尔罕茂明安联合旗土默特右旗*白云鄂博满都拉
乌海乌海
赤峰赤峰宁城林西喀喇沁旗巴林右旗敖汉旗阿鲁科尔沁旗翁牛特旗克什克腾旗巴林左旗*浩尔吐*宝过图*岗子*八里罕
通辽通辽开鲁科尔沁左翼中旗科尔沁左翼后旗库伦旗奈曼旗扎鲁特旗*青龙山*巴雅尔吐胡硕*高力板*舍伯吐
鄂尔多斯鄂尔多斯东胜准格尔旗乌审旗伊金霍洛旗鄂托克旗鄂托克前旗杭锦旗达拉特旗河南*乌审召*伊克乌素
呼伦贝尔呼伦贝尔海拉尔满洲里牙克石扎兰屯根河额尔古纳陈巴尔虎旗阿荣旗新巴尔虎左旗新巴尔虎右旗鄂伦春旗莫力达瓦旗鄂温克旗小二沟图里河
巴彦淖尔巴彦淖尔五原磴口杭锦后旗乌拉特中旗乌拉特前旗乌拉特后旗*海力素那仁宝力格*大佘太
乌兰察布乌兰察布丰镇兴和卓资商都凉城化德四子王旗察哈尔右翼前旗察哈尔右翼中旗察哈尔右翼后旗
锡林郭勒盟锡林浩特二连浩特多伦阿巴嘎旗西乌珠穆沁旗东乌珠穆沁旗苏尼特左旗苏尼特右旗太仆寺旗正镶白旗正兰旗镶黄旗朱日和博克图*乌拉盖
兴安盟乌兰浩特阿尔山突泉扎赉特旗科尔沁右翼中旗*霍林郭勒*索伦*胡尔勒
阿拉善盟阿拉善左旗阿拉善右旗额济纳旗拐子湖吉兰太*孪井滩*头道湖*中泉子*巴彦诺尔贡*雅布赖*乌斯太*锡林高勒
陕西:
西安西安临潼长安高陵蓝田户县周至*杨凌
铜川铜川耀县宜君
宝鸡宝鸡陈仓凤翔岐山扶风眉县陇县千阳麟游凤县太白*宝鸡县
咸阳咸阳兴平三原泾阳乾县礼泉永寿彬县长武旬邑淳化武功*杨凌
渭南渭南华阴韩城华县潼关大荔蒲城澄城白水合阳富平华山
延安延安延长延川子长安塞志丹吴起甘泉富县洛川宜川黄龙黄陵
汉中汉中南郑城固洋县西乡勉县宁强略阳镇巴留坝佛坪
榆林榆林神木府谷横山靖边定边绥德米脂佳县吴堡清涧子洲
安康安康汉阴石泉宁陕紫阳岚皋平利镇坪旬阳白河
商洛商洛洛南丹凤商南山阳镇安柞水
宁夏:
银川银川灵武永宁贺兰
石嘴山石嘴山大武口惠农平罗*陶乐石炭井
吴忠吴忠青铜峡同心盐池*韦州*麻黄山
固原固原西吉彭阳泾源隆德*六盘山
中卫中卫海原中宁*兴仁堡
甘肃:
兰州兰州永登榆中皋兰
金昌金昌永昌
白银白银靖远景泰会宁华家岭
天水天水武山甘谷清水秦安张家川*麦积*北道区
嘉峪关嘉峪关
武威武威民勤古浪天祝乌鞘岭
张掖张掖民乐山丹临泽高台肃南
平凉平凉灵台静宁崇信华亭泾川庄浪*崆峒
酒泉酒泉玉门敦煌金塔肃北*瓜州*鼎新马鬃山
庆阳庆阳西峰庆城镇原合水华池环县宁县正宁
定西定西安定通渭临洮漳县岷县渭源陇西
武都武都成县宕昌康县文县西和礼县两当徽县
临夏临夏康乐永靖广河和政东乡
合作合作临潭卓尼舟曲迭部玛曲碌曲夏河
青海:
西宁西宁湟源湟中大通
海东*海东平安乐都民和互助化隆循化冷湖
海北*海北海晏祁连刚察门源*托勒
黄南*黄南尖扎泽库河南
海南*海南共和同德贵德兴海贵南*海南
果洛*果洛玛沁班玛甘德达日久治玛多*清水河
玉树玉树杂多治多囊谦曲麻莱托托河
海西*海西格尔木德令哈乌兰都兰天峻*野牛沟*五道梁*小灶火*诺木洪茫崖大柴旦*茶卡
新疆:
乌鲁木齐乌鲁木齐*小渠子巴仑台*白杨沟*十三间房气象站*天山大西沟*乌鲁木齐牧试站*天池*蔡家湖*达坂城
克拉玛依克拉玛依
石河子*石河子*莫索湾*乌兰乌苏*炮台
阿拉尔阿拉尔
博乐*博乐精河*阿拉山口*温泉
吐鲁番吐鲁番鄯善托克逊*红柳河*吐鲁番东坎
哈密哈密伊吾巴里坤*淖毛湖
阿克苏阿克苏温宿沙雅拜城阿瓦提库车柯坪新和乌什
和田和田墨玉皮山洛浦策勒于田民丰
喀什喀什巴楚泽普伽师叶城岳普湖麦盖提英吉沙莎车塔什库尔干
阿图什阿图什阿克陶阿合奇乌恰*吐尔尕特
库尔勒库尔勒轮台尉犁若羌且末焉耆和静和硕博湖*塔中*库米什巴音布鲁克铁干里克
昌吉昌吉阜康米泉呼图壁玛纳斯奇台吉木萨尔木垒北塔山
伊宁伊宁霍城巩留新源昭苏特克斯尼勒克察布查尔*伊宁县*霍尔果斯
塔城塔城乌苏额敏沙湾托里裕民和布克赛尔*和丰
阿勒泰阿勒泰布尔津富蕴福海哈巴河青河吉木乃
四川:
成都成都新都温江都江堰彭州邛崃崇州金堂郫县新津双流蒲江大邑*崇庆*彭县*龙泉驿
自贡自贡荣县富顺
攀枝花攀枝花米易盐边*仁和
泸州泸州纳溪泸县合江叙永古蔺
德阳德阳广汉什邡绵竹中江*罗江
绵阳绵阳江油盐亭三台平武安县梓潼北川
广元广元青川旺苍剑阁苍溪
遂宁遂宁射洪蓬溪
内江内江资中隆昌威远*东兴
乐山乐山峨眉山夹江井研犍为沐川马边峨边*峨眉
南充南充阆中营山蓬安仪陇南部西充
眉山眉山仁寿彭山洪雅丹棱青神
宜宾宜宾宜宾县兴文南溪珙县长宁高县江安筠连屏山
广安广安华蓥山岳池邻水武胜
达州达州万源渠县宣汉开江大竹*达川
雅安雅安芦山石棉名山天全荥经宝兴汉源
巴中巴中南江平昌通江
资阳资阳简阳安岳乐至
阿坝*阿坝马尔康九寨沟红原汶川阿坝理县小金若尔盖黑水金川松潘壤塘茂县*南坪
甘孜甘孜康定丹巴炉霍九龙雅江新龙道孚白玉理塘德格乡城石渠稻城色达泸定巴塘得荣
凉山*凉山西昌美姑昭觉金阳甘洛布拖雷波普格宁南喜德会东越西会理盐源德昌冕宁木里
云南:
昆明昆明东川安宁呈贡晋宁富民宜良嵩明石林禄劝寻甸*河口*太华山
曲靖曲靖宣威马龙陆良师宗罗平富源会泽沾益
玉溪玉溪江川澄江通海华宁易门峨山新平元江
保山保山腾冲施甸龙陵昌宁*富宁
昭通昭通鲁甸巧家盐津大关永善绥江镇雄彝良威信
丽江*丽江永胜华坪宁蒗
普洱普洱墨江景东景谷镇沅江城孟连澜沧西盟*宁洱*镇源
临沧临沧凤庆云县永德镇康双江耿马沧源
文山文山砚山西畴麻栗坡马关丘北广南
红河红河蒙自个旧开远绿春建水石屏弥勒泸西元阳金平屏边
楚雄楚雄双柏牟定南华姚安大姚永仁元谋武定禄丰
大理大理祥云宾川弥渡永平云龙洱源剑川鹤庆漾濞南涧巍山
德宏*德宏潞西瑞丽梁河盈江陇川
怒江*怒江兰坪泸水福贡贡山*六库
香格里拉德钦香格里拉维西*中甸
贵州:
贵阳贵阳清镇开阳修文息烽*花溪*白云*乌当
六盘水六盘水水城盘县六枝
遵义遵义赤水仁怀遵义县绥阳桐梓习水凤冈正安余庆湄潭道真务川*汇川
安顺安顺普定平坝镇宁紫云关岭
铜仁铜仁德江江口思南石阡玉屏松桃印江沿河万山
毕节毕节黔西大方织金金沙赫章纳雍威宁
兴义兴义望谟兴仁普安册亨晴隆贞丰安龙
凯里凯里施秉从江锦屏镇远麻江台江天柱黄平榕江剑河三穗雷山黎平岑巩丹寨
都匀都匀福泉贵定惠水罗甸瓮安荔波龙里平塘长顺独山三都
西藏:
拉萨拉萨当雄尼木墨竹贡卡
昌都昌都类乌齐丁青八宿左贡芒康洛隆
山南山南贡嘎琼结加查隆子错那浪卡子泽当
日喀则日喀则南木林江孜定日拉孜聂拉木帕里
那曲那曲嘉黎比如安多索县班戈
阿里阿里普兰改则狮泉河申扎
林芝林芝米林察隅波密
台湾:
台北台北台北县
高雄高雄
台中台中
特区香港澳门
注：标有*的城市及地区只有未来两天的天气预报，其余有未来四天天气预报
处理数据批量生成sql插入语句
今天是2010年4月5日 星期一 二月廿一 相关地区 兰州永登榆中皋兰 兰州(Lanzhou) 城市标识征集天气社区 最新实况(08:00)雷达图>> 气温 50 -
25 -
0 -
-25 -
-50 - 8.7℃
湿度：27% 气压：848.8hPa 风向 0.8
m/s 东风 小于3级 相关数据 今日日出日落时间 06:45 | 19:29 明日日出日落时间 06:44 | 19:30 邮政编码 730000 兰州天气预报(2010-04-05 08:00发布) 查看未来4-7天天气预报 天气图例 日期天气现象气温风向风力5日星期一白天晴高温 18℃ 无持续风向 微风 夜间晴低温 6℃ 无持续风向 微风 6日星期二白天晴高温 17℃ 无持续风向 微风 夜间晴低温 6℃ 无持续风向 微风 7日星期三白天晴高温 19℃ 无持续风向 微风 夜间晴低温 6℃ 无持续风向 微风 未来4-7天天气预报（2010-04-04 18:00发布） 仅供参考 8日星期四白天晴高温 24℃ 无持续风向 微风 夜间多云低温 8℃ 无持续风向 微风 9日星期五白天多云高温 18℃ 西北风 3-4级 夜间多云低温 6℃ 西北风 3-4级 10日星期六白天多云高温 20℃ 无持续风向 微风 夜间晴低温 7℃ 无持续风向 微风 11日星期日白天晴高温 22℃ 无持续风向 微风 周边地区今日天气(2010-04-05 08:00发布) 西宁12℃/-2℃海东12℃/-1℃黄南13℃/-1℃海南13℃/-2℃果洛9℃/-6℃海北8℃/-7℃乌海12℃/0℃临夏15℃/2℃白银14℃/5℃天水20℃/7℃张掖12℃/1℃金昌9℃/-2℃武威13℃/2℃定西15℃/4℃平凉20℃/6℃安定15℃/4℃临洮17℃/3℃渭源15℃/2℃陇西16℃/4℃天祝8℃/-7℃榆中15℃/2℃</B></TABLE></B></TABLE></B></TABLE></B></TABLE></B></TABLE></B></TABLE>
处理数据批量生成sql插入语句
最近在做一个天气预报模块，首先需要将客户端公网ip转换成所在城市，然后将所在城市名转换成对应的城市代码，在网上找到了城市代码，但是需要处理一下，看了看，有三百多城市及对应的城市代码，想存到数据库。就想着做一个数据处理自动生成sql语句的工具，提高效率。
1 直辖市
2 "北京","上海","天津","重庆"
3 "101010100","101020100","101030100","101040100"
4
5 特别行政区
6 "香港","澳门"
7 "101320101","101330101"
8
9 黑龙江
10 "哈尔滨","齐齐哈尔","牡丹江","大庆","伊春","双鸭山","鹤岗","鸡西","佳木斯","七台河","黑河","绥化","大兴安岭"
11 "101050101","101050201","101050301","101050901","101050801","101051301","101051201","101051101","101050401","101051002","101050601","101050501","101050701"
12
13 吉林
14 "长春","延吉","吉林","白山","白城","四平","松原","辽源","大安","通化"
15 "101060101","101060301","101060201","101060901","101060601","101060401","101060801","101060701","101060603","101060501"
16
17 辽宁
18 "沈阳","大连","葫芦岛","盘锦","本溪","抚顺","铁岭","辽阳","营口","阜新","朝阳","锦州","丹东","鞍山"
19 "101070101","101070201","101071401","101071301","101070501","101070401","101071101","101071001","101070801","101070901","101071201","101070701","101070601","101070301"
20
21 内蒙古
22 "呼和浩特","呼伦贝尔","锡林浩特","包头","赤峰","海拉尔","乌海","鄂尔多斯","通辽"
23 "101080101","101081000","101080901","101080201","101080601","101081001","101080301","101080701","101080501"
24
25 河北
26 "石家庄","唐山","张家口","廊坊","邢台","邯郸","沧州","衡水","承德","保定","秦皇岛"
27 "101090101","101090501","101090301","101090601","101090901","101091001","101090701","101090801","101090402","101090201","101091101"
28
29 河南
30 "郑州","开封","洛阳","平顶山","焦作","鹤壁","新乡","安阳","濮阳","许昌","漯河","三门峡","南阳","商丘","信阳","周口","驻马店"
31 "101180101","101180801","101180901","101180501","101181101","101181201","101180301","101180201","101181301","101180401","101181501","101181701","101180701","101181001","101180601","101181401","101181601"
32
33 山东
34 "济南","青岛","淄博","威海","曲阜","临沂","烟台","枣庄","聊城","济宁","菏泽","泰安","日照","东营","德州","滨州","莱芜","潍坊"
35 "101120101","101120201","101120301","101121301","101120710","101120901","101120501","101121401","101121701","101120701","101121001","101120801","101121501","101121201","101120401","101121101","101121601","101120601"
36
37 山西
38 "太原","阳泉","晋城","晋中","临汾","运城","长治","朔州","忻州","大同","吕梁"
39 "101100101","101100301","101100601","101100401","101100701","101100801","101100501","101100901","101101001","101100201","101101101"
40
41 江苏
42 "南京","苏州","昆山","南通","太仓","吴县","徐州","宜兴","镇江","淮安","常熟","盐城","泰州","无锡","连云港","扬州","常州","宿迁"
43 "101190101","101190401","101190404","101190501","101190408","101190406","101190801","101190203","101190301","101190901","101190402","101190701","101191201","101190201","101191001","101190601","101191101","101191301"
44
45 安徽
46 "合肥","巢湖","蚌埠","安庆","六安","滁州","马鞍山","阜阳","宣城","铜陵","淮北","芜湖","毫州","宿州","淮南","池州"
47 "101220101","101221601","101220201","101220601","101221501","101221101","101220501","101220801","101221401","101221301","101221201","101220301","101220901","101220701","101220401","101221701"
48
49 陕西
50 "西安","韩城","安康","汉中","宝鸡","咸阳","榆林","渭南","商洛","铜川","延安"
51 "101110101","101110510","101110701","101110801","101110901","101110200","101110401","101110501","101110601","101111001","101110300"
52
53 宁夏
54 "银川","固原","中卫","石嘴山","吴忠"
55 "101170101","101170401","101170501","101170201","101170301"
56
57 甘肃
58 "兰州","白银","庆阳","酒泉","天水","武威","张掖","甘南","临夏","平凉","定西","金昌"
59 "101160101","101161301","101160401","101160801","101160901","101160501","101160701","101050204","101161101","101160301","101160201","101160601"
60
61 青海
62 "西宁","海北","海西","黄南","果洛","玉树","海东","海南"
63 "101150101","101150801","101150701","101150301","101150501","101150601","101150201","101150401"
64
65 湖北
66 "武汉","宜昌","黄冈","恩施","荆州","神农架","十堰","咸宁","襄阳","孝感","随州","黄石","荆门","鄂州"
67 "101200101","101200901","101200501","101201001","101200801","101201201","101201101","101200701","101200201","101200401","101201301","101200601","101201401","101200301"
68
69 湖南
70 "长沙","邵阳","常德","郴州","吉首","株洲","娄底","湘潭","益阳","永州","岳阳","衡阳","怀化","韶山","张家界"
71 "101250101","101250901","101250601","101250501","101251501","101250301","101250801","101250201","101250701","101251401","101251001","101250401","101251201","101250202","101251101"
72
73 浙江
74 "杭州","湖州","金华","宁波","丽水","绍兴","衢州","嘉兴","台州","舟山","温州"
75 "101210101","101210201","101210901","101210401","101210801","101210501","101211001","101210301","101210601","101211101","101210701"
76
77 江西
78 "南昌","萍乡","九江","上饶","抚州","吉安","鹰潭","宜春","新余","景德镇","赣州"
79 "101240101","101240901","101240201","101240301","101240401","101240601","101241101","101240501","101241001","101240801","101240701"
80
81 福建
82 "福州","厦门","龙岩","南平","宁德","莆田","泉州","三明","漳州"
83 "101230101","101230201","101230701","101230901","101230301","101230401","101230501","101230801","101230601"
84
85 贵州
86 "贵阳","安顺","赤水","遵义","铜仁","六盘水","毕节","凯里","都匀"
87 "101260101","101260301","101260208","101260201","101260601","101260801","101260701","101260501","101260401"
88
89 四川
90 "成都","泸州","内江","凉山","阿坝","巴中","广元","乐山","绵阳","德阳","攀枝花","雅安","宜宾","自贡","甘孜州","达州","资阳","广安","遂宁","眉山","南充"
91 "101270101","101271001","101271201","101271601","101271901","101270901","101272101","101271401","101270401","101272001","101270201","101271701","101271101","101270301","101271801","101270601","101271301","101270801","101270701","101271501","101270501"
92
93 广东
94 "广州","深圳","潮州","韶关","湛江","惠州","清远","东莞","江门","茂名","肇庆","汕尾","河源","揭阳","梅州","中山","德庆","阳江","云浮","珠海","汕头","佛山"
95 "101280101","101280601","101281501","101280201","101281001","101280301","101281301","101281601","101281101","101282001","101280901","101282101","101281201","101281901","101280401","101281701","101280905","101281801","101281401","101280701","101280501","101280800"
96
97 广西
98 "南宁","桂林","阳朔","柳州","梧州","玉林","桂平","贺州","钦州","贵港","防城港","百色","北海","河池","来宾","崇左"
99 "101300101","101300501","101300510","101300301","101300601","101300901","101300802","101300701","101301101","101300801","101301401","101301001","101301301","101301201","101300401","101300201"
100
101 云南
102 "昆明","保山","楚雄","德宏","红河","临沧","怒江","曲靖","思茅","文山","玉溪","昭通","丽江","大理"
103 "101290101","101290501","101290801","101291501","101290301","101291101","101291201","101290401","101290901","101290601","101290701","101291001","101291401","101290201"
104
105 海南
106 "海口","三亚","儋州","琼山","通什","文昌"
107 "101310101","101310201","101310205","101310102","101310222","101310212"
108
109 新疆
110 "乌鲁木齐","阿勒泰","阿克苏","昌吉","哈密","和田","喀什","克拉玛依","石河子","塔城","库尔勒","吐鲁番","伊宁"
111 "101130101","101131401","101130801","101130401","101131201","101131301","101130901","101130201","101130301","101131101","101130601","101130501","101131001"
112
113 西藏
114 "拉萨","阿里","昌都","那曲","日喀则","山南","林芝"
115 "101140101","101140701","101140501","101140601","101140201","101140301","101140401"
116
117 台湾
118 "台北","高雄"
119 "101340102","101340201"
城市代码
一看上去很乱的，而且对应关系是每个省城市一行，代码一行，分别用引号引起，用逗号分隔，每行间都没有符号分隔，省名没有用引号。首先是想着把省名去掉，因为每个城市名都是不相同的。想着每两行两行的去处理，但是也要费不少功夫，还容易出错。就想个索性一次性的全处理的算法。
ps：界面很简单，上面是输入数据，中间是转换，下面是输出数据。
后台主要代码：
[csharp] view plain copy
private void button1_Click(object sender, EventArgs e)
{
string data = textBox1.Text.Replace("r", "").Replace("n", "").Replace("t", "").Replace(" ", "").Replace(" ", "").Replace(" ", "");
MatchCollection matchsdata = matches(data, ""[sS]*?"");
string[,] temps = new string[matchsdata.Count / 2, 2];
int count0 = 0;
int count1 = 0;
string input = string.Empty;
foreach (Match m in matchsdata)
{
string tempdata = m.Value.Replace(""", "");
try
{
int tryp = int.Parse(tempdata);
temps[count1, 1] = tempdata;
count1++;
}
catch (Exception ex)
{
temps[count0, 0] = tempdata;
count0++;
}
}
for (int i = 0; i < (matchsdata.Count / 2); i++)
{
input += "insert into tbl_CityCode(c_city,c_code) values( + temps[i, 0] + , + temps[i, 1] + )rn";
}
textBox2.Text = input;
}
public static MatchCollection matches(string str, string exp)
{
return Regex.Matches(str, exp, RegexOptions.IgnoreCase);
}
首先是将输入的数据处理，去除换行符，空格什么的。然后你应该是会得到一行数据，然后通过正则表达式匹配出所有带引号的数据，你会发现需要的数据全部都是用引号引起来的，但是怎样区分城市名和城市代码呢，它们是混在一起的。不用担心，你发现了吗？城市名是字符串，城市代码是一串数字，我们只要将匹配出的数据数组遍历，每一行数据都去转换成int类型，这样城市名的行就会报错，在catch中捕捉，这一行就是城市名，没错的就是城市代码，把数据一次存到一个二维数组，对应的列中就行了。这样就会获得了相对应的城市名和城市代码。生成的sql语句要对应相应的数据库表。
表结构：
转换完了将生成的sql语句放到查询器中执行就ok了。共处理了349个城市。
最后不放心自己的算法，随机抽查了几条数据，没有错误。
<script type="text/javascript"><!-- google_ad_client = "ca-pub-1944176156128447"; /* cnblogs 首页横幅 */ google_ad_slot = "5419468456"; google_ad_width = 728; google_ad_height = 90; //--></script><script type="text/javascript" src=""></script>
