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