全國省市縣無刷新多級關聯菜單[網頁特效JS代碼]-
2006-3-21 22:56:27
<html>
<head>
<title>省市縣關聯菜單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body,select
{
font-size:9pt;
font-family:Verdana;
}
a
{
color:red;
text-decoration:none;
}
a:hover{
text-decoration:underline;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--
function Dsy()
{
this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
if(typeof(this.Items[id]) == "undefined") return false;
return true;
}
function change(v){
var str="0";
for(i=0;i<v;i++){ str+=("_"+(document.getElementById(s[i]).selectedIndex-1));};
var ss=document.getElementById(s[v]);
with(ss){
length = 0;
options[0]=new Option(opt0[v],opt0[v]);
if(v && document.getElementById(s[v-1]).selectedIndex>0 || !v)
{
if(dsy.Exists(str)){
ar = dsy.Items[str];
for(i=0;i<ar.length;i++)options[length]=new Option(ar[i],ar[i]);
if(v)options[1].selected = true;
}
}
if(++v<s.length){change(v);}
}
}
var dsy = new Dsy();
dsy.add("0",["安徽","北京","福建","甘肅","廣東","廣西","貴州","海南","河北","河南","黑龍江","湖北","湖南","吉林","江蘇","江西","遼寧","內蒙古","寧夏","青海","山東","山西","陝西","上海","四川","天津","西藏","新疆","雲南","浙江","重慶"]);
dsy.add("0_0",["安慶","蚌埠","巢湖","池州","滁州","阜陽","合肥","淮北","淮南","黃山","六安","馬鞍山","宿州","銅陵","蕪湖","宣城","亳州"]);
dsy.add("0_0_0",["安慶市","懷寧縣","潛山縣","宿松縣","太湖縣","桐城市","望江縣","岳西縣","樅陽縣"]);
dsy.add("0_0_1",["蚌埠市","固鎮縣","懷遠縣","五河縣"]);
dsy.add("0_0_2",["巢湖市","含山縣","和縣","廬江縣","無為縣"]);
dsy.add("0_0_3",["池州市","東至縣","青陽縣","石台縣"]);
dsy.add("0_0_4",["滁州市","定遠縣","鳳陽縣","來安縣","明光市","全椒縣","天長市"]);
dsy.add("0_0_5",["阜南縣","阜陽市","界首市","臨泉縣","太和縣","穎上縣"]);
dsy.add("0_0_6",["長豐縣","肥東縣","肥西縣"]);
dsy.add("0_0_7",["淮北市","濉溪縣"]);
dsy.add("0_0_8",["鳳台縣","淮南市"]);
dsy.add("0_0_9",["黃山市","祁門縣","休寧縣","歙縣","黟縣"]);
dsy.add("0_0_10",["霍邱縣","霍山縣","金寨縣","六安市","壽縣","舒城縣"]);
dsy.add("0_0_11",["當塗縣","馬鞍山市"]);
dsy.add("0_0_12",["靈璧縣","宿州市","蕭縣","泗縣","碭山縣"]);
dsy.add("0_0_13",["銅陵市","銅陵縣"]);
dsy.add("0_0_14",["繁昌縣","南陵縣","蕪湖市","蕪湖縣"]);
dsy.add("0_0_15",["廣德縣","績溪縣","郎溪縣","寧國市","宣城市","涇縣","旌德縣"]);
dsy.add("0_0_16",["利辛縣","蒙城縣","渦陽縣","亳州市"]);
dsy.add("0_1",["北京"]);
dsy.add("0_1_0",["北京市","密雲縣","延慶縣"]);
dsy.add("0_2",["福州","龍岩","南平","寧德","莆田","泉州","三明","廈門","漳州"]);
dsy.add("0_2_0",["長樂市","福清市","福州市","連江縣","羅源縣","閩侯縣","閩清縣","平潭縣","永泰縣"]);
dsy.add("0_2_1",["長汀縣","連城縣","龍岩市","上杭縣","武平縣","永定縣","漳平市"]);
dsy.add("0_2_2",["光澤縣","建陽市","建甌市","南平市","浦城縣","邵武市","順昌縣","松溪縣","武夷山市","政和縣"]);
dsy.add("0_2_3",["福安市","福鼎市","古田縣","寧德市","屏南縣","壽寧縣","霞浦縣","周寧縣","柘榮縣"]);
dsy.add("0_2_4",["莆田市","仙游縣"]);
dsy.add("0_2_5",["安溪縣","德化縣","惠安縣","金門縣","晉江市","南安市","泉州市","石獅市","永春縣"]);
dsy.add("0_2_6",["大田縣","建寧縣","將樂縣","明溪縣","寧化縣","清流縣","三明市","沙縣","泰寧縣","永安市","尤溪縣"]);
dsy.add("0_2_7",["廈門市"]);
dsy.add("0_2_8",["長泰縣","東山縣","華安縣","龍海市","南靖縣","平和縣","雲霄縣","漳浦縣","漳州市","詔安縣"]);
dsy.add("0_3",["白銀","定西","甘南藏族自治州","嘉峪關","金昌","酒泉","蘭州","臨夏回族自治州","隴南","平涼","慶陽","天水","武威","張掖"]);
dsy.add("0_3_0",["白銀市","會寧縣","景泰縣","靖遠縣"]);
dsy.add("0_3_1",["定西縣","臨洮縣","隴西縣","通渭縣","渭源縣","漳縣","岷縣"]);
dsy.add("0_3_2",["迭部縣","合作市","臨潭縣","碌曲縣","瑪曲縣","夏河縣","舟曲縣","卓尼縣"]);
dsy.add("0_3_3",["嘉峪關市"]);
dsy.add("0_3_4",["金昌市","永昌縣"]);
dsy.add("0_3_5",["阿克塞哈薩克族自治縣","安西縣","敦煌市","金塔縣","酒泉市","肅北蒙古族自治縣","玉門市"]);
dsy.add("0_3_6",["皋蘭縣","蘭州市","永登縣","榆中縣"]);
dsy.add("0_3_7",["東鄉族自治縣","廣河縣","和政縣","積石山保安族東鄉族撒拉族自治縣","康樂縣","臨夏市","臨夏縣","永靖縣"]);
dsy.add("0_3_8",["成縣","徽縣","康縣","禮縣","兩當縣","文縣","武都縣","西和縣","宕昌縣"]);
dsy.add("0_3_9",["崇信縣","華亭縣","靜寧縣","靈台縣","平涼市","庄浪縣","涇川縣"]);
dsy.add("0_3_10",["合水縣","華池縣","環縣","寧縣","慶城縣","慶陽市","鎮原縣","正寧縣"]);
dsy.add("0_3_11",["甘谷縣","秦安縣","清水縣","天水市","武山縣","張家川回族自治縣"]);
dsy.add("0_3_12",["古浪縣","民勤縣","天祝藏族自治縣","武威市"]);
dsy.add("0_3_13",["高台縣","臨澤縣","民樂縣","山丹縣","肅南裕固族自治縣","張掖市"]);
dsy.add("0_4",["潮州","東莞","佛山","廣州","河源","惠州","江門","揭陽","茂名","梅州","清遠","汕頭","汕尾","韶關","深圳","陽江","雲浮","湛江","肇慶","中山","珠海"]);
dsy.add("0_4_0",["潮安縣","潮州市","饒平縣"]);
dsy.add("0_4_1",["東莞市"]);
dsy.add("0_4_2",["佛山市"]);
dsy.add("0_4_3",["從化市","廣州市","增城市"]);
dsy.add("0_4_4",["東源縣","和平縣","河源市","連平縣","龍川縣","紫金縣"]);
dsy.add("0_4_5",["博羅縣","惠東縣","惠陽市","惠州市","龍門縣"]);
dsy.add("0_4_6",["恩平市","鶴山市","江門市","開平市","台山市"]);
dsy.add("0_4_7",["惠來縣","揭東縣","揭西縣","揭陽市","普寧市"]);
dsy.add("0_4_8",["電白縣","高州市","化州市","茂名市","信宜市"]);
dsy.add("0_4_9",["大埔縣","豐順縣","蕉嶺縣","梅縣","梅州市","平遠縣","五華縣","興寧市"]);
dsy.add("0_4_10",["佛岡縣","連南瑤族自治縣","連山壯族瑤族自治縣","連州市","清新縣","清遠市","陽山縣","英德市"]);
dsy.add("0_4_11",["潮陽市","澄海市","南澳縣","汕頭市"]);
dsy.add("0_4_12",["海豐縣","陸豐市","陸河縣","汕尾市"]);
dsy.add("0_4_13",["樂昌市","南雄市","曲江縣","仁化縣","乳源瑤族自治縣","韶關市","始興縣","翁源縣","新豐縣"]);
dsy.add("0_4_14",["深圳市"]);
dsy.add("0_4_15",["陽春市","陽東縣","陽江市","陽西縣"]);
dsy.add("0_4_16",["羅定市","新興縣","鬱南縣","雲安縣","雲浮市"]);
dsy.add("0_4_17",["雷州市","廉江市","遂溪縣","吳川市","徐聞縣","湛江市"]);
dsy.add("0_4_18",["德慶縣","封開縣","高要市","廣寧縣","懷集縣","四會市","肇慶市"]);
dsy.add("0_4_19",["中山市"]);
dsy.add("0_4_20",["珠海市"]);
dsy.add("0_5",["百色","北海","崇左","防城港","桂林","貴港","河池","賀州","來賓","柳州","南寧","欽州","梧州","玉林"]);
dsy.add("0_5_0",["百色市","德保縣","靖西縣","樂業縣","凌雲縣","隆林各族自治縣","那坡縣","平果縣","田東縣","田林縣","田陽縣","西林縣"]);
dsy.add("0_5_1",["北海市","合浦縣"]);
dsy.add("0_5_2",["崇左市","大新縣","扶綏縣","龍州縣","寧明縣","憑祥市","天等縣"]);
dsy.add("0_5_3",["東興市","防城港市","上思縣"]);
dsy.add("0_5_4",["恭城瑤族自治縣","灌陽縣","桂林市","荔浦縣","臨桂縣","靈川縣","龍勝各族自治縣","平樂縣","全州縣","興安縣","陽朔縣","永福縣","資源縣"]);
dsy.add("0_5_5",["桂平市","貴港市","平南縣"]);
dsy.add("0_5_6",["巴馬瑤族自治縣","大化瑤族自治縣","東蘭縣","都安瑤族自治縣","鳳山縣","河池市","環江毛南族自治縣","羅城仡佬族自治縣","南丹縣","天峨縣","宜州市"]);
dsy.add("0_5_7",["富川瑤族自治縣","賀州市","昭平縣","鍾山縣"]);
dsy.add("0_5_8",["合山市","金秀瑤族自治縣","來賓市","武宣縣","象州縣","忻城縣"]);
dsy.add("0_5_9",["柳城縣","柳江縣","柳州市","鹿寨縣","融安縣","融水苗族自治縣","三江侗族自治縣"]);
dsy.add("0_5_10",["賓陽縣","橫縣","隆安縣","馬山縣","南寧市","上林縣","武鳴縣","邕寧縣"]);
dsy.add("0_5_11",["靈山縣","浦北縣","欽州市"]);
dsy.add("0_5_12",["蒼梧縣","蒙山縣","藤縣","梧州市","岑溪市"]);
dsy.add("0_5_13",["北流市","博白縣","陸川縣","容縣","興業縣","玉林市"]);
dsy.add("0_6",["安順","畢節","貴陽","六盤水","黔東南苗族侗族自治州","黔南布依族苗族自治州","黔西南布依族苗族自治州","銅仁","遵義"]);
dsy.add("0_6_0",["安順市","關嶺布依族苗族自治縣","平壩縣","普定縣","鎮寧布依族苗族自治縣","紫雲苗族布依族自治縣"]);
dsy.add("0_6_1",["畢節市","大方縣","赫章縣","金沙縣","納雍縣","黔西縣","威寧彝族回族苗族自治縣","織金縣"]);
dsy.add("0_6_2",["貴陽市","開陽縣","清鎮市","息烽縣","修文縣"]);
dsy.add("0_6_3",["六盤水市","六枝特區","盤縣","水城縣"]);
dsy.add("0_6_4",["從江縣","丹寨縣","黃平縣","劍河縣","錦屏縣","凱里市","雷山縣","黎平縣","麻江縣","三穗縣","施秉縣","台江縣","天柱縣","鎮遠縣","岑鞏縣","榕江縣"]);
dsy.add("0_6_5",["長順縣","都勻市","獨山縣","福泉市","貴定縣","惠水縣","荔波縣","龍里縣","羅甸縣","平塘縣","三都水族自治縣","甕安縣"]);
dsy.add("0_6_6",["安龍縣","冊亨縣","普安縣","晴隆縣","望謨縣","興仁縣","興義市","貞豐縣"]);
dsy.add("0_6_7",["德江縣","江口縣","石阡縣","思南縣","松桃苗族自治縣","銅仁市","萬山特區","沿河土家族自治縣","印江土家族苗族自治縣","玉屏侗族自治縣"]);
dsy.add("0_6_8",["赤水市","道真仡佬族苗族自治縣","鳳岡縣","仁懷市","綏陽縣","桐梓縣","務川仡佬族苗族自治縣","習水縣","余慶縣","正安縣","遵義市","遵義縣","湄潭縣"]);
dsy.add("0_7",["白沙黎族自治縣","保亭黎族苗族自治縣","昌江黎族自治縣","澄邁縣","定安縣","東方","海口","樂東黎族自治縣","臨高縣","陵水黎族自治縣","瓊海","瓊中黎族苗族自治縣","三亞","屯昌縣","萬寧","文昌","五指山","儋州"]);
dsy.add("0_7_0",["白沙黎族自治縣"]);
dsy.add("0_7_1",["保亭黎族苗族自治縣"]);
dsy.add("0_7_2",["昌江黎族自治縣"]);
dsy.add("0_7_3",["澄邁縣"]);
dsy.add("0_7_4",["定安縣"]);
dsy.add("0_7_5",["東方市"]);
dsy.add("0_7_6",["海口市"]);
dsy.add("0_7_7",["樂東黎族自治縣"]);
dsy.add("0_7_8",["臨高縣"]);
dsy.add("0_7_9",["陵水黎族自治縣"]);
dsy.add("0_7_10",["瓊海市"]);
dsy.add("0_7_11",["瓊中黎族苗族自治縣"]);
dsy.add("0_7_12",["三亞市"]);
dsy.add("0_7_13",["屯昌縣"]);
dsy.add("0_7_14",["萬寧市"]);
dsy.add("0_7_15",["文昌市"]);
dsy.add("0_7_16",["五指山市"]);
dsy.add("0_7_17",["儋州市"]);
dsy.add("0_8",["保定","滄州","承德","邯鄲","衡水","廊坊","秦皇島","石家莊","唐山","邢台","張家口"]);
dsy.add("0_8_0",["安國市","安新縣","保定市","博野縣","定興縣","定州市","阜平縣","高碑店市","高陽縣","滿城縣","清苑縣","曲陽縣","容城縣","順平縣","唐縣","望都縣","雄縣","徐水縣","易縣","淶水縣","淶源縣","涿州市","蠡縣"]);
dsy.add("0_8_1",["泊頭市","滄縣","滄州市","東光縣","海興縣","河間市","黃驊市","孟村回族自治縣","南皮縣","青縣","任丘市","肅寧縣","吳橋縣","獻縣","鹽山縣"]);
dsy.add("0_8_2",["承德市","承德縣","豐寧滿族自治縣","寬城滿族自治縣","隆化縣","灤平縣","平泉縣","圍場滿族蒙古族自治縣","興隆縣"]);
dsy.add("0_8_3",["成安縣","磁縣","大名縣","肥鄉縣","館陶縣","廣平縣","邯鄲市","邯鄲縣","雞澤縣","臨漳縣","邱縣","曲周縣","涉縣","魏縣","武安市","永年縣"]);
dsy.add("0_8_4",["安平縣","阜城縣","故城縣","衡水市","冀州市","景縣","饒陽縣","深州市","武強縣","武邑縣","棗強縣"]);
dsy.add("0_8_5",["霸州市","大廠回族自治縣","大城縣","固安縣","廊坊市","三河市","文安縣","香河縣","永清縣"]);
dsy.add("0_8_6",["昌黎縣","撫寧縣","盧龍縣","秦皇島市","青龍滿族自治縣"]);
dsy.add("0_8_7",["高邑縣","晉州市","井陘縣","靈壽縣","鹿泉市","平山縣","深澤縣","石家莊市","無極縣","辛集市","新樂市","行唐縣","元氏縣","贊皇縣","趙縣","正定縣","藁城市","欒城縣"]);
dsy.add("0_8_8",["樂亭縣","灤南縣","灤縣","遷安市","遷西縣","唐海縣","唐山市","玉田縣","遵化市"]);
dsy.add("0_8_9",["柏鄉縣","廣宗縣","巨鹿縣","臨城縣","臨西縣","隆堯縣","南宮市","南和縣","內丘縣","寧晉縣","平鄉縣","清河縣","任縣","沙河市","威縣","新河縣","邢台市","邢台縣"]);
dsy.add("0_8_10",["赤城縣","崇禮縣","沽源縣","懷安縣","懷來縣","康保縣","尚義縣","萬全縣","蔚縣","宣化縣","陽原縣","張北縣","張家口市","涿鹿縣"]);
dsy.add("0_9",["安陽","鶴壁","濟源","焦作","開封","洛陽","南陽","平頂山","三門峽","商丘","新鄉","信陽","許昌","鄭州","周口","駐馬店","漯河","濮陽"]);
dsy.add("0_9_0",["安陽市","安陽縣","滑縣","林州市","內黃縣","湯陰縣"]);
dsy.add("0_9_1",["","鶴壁市","浚縣","淇縣"]);
dsy.add("0_9_2",["濟源市"]);
dsy.add("0_9_3",["博愛縣","焦作市","孟州市","沁陽市","溫縣","武陟縣","修武縣"]);
dsy.add("0_9_4",["開封市","開封縣","蘭考縣","通許縣","尉氏縣","杞縣"]);
dsy.add("0_9_5",["洛寧縣","洛陽市","孟津縣","汝陽縣","新安縣","伊川縣","宜陽縣","偃師市","嵩縣","欒川縣"]);
dsy.add("0_9_6",["鄧州市","方城縣","南陽市","南召縣","內鄉縣","社旗縣","唐河縣","桐柏縣","西峽縣","新野縣","鎮平縣","淅川縣"]);
dsy.add("0_9_7",["寶豐縣","魯山縣","平頂山市","汝州市","舞鋼市","葉縣","郟縣"]);
dsy.add("0_9_8",["靈寶市","盧氏縣","三門峽市","陝縣","義馬市","澠池縣"]);
dsy.add("0_9_9",["民權縣","寧陵縣","商丘市","夏邑縣","永城市","虞城縣","柘城縣","睢縣"]);
dsy.add("0_9_10",["長垣縣","封丘縣","輝縣市","獲嘉縣","衛輝市","新鄉市","新鄉縣","延津縣","原陽縣"]);
dsy.add("0_9_11",["固始縣","光山縣","淮濱縣","羅山縣","商城縣","息縣","新縣","信陽市","潢川縣"]);
dsy.add("0_9_12",["長葛市","襄城縣","許昌市","許昌縣","禹州市","鄢陵縣"]);
dsy.add("0_9_13",["登封市","鞏義市","新密市","新鄭市","鄭州市","中牟縣","滎陽市"]);
dsy.add("0_9_14",["鄲城縣","扶溝縣","淮陽縣","鹿邑縣","商水縣","沈丘縣","太康縣","西華縣","項城市","周口市"]);
dsy.add("0_9_15",["泌陽縣","平輿縣","確山縣","汝南縣","上蔡縣","遂平縣","西平縣","新蔡縣","正陽縣","駐馬店市"]);
dsy.add("0_9_16",["臨潁縣","舞陽縣","郾城縣","漯河市"]);
dsy.add("0_9_17",["范縣","南樂縣","清豐縣","台前縣","濮陽市","濮陽縣"]);
dsy.add("0_10",["大慶","大興安嶺","哈爾濱","鶴崗","黑河","雞西","佳木斯","牡丹江","七台河","齊齊哈爾","雙鴨山","綏化","伊春"]);
dsy.add("0_10_0",["大慶市","杜爾伯特蒙古族自治縣","林甸縣","肇源縣","肇州縣"]);
dsy.add("0_10_1",["呼瑪縣","漠河縣","塔河縣"]);
dsy.add("0_10_2",["阿城市","巴彥縣","賓縣","方正縣","哈爾濱市","呼蘭縣","木蘭縣","尚志市","雙城市","通河縣","五常市","延壽縣","依蘭縣"]);
dsy.add("0_10_3",["鶴崗市","蘿北縣","綏濱縣"]);
dsy.add("0_10_4",["北安市","黑河市","嫩江縣","孫吳縣","五大連池市","遜克縣"]);
dsy.add("0_10_5",["虎林市","雞東縣","雞西市","密山市"]);
dsy.add("0_10_6",["撫遠縣","富錦市","佳木斯市","湯原縣","同江市","樺川縣","樺南縣"]);
dsy.add("0_10_7",["東寧縣","海林市","林口縣","牡丹江市","穆棱市","寧安市","綏芬河市"]);
dsy.add("0_10_8",["勃利縣","七台河市"]);
dsy.add("0_10_9",["拜泉縣","富裕縣","甘南縣","克東縣","克山縣","龍江縣","齊齊哈爾市","泰來縣","依安縣","訥河市"]);
dsy.add("0_10_10",["寶清縣","集賢縣","饒河縣","雙鴨山市","友誼縣"]);
dsy.add("0_10_11",["安達市","海倫市","蘭西縣","明水縣","青岡縣","慶安縣","綏化市","綏棱縣","望奎縣","肇東市"]);
dsy.add("0_10_12",["嘉蔭縣","鐵力市","伊春市"]);
dsy.add("0_11",["鄂州","恩施土家族苗族自治州","黃岡","黃石","荊門","荊州","潛江","神農架林區","十堰","隨州","天門","武漢","仙桃","咸寧","襄樊","孝感","宜昌"]);
dsy.add("0_11_0",["鄂州市"]);
dsy.add("0_11_1",["巴東縣","恩施市","鶴峰縣","建始縣","來鳳縣","利川市","咸豐縣","宣恩縣"]);
dsy.add("0_11_2",["紅安縣","黃岡市","黃梅縣","羅田縣","麻城市","團風縣","武穴市","英山縣","蘄春縣","浠水縣"]);
dsy.add("0_11_3",["大冶市","黃石市","陽新縣"]);
dsy.add("0_11_4",["荊門市","京山縣","沙洋縣","鍾祥市"]);
dsy.add("0_11_5",["公安縣","洪湖市","監利縣","江陵縣","荊州市","石首市","松滋市"]);
dsy.add("0_11_6",["潛江市"]);
dsy.add("0_11_7",["神農架林區"]);
dsy.add("0_11_8",["丹江口市","房縣","十堰市","鄖西縣","鄖縣","竹山縣","竹溪縣"]);
dsy.add("0_11_9",["廣水市","隨州市"]);
dsy.add("0_11_10",["天門市"]);
dsy.add("0_11_11",["武漢市"]);
dsy.add("0_11_12",["仙桃市"]);
dsy.add("0_11_13",["赤壁市","崇陽縣","嘉魚縣","通城縣","通山縣","咸寧市"]);
dsy.add("0_11_14",["保康縣","谷城縣","老河口市","南漳縣","襄樊市","宜城市","棗陽市"]);
dsy.add("0_11_15",["安陸市","大悟縣","漢川市","孝昌縣","孝感市","應城市","雲夢縣"]);
dsy.add("0_11_16",["長陽土家族自治縣","當陽市","五峰土家族自治縣","興山縣","宜昌市","宜都市","遠安縣","枝江市","秭歸縣"]);
dsy.add("0_12",["常德","長沙","郴州","衡陽","懷化","婁底","邵陽","湘潭","湘西土家族苗族自治州","益陽","永州","岳陽","張家界","株洲"]);
dsy.add("0_12_0",["安鄉縣","常德市","漢壽縣","津市市","臨澧縣","石門縣","桃源縣","澧縣"]);
dsy.add("0_12_1",["長沙市","長沙縣","寧鄉縣","望城縣","瀏陽市"]);
dsy.add("0_12_2",["安仁縣","郴州市","桂東縣","桂陽縣","嘉禾縣","臨武縣","汝城縣","宜章縣","永興縣","資興市"]);
dsy.add("0_12_3",["常寧市","衡東縣","衡南縣","衡山縣","衡陽市","衡陽縣","祁東縣","耒陽市"]);
dsy.add("0_12_4",["辰溪縣","洪江市","懷化市","會同縣","靖州苗族侗族自治縣","麻陽苗族自治縣","通道侗族自治縣","新晃侗族自治縣","中方縣","芷江侗族自治縣","沅陵縣","漵浦縣"]);
dsy.add("0_12_5",["冷水江市","漣源市","婁底市","雙峰縣","新化縣"]);
dsy.add("0_12_6",["城步苗族自治縣","洞口縣","隆回縣","邵東縣","邵陽市","邵陽縣","綏寧縣","武岡市","新寧縣","新邵縣"]);
dsy.add("0_12_7",["韶山市","湘潭市","湘潭縣","湘鄉市"]);
dsy.add("0_12_8",["保靖縣","鳳凰縣","古丈縣","花垣縣","吉首市","龍山縣","永順縣","瀘溪縣"]);
dsy.add("0_12_9",["安化縣","南縣","桃江縣","益陽市","沅江市"]);
dsy.add("0_12_10",["道縣","東安縣","江華瑤族自治縣","江永縣","藍山縣","寧遠縣","祁陽縣","雙牌縣","新田縣","永州市"]);
dsy.add("0_12_11",["華容縣","臨湘市","平江縣","湘陰縣","岳陽市","岳陽縣","汨羅市"]);
dsy.add("0_12_12",["慈利縣","桑植縣","張家界市"]);
dsy.add("0_12_13",["茶陵縣","炎陵縣","株洲市","株洲縣","攸縣","醴陵市"]);
dsy.add("0_13",["白城","白山","長春","吉林","遼源","四平","松原","通化","延邊朝鮮族自治州"]);
dsy.add("0_13_0",["白城市","大安市","通榆縣","鎮賚縣","洮南市"]);
dsy.add("0_13_1",["白山市","長白朝鮮族自治縣","撫松縣","江源縣","靖宇縣","臨江市"]);
dsy.add("0_13_2",["長春市","德惠市","九台市","農安縣","榆樹市"]);
dsy.add("0_13_3",["吉林市","磐石市","舒蘭市","永吉縣","樺甸市","蛟河市"]);
dsy.add("0_13_4",["東豐縣","東遼縣","遼源市"]);
dsy.add("0_13_5",["公主嶺市","梨樹縣","雙遼市","四平市","伊通滿族自治縣"]);
dsy.add("0_13_6",["長嶺縣","扶余縣","乾安縣","前郭爾羅斯蒙古族自治縣","松原市"]);
dsy.add("0_13_7",["輝南縣","集安市","柳河縣","梅河口市","通化市","通化縣"]);
dsy.add("0_13_8",["安圖縣","敦化市","和龍市","龍井市","圖們市","汪清縣","延吉市","琿春市"]);
dsy.add("0_14",["常州","淮安","連雲港","南京","南通","蘇州","宿遷","泰州","無錫","徐州","鹽城","揚州","鎮江"]);
dsy.add("0_14_0",["常州市","金壇市","溧陽市"]);
dsy.add("0_14_1",["洪澤縣","淮安市","金湖縣","漣水縣","盱眙縣"]);
dsy.add("0_14_2",["東海縣","贛榆縣","灌南縣","灌雲縣","連雲港市"]);
dsy.add("0_14_3",["高淳縣","南京市","溧水縣"]);
dsy.add("0_14_4",["海安縣","海門市","南通市","啟東市","如東縣","如皋市","通州市"]);
dsy.add("0_14_5",["常熟市","崑山市","蘇州市","太倉市","吳江市","張家港市"]);
dsy.add("0_14_6",["宿遷市","宿豫縣","沭陽縣","泗洪縣","泗陽縣"]);
dsy.add("0_14_7",["姜堰市","靖江市","泰興市","泰州市","興化市"]);
dsy.add("0_14_8",["江陰市","無錫市","宜興市"]);
dsy.add("0_14_9",["豐縣","沛縣","銅山縣","新沂市","徐州市","邳州市","睢寧縣"]);
dsy.add("0_14_10",["濱海縣","大豐市","東台市","阜寧縣","建湖縣","射陽縣","響水縣","鹽城市","鹽都縣"]);
dsy.add("0_14_11",["寶應縣","高郵市","江都市","揚州市","儀征市"]);
dsy.add("0_14_12",["丹陽市","句容市","揚中市","鎮江市"]);
dsy.add("0_15",["撫州","贛州","吉安","景德鎮","九江","南昌","萍鄉","上饒","新余","宜春","鷹潭"]);
dsy.add("0_15_0",["崇仁縣","東鄉縣","撫州市","廣昌縣","金溪縣","樂安縣","黎川縣","南城縣","南豐縣","宜黃縣","資溪縣"]);
dsy.add("0_15_1",["安遠縣","崇義縣","大余縣","定南縣","贛縣","贛州市","會昌縣","龍南縣","南康市","寧都縣","全南縣","瑞金市","上猶縣","石城縣","信豐縣","興國縣","尋烏縣","於都縣"]);
dsy.add("0_15_2",["安福縣","吉安市","吉安縣","吉水縣","井岡山市","遂川縣","泰和縣","萬安縣","峽江縣","新干縣","永豐縣","永新縣"]);
dsy.add("0_15_3",["浮梁縣","景德鎮市","樂平市"]);
dsy.add("0_15_4",["德安縣","都昌縣","湖口縣","九江市","九江縣","彭澤縣","瑞昌市","武寧縣","星子縣","修水縣","永修縣"]);
dsy.add("0_15_5",["安義縣","進賢縣","南昌市","南昌縣","新建縣"]);
dsy.add("0_15_6",["蓮花縣","蘆溪縣","萍鄉市","上栗縣"]);
dsy.add("0_15_7",["波陽縣","德興市","廣豐縣","橫峰縣","鉛山縣","上饒市","上饒縣","萬年縣","余干縣","玉山縣","弋陽縣","婺源縣"]);
dsy.add("0_15_8",["分宜縣","新余市"]);
dsy.add("0_15_9",["豐城市","奉新縣","高安市","靖安縣","上高縣","銅鼓縣","萬載縣","宜春市","宜豐縣","樟樹市"]);
dsy.add("0_15_10",["貴溪市","鷹潭市","余江縣"]);
dsy.add("0_16",["鞍山","本溪","朝陽","大連","丹東","撫順","阜新","葫蘆島","錦州","遼陽","盤錦","沈陽","鐵嶺","營口"]);
dsy.add("0_16_0",["鞍山市","海城市","台安縣","岫岩滿族自治縣"]);
dsy.add("0_16_1",["本溪滿族自治縣","本溪市","桓仁滿族自治縣"]);
dsy.add("0_
❷ SQL資料庫是什麼
SQL是Structured Query Language(結構化查詢語言)的縮寫。SQL是專為資料庫而建立的操作命令集，是一種功能齊全的資料庫語言。在使用它時，只需要發出「做什麼」的命令，「怎麼做」是不用使用者考慮的。
SQL資料庫的數據體系結構基本上是三級結構，但使用術語與傳統關系模型術語不同。在SQL中，關系模式(模式)稱為"基本表"(base table);存儲模式(內模式)稱為"存儲文件"(stored file)；子模式(外模式)稱為"視圖"(view);元組稱為"行"(row);屬性稱為"列"(column)。
(2)桂平sql資料庫擴展閱讀：
SQL資料庫的優點：
1、易用性高：
適合分布式組織的可伸縮性、用於決策支持的數據倉庫功能、與許多其他伺服器軟體緊密關聯的集成性、良好的性價比等。
2.為數據管理與分析帶來了靈活性：
允許單位在快速變化的環境中從容響應，從而獲得競爭優勢。從數據管理和分析角度看，將原始數據轉化為商業智能和充分利用Web帶來的機會非常重要。作為一個完備的資料庫和數據分析包，SQLServer為快速開發新一代企業級商業應用程序、為企業贏得核心競爭優勢打開了勝利之門。
❸ SQL資料庫是什麼 主要干什麼用的
資料庫當然就是用來存儲數據的
只不過訪問和查詢比較快
SQL是一種資料庫描述語言
實際也就是程序語言
在主流編程語言中均支持
資料庫管理軟體主要有微軟的MS
SQL,
Orcal,DB2,和MySQL
語法相似
最好學MySQL
因為現在php比較流行
而php+MySQL+Alpha是主流的建站選擇
❹ SQL資料庫的全稱它的用意
SQL(Structured Query Language)結構化查詢語言，是一種資料庫查詢和程序設計語言，用於存取數據以及查詢、更新和管理關系資料庫系統。同時也是資料庫腳本文件的擴展名。
SQL 面向資料庫執行查詢；SQL 可從資料庫取回數據；SQL 可在資料庫中插入新的記錄；SQL 可更新資料庫中的數據；SQL 可從資料庫刪除記錄；SQL 可創建新資料庫；SQL 可在資料庫中創建新表；SQL 可在資料庫中創建存儲過程；SQL 可在資料庫中創建視圖；SQL 可以設置表、存儲過程和視圖的許可權。
❺ sql資料庫的基本操作
命令行
1、顯示當前資料庫伺服器中的資料庫列表：mysql> SHOW DATABASES;
2、建立資料庫：mysql> CREATE DATABASE 庫名;
3、建立數據表：mysql> USE 庫名;mysql> CREATE TABLE 表名 (欄位名 VARCHAR(20), 欄位名 CHAR(1));
4、刪除資料庫：mysql> DROP DATABASE 庫名;
5、刪除數據表：mysql> DROP TABLE 表名；
6、將表中記錄清空：mysql> DELETE FROM 表名;
7、往表中插入記錄：mysql> INSERT INTO 表名 VALUES ("hyq","M");
8、更新表中數據：mysql-> UPDATE 表名 SET 欄位名1='a',欄位名2='b' WHERE 欄位名3='c';
9、用文本方式將數據裝入數據表中：mysql> load data local infile "d:/mysql.txt" into table 表名;
10、導入.sql文件命令：mysql> USE 資料庫名;mysql> source d:/mysql.sql;
11、命令行修改root密碼：mysql> update mysql.user set password=password('新密碼') where user='root';mysql> flush privileges;
12.修改密碼的三種方法:mysql>update user set password=password('123456') where user='joy_pen';mysql>flush privileges;mysql>set password for 'joy_oen'=password('123456');mysql>grant usage on *.* to 'joy_pen' identified by '123456';
1、創建資料庫
命令：create database <資料庫名> 例如：建立一個名為xhkdb的資料庫mysql> create database xhkdb;
2、顯示所有的資料庫
命令：show databases （注意：最後有個s）mysql> show databases;
3、刪除資料庫
命令：drop database <資料庫名> 例如：刪除名為 xhkdb的資料庫mysql> drop database xhkdb;
4、連接資料庫
命令： use <資料庫名> 例如：如果xhkdb資料庫存在，嘗試存取它：mysql> use xhkdb; 屏幕提示：Database changed
5、當前選擇（連接）的資料庫mysql> select database();
6、當前資料庫包含的表信息：mysql> show tables; （注意：最後有個s）
三、表操作，操作之前應連接某個資料庫
1、建表
命令：create table <表名> ( <欄位名1> <類型1> [,..<欄位名n> <類型n>]);
mysql> create table MyClass(
> id int(4) not null primary key auto_increment,
> name char(20) not null,
> sex int(4) not null default ''0'',
> degree double(16,2));
2、獲取表結構
命令： desc 表名，或者show columns from 表名
mysql>DESCRIBE MyClass
mysql> desc MyClass;
mysql> show columns from MyClass;
3、刪除表
命令：drop table <表名>
例如：刪除表名為 MyClass 的表 mysql> drop table MyClass;
4、插入數據
命令：insert into <表名> [( <欄位名1>[,..<欄位名n > ])] values ( 值1 )[, ( 值n )]
例如，往表 MyClass中插入二條記錄, 這二條記錄表示：編號為1的名為Tom的成績為96.45, 編號為2 的名為Joan 的成績為82.99，編號為3 的名為Wang 的成績為96.5.
mysql> insert into MyClass values(1,'Tom',96.45),(2,'Joan',82.99), (2,'Wang', 96.59);
5、查詢表中的數據
1)、查詢所有行
命令： select <欄位1，欄位2，...> from < 表名 > where < 表達式 >
例如：查看錶 MyClass 中所有數據 mysql> select * from MyClass;
2）、查詢前幾行數據
例如：查看錶 MyClass 中前2行數據
mysql> select * from MyClass order by id limit 0,2;
6、刪除表中數據
命令：delete from 表名 where 表達式
例如：刪除表 MyClass中編號為1 的記錄
mysql> delete from MyClass where id=1;
7、修改表中數據：update 表名 set 欄位=新值,… where 條件
mysql> update MyClass set name=''Mary'' where id=1;
8、在表中增加欄位：
命令：alter table 表名 add 欄位 類型 其他;
例如：在表MyClass中添加了一個欄位passtest，類型為int(4)，默認值為0
mysql> alter table MyClass add passtest int(4) default ''0''
9、更改表名：
命令：rename table 原表名 to 新表名;
例如：在表MyClass名字更改為YouClass
mysql> rename table MyClass to YouClass;
更新欄位內容
update 表名 set 欄位名 = 新內容
update 表名 set 欄位名 = replace(欄位名,''舊內容'',''新內容'');
❻ 如何使用SQL資料庫
方法：
1、首先打開SQL SERVER自帶的資料庫管理工具，從開始菜單中可以找到，如圖點擊進去；
2、開始連接SQL SERVER伺服器，就是我們裝好的SQL SERVER 伺服器；
3、如圖，右擊資料庫，選擇第一個，新建一個資料庫；
4、填寫資料庫的名稱（箭頭方向），下面是設置自動增長的，一般不用管，默認
5、點擊確定後就可以生成一個資料庫，此時裡面是沒有表的；
6、右擊表新建一個表，填寫你要的欄位名稱
7、填完欄位名稱後點擊欄位名稱那個內部窗口的小叉叉，然後就提示你輸入表名了，填寫下表名，一個資料庫的建立過程就是這樣的；
注意事項：
建立資料庫需要先打開資料庫伺服器。
❼ sql資料庫是怎麼回事哦
SQL是Structured Quevy Language(結構化查詢語言)的縮寫。SQL是專為資料庫而建立的操作命令集，是一種功能齊全的資料庫語言。在使用它時，只需要發出「做什麼」的命令，「怎麼做」是不用使用者考慮的。SQL功能強大、簡單易學、使用方便，已經成為了資料庫操作的基礎，並且現在幾乎所有的資料庫均支持SQL。
1 二、SQL資料庫數據體系結構
SQL資料庫的數據體系結構基本上是三級結構，但使用術語與傳統關系模型術語不同。在SQL中，關系模式(模式)稱為「基本表」(base table)；存儲模式(內模式)稱為「存儲文件」(stored file)；子模式(外模式)稱為「視圖」(view)；元組稱為「行」(row)；屬性稱為「列」(column)。名稱對稱如^00100009a^：
1 三、SQL語言的組成
在正式學習SQL語言之前，首先讓我們對SQL語言有一個基本認識，介紹一下SQL語言的組成：
1.一個SQL資料庫是表(Table)的集合，它由一個或多個SQL模式定義。
2.一個SQL表由行集構成，一行是列的序列(集合)，每列與行對應一個數據項。
3.一個表或者是一個基本表或者是一個視圖。基本表是實際存儲在資料庫的表，而視圖是由若干基本表或其他視圖構成的表的定義。
4.一個基本表可以跨一個或多個存儲文件，一個存儲文件也可存放一個或多個基本表。每個存儲文件與外部存儲上一個物理文件對應。
5.用戶可以用SQL語句對視圖和基本表進行查詢等操作。在用戶角度來看，視圖和基本表是一樣的，沒有區別，都是關系(表格)。
6.SQL用戶可以是應用程序，也可以是終端用戶。SQL語句可嵌入在宿主語言的程序中使用，宿主語言有FORTRAN，COBOL，PASCAL，PL/I，C和Ada語言等。SQL用戶也能作為獨立的用戶介面，供交互環境下的終端用戶使用。
1 四、對資料庫進行操作
SQL包括了所有對資料庫的操作，主要是由4個部分組成：
1.數據定義：這一部分又稱為「SQL DDL」，定義資料庫的邏輯結構，包括定義資料庫、基本表、視圖和索引4部分。
2.數據操縱：這一部分又稱為「SQL DML」，其中包括數據查詢和數據更新兩大類操作，其中數據更新又包括插入、刪除和更新三種操作。
3.數據控制：對用戶訪問數據的控制有基本表和視圖的授權、完整性規則的描述，事務控制語句等。
4.嵌入式SQL語言的使用規定：規定SQL語句在宿主語言的程序中使用的規則。
下面我們將分別介紹：
2 (一)數據定義
SQL數據定義功能包括定義資料庫、基本表、索引和視圖。
首先，讓我們了解一下SQL所提供的基本數據類型：(如^00100009b^)
1.資料庫的建立與刪除
(1)建立資料庫：資料庫是一個包括了多個基本表的數據集，其語句格式為：
CREATE DATABASE <資料庫名> 〔其它參數〕
其中，<資料庫名>在系統中必須是唯一的，不能重復，不然將導致數據存取失誤。〔其它參數〕因具體資料庫實現系統不同而異。
例：要建立項目管理資料庫(xmmanage)，其語句應為：
CREATE DATABASE xmmanage
(2) 資料庫的刪除：將資料庫及其全部內容從系統中刪除。
其語句格式為：DROP DATABASE <資料庫名>
例：刪除項目管理資料庫(xmmanage)，其語句應為：
DROP DATABASE xmmanage
2.基本表的定義及變更
本身獨立存在的表稱為基本表，在SQL語言中一個關系唯一對應一個基本表。基本表的定義指建立基本關系模式，而變更則是指對資料庫中已存在的基本表進行刪除與修改。
❽ SQL資料庫與資料庫
用Insert Into，可以用Select 語句插入值，但是最好是把欄位名列出，以免表發生變動時語句失敗
INSERT INTO [Table] ([Field1],[Field2]......[Fieldn])
SELECT [Field1],[Field2]......[Fieldn]
FROM [Table1].....
你可以這樣：
INSERT INTO B select * from A where 條件1 and 條件2
使用SELECT查詢的欄位數必須與INSERT中指定的欄位數完全相等，並且數據類型能兼容（支持隱性轉換）
對於一些不能進行隱性轉換的數據，需要在SELECT中進行顯式轉換
例如欄位中的類型是Varchar，而SELECT中的是Money，此時就必須進行顯式轉換才能插入成功。
❾ 處理數據批量生成sql插入語句
處理數據批量生成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
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="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>