我寫了一個(gè)Java類,從xml把全國(guó)地址解釋出來生成SQL語(yǔ)句寫入TXT文檔. 以下是代碼跟大家一起分享.
完整的SQL文檔可在這里下載
下載地址:
??????? 1. ?
ChinaAllCity_省市縣3級(jí)-sql.tar.gz?? 44.9 KB (只有SQL文件)
??????? 2.??
ChinaAllCity_省市縣3級(jí)-data-src.tar.gz?? 67.2 KB(本文全部代碼)
記住喔，如果有遺漏的城市請(qǐng)通知道我.我會(huì)更新的.方便大家.
??1?
import?java.io.File;
??2?
import?java.io.FileNotFoundException;
??3?
import?java.io.FileWriter;
??4?
import?java.io.IOException;
??5?
import?java.util.HashMap;
??6?
import?java.util.Map;
??7?
??8?
import?javax.xml.parsers.DocumentBuilder;
??9?
import?javax.xml.parsers.DocumentBuilderFactory;
?10?
import?javax.xml.parsers.ParserConfigurationException;
?11?
?12?
import?org.w3c.dom.Document;
?13?
import?org.w3c.dom.NamedNodeMap;
?14?
import?org.w3c.dom.Node;
?15?
import?org.w3c.dom.NodeList;
?16?
import?org.xml.sax.SAXException;
?17?
?18?
/**
?19?
?*?讀取省`市`縣級(jí),地名生成SQL語(yǔ)句
?20?
?*?@author?alex刺客
?21?
?*
?22?
?*/
?23?
public?class?ReadLocalityXml?{
?24?
?25?
????/**?文檔對(duì)象?*/
?26?
????private?Document?document?=?null;
?27?
????/**?寫入文本文件對(duì)象?*/
?28?
????private?FileWriter?writer?=?null;
?29?
?30?
????public?ReadLocalityXml(String?uri)?throws?ParserConfigurationException,
?31?
????????????SAXException,?IOException?{
?32?
????????
?33?
????????//得出文件路徑絕對(duì)地址
?34?
????????File?xmlFile?=?new?File(uri);
?35?
????????System.out.println("adderss.xml路徑所在："?+?xmlFile.getAbsolutePath());
?36?
????????//?是否為文件
?37?
????????if?(xmlFile.isFile())?{
?38?
????????????//文檔建造工廠
?39?
????????????DocumentBuilderFactory?dbf?=?DocumentBuilderFactory.newInstance();
?40?
????????????//建造文檔
?41?
????????????DocumentBuilder?db?=?dbf.newDocumentBuilder();
?42?
????????????//解析XML文件,獲得DOM對(duì)象
?43?
????????????document?=?db.parse(xmlFile);
?44?
????????}?else?{
?45?
????????????throw?new?FileNotFoundException("未找到adderss.xml文件！");
?46?
????????}
?47?
????}
?48?
????
?49?
????/**
?50?
?????*?
?51?
?????*?@param?tagname?省?市?縣
?52?
?????*?@throws?IOException?
?53?
?????*/
?54?
????public?void?work(String
?tagname)?throws?IOException?{
?55?
????????//臨時(shí)存儲(chǔ)省級(jí)信息
?56?
????????Map<String,?String>?map1?=?new?HashMap<String,?String>();
?57?
????????//臨時(shí)存儲(chǔ)市級(jí)信息
?58?
????????Map<String,?String>?map2?=?new?HashMap<String,?String>();
?59?
????????
?60?
????????File?file?=?new?File("./allCity.sql");
?61?
????????//生成文件文檔(SQL)
?62?
????????file.createNewFile();
?63?
????????//向此文檔寫入SQL語(yǔ)句
?64?
????????writer?=?new?FileWriter(file);
?65?
????????//級(jí)別
?66?
????????int?level?=0;
?67?
????????//SQL編號(hào)?唯一
?68?
????????int?inumber?=?0;
?69?
????????
?70?
????????//處理
?71?
????????for?(String?tag?:?tagname)?{
?72?
????????????level?++;
?73?
????????????NodeList?nodelist?=?document.getElementsByTagName(tag);
?74?
????????????int?nodeszie?=?nodelist.getLength();
?75?
????????????writer.write("--?Alex?刺客.?獲取"+?tag?+?"?標(biāo)簽,此標(biāo)簽一共有?"?+?nodeszie?+?"個(gè).\n");
?76?
????????????System.out.println("獲取"+?tag?+?"?標(biāo)簽,此標(biāo)簽一共有?"?+?nodeszie?+?"個(gè)。");
?77?
????????????//當(dāng)前節(jié)點(diǎn)的父節(jié)點(diǎn)name名稱
?78?
????????????String?parent?=?null;
?79?
????????????//次級(jí)編號(hào)
?80?
????????????int?newValue?=?1;
?81?
????????????
?82?
????????????for?(int?i?=?0;?i?<?nodeszie;?i++)?{
?83?
????????????????//生成唯一編號(hào)
?84?
????????????????inumber++;
?85?
????????????????//獲取標(biāo)簽名為?tag?的i個(gè)節(jié)點(diǎn)
?86?
????????????????Node?node?=?nodelist.item(i);
?87?
????????????????//獲取節(jié)點(diǎn)的屬性節(jié)點(diǎn)
?88?
????????????????NamedNodeMap?nameNodeMap?=?node.getAttributes();
?89?
????????????????//獲取屬性為name的節(jié)點(diǎn)
?90?
????????????????Node?namenode?=?nameNodeMap.getNamedItem("name");
?91?
????????????????//獲取name節(jié)點(diǎn)地名
?92?
????????????????String?addname?=?namenode.getNodeValue();
?93?
????????????????
?94?
????????????????//處理省級(jí)別
?95?
????????????????if(level?==?1){
?96?
????????????????????//生成編號(hào)
?97?
????????????????????String?value?=?this.getnumber(i?+?1);
?98?
????????????????????map1.put(addname,?value);
?99?
????????????????????println(inumber,?level,?value,?"0",?addname);
100?
????????????????
101?
????????????????//處理市級(jí)別
102?
????????????????}else?if(level?==?2)?{
103?
????????????????????
104?
????????????????????Node?parentAttrNamed?=?node.getParentNode().getAttributes().getNamedItem("name");
105?
????????????????????if(parent?==?null){
106?
????????????????????????parent?=?parentAttrNamed.getNodeValue();
107?
????????????????????}else?if(parent?!=?parentAttrNamed.getNodeValue()){
108?
????????????????????????writer.write("--?Alex_刺客說:?"?+?parent?+?"?共有?"?+?newValue?+"?個(gè)子級(jí)城市！\n\n");
109?
????????????????????????System.out.println(parent?+?"?共有?"?+?newValue?+"?個(gè)子級(jí)城市!");
110?
????????????????????????newValue?=?1;
111?
????????????????????????parent?=?parentAttrNamed.getNodeValue();
112?
????????????????????}else{
113?
????????????????????????newValue?++;
114?
????????????????????}
115?
????????????????????
116?
????????????????????String?belongkey?=?map1.get(parent);
117?
????????????????????String?value?=?belongkey?+?this.getnumber(newValue);
118?
????????????????????map2.put(addname,?value);
119?
????????????????????println(inumber,?level,?value,?belongkey,?addname);
120?
????????????????????
121?
????????????????//處理縣級(jí)別
122?
????????????????}else?if?(level?==?3){
123?
????????????????????Node?parentAttrNamed?=?node.getParentNode().getAttributes().getNamedItem("name");
124?
????????????????????if(parent?==?null){
125?
????????????????????????parent?=?parentAttrNamed.getNodeValue();
126?
????????????????????}else?if(parent?!=?parentAttrNamed.getNodeValue()){
127?
????????????????????????writer.write("--?alex刺客說:?"?+?parent?+?"?共有?"?+?newValue?+"?個(gè)子級(jí)城市！\n\n");
128?
????????????????????????System.out.println(parent?+?"?共有?"?+?newValue?+"?個(gè)子級(jí)城市!");
129?
????????????????????????newValue?=?1;
130?
????????????????????????parent?=?parentAttrNamed.getNodeValue();
131?
????????????????????}else{
132?
????????????????????????newValue?++;
133?
????????????????????}
134?
135?
????????????????????String?belongkey?=?map2.get(parent);
136?
????????????????????String?value?=?belongkey?+?this.getnumber(newValue);
137?
????????????????????println(inumber,?level,?value,?belongkey,?addname);
138?
????????????????}
139?
????????????}
140?
????????}
141?
????????
142?
????????writer.flush();
143?
????????writer.close();
144?
????}
145?
????
146?
????/**
147?
?????*?輸出SQL插入語(yǔ)句
148?
?????*?@param?inumber
149?
?????*?@param?level
150?
?????*?@param?value
151?
?????*?@param?key
152?
?????*?@throws?IOException?
153?
?????*/
154?
????private?void?println(int?inumber,?int?level,?String?value,?String?belongkey,?String?addname)?throws?IOException{
155?
????????writer.write("insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?("+inumber+","+level+",'"+value+"','"+belongkey+"','"+addname+"');\n");
156?
????????//System.out.println("insert?into?address(id,?levels,?key,?toponym)?values?("+inumber+","+level+",'"+key+"','"+value+"');");
157?
????}
158?
159?
????/**
160?
?????*?生成字符串編號(hào)
161?
?????*?@param?id?編號(hào)?
162?
?????*?@return?字符編號(hào)
163?
?????*/
164?
????public?String?getnumber(int?id)?{
165?
????????//?新的編號(hào)
166?
????????String?newid?=?"";
167?
????????//?編號(hào)樣式
168?
????????String?number?=?"000";
169?
????????//?編號(hào)長(zhǎng)度
170?
????????int?idlength?=?Integer.toString(id).length();
171?
????????//?編號(hào)前有幾個(gè)‘0’
172?
????????int?surpluslength?=?number.length()?-?idlength;
173?
????????while?(surpluslength?>?0)?{
174?
????????????newid?+=?"0";
175?
????????????surpluslength--;
176?
????????}
177?
????????return?newid?+?id;
178?
????}
179?
180?
????public?static?void?main(String[]?args)?{
181?
????????try?{
182?
????????????ReadLocalityXml?rlx?=?new?ReadLocalityXml("adderss.xml");
183?
????????????rlx.work("province","city","country");
184?
????????}?catch?(Exception?e)?{
185?
????????????e.printStackTrace();
186?
????????}
187?
????}
188?
}
189?
生成輸出結(jié)果
??1?[alex@localhost?temp]$?javac?ReadLocalityXml.java?
??2?[alex@localhost?temp]$?java?ReadLocalityXml
??3?adderss.xml路徑所在：/home/alex/桌面/temp/adderss.xml
??4?獲取province?標(biāo)簽,此標(biāo)簽一共有?34個(gè)。
??5?獲取city?標(biāo)簽,此標(biāo)簽一共有?345個(gè)。
??6?北京市?共有?2?個(gè)子級(jí)城市!
??7?天津市?共有?2?個(gè)子級(jí)城市!
??8?河北省?共有?11?個(gè)子級(jí)城市!
??9?山西省?共有?11?個(gè)子級(jí)城市!
?10?內(nèi)蒙古區(qū)?共有?12?個(gè)子級(jí)城市!
?11?遼寧省?共有?14?個(gè)子級(jí)城市!
?12?吉林省?共有?9?個(gè)子級(jí)城市!
?13?黑龍江省?共有?13?個(gè)子級(jí)城市!
?14?上海市?共有?2?個(gè)子級(jí)城市!
?15?江蘇省?共有?13?個(gè)子級(jí)城市!
?16?浙江省?共有?11?個(gè)子級(jí)城市!
?17?安徽省?共有?17?個(gè)子級(jí)城市!
?18?福建省?共有?9?個(gè)子級(jí)城市!
?19?江西省?共有?11?個(gè)子級(jí)城市!
?20?山東省?共有?17?個(gè)子級(jí)城市!
?21?河南省?共有?17?個(gè)子級(jí)城市!
?22?湖北省?共有?14?個(gè)子級(jí)城市!
?23?湖南省?共有?14?個(gè)子級(jí)城市!
?24?廣東省?共有?21?個(gè)子級(jí)城市!
?25?廣西區(qū)?共有?14?個(gè)子級(jí)城市!
?26?海南省?共有?3?個(gè)子級(jí)城市!
?27?重慶市?共有?3?個(gè)子級(jí)城市!
?28?四川省?共有?21?個(gè)子級(jí)城市!
?29?貴州省?共有?9?個(gè)子級(jí)城市!
?30?云南省?共有?16?個(gè)子級(jí)城市!
?31?西藏區(qū)?共有?7?個(gè)子級(jí)城市!
?32?陜西省?共有?10?個(gè)子級(jí)城市!
?33?甘肅省?共有?14?個(gè)子級(jí)城市!
?34?青海省?共有?8?個(gè)子級(jí)城市!
?35?寧夏區(qū)?共有?5?個(gè)子級(jí)城市!
?36?獲取country?標(biāo)簽,此標(biāo)簽一共有?3144個(gè)。
?37?北京轄區(qū)?共有?16?個(gè)子級(jí)城市!
?38?北京轄縣?共有?2?個(gè)子級(jí)城市!
?39?天津轄區(qū)?共有?15?個(gè)子級(jí)城市!
?40?天津轄縣?共有?3?個(gè)子級(jí)城市!
?41?石家莊市?共有?24?個(gè)子級(jí)城市!
?42?唐山市?共有?15?個(gè)子級(jí)城市!
?43?秦皇島市?共有?8?個(gè)子級(jí)城市!
?44?邯鄲市?共有?20?個(gè)子級(jí)城市!
?45?邢臺(tái)市?共有?20?個(gè)子級(jí)城市!
?46?保定市?共有?26?個(gè)子級(jí)城市!
?47?張家口市?共有?18?個(gè)子級(jí)城市!
?48?承德市?共有?12?個(gè)子級(jí)城市!
?49?滄州市?共有?17?個(gè)子級(jí)城市!
?50?廊坊市?共有?11?個(gè)子級(jí)城市!
?51?衡水市?共有?12?個(gè)子級(jí)城市!
?52?太原市?共有?11?個(gè)子級(jí)城市!
?53?大同市?共有?12?個(gè)子級(jí)城市!
?54?陽(yáng)泉市?共有?6?個(gè)子級(jí)城市!
?55?長(zhǎng)治市?共有?14?個(gè)子級(jí)城市!
?56?晉城市?共有?7?個(gè)子級(jí)城市!
?57?朔州市?共有?7?個(gè)子級(jí)城市!
?58?晉中市?共有?12?個(gè)子級(jí)城市!
?59?運(yùn)城市?共有?14?個(gè)子級(jí)城市!
?60?忻州市?共有?15?個(gè)子級(jí)城市!
?61?臨汾市?共有?18?個(gè)子級(jí)城市!
?62?呂梁市?共有?14?個(gè)子級(jí)城市!
?63?呼和浩特市?共有?10?個(gè)子級(jí)城市!
?64?包頭市?共有?10?個(gè)子級(jí)城市!
?65?烏海市?共有?4?個(gè)子級(jí)城市!
?66?赤峰市?共有?13?個(gè)子級(jí)城市!
?67?通遼市?共有?9?個(gè)子級(jí)城市!
?68?鄂爾多斯市?共有?8?個(gè)子級(jí)城市!
?69?呼倫貝爾市?共有?14?個(gè)子級(jí)城市!
?70?巴彥淖爾市?共有?8?個(gè)子級(jí)城市!
?71?烏蘭察布市?共有?12?個(gè)子級(jí)城市!
?72?興安盟?共有?6?個(gè)子級(jí)城市!
?73?錫林郭勒盟?共有?12?個(gè)子級(jí)城市!
?74?阿拉善盟?共有?3?個(gè)子級(jí)城市!
?75?沈陽(yáng)市?共有?14?個(gè)子級(jí)城市!
?76?大連市?共有?11?個(gè)子級(jí)城市!
?77?鞍山市?共有?8?個(gè)子級(jí)城市!
?78?撫順市?共有?8?個(gè)子級(jí)城市!
?79?本溪市?共有?7?個(gè)子級(jí)城市!
?80?丹東市?共有?7?個(gè)子級(jí)城市!
?81?錦州市?共有?8?個(gè)子級(jí)城市!
?82?營(yíng)口市?共有?7?個(gè)子級(jí)城市!
?83?阜新市?共有?8?個(gè)子級(jí)城市!
?84?遼陽(yáng)市?共有?8?個(gè)子級(jí)城市!
?85?盤錦市?共有?5?個(gè)子級(jí)城市!
?86?鐵嶺市?共有?8?個(gè)子級(jí)城市!
?87?朝陽(yáng)市?共有?8?個(gè)子級(jí)城市!
?88?葫蘆島市?共有?7?個(gè)子級(jí)城市!
?89?長(zhǎng)春市?共有?11?個(gè)子級(jí)城市!
?90?吉林市?共有?10?個(gè)子級(jí)城市!
?91?四平市?共有?7?個(gè)子級(jí)城市!
?92?遼源市?共有?5?個(gè)子級(jí)城市!
?93?通化市?共有?8?個(gè)子級(jí)城市!
?94?白山市?共有?7?個(gè)子級(jí)城市!
?95?松原市?共有?6?個(gè)子級(jí)城市!
?96?白城市?共有?6?個(gè)子級(jí)城市!
?97?延邊自治州?共有?8?個(gè)子級(jí)城市!
?98?哈爾濱市?共有?20?個(gè)子級(jí)城市!
?99?齊齊哈爾市?共有?17?個(gè)子級(jí)城市!
100?雞西市?共有?10?個(gè)子級(jí)城市!
101?鶴崗市?共有?9?個(gè)子級(jí)城市!
102?雙鴨山市?共有?9?個(gè)子級(jí)城市!
103?大慶市?共有?10?個(gè)子級(jí)城市!
104?伊春市?共有?18?個(gè)子級(jí)城市!
105?佳木斯市?共有?12?個(gè)子級(jí)城市!
106?七臺(tái)河市?共有?5?個(gè)子級(jí)城市!
107?牡丹江市?共有?11?個(gè)子級(jí)城市!
108?黑河市?共有?7?個(gè)子級(jí)城市!
109?綏化市?共有?11?個(gè)子級(jí)城市!
110?大興安嶺地區(qū)?共有?3?個(gè)子級(jí)城市!
111?上海轄區(qū)?共有?18?個(gè)子級(jí)城市!
112?上海轄縣?共有?1?個(gè)子級(jí)城市!
113?南京市?共有?14?個(gè)子級(jí)城市!
114?無錫市?共有?9?個(gè)子級(jí)城市!
115?徐州市?共有?12?個(gè)子級(jí)城市!
116?常州市?共有?8?個(gè)子級(jí)城市!
117?蘇州市?共有?12?個(gè)子級(jí)城市!
118?南通市?共有?9?個(gè)子級(jí)城市!
119?連云港市?共有?8?個(gè)子級(jí)城市!
120?淮安市?共有?9?個(gè)子級(jí)城市!
121?鹽城市?共有?10?個(gè)子級(jí)城市!
122?揚(yáng)州市?共有?8?個(gè)子級(jí)城市!
123?鎮(zhèn)江市?共有?7?個(gè)子級(jí)城市!
124?泰州市?共有?7?個(gè)子級(jí)城市!
125?宿遷市?共有?6?個(gè)子級(jí)城市!
126?杭州市?共有?14?個(gè)子級(jí)城市!
127?寧波市?共有?12?個(gè)子級(jí)城市!
128?溫州市?共有?12?個(gè)子級(jí)城市!
129?嘉興市?共有?8?個(gè)子級(jí)城市!
130?湖州市?共有?6?個(gè)子級(jí)城市!
131?紹興市?共有?7?個(gè)子級(jí)城市!
132?金華市?共有?10?個(gè)子級(jí)城市!
133?衢州市?共有?7?個(gè)子級(jí)城市!
134?舟山市?共有?5?個(gè)子級(jí)城市!
135?臺(tái)州市?共有?10?個(gè)子級(jí)城市!
136?麗水市?共有?10?個(gè)子級(jí)城市!
137?合肥市?共有?8?個(gè)子級(jí)城市!
138?蕪湖市?共有?8?個(gè)子級(jí)城市!
139?蚌埠市?共有?8?個(gè)子級(jí)城市!
140?淮南市?共有?7?個(gè)子級(jí)城市!
141?馬鞍山市?共有?5?個(gè)子級(jí)城市!
142?淮北市?共有?5?個(gè)子級(jí)城市!
143?銅陵市?共有?5?個(gè)子級(jí)城市!
144?安慶市?共有?12?個(gè)子級(jí)城市!
145?黃山市?共有?8?個(gè)子級(jí)城市!
146?滁州市?共有?9?個(gè)子級(jí)城市!
147?阜陽(yáng)市?共有?9?個(gè)子級(jí)城市!
148?宿州市?共有?6?個(gè)子級(jí)城市!
149?巢湖市?共有?6?個(gè)子級(jí)城市!
150?六安市?共有?8?個(gè)子級(jí)城市!
151?亳州市?共有?5?個(gè)子級(jí)城市!
152?池州市?共有?5?個(gè)子級(jí)城市!
153?宣城市?共有?8?個(gè)子級(jí)城市!
154?福州市?共有?14?個(gè)子級(jí)城市!
155?廈門市?共有?7?個(gè)子級(jí)城市!
156?莆田市?共有?6?個(gè)子級(jí)城市!
157?三明市?共有?13?個(gè)子級(jí)城市!
158?泉州市?共有?13?個(gè)子級(jí)城市!
159?漳州市?共有?12?個(gè)子級(jí)城市!
160?南平市?共有?11?個(gè)子級(jí)城市!
161?龍巖市?共有?8?個(gè)子級(jí)城市!
162?寧德市?共有?10?個(gè)子級(jí)城市!
163?南昌市?共有?10?個(gè)子級(jí)城市!
164?景德鎮(zhèn)市?共有?5?個(gè)子級(jí)城市!
165?萍鄉(xiāng)市?共有?6?個(gè)子級(jí)城市!
166?九江市?共有?13?個(gè)子級(jí)城市!
167?新余市?共有?3?個(gè)子級(jí)城市!
168?鷹潭市?共有?4?個(gè)子級(jí)城市!
169?贛州市?共有?19?個(gè)子級(jí)城市!
170?吉安市?共有?14?個(gè)子級(jí)城市!
171?宜春市?共有?11?個(gè)子級(jí)城市!
172?撫州市?共有?12?個(gè)子級(jí)城市!
173?上饒市?共有?13?個(gè)子級(jí)城市!
174?濟(jì)南市?共有?11?個(gè)子級(jí)城市!
175?青島市?共有?13?個(gè)子級(jí)城市!
176?淄博市?共有?9?個(gè)子級(jí)城市!
177?棗莊市?共有?7?個(gè)子級(jí)城市!
178?東營(yíng)市?共有?6?個(gè)子級(jí)城市!
179?煙臺(tái)市?共有?13?個(gè)子級(jí)城市!
180?濰坊市?共有?13?個(gè)子級(jí)城市!
181?濟(jì)寧市?共有?13?個(gè)子級(jí)城市!
182?泰安市?共有?7?個(gè)子級(jí)城市!
183?威海市?共有?5?個(gè)子級(jí)城市!
184?日照市?共有?5?個(gè)子級(jí)城市!
185?萊蕪市?共有?3?個(gè)子級(jí)城市!
186?臨沂市?共有?13?個(gè)子級(jí)城市!
187?德州市?共有?12?個(gè)子級(jí)城市!
188?聊城市?共有?9?個(gè)子級(jí)城市!
189?濱州市?共有?8?個(gè)子級(jí)城市!
190?荷澤市?共有?10?個(gè)子級(jí)城市!
191?鄭州市?共有?13?個(gè)子級(jí)城市!
192?開封市?共有?11?個(gè)子級(jí)城市!
193?洛陽(yáng)市?共有?16?個(gè)子級(jí)城市!
194?平頂山市?共有?11?個(gè)子級(jí)城市!
195?安陽(yáng)市?共有?10?個(gè)子級(jí)城市!
196?鶴壁市?共有?6?個(gè)子級(jí)城市!
197?新鄉(xiāng)市?共有?13?個(gè)子級(jí)城市!
198?焦作市?共有?12?個(gè)子級(jí)城市!
199?濮陽(yáng)市?共有?7?個(gè)子級(jí)城市!
200?許昌市?共有?7?個(gè)子級(jí)城市!
201?漯河市?共有?6?個(gè)子級(jí)城市!
202?三門峽市?共有?7?個(gè)子級(jí)城市!
203?南陽(yáng)市?共有?14?個(gè)子級(jí)城市!
204?商丘市?共有?10?個(gè)子級(jí)城市!
205?信陽(yáng)市?共有?11?個(gè)子級(jí)城市!
206?周口市?共有?11?個(gè)子級(jí)城市!
207?駐馬店市?共有?11?個(gè)子級(jí)城市!
208?武漢市?共有?14?個(gè)子級(jí)城市!
209?黃石市?共有?7?個(gè)子級(jí)城市!
210?十堰市?共有?9?個(gè)子級(jí)城市!
211?宜昌市?共有?14?個(gè)子級(jí)城市!
212?襄樊市?共有?10?個(gè)子級(jí)城市!
213?鄂州市?共有?4?個(gè)子級(jí)城市!
214?荊門市?共有?6?個(gè)子級(jí)城市!
215?孝感市?共有?8?個(gè)子級(jí)城市!
216?荊州市?共有?9?個(gè)子級(jí)城市!
217?黃岡市?共有?11?個(gè)子級(jí)城市!
218?咸寧市?共有?7?個(gè)子級(jí)城市!
219?隨州市?共有?3?個(gè)子級(jí)城市!
220?恩施自治州?共有?8?個(gè)子級(jí)城市!
221?湖北省轄單位?共有?4?個(gè)子級(jí)城市!
222?長(zhǎng)沙市?共有?10?個(gè)子級(jí)城市!
223?株洲市?共有?10?個(gè)子級(jí)城市!
224?湘潭市?共有?6?個(gè)子級(jí)城市!
225?衡陽(yáng)市?共有?13?個(gè)子級(jí)城市!
226?邵陽(yáng)市?共有?13?個(gè)子級(jí)城市!
227?岳陽(yáng)市?共有?10?個(gè)子級(jí)城市!
228?常德市?共有?10?個(gè)子級(jí)城市!
229?張家界市?共有?5?個(gè)子級(jí)城市!
230?益陽(yáng)市?共有?7?個(gè)子級(jí)城市!
231?郴州市?共有?12?個(gè)子級(jí)城市!
232?永州市?共有?12?個(gè)子級(jí)城市!
233?懷化市?共有?13?個(gè)子級(jí)城市!
234?婁底市?共有?6?個(gè)子級(jí)城市!
235?湘西自治州?共有?8?個(gè)子級(jí)城市!
236?廣州市?共有?13?個(gè)子級(jí)城市!
237?韶關(guān)市?共有?11?個(gè)子級(jí)城市!
238?深圳市?共有?7?個(gè)子級(jí)城市!
239?珠海市?共有?4?個(gè)子級(jí)城市!
240?汕頭市?共有?8?個(gè)子級(jí)城市!
241?佛山市?共有?6?個(gè)子級(jí)城市!
242?江門市?共有?8?個(gè)子級(jí)城市!
243?湛江市?共有?10?個(gè)子級(jí)城市!
244?茂名市?共有?7?個(gè)子級(jí)城市!
245?肇慶市?共有?9?個(gè)子級(jí)城市!
246?惠州市?共有?6?個(gè)子級(jí)城市!
247?梅州市?共有?9?個(gè)子級(jí)城市!
248?汕尾市?共有?5?個(gè)子級(jí)城市!
249?河源市?共有?7?個(gè)子級(jí)城市!
250?陽(yáng)江市?共有?5?個(gè)子級(jí)城市!
251?清遠(yuǎn)市?共有?9?個(gè)子級(jí)城市!
252?潮州市?共有?4?個(gè)子級(jí)城市!
253?揭陽(yáng)市?共有?6?個(gè)子級(jí)城市!
254?云浮市?共有?6?個(gè)子級(jí)城市!
255?南寧市?共有?13?個(gè)子級(jí)城市!
256?柳州市?共有?11?個(gè)子級(jí)城市!
257?桂林市?共有?18?個(gè)子級(jí)城市!
258?梧州市?共有?8?個(gè)子級(jí)城市!
259?北海市?共有?5?個(gè)子級(jí)城市!
260?防城港市?共有?5?個(gè)子級(jí)城市!
261?欽州市?共有?5?個(gè)子級(jí)城市!
262?貴港市?共有?6?個(gè)子級(jí)城市!
263?玉林市?共有?7?個(gè)子級(jí)城市!
264?百色市?共有?13?個(gè)子級(jí)城市!
265?賀州市?共有?5?個(gè)子級(jí)城市!
266?河池市?共有?12?個(gè)子級(jí)城市!
267?來賓市?共有?7?個(gè)子級(jí)城市!
268?崇左市?共有?8?個(gè)子級(jí)城市!
269??？谑?共有?5?個(gè)子級(jí)城市!
270?三亞市?共有?1?個(gè)子級(jí)城市!
271?海南直轄縣?共有?19?個(gè)子級(jí)城市!
272?重慶轄區(qū)?共有?15?個(gè)子級(jí)城市!
273?重慶轄縣?共有?21?個(gè)子級(jí)城市!
274?重慶轄市?共有?4?個(gè)子級(jí)城市!
275?成都市?共有?20?個(gè)子級(jí)城市!
276?自貢市?共有?7?個(gè)子級(jí)城市!
277?攀枝花市?共有?6?個(gè)子級(jí)城市!
278?瀘州市?共有?8?個(gè)子級(jí)城市!
279?德陽(yáng)市?共有?7?個(gè)子級(jí)城市!
280?綿陽(yáng)市?共有?10?個(gè)子級(jí)城市!
281?廣元市?共有?8?個(gè)子級(jí)城市!
282?遂寧市?共有?6?個(gè)子級(jí)城市!
283?內(nèi)江市?共有?6?個(gè)子級(jí)城市!
284?樂山市?共有?12?個(gè)子級(jí)城市!
285?南充市?共有?10?個(gè)子級(jí)城市!
286?眉山市?共有?7?個(gè)子級(jí)城市!
287?宜賓市?共有?11?個(gè)子級(jí)城市!
288?廣安市?共有?6?個(gè)子級(jí)城市!
289?達(dá)州市?共有?8?個(gè)子級(jí)城市!
290?雅安市?共有?9?個(gè)子級(jí)城市!
291?巴中市?共有?5?個(gè)子級(jí)城市!
292?資陽(yáng)市?共有?5?個(gè)子級(jí)城市!
293?阿壩自治州?共有?13?個(gè)子級(jí)城市!
294?甘孜自治州?共有?18?個(gè)子級(jí)城市!
295?涼山自治州?共有?17?個(gè)子級(jí)城市!
296?貴陽(yáng)市?共有?11?個(gè)子級(jí)城市!
297?六盤水市?共有?4?個(gè)子級(jí)城市!
298?遵義市?共有?15?個(gè)子級(jí)城市!
299?安順市?共有?7?個(gè)子級(jí)城市!
300?銅仁地區(qū)?共有?10?個(gè)子級(jí)城市!
301?黔西南自治州?共有?8?個(gè)子級(jí)城市!
302?畢節(jié)地區(qū)?共有?8?個(gè)子級(jí)城市!
303?黔東南自治州?共有?16?個(gè)子級(jí)城市!
304?黔南自治州?共有?12?個(gè)子級(jí)城市!
305?昆明市?共有?15?個(gè)子級(jí)城市!
306?曲靖市?共有?10?個(gè)子級(jí)城市!
307?玉溪市?共有?10?個(gè)子級(jí)城市!
308?保山市?共有?6?個(gè)子級(jí)城市!
309?昭通市?共有?12?個(gè)子級(jí)城市!
310?麗江市?共有?6?個(gè)子級(jí)城市!
311?思茅市?共有?11?個(gè)子級(jí)城市!
312?臨滄市?共有?9?個(gè)子級(jí)城市!
313?楚雄自治州?共有?10?個(gè)子級(jí)城市!
314?紅河自治州?共有?13?個(gè)子級(jí)城市!
315?文山自治州?共有?8?個(gè)子級(jí)城市!
316?西雙版納州?共有?3?個(gè)子級(jí)城市!
317?大理自治州?共有?12?個(gè)子級(jí)城市!
318?德宏自治州?共有?5?個(gè)子級(jí)城市!
319?怒江傈自治州?共有?4?個(gè)子級(jí)城市!
320?迪慶自治州?共有?3?個(gè)子級(jí)城市!
321?拉薩市?共有?9?個(gè)子級(jí)城市!
322?昌都地區(qū)?共有?11?個(gè)子級(jí)城市!
323?山南地區(qū)?共有?12?個(gè)子級(jí)城市!
324?日喀則地區(qū)?共有?18?個(gè)子級(jí)城市!
325?那曲地區(qū)?共有?10?個(gè)子級(jí)城市!
326?阿里地區(qū)?共有?7?個(gè)子級(jí)城市!
327?林芝地區(qū)?共有?7?個(gè)子級(jí)城市!
328?西安市?共有?14?個(gè)子級(jí)城市!
329?銅川市?共有?5?個(gè)子級(jí)城市!
330?寶雞市?共有?13?個(gè)子級(jí)城市!
331?咸陽(yáng)市?共有?15?個(gè)子級(jí)城市!
332?渭南市?共有?12?個(gè)子級(jí)城市!
333?延安市?共有?14?個(gè)子級(jí)城市!
334?漢中市?共有?12?個(gè)子級(jí)城市!
335?榆林市?共有?13?個(gè)子級(jí)城市!
336?安康市?共有?11?個(gè)子級(jí)城市!
337?商洛市?共有?8?個(gè)子級(jí)城市!
338?蘭州市?共有?9?個(gè)子級(jí)城市!
339?嘉峪關(guān)市?共有?1?個(gè)子級(jí)城市!
340?金昌市?共有?3?個(gè)子級(jí)城市!
341?白銀市?共有?6?個(gè)子級(jí)城市!
342?天水市?共有?8?個(gè)子級(jí)城市!
343?武威市?共有?5?個(gè)子級(jí)城市!
344?張掖市?共有?7?個(gè)子級(jí)城市!
345?平?jīng)鍪?共有?8?個(gè)子級(jí)城市!
346?酒泉市?共有?8?個(gè)子級(jí)城市!
347?慶陽(yáng)市?共有?9?個(gè)子級(jí)城市!
348?定西市?共有?8?個(gè)子級(jí)城市!
349?隴南市?共有?10?個(gè)子級(jí)城市!
350?臨夏自治州?共有?8?個(gè)子級(jí)城市!
351?甘南自治州?共有?8?個(gè)子級(jí)城市!
352?西寧市?共有?8?個(gè)子級(jí)城市!
353?海東地區(qū)?共有?6?個(gè)子級(jí)城市!
354?海北自治州?共有?4?個(gè)子級(jí)城市!
355?黃南自治州?共有?4?個(gè)子級(jí)城市!
356?海南自治州?共有?5?個(gè)子級(jí)城市!
357?果洛自治州?共有?6?個(gè)子級(jí)城市!
358?玉樹自治州?共有?6?個(gè)子級(jí)城市!
359?海西自治州?共有?5?個(gè)子級(jí)城市!
360?銀川市?共有?7?個(gè)子級(jí)城市!
361?石嘴山市?共有?4?個(gè)子級(jí)城市!
362?吳忠市?共有?5?個(gè)子級(jí)城市!
363?固原市?共有?6?個(gè)子級(jí)城市!
364?中衛(wèi)市?共有?4?個(gè)子級(jí)城市!
365?烏魯木齊市?共有?9?個(gè)子級(jí)城市!
366?克拉瑪依市?共有?5?個(gè)子級(jí)城市!
367?吐魯番地區(qū)?共有?3?個(gè)子級(jí)城市!
368?哈密地區(qū)?共有?3?個(gè)子級(jí)城市!
369?昌吉自治州?共有?8?個(gè)子級(jí)城市!
370?博爾塔拉州?共有?3?個(gè)子級(jí)城市!
371?巴音郭楞州?共有?9?個(gè)子級(jí)城市!
372?阿克蘇地區(qū)?共有?9?個(gè)子級(jí)城市!
373?克孜勒蘇州?共有?4?個(gè)子級(jí)城市!
374?喀什地區(qū)?共有?12?個(gè)子級(jí)城市!
375?和田地區(qū)?共有?8?個(gè)子級(jí)城市!
376?伊犁自治州?共有?10?個(gè)子級(jí)城市!
377?塔城地區(qū)?共有?7?個(gè)子級(jí)城市!
378?阿勒泰地區(qū)?共有?7?個(gè)子級(jí)城市!
379?[alex@localhost?temp]$
4270行SQL 以下給出部分 太大啦. (全部SQL請(qǐng)下載)
?1?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(1,1,'001','0','北京市');
?2?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(2,1,'002','0','天津市');
?3?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(3,1,'003','0','河北省');
?4?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(4,1,'004','0','山西省');
?5?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(5,1,'005','0','內(nèi)蒙古區(qū)');
?6?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(6,1,'006','0','遼寧省');
?7?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(7,1,'007','0','吉林省');
?8?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(8,1,'008','0','黑龍江省');
?9?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(9,1,'009','0','上海市');
10?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(10,1,'010','0','江蘇省');
11?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(11,1,'011','0','浙江省');
12?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(12,1,'012','0','安徽省');
13?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(13,1,'013','0','福建省');
14?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(14,1,'014','0','江西省');
15?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(15,1,'015','0','山東省');
16?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(16,1,'016','0','河南省');
17?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(17,1,'017','0','湖北省');
18?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(18,1,'018','0','湖南省');
19?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(19,1,'019','0','廣東省');
20?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(20,1,'020','0','廣西區(qū)');
21?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(21,1,'021','0','海南省');
22?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(22,1,'022','0','重慶市');
23?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(23,1,'023','0','四川省');
24?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(24,1,'024','0','貴州省');
25?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(25,1,'025','0','云南省');
26?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(26,1,'026','0','西藏區(qū)');
27?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(27,1,'027','0','陜西省');
28?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(28,1,'028','0','甘肅省');
29?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(29,1,'029','0','青海省');
30?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(30,1,'030','0','寧夏區(qū)');
31?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(31,1,'031','0','新疆區(qū)');
32?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(32,1,'032','0','臺(tái)灣省');
33?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(33,1,'033','0','香港特區(qū)');
34?insert?into?address(id,?levels,?addkey,?belongkey,?toponym)?values?(34,1,'034','0','澳門特區(qū)');
自己建表,表結(jié)構(gòu)很簡(jiǎn)單的吧!以上SQL插入語(yǔ)句大多數(shù)數(shù)據(jù)庫(kù)都能用. (不能用自己改動(dòng)ReadLocalityXml.java再用源碼生成SQL)
?1?mysql>?show?create?table?address;
?2?+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
?3?|?Table???|?Create?Table?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|
?4?+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
?5?|?address?|?CREATE?TABLE?`address`?(
?6???`id`?int(11)?NOT?NULL,
?7???`levels`?tinyint(4)?NOT?NULL,
?8???`addkey`?varchar(10)?NOT?NULL,
?9???`belongkey`?varchar(10)?NOT?NULL,
10???`toponym`?varchar(20)?NOT?NULL
11?)?ENGINE=InnoDB?DEFAULT?CHARSET=utf8?|
12?+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
13?1?row?in?set?(0.00?sec)
這樣查詢一級(jí)一級(jí).
?1?mysql>?select?`addkey`,`toponym`?from?address?where?belongkey?=?'0';
?2?+--------+--------------+
?3?|?addkey?|?toponym??????|
?4?+--------+--------------+
?5?|?001????|?北京市???????|
?6?|?002????|?天津市???????|
?7?|?003????|?河北省???????|
?8?|?004????|?山西省???????|
?9?|?005????|?內(nèi)蒙古區(qū)?????|
10?|?006????|?遼寧省???????|
11?|?007????|?吉林省???????|
12?|?008????|?黑龍江省?????|
13?|?009????|?上海市???????|
14?|?010????|?江蘇省???????|
15?|?011????|?浙江省???????|
16?|?012????|?安徽省???????|
17?|?013????|?福建省???????|
18?|?014????|?江西省???????|
19?|?015????|?山東省???????|
20?|?016????|?河南省???????|
21?|?017????|?湖北省???????|
22?|?018????|?湖南省???????|
23?|?019????|?廣東省???????|
24?|?020????|?廣西區(qū)???????|
25?|?021????|?海南省???????|
26?|?022????|?重慶市???????|
27?|?023????|?四川省???????|
28?|?024????|?貴州省???????|
29?|?025????|?云南省???????|
30?|?026????|?西藏區(qū)???????|
31?|?027????|?陜西省???????|
32?|?028????|?甘肅省???????|
33?|?029????|?青海省???????|
34?|?030????|?寧夏區(qū)???????|
35?|?031????|?新疆區(qū)???????|
36?|?032????|?臺(tái)灣省???????|
37?|?033????|?香港特區(qū)?????|
38?|?034????|?澳門特區(qū)?????|
39?+--------+--------------+
40?34?rows?in?set?(0.01?sec)
41?
42?mysql>
?1?mysql>?select?`addkey`,`toponym`?from?address?where?belongkey?=?'018';
?2?+--------+-----------------+
?3?|?addkey?|?toponym?????????|
?4?+--------+-----------------+
?5?|?018001?|?長(zhǎng)沙市??????????|
?6?|?018002?|?株洲市??????????|
?7?|?018003?|?湘潭市??????????|
?8?|?018004?|?衡陽(yáng)市??????????|
?9?|?018005?|?邵陽(yáng)市??????????|
10?|?018006?|?岳陽(yáng)市??????????|
11?|?018007?|?常德市??????????|
12?|?018008?|?張家界市????????|
13?|?018009?|?益陽(yáng)市??????????|
14?|?018010?|?郴州市??????????|
15?|?018011?|?永州市??????????|
16?|?018012?|?懷化市??????????|
17?|?018013?|?婁底市??????????|
18?|?018014?|?湘西自治州??????|
19?+--------+-----------------+
20?14?rows?in?set?(0.00?sec)
21?
22?mysql>
?1?mysql>?select?`addkey`,`toponym`?from?address?where?belongkey?=?'018011';
?2?+-----------+-----------------------+
?3?|?addkey????|?toponym???????????????|
?4?+-----------+-----------------------+
?5?|?018011001?|?市轄區(qū)????????????????|
?6?|?018011002?|?芝山區(qū)????????????????|
?7?|?018011003?|?冷水灘區(qū)??????????????|
?8?|?018011004?|?祁陽(yáng)縣????????????????|
?9?|?018011005?|?東安縣????????????????|
10?|?018011006?|?雙牌縣????????????????|
11?|?018011007?|?道縣??????????????????|
12?|?018011008?|?江永縣????????????????|
13?|?018011009?|?寧遠(yuǎn)縣????????????????|
14?|?018011010?|?藍(lán)山縣????????????????|
15?|?018011011?|?新田縣????????????????|
16?|?018011012?|?江華瑤族自治縣????????|
17?+-----------+-----------------------+
18?12?rows?in?set?(0.00?sec)
19?
20?mysql>