mybatis框架練習

mybatis框架中，包括實體類（這些實體類與數據庫中的字段屬性相對應），mybatis的配置文件（即mybatis-config.xml，這個配置文件用于連接實體類和orm（object relationship mapping 對象關系映射），以及做連接數據庫的配置信息的配置），ORM（相當于xxxDao的實現類，同時將對象和數據庫表的關系對應起來），xxxDao接口（用于外界使用時調用功能方法）

一對多關系查詢

user對象----pet對象：一個人user可以有多只寵物?pet，而一個寵物只能有一個主人，因此他們是一對多的關系?

user對象----hobby對象：一個人可以有多個愛好，一個愛好也可以有多個人同時擁有，因此他們是多對多的關系

area對象 上級對下級是一對多關系 采用 自連接 實現關系查詢

user(

int userId

String userName

String gender

int score

list<pet> pets ?//在user對象中，設置一個list來存放寵物

list<hobby> hobbys?

)

pet（

user user // 在pet對象中，設置一個user對象，表示該寵物的主人

int petId

String petName

）

hobby（

list<user> users

int hobbyId

String hobbyName

）

area(

int areaId

String areaName

int parentId

list<area> childAreaList

)

文檔樹建立

MyBatisUtils?類，用來讀取mybatis的配置文件mybatis-config.xml

import java.io.IOException; import java.io.Reader; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public class MyBatisUtils {private static SqlSessionFactory sqlSessionFactory;private static Reader reader;static {try {reader = Resources.getResourceAsReader("mybatis-config.xml");sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);} catch (IOException e) {e.printStackTrace();}}public static SqlSession getSession() {return sqlSessionFactory.openSession();} }

配置實體類和ORM的路徑

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration><!-- 1. 模型對象 --><typeAliases> <!-- 定義實體類的地方 --><typeAlias alias="User" type="com.bwf.entity.User"/> <typeAlias alias="Pet" type="com.bwf.entity.Pet"/><typeAlias alias="Hobby" type="com.bwf.entity.Hobby"/><typeAlias alias="Area" type="com.bwf.entity.Area"/><!-- <package name="com.bwf.entity"/> 這種方式就可以把entity包下的類都定義好，只是自動定義的別名是類名的小寫形式--></typeAliases> <!-- 2. 數據庫連接信息 --><environments default="development"><!-- 開發環境 --><environment id="development"><!-- 事務管理器：基于jdbc --><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="com.mysql.cj.jdbc.Driver"/><!-- jdbc參數：user 用戶名password 密碼useUnicode 是否使用Unicode字符集characterEncoding 當useUnicode為true是，指定字符編碼(utf-8\gbk\gb2312)autoReconnect 當數據庫斷開時，是否自動連接autoReconnectForPools 是否使用針對數據庫連接池的重連策略failOverReadOnly 自動重連成功后，連接是否設置為只讀？maxReconnects autoReconnect設置為true時，重試連接的次數initialTimeout autoReconnect設置為true時，兩次重連之間的時間間隔，單位：秒connectTimeout 和數據庫服務器建立socket連接時的超時，單位：毫秒。 0表示永不超時，適用于JDK 1.4及更高版本socketTimeout socket操作（讀寫）超時，單位：毫秒。 0表示永不超時timeZone\serverTimezone 設置時區useSSL 使用ssl協議--><property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis1?useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=PRC&amp;useSSL=true" /><property name="username" value="root"/><property name="password" value="123456"/></dataSource></environment><!-- 生產環境<environment id="production"></environment>--></environments><!-- 3. ORM --><mappers><!-- 通過這個文件 把 數據庫中的表 映射到 實體類上去 --><mapper resource="com/bwf/mapper/User.xml"/><mapper resource="com/bwf/mapper/Pet.xml"/><mapper resource="com/bwf/mapper/Hobby.xml"/><mapper resource="com/bwf/mapper/Area.xml"/></mappers></configuration>

?UserDao

public interface UserDao {//查詢單個userUser getUserById(int id);//增加void add(User user);//刪除void delete(int id);//更新void update(User user);//查詢所有元素List<User> getUserList();//查詢指定性別的用戶List<User> getUserByGender(String gender);//查詢數據庫表中的指定字段數據 ，需要在user.xml中配置resultMapList<User> getNewUser();//查詢帶有Pet集合的user列表List<User> getUserListWithPet();//查詢帶有Hobby集合的user列表List<User> getUserListwithHobby(); }

ORM:user.xml配置

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!-- 對應 dao 中的 接口 相當于實現UserDao接口--> <mapper namespace="com.bwf.dao.UserDao"><!-- 這個配置文件相當于UserDao的實現類 --><!-- 自定義 返回數據類型 resultMap 這個東西在多表聯查中使用較多--><!-- resultMap內放的是實體類的成員屬性 --><!-- 如果數據庫中的字段名與實體類中的屬性名不同，則要配置下面的 映射 --><resultMap type="User" id="newUser"><!-- 這里的type表示實體類 id表示經過映射得到的結果類 id="newUser"表示我們查詢的結果可以用這個newUser來封裝 在后面的查詢配置中寫返回值類型時就是用的id的值 --><!-- id標簽表示主鍵字段 result標簽表示其他字段 里面的column屬性對應數據庫中的字段名 property對應實體類中的屬性名--><id column="user_id" property="userId"/><result column="username" property="username"/><result column="gender" property="gender"/><result column="score" property="score"/></resultMap><resultMap type="User" id="newUserwithPet"><id column="user_id" property="userId"/><result column="username" property="username"/><result column="gender" property="gender"/><result column="score" property="score"/><!-- user對pet是一對多的關系 使用collection標簽表示 --><!-- property 對應User中的List<Pet> pets集合 對應一方實體類中的 多方引用的屬性ofType 對應pets集合中元素的類型 對應查詢結果集合中的元素類型resultMap 相當于將Pet.xml中的resultMap加載進來 加載封裝類newPet也可以直接將Pet.xml中的resultMap復制過來 --><collection property="pets" ofType="Pet" resultMap="com.bwf.dao.PetDao.newPet" ></collection></resultMap><resultMap type="User" id="newUserwithHobby"><id column="user_id" property="userId"/><result column="username" property="username"/><result column="gender" property="gender"/><result column="score" property="score"/><!-- 打造包含Hobby集合的映射類 --><collection property="hobbies" ofType="Hobby" resultMap="com.bwf.dao.HobbyDao.newHobby"></collection></resultMap><!-- 對應 dao接口中的方法id -> 方法名parameterType -> 方法的形參類型resultType -> 方法的返回值類型--><!-- 添加模型對象 --><insert id="add" parameterType="User" keyProperty="user_id" useGeneratedKeys="true"><!-- keyProperty="id"表示主鍵列為user.id,這個可有可無 useGeneratedKeys="true"表示插入數據時自增列自動增長 --><!-- insert into 'user' (username,gender,score) values (#{username},#{gender},#{score}); -->insert into user values(null,#{username},#{gender},#{score})</insert><!-- 刪除模型對象 --><delete id="delete" parameterType="int">delete from user where id = #{userId}</delete><!-- 更新對象數據 --><update id="update" parameterType="User">update `user` set username=#{username},gender=#{gender},score=#{score} where user_id=#{userId}</update><!-- 查詢對象數據 ：：：注意：：：無論是查詢單個還是多個對象，select標簽中的返回值類型resultType 都必須設置成對應的實體類User --><!-- 根據Id查詢一個模型對象 --><select id="getUserById" parameterType="int" resultMap="newUser">select * from `user` where user_id = #{userId}</select><!-- 查詢用戶列表 --><select id="getUserList" resultMap="newUser">select * from `user`</select><!-- 查詢指定性別的user --><!-- 因為String不是基本數據類型，所以要帶上包名 --><select id="getUserByGender" parameterType="java.lang.String" resultMap="newUser">select * from `user` where gender=#{gender}</select><!-- 查詢數據庫表中的指定字段數據 在這里就使用到了resultMap中的newUser--><select id="getNewUser" resultMap="newUser">select user_id,username from `user`<!-- 也可以這樣 select * from `user` 只是待會mybatis封裝時只封裝這兩個字段的數據 但是這種方法會將查詢結果封裝成User 不建議這樣寫 --><!-- 我覺得并不是這樣，而是只要寫一個簡單類型(包括所有的簡單數據類型屬性)的resultMap,然后寫一個查找指定字段的sql語句 --></select><!-- 查詢帶有Pet集合的user列表 --><select id="getUserListWithPet" resultMap="newUserwithPet">select * from user left outer join pet on user.user_id = pet.user_id</select><!-- 查詢帶有Hobby集合的user列表 --><select id="getUserListwithHobby" resultMap="newUserwithHobby">select * from user u left join user_hobby uh on u.user_id = uh.user_id left join hobby h on uh.hobby_id = h.hobby_id</select></mapper>

PetDao

public interface PetDao {Pet getPetById(int petId);List<Pet> getPetList();List<Pet> getPetswithUser(); }

pet.xml配置

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!-- 對應 dao 中的 接口 --> <mapper namespace="com.bwf.dao.PetDao"><resultMap type="Pet" id="newPet"><id column="pet_id" property="petId"/><result column="pet_name" property="petName"/></resultMap><resultMap type="Pet" id="newPetwithUser"><id column="pet_id" property="petId"/><result column="pet_name" property="petName"/><!-- Pet對User是多對一關系 使用association(關聯)標簽方法一與User.xml中的一樣，引用過來不同點事這里用的 javaType--><association property="user" javaType="User" resultMap="com.bwf.dao.UserDao.newUser"><!-- 一種方法是將User.xml中的resultMap內容拷過來 --></association></resultMap><!-- 查詢對象數據 --><!-- 根據Id查詢一個模型對象 --><select id="getPetById" parameterType="int" resultMap="newPet">select * from `pet` where pet_id = #{petId}</select><!-- 查詢用戶列表 --><select id="getPetList" resultMap="newPet">select * from `pet`</select><select id="getPetswithUser" resultMap="newPetwithUser">select * from pet left outer join user on pet.user_id=user.user_id</select></mapper>

HobbyDao

public interface HobbyDao {//查詢有同一愛好的所有用戶和愛好的信息List<Hobby> getHobbyListforUser(); }

hobby.xml配置

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.bwf.dao.HobbyDao"><resultMap type="Hobby" id="newHobby"><id column="hobby_id" property="hobbyId"/><result column="hobby_name" property="hobbyName"/></resultMap><resultMap type="Hobby" id="newHobbyforUser"><id column="hobby_id" property="hobbyId"/><result column="hobby_name" property="hobbyName"/><collection property="users" ofType="User" resultMap="com.bwf.dao.UserDao.newUser"></collection></resultMap><select id="getHobbyListforUser" resultMap="newHobbyforUser">select * from hobby h left join user_hobby uh on h.hobby_id = uh.hobby_id left join user u on uh.user_id = u.user_id</select> </mapper>

AreaDao

public interface AreaDao {Area getAreaById(int areaId);List<Area> getAreaByName(String areaName); //查詢帶下級的AreaArea getAreawithChild(int areaId); List<Area> getChildAreaByParentId(int parentId); //查詢一個帶上下級的AreaArea getAreawithParentandChild(int areaId); }

area.xml配置

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.bwf.dao.AreaDao"><resultMap type="Area" id="baseArea"><id column="area_id" property="areaId"/><result column="area_name" property="areaName"/><result column="parent_id" property="parentId"/></resultMap><!-- 查詢帶子集的Area --><resultMap type="Area" id="areawithChild"><id column="area_id" property="areaId"/><result column="area_name" property="areaName"/><result column="parent_id" property="parentId"/><!-- <collection property="childAreaList" ofType="Area" resultMap="baseArea"></collection>這種方式查出的結果主表和從表的屬性名會重復，我們不知道要如何進行封裝，不可行--><!-- 上下級關系為 “自連接” 關系要采用兩次查詢，即通過遞歸解決column 表示主鍵列，我們要通過主鍵列來進行二次查詢select 引用另一個方法：我們傳入一個編號，他幫我們查出所有子集，不包括自己接下來在 Area 中添加一個 getChildAreaByParentId 方法要實現遞歸操作，將 ofType 的值設置成 areawithChild 類型 這樣查詢結果就可以帶 子集如果寫Area類型相當于用的是baseArea類型--><collection property="childAreaList" ofType="areawithChild" column="area_id"select="getChildAreaByParentId"></collection></resultMap><select id="getAreaById" parameterType="int" resultMap="baseArea">select * from area where area_id = #{areaId}</select><select id="getAreawithChild" parameterType="int" resultMap="areawithChild">select * from area where area_id = #{areaId}</select><!-- 通過parentId查詢本級的所有子集，不包括本級本身，由sql語句決定這里的 resultMap 設置成 areawithChild 類型是為了遞歸查找子集，一直可以查詢下去--><select id="getChildAreaByParentId" parameterType="int" resultMap="areawithChild">select * from area where parent_id = #{parentId}</select><!-- <select id="getAreawithParentandChild" parameterType="int" resultMap=""></select> --> </mapper>

測試數據mybatis.sql

/* SQLyog Ultimate v8.32 MySQL - 5.5.20 : Database - mybatis1 ********************************************************************* *//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`mybatis1` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `mybatis1`;/*Table structure for table `area` */DROP TABLE IF EXISTS `area`;CREATE TABLE `area` (`area_id` int(11) NOT NULL,`area_name` varchar(40) DEFAULT NULL,`parent_id` int(11) DEFAULT NULL,PRIMARY KEY (`area_id`),KEY `FK_CHINA_REFERENCE_CHINA` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;/*Data for the table `area` */insert into `area`(`area_id`,`area_name`,`parent_id`) values (110000,'北京市',NULL),(110100,'東城區',110000),(110200,'西城區',110000),(110500,'朝陽區',110000),(110600,'豐臺區',110000),(110700,'石景山區',110000),(110800,'海淀區',110000),(110900,'門頭溝區',110000),(111100,'房山區',110000),(111200,'通州區',110000),(111300,'順義區',110000),(111400,'昌平區',110000),(111500,'大興區',110000),(111600,'懷柔區',110000),(111700,'平谷區',110000),(112800,'密云縣',110000),(112900,'延慶縣',110000),(120000,'天津市',NULL),(120100,'和平區',120000),(120200,'河東區',120000),(120300,'河西區',120000),(120400,'南開區',120000),(120500,'河北區',120000),(120600,'紅橋區',120000),(120900,'濱海新區',120000),(121000,'東麗區',120000),(121100,'西青區',120000),(121200,'津南區',120000),(121300,'北辰區',120000),(121400,'武清區',120000),(121500,'寶坻區',120000),(122100,'寧河縣',120000),(122300,'靜海縣',120000),(122500,'薊縣',120000),(130000,'河北省',NULL),(130100,'石家莊市',130000),(130101,'市轄區',130100),(130102,'長安區',130101),(130103,'橋東區',130101),(130104,'橋西區',130101),(130105,'新華區',130101),(130107,'井陘礦區',130101),(130108,'裕華區',130101),(130121,'井陘縣',130100),(130123,'正定縣',130100),(130124,'欒城縣',130100),(130125,'行唐縣',130100),(130126,'靈壽縣',130100),(130127,'高邑縣',130100),(130128,'深澤縣',130100),(130129,'贊皇縣',130100),(130130,'無極縣',130100),(130131,'平山縣',130100),(130132,'元氏縣',130100),(130133,'趙縣',130100),(130181,'辛集市',130100),(130182,'藁城市',130100),(130183,'晉州市',130100),(130184,'新樂市',130100),(130185,'鹿泉市',130100),(130200,'唐山市',130000),(130201,'市轄區',130200),(130202,'路南區',130201),(130203,'路北區',130201),(130204,'古冶區',130201),(130205,'開平區',130201),(130207,'豐南區',130201),(130208,'豐潤區',130201),(130223,'灤縣',130200),(130224,'灤南縣',130200),(130225,'樂亭縣',130200),(130227,'遷西縣',130200),(130229,'玉田縣',130200),(130230,'唐海縣',130200),(130281,'遵化市',130200),(130283,'遷安市',130200),(130300,'秦皇島市',130000),(130301,'海港區',130300),(130303,'山海關區',130300),(130304,'北戴河區',130300),(130321,'青龍滿族自治縣',130300),(130322,'昌黎縣',130300),(130323,'撫寧縣',130300),(130324,'盧龍縣',130300),(130400,'邯鄲市',130000),(130401,'市轄區',130400),(130402,'邯山區',130401),(130403,'叢臺區',130401),(130404,'復興區',130401),(130406,'峰峰礦區',130401),(130421,'邯鄲縣',130400),(130423,'臨漳縣',130400),(130424,'成安縣',130400),(130425,'大名縣',130400),(130426,'涉縣',130400),(130427,'磁縣',130400),(130428,'肥鄉縣',130400),(130429,'永年縣',130400),(130430,'邱縣',130400),(130431,'雞澤縣',130400),(130432,'廣平縣',130400),(130433,'館陶縣',130400),(130434,'魏縣',130400),(130435,'曲周縣',130400),(130481,'武安市',130400),(130500,'邢臺市',130000),(130501,'市轄區',130500),(130502,'橋東區',130501),(130503,'橋西區',130501),(130521,'邢臺縣',130500),(130522,'臨城縣',130500),(130523,'內丘縣',130500),(130524,'柏鄉縣',130500),(130525,'隆堯縣',130500),(130526,'任縣',130500),(130527,'南和縣',130500),(130528,'寧晉縣',130500),(130529,'巨鹿縣',130529),(130530,'新河縣',130500),(130531,'廣宗縣',130500),(130532,'平鄉縣',130500),(130533,'威縣',130500),(130534,'清河縣',130500),(130535,'臨西縣',130500),(130581,'南宮市',130500),(130582,'沙河市',130500),(130600,'保定市',130000),(130601,'新市區',130600),(130603,'北市區',130600),(130604,'南市區',130600),(130621,'滿城縣',130600),(130622,'清苑縣',130600),(130623,'淶水縣',130600),(130624,'阜平縣',130600),(130625,'徐水縣',130600),(130626,'定興縣',130600),(130627,'唐縣',130600),(130628,'高陽縣',130600),(130629,'容城縣',130600),(130630,'淶源縣',130600),(130631,'望都縣',130600),(130632,'安新縣',130600),(130633,'易縣',130600),(130634,'曲陽縣',130600),(130635,'蠡縣',130600),(130636,'順平縣',130600),(130637,'博野縣',130600),(130638,'雄縣',130600),(130681,'涿州市',130600),(130682,'定州市',130600),(130683,'安國市',130600),(130684,'高碑店市',130600),(130685,'白溝新城縣',130600),(130700,'張家口市',130000),(130701,'市轄區',130700),(130702,'橋東區',130701),(130703,'橋西區',130701),(130705,'宣化區',130701),(130706,'下花園區',130701),(130721,'宣化縣',130700),(130722,'張北縣',130700),(130723,'康保縣',130700),(130724,'沽源縣',130700),(130725,'尚義縣',130700),(130726,'蔚縣',130700),(130727,'陽原縣',130700),(130728,'懷安縣',130700),(130729,'萬全縣',130700),(130730,'懷來縣',130700),(130731,'涿鹿縣',130700),(130732,'赤城縣',130700),(130733,'崇禮縣',130700),(130800,'承德市',130000),(130801,'市轄區',130800),(130802,'雙橋區',130801),(130803,'雙灤區',130801),(130804,'鷹手營子礦區',130801),(130821,'承德縣',130800),(130822,'興隆縣',130800),(130823,'平泉縣',130800),(130824,'灤平縣',130800),(130825,'隆化縣',130800),(130826,'豐寧滿族自治縣',130800),(130827,'寬城滿族自治縣',130800),(130828,'圍場滿族蒙古族自治縣',130800),(130900,'滄州市',130000),(130901,'市轄區',130900),(130902,'新華區',130901),(130903,'運河區',130901),(130921,'滄縣',130900),(130922,'青縣',130900),(130923,'東光縣',130900),(130924,'海興縣',130900),(130925,'鹽山縣',130900),(130926,'肅寧縣',130900),(130927,'南皮縣',130900),(130928,'吳橋縣',130900),(130929,'獻縣',130900),(130930,'孟村回族自治縣',130900),(130981,'泊頭市',130900),(130982,'任丘市',130900),(130983,'黃驊市',130900),(130984,'河間市',130900),(131000,'廊坊市',130000),(131001,'市轄區',131000),(131002,'安次區',131001),(131003,'廣陽區',131001),(131022,'固安縣',131000),(131023,'永清縣',131000),(131024,'香河縣',131000),(131025,'大城縣',131000),(131026,'文安縣',131000),(131028,'大廠回族自治縣',131000),(131081,'霸州市',131000),(131082,'三河市',131000),(131100,'衡水市',130000),(131101,'市轄區',131100),(131102,'桃城區',131101),(131121,'棗強縣',131100),(131122,'武邑縣',131100),(131123,'武強縣',131100),(131124,'饒陽縣',131100),(131125,'安平縣',131100),(131126,'故城縣',131100),(131127,'景縣',131100),(131128,'阜城縣',131100),(131181,'冀州市',131100),(131182,'深州市',131100),(140000,'山西省',NULL),(140100,'太原市',140000),(140101,'市轄區',140100),(140105,'小店區',140101),(140106,'迎澤區',140101),(140107,'杏花嶺區',140101),(140108,'尖草坪區',140101),(140109,'萬柏林區',140101),(140110,'晉源區',140101),(140121,'清徐縣',140100),(140122,'陽曲縣',140100),(140123,'婁煩縣',140100),(140181,'古交市',140100),(140200,'大同市',140000),(140201,'市轄區',140200),(140202,'城區',140201),(140203,'礦區',140201),(140211,'南郊區',140201),(140212,'新榮區',140201),(140221,'陽高縣',140200),(140222,'天鎮縣',140200),(140223,'廣靈縣',140200),(140224,'靈丘縣',140200),(140225,'渾源縣',140200),(140226,'左云縣',140200),(140227,'大同縣',140200),(140300,'陽泉市',140000),(140301,'市轄區',140300),(140302,'城區',140301),(140303,'礦區',140301),(140311,'郊區',140301),(140321,'平定縣',140300),(140322,'盂縣',140300),(140400,'長治市',140000),(140401,'市轄區',140400),(140402,'城區',140401),(140411,'郊區',140401),(140421,'長治縣',140400),(140423,'襄垣縣',140400),(140424,'屯留縣',140400),(140425,'平順縣',140400),(140426,'黎城縣',140400),(140427,'壺關縣',140400),(140428,'長子縣',140400),(140429,'武鄉縣',140400),(140430,'沁縣',140400),(140431,'沁源縣',140400),(140481,'潞城市',140400),(140500,'晉城市',140000),(140501,'市轄區',140500),(140502,'城區',140501),(140521,'沁水縣',140500),(140522,'陽城縣',140500),(140524,'陵川縣',140500),(140525,'澤州縣',140500),(140581,'高平市',140500),(140600,'朔州市',140000),(140601,'市轄區',140600),(140602,'朔城區',140601),(140603,'平魯區',140601),(140621,'山陰縣',140600),(140622,'應縣',140600),(140623,'右玉縣',140600),(140624,'懷仁縣',140600),(140700,'晉中市',140000),(140701,'市轄區',140700),(140702,'榆次區',140701),(140721,'榆社縣',140700),(140722,'左權縣',140700),(140723,'和順縣',140700),(140724,'昔陽縣',140700),(140725,'壽陽縣',140700),(140726,'太谷縣',140700),(140727,'祁縣',140700),(140728,'平遙縣',140700),(140729,'靈石縣',140700),(140781,'介休市',140700),(140800,'運城市',140000),(140801,'市轄區',140800),(140802,'鹽湖區',140801),(140821,'臨猗縣',140800),(140822,'萬榮縣',140800),(140823,'聞喜縣',140800),(140824,'稷山縣',140800),(140825,'新絳縣',140800),(140826,'絳縣',140800),(140827,'垣曲縣',140800),(140828,'夏縣',140800),(140829,'平陸縣',140800),(140830,'芮城縣',140800),(140881,'永濟市',140800),(140882,'河津市',140800),(140900,'忻州市',140000),(140901,'忻府區',140900),(140921,'定襄縣',140900),(140922,'五臺縣',140900),(140923,'代縣',140900),(140924,'繁峙縣',140900),(140925,'寧武縣',140900),(140926,'靜樂縣',140900),(140927,'神池縣',140900),(140928,'五寨縣',140900),(140929,'岢嵐縣',140900),(140930,'河曲縣',140900),(140931,'保德縣',140900),(140932,'偏關縣',140900),(140981,'原平市',140900),(141000,'臨汾市',140000),(141001,'市轄區',141000),(141002,'堯都區',141000),(141021,'曲沃縣',141000),(141022,'翼城縣',141000),(141023,'襄汾縣',141000),(141024,'洪洞縣',141000),(141025,'古縣',141000),(141026,'安澤縣',141000),(141027,'浮山縣',141000),(141028,'吉縣',141000),(141029,'鄉寧縣',141000),(141030,'大寧縣',141000),(141031,'隰縣',141000),(141032,'永和縣',141000),(141033,'蒲縣',141000),(141034,'汾西縣',141000),(141081,'侯馬市',141000),(141082,'霍州市',141000),(141100,'呂梁市',140000),(141101,'市轄區',141100),(141102,'離石區',141101),(141121,'文水縣',141100),(141122,'交城縣',141100),(141123,'興縣',141100),(141124,'臨縣',141100),(141125,'柳林縣',141100),(141126,'石樓縣',141100),(141127,'嵐縣',141100),(141128,'方山縣',141100),(141129,'中陽縣',141100),(141130,'交口縣',141100),(141181,'孝義市',141100),(141182,'汾陽市',141100),(150000,'內蒙古自治區',NULL),(150100,'呼和浩特市',150000),(150101,'市轄區',150100),(150102,'新城區',150101),(150103,'回民區',150101),(150104,'玉泉區',150101),(150105,'賽罕區',150101),(150121,'土默特左旗',150100),(150122,'托克托縣',150100),(150123,'和林格爾縣',150100),(150124,'清水河縣',150100),(150125,'武川縣',150100),(150200,'包頭市',150000),(150201,'市轄區',150200),(150202,'東河區',150201),(150203,'昆都侖區',150201),(150204,'青山區',150201),(150205,'石拐區',150201),(150206,'白云礦區',150201),(150207,'九原區',150201),(150221,'土默特右旗',150200),(150222,'固陽縣',150200),(150223,'達爾罕茂明安聯合旗',150200),(150300,'烏海市',150000),(150301,'市轄區',150300),(150302,'海勃灣區',150301),(150303,'海南區',150301),(150304,'烏達區',150301),(150400,'赤峰市',150000),(150401,'市轄區',150400),(150402,'紅山區',150401),(150403,'元寶山區',150401),(150404,'松山區',150401),(150421,'阿魯科爾沁旗',150400),(150422,'巴林左旗',150400),(150423,'巴林右旗',150400),(150424,'林西縣',150400),(150425,'克什克騰旗',150400),(150426,'翁牛特旗',150400),(150428,'喀喇沁旗',150400),(150429,'寧城縣',150400),(150430,'敖漢旗',150400),(150500,'通遼市',150000),(150501,'市轄區',150500),(150502,'科爾沁區',150501),(150521,'科爾沁左翼中旗',150500),(150522,'科爾沁左翼后旗',150500),(150523,'開魯縣',150500),(150524,'庫倫旗',150500),(150525,'奈曼旗',150500),(150526,'扎魯特旗',150500),(150581,'霍林郭勒市',150500),(150600,'鄂爾多斯市',150000),(150602,'東勝區',150600),(150621,'達拉特旗',150600),(150622,'準格爾旗',150600),(150623,'鄂托克前旗',150600),(150624,'鄂托克旗',150600),(150625,'杭錦旗',150600),(150626,'烏審旗',150600),(150627,'伊金霍洛旗',150600),(150700,'呼倫貝爾市',150000),(150701,'市轄區',150700),(150702,'海拉爾區',150701),(150721,'阿榮旗',150700),(150722,'莫力達瓦達斡爾族自治旗',150700),(150723,'鄂倫春自治旗',150700),(150724,'鄂溫克族自治旗',150700),(150725,'陳巴爾虎旗',150700),(150726,'新巴爾虎左旗',150700),(150727,'新巴爾虎右旗',150700),(150781,'滿洲里市',150700),(150782,'牙克石市',150700),(150783,'扎蘭屯市',150700),(150784,'額爾古納市',150700),(150785,'根河市',150700),(150800,'巴彥淖爾市',150000),(150801,'市轄區',150800),(150802,'臨河區',150800),(150821,'五原縣',150800),(150822,'磴口縣',150800),(150823,'烏拉特前旗',150800),(150824,'烏拉特中旗',150800),(150825,'烏拉特后旗',150800),(150826,'杭錦后旗',150800),(150900,'烏蘭察布市',150000),(150901,'市轄區',150900),(150902,'集寧區',150901),(150921,'卓資縣',150900),(150922,'化德縣',150900),(150923,'商都縣',150900),(150924,'興和縣',150900),(150925,'涼城縣',150900),(150926,'察哈爾右翼前旗',150900),(150927,'察哈爾右翼中旗',150900),(150928,'察哈爾右翼后旗',150900),(150929,'四子王旗',150900),(150981,'豐鎮市',150900),(152200,'興安盟',150000),(152201,'烏蘭浩特市',152200),(152202,'阿爾山市',152200),(152221,'科爾沁右翼前旗',152200),(152222,'科爾沁右翼中旗',152200),(152223,'扎賚特旗',152200),(152224,'突泉縣',152200),(152500,'錫林郭勒盟',150000),(152501,'二連浩特市',152500),(152502,'錫林浩特市',152500),(152522,'阿巴嘎旗',152500),(152523,'蘇尼特左旗',152500),(152524,'蘇尼特右旗',152500),(152525,'東烏珠穆沁旗',152500),(152526,'西烏珠穆沁旗',152500),(152527,'太仆寺旗',152500),(152528,'鑲黃旗',152500),(152529,'正鑲白旗',152500),(152530,'正藍旗',152500),(152531,'多倫縣',152500),(152900,'阿拉善盟',150000),(152921,'阿拉善左旗',152900),(152922,'阿拉善右旗',152900),(152923,'額濟納旗',152900),(210000,'遼寧省',NULL),(210100,'沈陽市',210000),(210101,'市轄區',210100),(210102,'和平區',210101),(210103,'沈河區',210101),(210104,'大東區',210101),(210105,'皇姑區',210101),(210106,'鐵西區',210101),(210111,'蘇家屯區',210101),(210112,'東陵區',210101),(210113,'新城子區',210101),(210114,'于洪區',210101),(210122,'遼中縣',210100),(210123,'康平縣',210100),(210124,'法庫縣',210100),(210181,'新民市',210100),(210182,'沈北新區',210100),(210200,'大連市',210000),(210201,'市轄區',210200),(210202,'中山區',210201),(210203,'西崗區',210201),(210204,'沙河口區',210201),(210211,'甘井子區',210201),(210212,'旅順口區',210201),(210213,'金州區',210201),(210224,'長海縣',210200),(210281,'瓦房店市',210200),(210282,'普蘭店市',210200),(210283,'莊河市',210200),(210300,'鞍山市',210000),(210301,'市轄區',210300),(210302,'鐵東區',210301),(210303,'鐵西區',210301),(210304,'立山區',210301),(210311,'千山區',210301),(210321,'臺安縣',210300),(210323,'岫巖滿族自治縣',210300),(210381,'海城市',210300),(210400,'撫順市',210000),(210401,'市轄區',210400),(210402,'新撫區',210401),(210403,'東洲區',210401),(210404,'望花區',210401),(210411,'順城區',210401),(210421,'撫順縣',210400),(210422,'新賓滿族自治縣',210400),(210423,'清原滿族自治縣',210400),(210500,'本溪市',210000),(210501,'市轄區',210500),(210502,'平山區',210501),(210503,'溪湖??',210501),(210504,'明山區',210501),(210505,'南芬區',210501),(210521,'本溪滿族自治縣',210500),(210522,'桓仁滿族自治縣',210500),(210600,'丹東市',210000),(210601,'市轄區',210600),(210602,'元寶區',210601),(210603,'振興區',210601),(210604,'振安區',210601),(210624,'寬甸滿族自治縣',210600),(210681,'東港市',210600),(210682,'鳳城市',210600),(210700,'錦州市',210000),(210701,'市轄區',210700),(210702,'古塔區',210701),(210703,'凌河區',210701),(210711,'太和區',210701),(210726,'黑山縣',210700),(210727,'義縣',210700),(210781,'凌海市',210700),(210782,'北寧市',210700),(210800,'營口市',210000),(210801,'市轄區',210800),(210802,'站前區',210801),(210803,'西市區',210801),(210804,'鲅魚圈區',210801),(210811,'老邊區',210801),(210881,'蓋州市',210800),(210882,'大石橋市',210800),(210900,'阜新市',210000),(210901,'市轄區',210900),(210902,'海州區',210901),(210903,'新邱區',210901),(210904,'太平區',210901),(210905,'清河門區',210901),(210911,'細河區',210901),(210921,'阜新蒙古族自治縣',210900),(210922,'彰武縣',210900),(211000,'遼陽市',210000),(211001,'市轄區',211000),(211002,'白塔區',211001),(211003,'文圣區',211001),(211004,'宏偉區',211001),(211005,'弓長嶺區',211001),(211011,'太子河區',211001),(211021,'遼陽縣',211000),(211081,'燈塔市',211000),(211100,'盤錦市',210000),(211101,'市轄區',211100),(211102,'雙臺子區',211101),(211103,'興隆臺區',211101),(211121,'大洼縣',211100),(211122,'盤山縣',211100),(211200,'鐵嶺市',210000),(211201,'市轄區',211200),(211202,'銀州區',211201),(211204,'清河區',211201),(211221,'鐵嶺縣',211200),(211223,'西豐縣',211200),(211224,'昌圖縣',211200),(211281,'調兵山市',211200),(211282,'開原市',211200),(211300,'朝陽市',210000),(211301,'市轄區',211300),(211302,'雙塔區',211301),(211303,'龍城區',211301),(211321,'朝陽縣',211300),(211322,'建平縣',211300),(211324,'喀喇沁左翼蒙古族自治縣',211300),(211381,'北票市',211300),(211382,'凌源市',211300),(211400,'葫蘆島市',210000),(211401,'市轄區',211400),(211402,'連山區',211401),(211403,'龍港區',211401),(211404,'南票區',211401),(211421,'綏中縣',211400),(211422,'建昌縣',211400),(211481,'興城市',211400),(220000,'吉林省',NULL),(220100,'長春市',220000),(220101,'市轄區',220100),(220102,'南關區',220101),(220103,'寬城區',220101),(220104,'朝陽區',220101),(220105,'二道區',220101),(220106,'綠園區',220101),(220112,'雙陽區',220101),(220122,'農安縣',220100),(220181,'九臺市',220100),(220182,'榆樹市',220100),(220183,'德惠市',220100),(220200,'吉林市',220000),(220201,'市轄區',220200),(220202,'昌邑區',220201),(220203,'龍潭區',220201),(220204,'船營區',220201),(220211,'豐滿區',220201),(220221,'永吉縣',220200),(220281,'蛟河市',220200),(220282,'樺甸市',220200),(220283,'舒蘭市',220200),(220284,'磐石市',220200),(220300,'四平市',220000),(220301,'市轄區',220300),(220302,'鐵西區',220301),(220303,'鐵東區',220301),(220322,'梨樹縣',220300),(220323,'伊通滿族自治縣',220300),(220381,'公主嶺市',220300),(220382,'雙遼市',220300),(220400,'遼源市',220000),(220401,'市轄區',220400),(220402,'龍山區',220401),(220403,'西安區',220401),(220421,'東豐縣',220400),(220422,'東遼縣',220400),(220500,'通化市',220000),(220501,'市轄區',220500),(220502,'東昌區',220501),(220503,'二道江區',220501),(220521,'通化縣',220500),(220523,'輝南縣',220500),(220524,'柳河縣',220500),(220581,'梅河口市',220500),(220582,'集安市',220500),(220600,'白山市',220000),(220601,'市轄區',220600),(220602,'八道江區',220601),(220621,'撫松縣',220600),(220622,'靖宇縣',220600),(220623,'長白朝鮮族自治縣',220600),(220625,'江源區',220600),(220681,'臨江市',220600),(220700,'松原市',220000),(220701,'市轄區',220700),(220702,'寧江區',220701),(220721,'前郭爾羅斯蒙古族自治縣',220700),(220722,'長嶺縣',220700),(220723,'乾安縣',220700),(220724,'扶余市',220700),(220800,'白城市',220000),(220801,'市轄區',220800),(220802,'洮北區',220800),(220821,'鎮賚縣',220800),(220822,'通榆縣',220800),(220881,'洮南市',220800),(220882,'大安市',220800),(222400,'延邊朝鮮族自治州',220000),(222401,'延吉市',222400),(222402,'圖們市',222400),(222403,'敦化市',222400),(222404,'琿春市',222400),(222405,'龍井市',222400),(222406,'和龍市',222400),(222424,'汪清縣',222400),(222426,'安圖縣',222400),(230000,'黑龍江省',NULL),(230100,'哈爾濱市',230000),(230101,'市轄區',230100),(230102,'道里區',230101),(230103,'南崗區',230101),(230104,'道外區',230101),(230106,'香坊區',230101),(230107,'動力區',230101),(230108,'平房區',230101),(230109,'松北區',230101),(230111,'呼蘭區',230101),(230123,'依蘭縣',230100),(230124,'方正縣',230100),(230125,'賓縣',230100),(230126,'巴彥縣',230100),(230127,'木蘭縣',230100),(230128,'通河縣',230100),(230129,'延壽縣',230100),(230181,'阿城市',230100),(230182,'雙城市',230100),(230183,'尚志市',230100),(230184,'五常市',230100),(230200,'齊齊哈爾市',230000),(230201,'市轄區',230200),(230202,'龍沙區',230201),(230203,'建華區',230201),(230204,'鐵鋒區',230201),(230205,'昂昂溪區',230201),(230206,'富拉爾基區',230201),(230207,'碾子山區',230201),(230208,'梅里斯達斡爾族區',230201),(230221,'龍江縣',230200),(230223,'依安縣',230200),(230224,'泰來縣',230200),(230225,'甘南縣',230200),(230227,'富裕縣',230200),(230229,'克山縣',230200),(230230,'克東縣',230200),(230231,'拜泉縣',230200),(230281,'訥河市',230200),(230300,'雞西市',230000),(230301,'市轄區',230300),(230302,'雞冠區',230301),(230303,'恒山區',230301),(230304,'滴道區',230301),(230305,'梨樹區',230301),(230306,'城子河區',230301),(230307,'麻山區',230301),(230321,'雞東縣',230300),(230381,'虎林市',230300),(230382,'密山市',230300),(230400,'鶴崗市',230000),(230401,'市轄區',230400),(230402,'向陽區',230401),(230403,'工農區',230401),(230404,'南山區',230401),(230405,'興安區',230401),(230406,'東山區',230401),(230407,'興山區',230401),(230421,'蘿北縣',230400),(230422,'綏濱縣',230400),(230500,'雙鴨山市',230000),(230501,'市轄區',230500),(230502,'尖山區',230501),(230503,'嶺東區',230501),(230505,'四方臺區',230501),(230506,'寶山區',230501),(230521,'集賢縣',230500),(230522,'友誼縣',230500),(230523,'寶清縣',230500),(230524,'饒河縣',230500),(230600,'大慶市',230000),(230601,'市轄區',230600),(230602,'薩爾圖區',230601),(230603,'龍鳳區',230601),(230604,'讓胡路區',230601),(230605,'紅崗區',230601),(230606,'大同區',230601),(230621,'肇州縣',230600),(230622,'肇源縣',230600),(230623,'林甸縣',230600),(230624,'杜爾伯特蒙古族自治縣',230600),(230700,'伊春市',230000),(230701,'市轄區',230700),(230702,'伊春區',230701),(230703,'南岔區',230701),(230704,'友好區',230701),(230705,'西林區',230701),(230706,'翠巒區',230701),(230707,'新青區',230701),(230708,'美溪區',230701),(230709,'金山屯區',230701),(230710,'五營區',230701),(230711,'烏馬河區',230701),(230712,'湯旺河區',230701),(230713,'帶嶺區',230701),(230714,'烏伊嶺區',230701),(230715,'紅星區',230701),(230716,'上甘嶺區',230701),(230722,'嘉蔭縣',230700),(230781,'鐵力市',230700),(230800,'佳木斯市',230000),(230801,'市轄區',230800),(230803,'向陽區',230801),(230804,'前進區',230801),(230805,'東風區',230801),(230811,'郊區',230801),(230822,'樺南縣',230800),(230826,'樺川縣',230800),(230828,'湯原縣',230800),(230833,'撫遠縣',230800),(230881,'同江市',230800),(230882,'富錦市',230800),(230900,'七臺河市',230000),(230901,'市轄區',230900),(230902,'新興區',230901),(230903,'桃山區',230901),(230904,'茄子河區',230901),(230921,'勃利縣',230900),(231000,'牡丹江市',230000),(231001,'市轄區',231000),(231002,'東安區',231001),(231003,'陽明區',231001),(231004,'愛民區',231001),(231005,'西安區',231001),(231024,'東寧縣',231000),(231025,'林口縣',231000),(231081,'綏芬河市',231000),(231083,'海林市',231000),(231084,'寧安市',231000),(231085,'穆棱市',231000),(231100,'黑河市',230000),(231101,'市轄區',231100),(231102,'愛輝區',231101),(231121,'嫩江縣',231100),(231123,'遜克縣',231100),(231124,'孫吳縣',231100),(231181,'北安市',231100),(231182,'五大連池市',231100),(231200,'綏化市',230000),(231201,'北林區',231200),(231221,'望奎縣',231200),(231222,'蘭西縣',231200),(231223,'青岡縣',231200),(231224,'慶安縣',231200),(231225,'明水縣',231200),(231226,'綏棱縣',231200),(231281,'安達市',231200),(231282,'肇東市',231200),(231283,'海倫市',231200),(232700,'大興安嶺地區',230000),(232701,'加格達奇區',232700),(232702,'松嶺區',232700),(232703,'新林區',232700),(232704,'呼中區',232700),(232721,'呼瑪縣',232700),(232722,'塔河縣',232700),(232723,'漠河縣',232700),(310000,'上海市',NULL),(310100,'黃浦區',310000),(310300,'盧灣區',310000),(310400,'徐匯區',310000),(310500,'長寧區',310000),(310600,'靜安區',310000),(310700,'普陀區',310000),(310800,'閘北區',310000),(310900,'虹口區',310000),(311000,'楊浦區',310000),(311200,'閔行區',310000),(311300,'寶山區',310000),(311400,'嘉定區',310000),(311500,'浦東新區',310000),(311600,'金山區',310000),(311700,'松江區',310000),(311800,'青浦區',310000),(311900,'南匯區',310000),(312000,'奉賢區',310000),(313000,'崇明縣',310000),(320000,'江蘇省',NULL),(320100,'南京市',320000),(320101,'市轄區',320100),(320102,'玄武區',320101),(320103,'白下區',320101),(320104,'秦淮區',320101),(320105,'建鄴區',320101),(320106,'鼓樓區',320101),(320107,'下關區',320101),(320111,'浦口區',320101),(320113,'棲霞區',320101),(320114,'雨花臺區',320101),(320115,'江寧區',320101),(320116,'六合區',320101),(320124,'溧水區',320100),(320125,'高淳區',320100),(320200,'無錫市',320000),(320201,'市轄區',320200),(320202,'崇安區',320201),(320203,'南長區',320201),(320204,'北塘區',320201),(320205,'錫山區',320201),(320206,'惠山區',320201),(320211,'濱湖區',320201),(320281,'江陰市',320200),(320282,'宜興市',320200),(320300,'徐州市',320000),(320301,'泉山區',320300),(320302,'鼓樓區',320300),(320303,'云龍區',320300),(320304,'九里區',320301),(320305,'賈汪區',320300),(320321,'豐縣',320300),(320322,'沛縣',320300),(320323,'銅山縣',320300),(320324,'睢寧縣',320300),(320381,'新沂市',320300),(320382,'邳州市',320300),(320400,'常州市',320000),(320401,'市轄區',320400),(320402,'天寧區',320401),(320404,'鐘樓區',320401),(320405,'戚墅堰區',320401),(320411,'新北區',320401),(320412,'武進區',320401),(320481,'溧陽市',320400),(320482,'金壇市',320400),(320500,'蘇州市',320000),(320501,'市轄區',320500),(320502,'滄浪區',320501),(320503,'平江區',320501),(320504,'金閶區',320501),(320505,'虎丘區',320501),(320506,'吳中區',320501),(320507,'相城區',320501),(320581,'常熟市',320500),(320582,'張家港市',320500),(320583,'昆山市',320500),(320584,'吳江市',320500),(320585,'太倉市',320500),(320600,'南通市',320000),(320601,'市轄區',320600),(320602,'崇川區',320601),(320611,'港閘區',320601),(320621,'海安縣',320600),(320623,'如東縣',320600),(320681,'啟東市',320600),(320682,'如皋市',320600),(320683,'通州市',320600),(320684,'海門市',320600),(320700,'連云港市',320000),(320701,'市轄區',320700),(320703,'連云區',320701),(320705,'新浦區',320701),(320706,'海州區',320701),(320721,'贛榆縣',320700),(320722,'東海縣',320700),(320723,'灌云縣',320700),(320724,'灌南縣',320700),(320800,'淮安市',320000),(320801,'市轄區',320800),(320802,'清河區',320801),(320803,'楚州區',320801),(320804,'淮陰區',320801),(320811,'清浦區',320801),(320826,'漣水縣',320800),(320829,'洪澤縣',320800),(320830,'盱眙縣',320800),(320831,'金湖縣',320800),(320900,'鹽城市',320000),(320901,'市轄區',320900),(320902,'亭湖區',320901),(320903,'鹽都區',320901),(320921,'響水縣',320900),(320922,'濱海縣',320900),(320923,'阜寧縣',320900),(320924,'射陽縣',320900),(320925,'建湖縣',320900),(320981,'東臺市',320900),(320982,'大豐市',320900),(321000,'揚州市',320000),(321001,'市轄區',321000),(321002,'廣陵區',321001),(321003,'邗江區',321001),(321011,'維揚區',321001),(321023,'寶應縣',321000),(321081,'儀征市',321000),(321084,'高郵市',321000),(321088,'江都市',321000),(321100,'鎮江市',320000),(321101,'市轄區',321100),(321102,'京口區',321101),(321111,'潤州區',321101),(321112,'丹徒區',321101),(321181,'丹陽市',321100),(321182,'揚中市',321100),(321183,'句容市',321100),(321200,'泰州市',320000),(321201,'市轄區',321200),(321202,'海陵區',321201),(321203,'高港區',321201),(321281,'興化市',321200),(321282,'靖江市',321200),(321283,'泰興市',321200),(321284,'姜堰市',321200),(321300,'宿遷市',320000),(321301,'市轄區',321300),(321302,'宿城區',321301),(321311,'宿豫區',321301),(321322,'沭陽縣',321300),(321323,'泗陽縣',321300),(321324,'泗洪縣',321300),(330000,'浙江省',NULL),(330100,'杭州市',330000),(330101,'市轄區',330100),(330102,'上城區',330101),(330103,'下城區',330101),(330104,'江干區',330101),(330105,'拱墅區',330101),(330106,'西湖區',330101),(330108,'濱江區',330101),(330109,'蕭山區',330101),(330110,'余杭區',330101),(330122,'桐廬縣',330100),(330127,'淳安縣',330100),(330182,'建德市',330100),(330183,'富陽市',330100),(330185,'臨安市',330100),(330200,'寧波市',330000),(330201,'市轄區',330200),(330203,'海曙區',330201),(330204,'江東區',330201),(330205,'江北區',330201),(330206,'北侖區',330201),(330211,'鎮海區',330201),(330212,'鄞州區',330201),(330225,'象山縣',330200),(330226,'寧海縣',330200),(330281,'余姚市',330200),(330282,'慈溪市',330200),(330283,'奉化市',330200),(330300,'溫州市',330000),(330301,'市轄區',330300),(330302,'鹿城區',330301),(330303,'龍灣區',330301),(330304,'甌海區',330301),(330322,'洞頭縣',330300),(330324,'永嘉縣',330300),(330326,'平陽縣',330300),(330327,'蒼南縣',330300),(330328,'文成縣',330300),(330329,'泰順縣',330300),(330381,'瑞安市',330300),(330382,'樂清市',330300),(330400,'嘉興市',330000),(330401,'市轄區',330400),(330402,'南湖區',330401),(330411,'秀洲區',330401),(330421,'嘉善縣',330400),(330424,'海鹽縣',330400),(330481,'海寧市',330400),(330482,'平湖市',330400),(330483,'桐鄉市',330400),(330500,'湖州市',330000),(330501,'市轄區',330500),(330502,'吳興區',330501),(330503,'南潯區',330501),(330521,'德清縣',330500),(330522,'長興縣',330500),(330523,'安吉縣',330500),(330600,'紹興市',330000),(330601,'市轄區',330600),(330602,'越城區',330601),(330621,'紹興縣',330600),(330624,'新昌縣',330600),(330681,'諸暨市',330600),(330682,'上虞市',330600),(330683,'嵊州市',330600),(330700,'金華市',330000),(330701,'市轄區',330700),(330702,'婺城區',330701),(330703,'金東區',330701),(330723,'武義縣',330700),(330726,'浦江縣',330700),(330727,'磐安縣',330700),(330781,'蘭溪市',330700),(330782,'義烏市',330700),(330783,'東陽市',330700),(330784,'永康市',330700),(330800,'衢州市',330000),(330801,'市轄區',330800),(330802,'柯城區',330801),(330803,'衢江區',330801),(330822,'常山縣',330800),(330824,'開化縣',330800),(330825,'龍游縣',330800),(330881,'江山市',330800),(330900,'舟山市',330000),(330901,'市轄區',330900),(330902,'定海區',330901),(330903,'普陀區',330901),(330921,'岱山縣',330900),(330922,'嵊泗縣',330900),(331000,'臺州市',330000),(331001,'市轄區',331000),(331002,'椒江區',331001),(331003,'黃巖區',331001),(331004,'路橋區',331001),(331021,'玉環縣',331000),(331022,'三門縣',331000),(331023,'天臺縣',331000),(331024,'仙居縣',331000),(331081,'溫嶺市',331000),(331082,'臨海市',331000),(331100,'麗水市',330000),(331101,'市轄區',331100),(331102,'蓮都區',331101),(331121,'青田縣',331100),(331122,'縉云縣',331100),(331123,'遂昌縣',331100),(331124,'松陽縣',331100),(331125,'云和縣',331100),(331126,'慶元縣',331100),(331127,'景寧畬族自治縣',331100),(331181,'龍泉市',331100),(340000,'安徽省',NULL),(340100,'合肥市',340000),(340101,'市轄區',340100),(340102,'瑤海區',340101),(340103,'廬陽區',340101),(340104,'蜀山區',340101),(340111,'包河區',340101),(340121,'長豐縣',340100),(340122,'肥東縣',340100),(340123,'肥西縣',340100),(340124,'廬江縣',340100),(340181,'巢湖市',340100),(340200,'蕪湖市',340000),(340201,'市轄區',340200),(340202,'鏡湖區',340201),(340203,'馬塘區',340201),(340207,'鳩江區',340201),(340221,'蕪湖縣',340200),(340222,'繁昌縣',340200),(340223,'南陵縣',340200),(340225,'無為縣',340200),(340300,'蚌埠市',340000),(340301,'市轄區',340300),(340302,'龍子湖區',340301),(340303,'蚌山區',340301),(340304,'禹會區',340301),(340311,'淮上區',340301),(340321,'懷遠縣',340300),(340322,'五河縣',340300),(340323,'固鎮縣',340300),(340400,'淮南市',340000),(340401,'市轄區',340400),(340402,'大通區',340401),(340403,'田家庵區',340401),(340404,'謝家集區',340401),(340405,'八公山區',340401),(340406,'潘集區',340401),(340421,'鳳臺縣',340400),(340500,'馬鞍山市',340000),(340501,'市轄區',340500),(340502,'金家莊區',340501),(340503,'花山區',340501),(340504,'雨山區',340501),(340521,'當涂縣',340500),(340522,'含山縣',340500),(340523,'和縣',340500),(340600,'淮北市',340000),(340601,'市轄區',340600),(340602,'杜集區',340601),(340603,'相山區',340601),(340604,'烈山區',340601),(340621,'濉溪縣',340600),(340700,'銅陵市',340000),(340701,'市轄區',340700),(340702,'銅官山區',340701),(340703,'獅子山區',340701),(340711,'郊區',340701),(340721,'銅陵縣',340700),(340800,'安慶市',340000),(340801,'市轄區',340800),(340802,'迎江區',340801),(340803,'大觀區',340801),(340811,'宜秀區',340801),(340822,'懷寧縣',340800),(340823,'樅陽縣',340800),(340824,'潛山縣',340800),(340825,'太湖縣',340800),(340826,'宿松縣',340800),(340827,'望江縣',340800),(340828,'岳西縣',340800),(340881,'桐城市',340800),(341000,'黃山市',340000),(341001,'黃山區',341000),(341002,'屯溪區',341000),(341004,'徽州區',341000),(341021,'歙縣',341000),(341022,'休寧縣',341000),(341023,'黟縣',341000),(341024,'祁門縣',341000),(341091,'湯口鎮',341000),(341100,'滁州市',340000),(341101,'市轄區',341100),(341102,'瑯琊區',341101),(341103,'南譙區',341101),(341122,'來安縣',341100),(341124,'全椒縣',341100),(341125,'定遠縣',341100),(341126,'鳳陽縣',341100),(341181,'天長市',341100),(341182,'明光市',341100),(341200,'阜陽市',340000),(341201,'潁泉區',341200),(341202,'潁州區',341200),(341203,'潁東區',341200),(341221,'臨泉縣',341200),(341222,'太和縣',341200),(341225,'阜南縣',341200),(341226,'潁上縣',341200),(341282,'界首市',341200),(341300,'宿州市',340000),(341301,'市轄區',341300),(341302,'埇橋區',341301),(341321,'碭山縣',341300),(341322,'蕭縣',341300),(341323,'靈璧縣',341300),(341324,'泗縣',341300),(341402,'居巢區',NULL),(341500,'六安市',340000),(341501,'市轄區',341500),(341502,'金安區',341501),(341503,'裕安區',341501),(341521,'壽縣',341500),(341522,'霍邱縣',341500),(341523,'舒城縣',341500),(341524,'金寨縣',341500),(341525,'霍山縣',341500),(341600,'亳州市',340000),(341601,'譙城區',341600),(341621,'渦陽縣',341600),(341622,'蒙城縣',341600),(341623,'利辛縣',341600),(341700,'池州市',340000),(341701,'市轄區',341700),(341702,'貴池區',341701),(341721,'東至縣',341700),(341722,'石臺縣',341700),(341723,'青陽縣',341700),(341800,'宣城市',340000),(341801,'市轄區',341800),(341802,'宣州區',341801),(341821,'郎溪縣',341800),(341822,'廣德縣',341800),(341823,'涇縣',341800),(341824,'績溪縣',341800),(341825,'旌德縣',341800),(341881,'寧國市',341800),(350000,'福建省',NULL),(350100,'福州市',350000),(350101,'市轄區',350100),(350102,'鼓樓區',350101),(350103,'臺江區',350101),(350104,'倉山區',350101),(350105,'馬尾區',350101),(350111,'晉安區',350101),(350121,'閩侯縣',350100),(350122,'連江縣',350100),(350123,'羅源縣',350100),(350124,'閩清縣',350100),(350125,'永泰縣',350100),(350128,'平潭縣',350100),(350181,'福清市',350100),(350182,'長樂市',350100),(350200,'廈門市',350000),(350201,'市轄區',350200),(350203,'思明區',350201),(350205,'海滄區',350201),(350206,'湖里區',350201),(350211,'集美區',350201),(350212,'同安區',350201),(350213,'翔安區',350201),(350300,'莆田市',350000),(350301,'市轄區',350300),(350302,'城廂區',350301),(350303,'涵江區',350301),(350304,'荔城區',350301),(350305,'秀嶼區',350301),(350322,'仙游縣',350300),(350400,'三明市',350000),(350401,'市轄區',350400),(350402,'梅列區',350401),(350403,'三元區',350401),(350421,'明溪縣',350400),(350423,'清流縣',350400),(350424,'寧化縣',350400),(350425,'大田縣',350400),(350426,'尤溪縣',350400),(350427,'沙縣',350400),(350428,'將樂縣',350400),(350429,'泰寧縣',350400),(350430,'建寧縣',350400),(350481,'永安市',350400),(350500,'泉州市',350000),(350501,'市轄區',350500),(350502,'鯉城區',350501),(350503,'豐澤區',350501),(350504,'洛江區',350501),(350505,'泉港區',350501),(350521,'惠安縣',350500),(350524,'安溪縣',350500),(350525,'永春縣',350500),(350526,'德化縣',350500),(350527,'金門縣',350500),(350581,'石獅市',350500),(350582,'晉江市',350500),(350583,'南安市',350500),(350600,'漳州市',350000),(350601,'市轄區',350600),(350602,'薌城區',350601),(350603,'龍文區',350601),(350622,'云霄縣',350600),(350623,'漳浦縣',350600),(350624,'詔安縣',350600),(350625,'長泰縣',350600),(350626,'東山縣',350600),(350627,'南靖縣',350600),(350628,'平和縣',350600),(350629,'華安縣',350600),(350681,'龍海市',350600),(350700,'南平市',350000),(350701,'市轄區',350700),(350702,'延平區',350701),(350721,'順昌縣',350700),(350722,'浦城縣',350700),(350723,'光澤縣',350700),(350724,'松溪縣',350700),(350725,'政和縣',350700),(350781,'邵武市',350700),(350782,'武夷山市',350700),(350783,'建甌市',350700),(350784,'建陽市',350700),(350800,'龍巖市',350000),(350801,'市轄區',350800),(350802,'新羅區',350801),(350821,'長汀縣',350800),(350822,'永定縣',350800),(350823,'上杭縣',350800),(350824,'武平縣',350800),(350825,'連城縣',350800),(350881,'漳平市',350800),(350900,'寧德市',350000),(350901,'市轄區',350900),(350902,'蕉城區',350901),(350921,'霞浦縣',350900),(350922,'古田縣',350900),(350923,'屏南縣',350900),(350924,'壽寧縣',350900),(350925,'周寧縣',350900),(350926,'柘榮縣',350900),(350981,'福安市',350900),(350982,'福鼎市',350900),(360000,'江西省',NULL),(360100,'南昌市',360000),(360101,'市轄區',360100),(360102,'東湖區',360101),(360103,'西湖區',360101),(360104,'青云譜區',360101),(360105,'灣里區',360101),(360111,'青山湖區',360101),(360121,'南昌縣',360100),(360122,'新建縣',360100),(360123,'安義縣',360100),(360124,'進賢縣',360100),(360200,'景德鎮市',360000),(360201,'市轄區',360200),(360202,'昌江區',360201),(360203,'珠山區',360201),(360222,'浮梁縣',360200),(360281,'樂平市',360200),(360300,'萍鄉市',360000),(360301,'市轄區',360300),(360302,'安源區',360301),(360313,'湘東區',360301),(360321,'蓮花縣',360300),(360322,'上栗縣',360300),(360323,'蘆溪縣',360300),(360400,'九江市',360000),(360401,'市轄區',360400),(360402,'廬山區',360401),(360403,'潯陽區',360401),(360421,'九江縣',360400),(360423,'武寧縣',360400),(360424,'修水縣',360400),(360425,'永修縣',360400),(360426,'德安縣',360400),(360427,'星子縣',360400),(360428,'都昌縣',360400),(360429,'湖口縣',360400),(360430,'彭澤縣',360400),(360481,'瑞昌市',360400),(360482,'共青城市',360400),(360500,'新余市',360000),(360501,'市轄區',360500),(360502,'渝水區',360501),(360521,'分宜縣',360500),(360600,'鷹潭市',360000),(360601,'市轄區',360600),(360602,'月湖區',360601),(360622,'余江縣',360600),(360681,'貴溪市',360600),(360700,'贛州市',360000),(360701,'市轄區',360700),(360702,'章貢區',360701),(360721,'贛縣',360700),(360722,'信豐縣',360700),(360723,'大余縣',360700),(360724,'上猶縣',360700),(360725,'崇義縣',360700),(360726,'安遠縣',360700),(360727,'龍南縣',360700),(360728,'定南縣',360700),(360729,'全南縣',360700),(360730,'寧都縣',360700),(360731,'于都縣',360700),(360732,'興國縣',360700),(360733,'會昌縣',360700),(360734,'尋烏縣',360700),(360735,'石城縣',360700),(360781,'瑞金市',360700),(360782,'南康市',360700),(360800,'吉安市',360000),(360801,'市轄區',360800),(360802,'吉州區',360801),(360803,'青原區',360801),(360821,'吉安縣',360800),(360822,'吉水縣',360800),(360823,'峽江縣',360800),(360824,'新干縣',360800),(360825,'永豐縣',360800),(360826,'泰和縣',360800),(360827,'遂川縣',360800),(360828,'萬安縣',360800),(360829,'安福縣',360800),(360830,'永新縣',360800),(360881,'井岡山市',360800),(360900,'宜春市',360000),(360901,'市轄區',360900),(360902,'袁州區',360901),(360921,'奉新縣',360900),(360922,'萬載縣',360900),(360923,'上高縣',360900),(360924,'宜豐縣',360900),(360925,'靖安縣',360900),(360926,'銅鼓縣',360900),(360981,'豐城市',360900),(360982,'樟樹市',360900),(360983,'高安市',360900),(361000,'撫州市',360000),(361001,'市轄區',361000),(361002,'臨川區',361001),(361021,'南城縣',361000),(361022,'黎川縣',361000),(361023,'南豐縣',361000),(361024,'崇仁縣',361000),(361025,'樂安縣',361000),(361026,'宜黃縣',361000),(361027,'金溪縣',361000),(361028,'資溪縣',361000),(361029,'東鄉縣',361000),(361030,'廣昌縣',361000),(361100,'上饒市',360000),(361101,'市轄區',361100),(361102,'信州區',361101),(361121,'上饒縣',361100),(361122,'廣豐縣',361100),(361123,'玉山縣',361100),(361124,'鉛山縣',361100),(361125,'橫峰縣',361100),(361126,'弋陽縣',361100),(361127,'余干縣',361100),(361128,'鄱陽縣',361100),(361129,'萬年縣',361100),(361130,'婺源縣',361100),(361181,'德興市',361100),(370000,'山東省',NULL),(370100,'濟南市',370000),(370101,'市轄區',370100),(370102,'歷下區',370101),(370103,'市中區',370101),(370104,'槐蔭區',370101),(370105,'天橋區',370101),(370112,'歷城區',370101),(370113,'長清區',370101),(370124,'平陰縣',370100),(370125,'濟陽縣',370100),(370126,'商河縣',370100),(370181,'章丘市',370100),(370200,'青島市',370000),(370201,'市轄區',370200),(370202,'市南區',370201),(370203,'市北區',370201),(370205,'四方區',370201),(370211,'黃島區',370201),(370212,'嶗山區',370201),(370213,'李滄區',370201),(370214,'城陽區',370201),(370281,'膠州市',370200),(370282,'即墨市',370200),(370283,'平度市',370200),(370284,'膠南市',370200),(370285,'萊西市',370200),(370300,'淄博市',370000),(370301,'市轄區',370300),(370302,'淄川區',370301),(370303,'張店區',370301),(370304,'博山區',370301),(370305,'臨淄區',370301),(370306,'周村區',370301),(370321,'桓臺縣',370300),(370322,'高青縣',370300),(370323,'沂源縣',370300),(370400,'棗莊市',370000),(370401,'市轄區',370400),(370402,'市中區',370401),(370403,'薛城區',370401),(370404,'嶧城區',370401),(370405,'臺兒莊區',370401),(370406,'山亭區',370401),(370481,'滕州市',370400),(370500,'東營市',370000),(370501,'市轄區',370500),(370502,'東營區',370501),(370503,'河口區',370501),(370521,'墾利縣',370500),(370522,'利津縣',370500),(370523,'廣饒縣',370500),(370600,'煙臺市',370000),(370601,'市轄區',370600),(370602,'芝罘區',370601),(370611,'福山區',370601),(370612,'牟平區',370601),(370613,'萊山區',370601),(370634,'長島縣',370600),(370681,'龍口市',370600),(370682,'萊陽市',370600),(370683,'萊州市',370600),(370684,'蓬萊市',370600),(370685,'招遠市',370600),(370686,'棲霞市',370600),(370687,'海陽市',370600),(370700,'濰坊市',370000),(370701,'市轄區',370700),(370702,'濰城區',370701),(370703,'寒亭區',370701),(370704,'坊子區',370701),(370705,'奎文區',370701),(370724,'臨朐縣',370700),(370725,'昌樂縣',370700),(370781,'青州市',370700),(370782,'諸城市',370700),(370783,'壽光市',370700),(370784,'安丘市',370700),(370785,'高密市',370700),(370786,'昌邑市',370700),(370800,'濟寧市',370000),(370801,'市轄區',370800),(370802,'市中區',370801),(370811,'任城區',370801),(370826,'微山縣',370800),(370827,'魚臺縣',370800),(370828,'金鄉縣',370800),(370829,'嘉祥縣',370800),(370830,'汶上縣',370800),(370831,'泗水縣',370800),(370832,'梁山縣',370800),(370881,'曲阜市',370800),(370882,'兗州市',370800),(370883,'鄒城市',370800),(370900,'泰安市',370000),(370901,'岱岳區',370900),(370902,'泰山區',370900),(370921,'寧陽縣',370900),(370923,'東平縣',370900),(370982,'新泰市',370900),(370983,'肥城市',370900),(371000,'威海市',370000),(371001,'市轄區',371000),(371002,'環翠區',371001),(371081,'文登市',371000),(371082,'榮成市',371000),(371083,'乳山市',371000),(371100,'日照市',370000),(371101,'市轄區',371100),(371102,'東港區',371101),(371103,'嵐山區',371101),(371121,'五蓮縣',371100),(371122,'莒縣',371100),(371200,'萊蕪市',370000),(371201,'市轄區',371200),(371202,'萊城區',371201),(371203,'鋼城區',371201),(371300,'臨沂市',370000),(371301,'市轄區',371300),(371302,'蘭山區',371301),(371311,'羅莊區',371301),(371312,'河東區',371301),(371321,'沂南縣',371300),(371322,'郯城縣',371300),(371323,'沂水縣',371300),(371324,'蒼山縣',371300),(371325,'費縣',371300),(371326,'平邑縣',371300),(371327,'莒南縣',371300),(371328,'蒙陰縣',371300),(371329,'臨沭縣',371300),(371400,'德州市',370000),(371401,'市轄區',371400),(371402,'德城區',371401),(371421,'陵縣',371400),(371422,'寧津縣',371400),(371423,'慶云縣',371400),(371424,'臨邑縣',371400),(371425,'齊河縣',371400),(371426,'平原縣',371400),(371427,'夏津縣',371400),(371428,'武城縣',371400),(371481,'樂陵市',371400),(371482,'禹城市',371400),(371500,'聊城市',370000),(371501,'市轄區',371500),(371502,'東昌府區',371501),(371521,'陽谷縣',371500),(371522,'莘縣',371500),(371523,'茌平縣',371500),(371524,'東阿縣',371500),(371525,'冠縣',371500),(371526,'高唐縣',371500),(371581,'臨清市',371500),(371600,'濱州市',370000),(371601,'市轄區',371600),(371602,'濱城區',371601),(371621,'惠民縣',371600),(371622,'陽信縣',371600),(371623,'無棣縣',371600),(371624,'沾化縣',371600),(371625,'博興縣',371600),(371626,'鄒平縣',371600),(371700,'菏澤市',370000),(371701,'市轄區',371700),(371702,'牡丹區',371701),(371721,'曹縣',371700),(371722,'單縣',371700),(371723,'成武縣',371700),(371724,'巨野縣',371700),(371725,'鄆城縣',371700),(371726,'鄄城縣',371700),(371727,'定陶縣',371700),(371728,'東明縣',371700),(410000,'河南省',NULL),(410100,'鄭州市',410000),(410101,'金水區',410100),(410102,'中原區',410100),(410103,'二七區',410100),(410104,'管城回族區',410100),(410106,'上街區',410100),(410108,'惠濟區',410100),(410122,'中牟縣',410100),(410181,'鞏義市',410100),(410182,'滎陽市',410100),(410183,'新密市',410100),(410184,'新鄭市',410100),(410185,'登封市',410100),(410200,'開封市',410000),(410201,'市轄區',410200),(410202,'龍亭區',410201),(410203,'順河回族區',410201),(410204,'鼓樓區',410201),(410205,'禹王臺區',410201),(410211,'金明區',410201),(410221,'杞縣',410200),(410222,'通許縣',410200),(410223,'尉氏縣',410200),(410224,'開封縣',410200),(410225,'蘭考縣',410200),(410300,'洛陽市',410000),(410301,'市轄區',410300),(410302,'老城區',410301),(410303,'西工區',410301),(410304,'廛河回族區',410301),(410305,'澗西區',410301),(410306,'吉利區',410301),(410307,'洛龍區',410301),(410322,'孟津縣',410300),(410323,'新安縣',410300),(410324,'欒川縣',410300),(410325,'嵩縣',410300),(410326,'汝陽縣',410300),(410327,'宜陽縣',410300),(410328,'洛寧縣',410300),(410329,'伊川縣',410300),(410381,'偃師市',410300),(410400,'平頂山市',410000),(410401,'市轄區',410400),(410402,'新華區',410401),(410403,'衛東區',410401),(410404,'石龍區',410401),(410411,'湛河區',410401),(410421,'寶豐縣',410400),(410422,'葉縣',410400),(410423,'魯山縣',410400),(410425,'郟縣',410400),(410481,'舞鋼市',410400),(410482,'汝州市',410400),(410500,'安陽市',410000),(410501,'市轄區',410500),(410502,'文峰區',410501),(410503,'北關區',410501),(410505,'殷都區',410501),(410506,'龍安區',410501),(410522,'安陽縣',410500),(410523,'湯陰縣',410500),(410526,'滑縣',410500),(410527,'內黃縣',410500),(410581,'林州市',410500),(410600,'鶴壁市',410000),(410601,'市轄區',410600),(410602,'鶴山區',410601),(410603,'山城區',410601),(410611,'淇濱區',410601),(410621,'浚縣',410600),(410622,'淇縣',410600),(410700,'新鄉市',410000),(410701,'市轄區',410700),(410702,'紅旗區',410700),(410703,'衛濱區',410700),(410704,'鳳泉區',410700),(410711,'牧野區',410700),(410721,'新鄉縣',410700),(410724,'獲嘉縣',410700),(410725,'原陽縣',410700),(410726,'延津縣',410700),(410727,'封丘縣',410700),(410728,'長垣縣',410700),(410781,'衛輝市',410700),(410782,'輝縣市',410700),(410800,'焦作市',410000),(410801,'市轄區',410800),(410802,'解放區',410801),(410803,'中站區',410801),(410804,'馬村區',410801),(410811,'山陽區',410801),(410821,'修武縣',410800),(410822,'博愛縣',410800),(410823,'武陟縣',410800),(410825,'溫縣',410800),(410882,'沁陽市',410800),(410883,'孟州市',410800),(410900,'濮陽市',410000),(410901,'市轄區',410900),(410902,'華龍區',410901),(410922,'清豐縣',410900),(410923,'南樂縣',410900),(410926,'范縣',410900),(410927,'臺前縣',410900),(410928,'濮陽縣',410900),(411000,'許昌市',410000),(411001,'市轄區',411000),(411002,'魏都區',411001),(411023,'許昌縣',411000),(411024,'鄢陵縣',411000),(411025,'襄城縣',411000),(411081,'禹州市',411000),(411082,'長葛市',411000),(411100,'漯河市',410000),(411101,'召陵區',411100),(411102,'源匯區',411100),(411103,'郾城區',411100),(411121,'舞陽縣',411100),(411122,'臨潁縣',411100),(411200,'三門峽市',410000),(411201,'市轄區',411200),(411202,'湖濱區',411201),(411221,'澠池縣',411200),(411222,'陜縣',411200),(411224,'盧氏縣',411200),(411281,'義馬市',411200),(411282,'靈寶市',411200),(411300,'南陽市',410000),(411301,'市轄區',411300),(411302,'宛城區',411301),(411303,'臥龍區',411301),(411321,'南召縣',411300),(411322,'方城縣',411300),(411323,'西峽縣',411300),(411324,'鎮平縣',411300),(411325,'內鄉縣',411300),(411326,'淅川縣',411300),(411327,'社旗縣',411300),(411328,'唐河縣',411300),(411329,'新野縣',411300),(411330,'桐柏縣',411300),(411381,'鄧州市',411300),(411400,'商丘市',410000),(411401,'市轄區',411400),(411402,'梁園區',411400),(411403,'睢陽區',411400),(411421,'民權縣',411400),(411422,'睢縣',411400),(411423,'寧陵縣',411400),(411424,'柘城縣',411400),(411425,'虞城縣',411400),(411426,'夏邑縣',411400),(411481,'永城市',411400),(411482,'新區',411400),(411500,'信陽市',410000),(411501,'市轄區',411500),(411502,'浉河區',411501),(411503,'平橋區',411501),(411521,'羅山縣',411500),(411522,'光山縣',411500),(411523,'新縣',411500),(411524,'商城縣',411500),(411525,'固始縣',411500),(411526,'潢川縣',411500),(411527,'淮濱縣',411500),(411528,'息縣',411500),(411600,'周口市',410000),(411601,'市轄區',411600),(411602,'川匯區',411601),(411621,'扶溝縣',411600),(411622,'西華縣',411600),(411623,'商水縣',411600),(411624,'沈丘縣',411600),(411625,'鄲城縣',411600),(411626,'淮陽縣',411600),(411627,'太康縣',411600),(411628,'鹿邑縣',411600),(411681,'項城市',411600),(411700,'駐馬店市',410000),(411701,'市轄區',411700),(411702,'驛城區',411701),(411721,'西平縣',411700),(411722,'上蔡縣',411700),(411723,'平輿縣',411700),(411724,'正陽縣',411700),(411725,'確山縣',411700),(411726,'泌陽縣',411700),(411727,'汝南縣',411700),(411728,'遂平縣',411700),(411729,'新蔡縣',411700),(411800,'濟源市',410000),(411801,'市轄區',411800),(420000,'湖北省',NULL),(420100,'武漢市',420000),(420101,'市轄區',420100),(420102,'江岸區',420101),(420103,'江漢區',420101),(420104,'硚口區',420101),(420105,'漢陽區',420101),(420106,'武昌區',420101),(420107,'青山區',420101),(420111,'洪山區',420101),(420112,'東西湖區',420101),(420113,'漢南區',420101),(420114,'蔡甸區',420101),(420115,'江夏區',420101),(420116,'黃陂區',420101),(420117,'新洲區',420100),(420200,'黃石市',420000),(420201,'市轄區',420200),(420202,'黃石港區',420201),(420203,'西塞山區',420201),(420204,'下陸區',420201),(420205,'鐵山區',420201),(420222,'陽新縣',420200),(420281,'大冶市',420200),(420300,'十堰市',420000),(420301,'市轄區',420300),(420302,'茅箭區',420301),(420303,'張灣區',420301),(420321,'鄖縣',420300),(420322,'鄖西縣',420300),(420323,'竹山縣',420300),(420324,'竹溪縣',420300),(420325,'房縣',420300),(420381,'丹江口市',420300),(420500,'宜昌市',420000),(420501,'市轄區',420500),(420502,'西陵區',420501),(420503,'伍家崗區',420501),(420504,'點軍區',420501),(420505,'猇亭區',420501),(420506,'夷陵區',420501),(420525,'遠安縣',420500),(420526,'興山縣',420500),(420527,'秭歸縣',420500),(420528,'長陽土家族自治縣',420500),(420529,'五峰土家族自治縣',420500),(420581,'宜都市',420500),(420582,'當陽市',420500),(420583,'枝江市',420500),(420600,'襄陽市',420000),(420601,'市轄區',420600),(420602,'襄城區',420601),(420606,'樊城區',420601),(420607,'襄州區',420601),(420624,'南漳縣',420600),(420625,'谷城縣',420600),(420626,'保康縣',420600),(420682,'老河口市',420600),(420683,'棗陽市',420600),(420684,'宜城市',420600),(420700,'鄂州市',420000),(420701,'市轄區',420700),(420702,'梁子湖區',420701),(420703,'華容區',420701),(420704,'鄂城區',420701),(420800,'荊門市',420000),(420801,'市轄區',420800),(420802,'東寶區',420801),(420804,'掇刀區',420801),(420821,'京山縣',420800),(420822,'沙洋縣',420800),(420881,'鐘祥市',420800),(420900,'孝感市',420000),(420901,'市轄區',420900),(420902,'孝南區',420901),(420921,'孝昌縣',420900),(420922,'大悟縣',420900),(420923,'云夢縣',420900),(420981,'應城市',420900),(420982,'安陸市',420900),(420984,'漢川市',420900),(421000,'荊州市',420000),(421001,'市轄區',421000),(421002,'沙市區',421001),(421003,'荊州區',421001),(421022,'公安縣',421000),(421023,'監利縣',421000),(421024,'江陵縣',421000),(421081,'石首市',421000),(421083,'洪湖市',421000),(421087,'松滋市',421000),(421100,'黃岡市',420000),(421101,'市轄區',421100),(421102,'黃州區',421101),(421121,'團風縣',421100),(421122,'紅安縣',421100),(421123,'羅田縣',421100),(421124,'英山縣',421100),(421125,'浠水縣',421100),(421126,'蘄春縣',421100),(421127,'黃梅縣',421100),(421181,'麻城市',421100),(421182,'武穴市',421100),(421200,'咸寧市',420000),(421201,'市轄區',421200),(421202,'咸安區',421201),(421221,'嘉魚縣',421200),(421222,'通城縣',421200),(421223,'崇陽縣',421200),(421224,'通山縣',421200),(421281,'赤壁市',421200),(421300,'隨州市',420000),(421301,'市轄區',421300),(421302,'曾都區',421301),(421381,'廣水市',421300),(422800,'恩施土家族苗族自治州',420000),(422801,'恩施市',422800),(422802,'利川市',422800),(422822,'建始縣',422800),(422823,'巴東縣',422800),(422825,'宣恩縣',422800),(422826,'咸豐縣',422800),(422827,'來鳳縣',422800),(422828,'鶴峰縣',422800),(429000,'省直轄行政單位',420000),(429004,'仙桃市',429000),(429005,'潛江市',429000),(429006,'天門市',429000),(429021,'神農架林區',429000),(430000,'湖南省',NULL),(430100,'長沙市',430000),(430101,'市轄區',430100),(430102,'芙蓉區',430101),(430103,'天心區',430101),(430104,'岳麓區',430101),(430105,'開福區',430101),(430111,'雨花區',430101),(430121,'長沙縣',430100),(430122,'望城縣',430100),(430124,'寧鄉縣',430100),(430181,'瀏陽市',430100),(430200,'株洲市',430000),(430201,'市轄區',430200),(430202,'荷塘區',430201),(430203,'蘆淞區',430201),(430204,'石峰區',430201),(430211,'天元區',430201),(430221,'株洲縣',430200),(430223,'攸縣',430200),(430224,'茶陵縣',430200),(430225,'炎陵縣',430200),(430281,'醴陵市',430200),(430300,'湘潭市',430000),(430301,'市轄區',430300),(430302,'雨湖區',430301),(430304,'岳塘區',430301),(430321,'湘潭縣',430300),(430381,'湘鄉市',430300),(430382,'韶山市',430300),(430400,'衡陽市',430000),(430401,'市轄區',430400),(430405,'珠暉區',430401),(430406,'雁峰區',430401),(430407,'石鼓區',430401),(430408,'蒸湘區',430401),(430412,'南岳區',430401),(430421,'衡陽縣',430400),(430422,'衡南縣',430400),(430423,'衡山縣',430400),(430424,'衡東縣',430400),(430426,'祁東縣',430400),(430481,'耒陽市',430400),(430482,'常寧市',430400),(430500,'邵陽市',430000),(430501,'市轄區',430500),(430502,'雙清區',430501),(430503,'大祥區',430501),(430511,'北塔區',430501),(430521,'邵東縣',430500),(430522,'新邵縣',430500),(430523,'邵陽縣',430500),(430524,'隆回縣',430500),(430525,'洞口縣',430500),(430527,'綏寧縣',430500),(430528,'新寧縣',430500),(430529,'城步苗族自治縣',430500),(430581,'武岡市',430500),(430600,'岳陽市',430000),(430601,'市轄區',430600),(430602,'岳陽樓區',430601),(430603,'云溪區',430601),(430611,'君山區',430601),(430621,'岳陽縣',430600),(430623,'華容縣',430600),(430624,'湘陰縣',430600),(430626,'平江縣',430600),(430681,'汨羅市',430600),(430682,'臨湘市',430600),(430700,'常德市',430000),(430701,'市轄區',430700),(430702,'武陵區',430701),(430703,'鼎城區',430701),(430721,'安鄉縣',430700),(430722,'漢壽縣',430700),(430723,'澧縣',430700),(430724,'臨澧縣',430700),(430725,'桃源縣',430700),(430726,'石門縣',430700),(430781,'津市市',430700),(430800,'張家界市',430000),(430801,'市轄區',430800),(430802,'永定區',430801),(430811,'武陵源區',430801),(430821,'慈利縣',430800),(430822,'桑植縣',430800),(430900,'益陽市',430000),(430901,'市轄區',430900),(430902,'資陽區',430901),(430903,'赫山區',430901),(430921,'南縣',430900),(430922,'桃江縣',430900),(430923,'安化縣',430900),(430981,'沅江市',430900),(431000,'郴州市',430000),(431001,'市轄區',431000),(431002,'北湖區',431001),(431003,'蘇仙區',431001),(431021,'桂陽縣',431000),(431022,'宜章縣',431000),(431023,'永興縣',431000),(431024,'嘉禾縣',431000),(431025,'臨武縣',431000),(431026,'汝城縣',431000),(431027,'桂東縣',431000),(431028,'安仁縣',431000),(431081,'資興市',431000),(431100,'永州市',430000),(431101,'市轄區',431100),(431102,'零陵區',431101),(431103,'冷水灘區',431101),(431121,'祁陽縣',431100),(431122,'東安縣',431100),(431123,'雙牌縣',431100),(431124,'道縣',431100),(431125,'江永縣',431100),(431126,'寧遠縣',431100),(431127,'藍山縣',431100),(431128,'新田縣',431100),(431129,'江華瑤族自治縣',431100),(431200,'懷化市',430000),(431201,'市轄區',431200),(431202,'鶴城區',431201),(431221,'中方縣',431200),(431222,'沅陵縣',431200),(431223,'辰溪縣',431200),(431224,'溆浦縣',431200),(431225,'會同縣',431200),(431226,'麻陽苗族自治縣',431200),(431227,'新晃侗族自治縣',431200),(431228,'芷江侗族自治縣',431200),(431229,'靖州苗族侗族自治縣',431200),(431230,'通道侗族自治縣',431200),(431281,'洪江市',431200),(431300,'婁底市',430000),(431301,'市轄區',431300),(431302,'婁星區',431301),(431321,'雙峰縣',431300),(431322,'新化縣',431300),(431381,'冷水江市',431300),(431382,'漣源市',431300),(433100,'湘西土家族苗族自治州',430000),(433101,'吉首市',433100),(433122,'瀘溪縣',433100),(433123,'鳳凰縣',433100),(433124,'花垣縣',433100),(433125,'保靖縣',433100),(433126,'古丈縣',433100),(433127,'永順縣',433100),(433130,'龍山縣',433100),(440000,'廣東省',NULL),(440100,'廣州市',440000),(440101,'市轄區',440100),(440103,'荔灣區',440101),(440104,'越秀區',440101),(440105,'海珠區',440101),(440106,'天河區',440101),(440111,'白云區',440101),(440112,'黃埔區',440101),(440113,'番禺區',440101),(440114,'花都區',440101),(440115,'南沙區',440101),(440116,'蘿崗區',440101),(440183,'增城市',440100),(440184,'從化市',440100),(440200,'韶關市',440000),(440201,'市轄區',440200),(440203,'武江區',440201),(440204,'湞江區',440201),(440205,'曲江區',440201),(440222,'始興縣',440200),(440224,'仁化縣',440200),(440229,'翁源縣',440200),(440232,'乳源瑤族自治縣',440200),(440233,'新豐縣',440200),(440281,'樂昌市',440200),(440282,'南雄市',440200),(440300,'深圳市',440000),(440301,'市轄區',440300),(440303,'羅湖區',440301),(440304,'福田區',440301),(440305,'南山區',440301),(440306,'寶安區',440301),(440307,'龍崗區',440301),(440308,'鹽田區',440301),(440400,'珠海市',440000),(440401,'市轄區',440400),(440402,'香洲區',440401),(440403,'斗門區',440401),(440404,'金灣區',440401),(440500,'汕頭市',440000),(440501,'市轄區',440500),(440507,'龍湖區',440501),(440511,'金平區',440501),(440512,'濠江區',440501),(440513,'潮陽區',440501),(440514,'潮南區',440501),(440515,'澄海區',440501),(440523,'南澳縣',440500),(440600,'佛山市',440000),(440601,'市轄區',440600),(440604,'禪城區',440600),(440605,'南海區',440600),(440606,'順德區',440600),(440607,'三水區',440600),(440608,'高明區',440600),(440700,'江門市',440000),(440701,'市轄區',440700),(440703,'蓬江區',440701),(440704,'江海區',440701),(440705,'新會區',440701),(440781,'臺山市',440700),(440783,'開平市',440700),(440784,'鶴山市',440700),(440785,'恩平市',440700),(440800,'湛江市',440000),(440801,'市轄區',440800),(440802,'赤坎區',440801),(440803,'霞山區',440801),(440804,'坡頭區',440801),(440811,'麻章區',440801),(440823,'遂溪縣',440800),(440825,'徐聞縣',440800),(440881,'廉江市',440800),(440882,'雷州市',440800),(440883,'吳川市',440800),(440900,'茂名市',440000),(440901,'市轄區',440900),(440902,'茂南區',440901),(440903,'茂港區',440901),(440923,'電白縣',440900),(440981,'高州市',440900),(440982,'化州市',440900),(440983,'信宜市',440900),(441200,'肇慶市',440000),(441201,'市轄區',441200),(441202,'端州區',441201),(441203,'鼎湖區',441201),(441223,'廣寧縣',441200),(441224,'懷集縣',441200),(441225,'封開縣',441200),(441226,'德慶縣',441200),(441283,'高要市',441200),(441284,'四會市',441200),(441300,'惠州市',440000),(441301,'市轄區',441300),(441302,'惠城區',441301),(441303,'惠陽區',441301),(441322,'博羅縣',441300),(441323,'惠東縣',441300),(441324,'龍門縣',441300),(441400,'梅州市',440000),(441401,'市轄區',441400),(441402,'梅江區',441401),(441421,'梅縣',441400),(441422,'大埔縣',441400),(441423,'豐順縣',441400),(441424,'五華縣',441400),(441426,'平遠縣',441400),(441427,'蕉嶺縣',441400),(441481,'興寧市',441400),(441500,'汕尾市',440000),(441501,'市轄區',441500),(441502,'城區',441501),(441521,'海豐縣',441500),(441523,'陸河縣',441500),(441581,'陸豐市',441500),(441600,'河源市',440000),(441601,'市轄區',441600),(441602,'源城區',441601),(441621,'紫金縣',441600),(441622,'龍川縣',441600),(441623,'連平縣',441600),(441624,'和平縣',441600),(441625,'東源縣',441600),(441700,'陽江市',440000),(441701,'市轄區',441700),(441702,'江城區',441701),(441721,'陽西縣',441700),(441723,'陽東縣',441700),(441781,'陽春市',441700),(441800,'清遠市',440000),(441801,'市轄區',441800),(441802,'清城區',441801),(441821,'佛岡縣',441800),(441823,'陽山縣',441800),(441825,'連山壯族瑤族自治縣',441800),(441826,'連南瑤族自治縣',441800),(441827,'清新縣',441800),(441881,'英德市',441800),(441882,'連州市',441800),(441900,'東莞市',440000),(442000,'中山市',440000),(445100,'潮州市',440000),(445101,'市轄區',445100),(445102,'湘橋區',445101),(445121,'潮安區',445100),(445122,'饒平縣',445100),(445200,'揭陽市',440000),(445201,'市轄區',445200),(445202,'榕城區',445201),(445221,'揭東縣',445200),(445222,'揭西縣',445200),(445224,'惠來縣',445200),(445281,'普寧市',445200),(445300,'云浮市',440000),(445301,'市轄區',445300),(445302,'云城區',445301),(445321,'新興縣',445300),(445322,'郁南縣',445300),(445323,'云安縣',445300),(445381,'羅定市',445300),(450000,'廣西壯族自治區',NULL),(450100,'南寧市',450000),(450101,'市轄區',450100),(450102,'興寧區',450101),(450103,'青秀區',450101),(450105,'江南區',450101),(450107,'西鄉塘區',450101),(450108,'良慶區',450101),(450109,'邕寧區',450101),(450122,'武鳴縣',450100),(450123,'隆安縣',450100),(450124,'馬山縣',450100),(450125,'上林縣',450100),(450126,'賓陽縣',450100),(450127,'橫縣',450100),(450200,'柳州市',450000),(450201,'市轄區',450200),(450202,'城中區',450201),(450203,'魚峰區',450201),(450204,'柳南區',450201),(450205,'柳北區',450201),(450221,'柳江縣',450200),(450222,'柳城縣',450200),(450223,'鹿寨縣',450200),(450224,'融安縣',450200),(450225,'融水苗族自治縣',450200),(450226,'三江侗族自治縣',450200),(450300,'桂林市',450000),(450301,'市轄區',450300),(450302,'秀峰區',450301),(450303,'疊彩區',450301),(450304,'象山區',450301),(450305,'七星區',450301),(450311,'雁山區',450301),(450321,'陽朔縣',450300),(450322,'臨桂區',450300),(450323,'靈川縣',450300),(450324,'全州縣',450300),(450325,'興安縣',450300),(450326,'永福縣',450300),(450327,'灌陽縣',450300),(450328,'龍勝各族自治縣',450300),(450329,'資源縣',450300),(450330,'平樂縣',450300),(450331,'荔浦縣',450300),(450332,'恭城瑤族自治縣',450300),(450400,'梧州市',450000),(450401,'市轄區',450400),(450403,'萬秀區',450401),(450404,'蝶山區',450401),(450405,'長洲區',450401),(450421,'蒼梧縣',450400),(450422,'藤縣',450400),(450423,'蒙山縣',450400),(450481,'岑溪市',450400),(450500,'北海市',450000),(450501,'市轄區',450500),(450502,'海城區',450501),(450503,'銀海區',450501),(450512,'鐵山港區',450501),(450521,'合浦縣',450500),(450600,'防城港市',450000),(450601,'市轄區',450600),(450602,'港口區',450601),(450603,'防城區',450601),(450621,'上思縣',450600),(450681,'東興市',450600),(450700,'欽州市',450000),(450701,'市轄區',450700),(450702,'欽南區',450700),(450703,'欽北區',450700),(450721,'靈山縣',450700),(450722,'浦北縣',450700),(450800,'貴港市',450000),(450801,'市轄區',450800),(450802,'港北區',450801),(450803,'港南區',450801),(450804,'覃塘區',450801),(450821,'平南縣',450800),(450881,'桂平市',450800),(450900,'玉林市',450000),(450901,'市轄區',450900),(450902,'玉州區',450901),(450921,'容縣',450900),(450922,'陸川縣',450900),(450923,'博白縣',450900),(450924,'興業縣',450900),(450981,'北流市',450900),(451000,'百色市',450000),(451001,'市轄區',451000),(451002,'右江區',451001),(451021,'田陽縣',451000),(451022,'田東縣',451000),(451023,'平果縣',451000),(451024,'德保縣',451000),(451025,'靖西縣',451000),(451026,'那坡縣',451000),(451027,'凌云縣',451000),(451028,'樂業縣',451000),(451029,'田林縣',451000),(451030,'西林縣',451000),(451031,'隆林各族自治縣',451000),(451100,'賀州市',450000),(451101,'市轄區',451100),(451102,'八步區',451101),(451121,'昭平縣',451100),(451122,'鐘山縣',451100),(451123,'富川瑤族自治縣',451100),(451200,'河池市',450000),(451201,'市轄區',451200),(451202,'金城江區',451201),(451221,'南丹縣',451200),(451222,'天峨縣',451200),(451223,'鳳山縣',451200),(451224,'東蘭縣',451200),(451225,'羅城仫佬族自治縣',451200),(451226,'環江毛南族自治縣',451200),(451227,'巴馬瑤族自治縣',451200),(451228,'都安瑤族自治縣',451200),(451229,'大化瑤族自治縣',451200),(451281,'宜州市',451200),(451300,'來賓市',450000),(451301,'市轄區',451300),(451302,'興賓區',451301),(451321,'忻城縣',451300),(451322,'象州縣',451300),(451323,'武宣縣',451300),(451324,'金秀瑤族自治縣',451300),(451381,'合山市',451300),(451400,'崇左市',450000),(451401,'市轄區',451400),(451402,'江洲區',451401),(451421,'扶綏縣',451400),(451422,'寧明縣',451400),(451423,'龍州縣',451400),(451424,'大新縣',451400),(451425,'天等縣',451400),(451481,'憑祥市',451400),(460000,'海南省',NULL),(460100,'海口市',460000),(460101,'市轄區',460100),(460105,'秀英區',460101),(460106,'龍華區',460101),(460107,'瓊山區',460101),(460108,'美蘭區',460101),(460200,'三亞市',460000),(460201,'市轄區',460200),(469000,'省直轄縣級行政單位',460000),(469001,'五指山市',469000),(469002,'瓊海市',469000),(469003,'儋州市',469000),(469005,'文昌市',469000),(469006,'萬寧市',469000),(469007,'東方市',469000),(469025,'定安縣',469000),(469026,'屯昌縣',469000),(469027,'澄邁縣',469000),(469028,'臨高縣',469000),(469030,'白沙黎族自治縣',469000),(469031,'昌江黎族自治縣',469000),(469033,'樂東黎族自治縣',469000),(469034,'陵水黎族自治縣',469000),(469035,'保亭黎族苗族自治縣',469000),(469036,'瓊中黎族苗族自治縣',469000),(469037,'西沙群島',469000),(469038,'南沙群島',469000),(469039,'中沙群島的島礁及其海域',469000),(500000,'重慶市',NULL),(500100,'萬州區',500000),(500101,'萬州區',500100),(500200,'涪陵區',500000),(500201,'涪陵區',500200),(500300,'渝中區',500000),(500301,'渝中區',500300),(500400,'大渡口區',500000),(500401,'大渡口區',500400),(500500,'江北區',500000),(500501,'江北區',500500),(500600,'沙坪壩區',500000),(500601,'沙坪壩區',500600),(500700,'九龍坡區',500000),(500701,'九龍坡區',500700),(500800,'南岸區',500000),(500801,'南岸區',500800),(500900,'北碚區',500000),(500901,'北碚區',500900),(501000,'萬盛區',500000),(501001,'萬盛區',501000),(501100,'雙橋區',500000),(501101,'雙橋區',501100),(501200,'渝北區',500000),(501201,'渝北區',501200),(501300,'巴南區',500000),(501301,'巴南區',501300),(501400,'黔江區',500000),(501401,'黔江區',501400),(501500,'長壽區',500000),(501501,'長壽區',501500),(502200,'綦江區',500000),(502201,'綦江區',502200),(502300,'潼南縣',500000),(502301,'潼南縣',502300),(502400,'銅梁縣',500000),(502401,'銅梁縣',502400),(502500,'大足區',500000),(502501,'大足區',502500),(502600,'榮昌縣',500000),(502601,'榮昌縣',502600),(502700,'璧山縣',500000),(502701,'璧山縣',502700),(502800,'梁平縣',500000),(502801,'梁平縣',502800),(502900,'城口縣',500000),(502901,'城口縣',502900),(503000,'豐都縣',500000),(503001,'豐都縣',503000),(503100,'墊江縣',500000),(503101,'墊江縣',503100),(503200,'武隆縣',500000),(503201,'武隆縣',503200),(503300,'忠縣',500000),(503301,'忠縣',503300),(503400,'開縣',500000),(503401,'開縣',503400),(503500,'云陽縣',500000),(503501,'云陽縣',503500),(503600,'奉節縣',500000),(503601,'奉節縣',503600),(503700,'巫山縣',500000),(503701,'巫山縣',503700),(503800,'巫溪縣',500000),(503801,'巫溪縣',503800),(504000,'石柱縣',500000),(504001,'石柱縣',504000),(504100,'秀山縣',500000),(504101,'秀山縣',504100),(504200,'酉陽縣',500000),(504201,'酉陽縣',504200),(504300,'彭水縣',500000),(504301,'彭水縣',504300),(508100,'江津區',500000),(508101,'江津區',508100),(508200,'合川區',500000),(508201,'合川區',508200),(508300,'永川區',500000),(508301,'永川區',508300),(508400,'南川區',500000),(508401,'南川區',508400),(510000,'四川省',NULL),(510100,'成都市',510000),(510101,'市轄區',510100),(510104,'錦江區',510101),(510105,'青羊區',510101),(510106,'金牛區',510101),(510107,'武侯區',510101),(510108,'成華區',510101),(510112,'龍泉驛區',510100),(510113,'青白江區',510101),(510114,'新都區',510101),(510115,'溫江區',510101),(510121,'金堂縣',510100),(510122,'雙流縣',510100),(510124,'郫縣',510100),(510129,'大邑縣',510100),(510131,'蒲江縣',510100),(510132,'新津縣',510100),(510181,'都江堰市',510100),(510182,'彭州市',510100),(510183,'邛崍市',510100),(510184,'崇州市',510100),(510300,'自貢市',510000),(510301,'市轄區',510300),(510302,'自流井區',510301),(510303,'貢井區',510301),(510304,'大安區',510301),(510311,'沿灘區',510301),(510321,'榮縣',510300),(510322,'富順縣',510300),(510400,'攀枝花市',510000),(510401,'市轄區',510400),(510402,'東區',510401),(510403,'西區',510401),(510411,'仁和區',510401),(510421,'米易縣',510400),(510422,'鹽邊縣',510400),(510500,'瀘州市',510000),(510501,'市轄區',510500),(510502,'江陽區',510501),(510503,'納溪區',510501),(510504,'龍馬潭區',510501),(510521,'瀘縣',510500),(510522,'合江縣',510500),(510524,'敘永縣',510500),(510525,'古藺縣',510500),(510600,'德陽市',510000),(510601,'市轄區',510600),(510603,'旌陽區',510601),(510623,'中江縣',510600),(510626,'羅江縣',510600),(510681,'廣漢市',510600),(510682,'什邡市',510600),(510683,'綿竹市',510600),(510700,'綿陽市',510000),(510701,'市轄區',510700),(510703,'涪城區',510701),(510704,'游仙區',510701),(510722,'三臺縣',510700),(510723,'鹽亭縣',510700),(510724,'安縣',510700),(510725,'梓潼縣',510700),(510726,'北川羌族自治縣',510700),(510727,'平武縣',510700),(510781,'江油市',510700),(510800,'廣元市',510000),(510801,'市轄區',510800),(510802,'市中區',510801),(510811,'元壩區',510801),(510812,'朝天區',510801),(510821,'旺蒼縣',510800),(510822,'青川縣',510800),(510823,'劍閣縣',510800),(510824,'蒼溪縣',510800),(510900,'遂寧市',510000),(510901,'市轄區',510900),(510903,'船山區',510901),(510904,'安居區',510901),(510921,'蓬溪縣',510900),(510922,'射洪縣',510900),(510923,'大英縣',510900),(511000,'內江市',510000),(511001,'市轄區',511000),(511002,'市中區',511001),(511011,'東興區',511001),(511024,'威遠縣',511000),(511025,'資中縣',511000),(511028,'隆昌縣',511000),(511100,'樂山市',510000),(511101,'市轄區',511100),(511102,'市中區',511101),(511111,'沙灣區',511101),(511112,'五通橋區',511101),(511113,'金口河區',511101),(511123,'犍為縣',511100),(511124,'井研縣',511100),(511126,'夾江縣',511100),(511129,'沐川縣',511100),(511132,'峨邊彝族自治縣',511100),(511133,'馬邊彝族自治縣',511100),(511181,'峨眉山市',511100),(511300,'南充市',510000),(511301,'市轄區',511300),(511302,'順慶區',511301),(511303,'高坪區',511301),(511304,'嘉陵區',511301),(511321,'南部縣',511300),(511322,'營山縣',511300),(511323,'蓬安縣',511300),(511324,'儀隴縣',511300),(511325,'西充縣',511300),(511381,'閬中市',511300),(511400,'眉山市',510000),(511401,'市轄區',511400),(511402,'東坡區',511401),(511421,'仁壽縣',511400),(511422,'彭山縣',511400),(511423,'洪雅縣',511400),(511424,'丹棱縣',511400),(511425,'青神縣',511400),(511500,'宜賓市',510000),(511501,'市轄區',511500),(511502,'翠屏區',511500),(511521,'宜賓縣',511500),(511522,'南溪縣',511500),(511523,'江安縣',511500),(511524,'長寧縣',511500),(511525,'高縣',511500),(511526,'珙縣',511500),(511527,'筠連縣',511500),(511528,'興文縣',511500),(511529,'屏山縣',511500),(511600,'廣安市',510000),(511601,'市轄區',511600),(511602,'廣安區',511601),(511621,'岳池縣',511600),(511622,'武勝縣',511600),(511623,'鄰水縣',511600),(511681,'華鎣市',511600),(511682,'廣安區',511600),(511700,'達州市',510000),(511701,'市轄區',511700),(511702,'通川區',511701),(511721,'達川區',511700),(511722,'宣漢縣',511700),(511723,'開江縣',511700),(511724,'大竹縣',511700),(511725,'渠縣',511700),(511781,'萬源市',511700),(511800,'雅安市',510000),(511801,'雨城區',511800),(511802,'雨城區',511801),(511821,'名山區',511800),(511822,'滎經縣',511800),(511823,'漢源縣',511800),(511824,'石棉縣',511800),(511825,'天全縣',511800),(511826,'蘆山縣',511800),(511827,'寶興縣',511800),(511900,'巴中市',510000),(511901,'市轄區',511900),(511902,'巴州區',511901),(511921,'通江縣',511900),(511922,'南江縣',511900),(511923,'平昌縣',511900),(512000,'資陽市',510000),(512001,'市轄區',512000),(512002,'雁江區',512001),(512021,'安岳縣',512000),(512022,'樂至縣',512000),(512081,'簡陽市',512000),(513200,'阿壩藏族羌族自治州',510000),(513221,'汶川縣',513200),(513222,'理縣',513200),(513223,'茂縣',513200),(513224,'松潘縣',513200),(513225,'九寨溝縣',513200),(513226,'金川縣',513200),(513227,'小金縣',513200),(513228,'黑水縣',513200),(513229,'馬爾康縣',513200),(513230,'壤塘縣',513200),(513231,'阿壩縣',513200),(513232,'若爾蓋縣',513200),(513233,'紅原縣',513200),(513300,'甘孜藏族自治州',510000),(513321,'康定縣',513300),(513322,'瀘定縣',513300),(513323,'丹巴縣',513300),(513324,'九龍縣',513300),(513325,'雅江縣',513300),(513326,'道孚縣',513300),(513327,'爐霍縣',513300),(513328,'甘孜縣',513300),(513329,'新龍縣',513300),(513330,'德格縣',513300),(513331,'白玉縣',513300),(513332,'石渠縣',513300),(513333,'色達縣',513300),(513334,'理塘縣',513300),(513335,'巴塘縣',513300),(513336,'鄉城縣',513300),(513337,'稻城縣',513300),(513338,'得榮縣',513300),(513400,'涼山彝族自治州',510000),(513401,'西昌市',513400),(513422,'木里藏族自治縣',513400),(513423,'鹽源縣',513400),(513424,'德昌縣',513400),(513425,'會理縣',513400),(513426,'會東縣',513400),(513427,'寧南縣',513400),(513428,'普格縣',513400),(513429,'布拖縣',513400),(513430,'金陽縣',513400),(513431,'昭覺縣',513400),(513432,'喜德縣',513400),(513433,'冕寧縣',513400),(513434,'越西縣',513400),(513435,'甘洛縣',513400),(513436,'美姑縣',513400),(513437,'雷波縣',513400),(520000,'貴州省',NULL),(520100,'貴陽市',520000),(520101,'市轄區',520100),(520102,'南明區',520101),(520103,'云巖區',520101),(520111,'花溪區',520101),(520112,'烏當區',520100),(520113,'白云區',520101),(520114,'小河區',520101),(520121,'開陽縣',520100),(520122,'息烽縣',520100),(520123,'修文縣',520100),(520181,'清鎮市',520100),(520200,'六盤水市',520000),(520201,'鐘山區',520200),(520203,'六枝特區',520200),(520221,'水城縣',520200),(520222,'盤縣',520200),(520300,'遵義市',520000),(520301,'市轄區',520300),(520302,'紅花崗區',520301),(520303,'匯川區',520301),(520321,'遵義縣',520300),(520322,'桐梓縣',520300),(520323,'綏陽縣',520300),(520324,'正安縣',520300),(520325,'道真仡佬族苗族自治縣',520300),(520326,'務川仡佬族苗族自治縣',520300),(520327,'鳳岡縣',520300),(520328,'湄潭縣',520300),(520329,'余慶縣',520300),(520330,'習水縣',520300),(520381,'赤水市',520300),(520382,'仁懷市',520300),(520400,'安順市',520000),(520401,'市轄區',520400),(520402,'西秀區',520401),(520421,'平壩縣',520400),(520422,'普定縣',520400),(520423,'鎮寧布依族苗族自治縣',520400),(520424,'關嶺布依族苗族自治縣',520400),(520425,'紫云苗族布依族自治縣',520400),(522200,'銅仁市',520000),(522201,'碧江區',522200),(522222,'江口縣',522200),(522223,'玉屏侗族自治縣',522200),(522224,'石阡縣',522200),(522225,'思南縣',522200),(522226,'印江土家族苗族自治縣',522200),(522227,'德江縣',522200),(522228,'沿河土家族自治縣',522200),(522229,'松桃苗族自治縣',522200),(522230,'萬山區',522200),(522300,'黔西南布依族苗族自治州',520000),(522301,'興義市',522300),(522322,'興仁縣',522300),(522323,'普安縣',522300),(522324,'晴隆縣',522300),(522325,'貞豐縣',522300),(522326,'望謨縣',522300),(522327,'冊亨縣',522300),(522328,'安龍縣',522300),(522400,'畢節市',520000),(522401,'七星關區',522400),(522422,'大方縣',522400),(522423,'黔西縣',522400),(522424,'金沙縣',522400),(522425,'織金縣',522400),(522426,'納雍縣',522400),(522427,'威寧彝族回族苗族自治縣',522400),(522428,'赫章縣',522400),(522600,'黔東南苗族侗族自治州',520000),(522601,'凱里市',522600),(522622,'黃平縣',522600),(522623,'施秉縣',522600),(522624,'三穗縣',522600),(522625,'鎮遠縣',522600),(522626,'岑鞏縣',522600),(522627,'天柱縣',522600),(522628,'錦屏縣',522600),(522629,'劍河縣',522600),(522630,'臺江縣',522600),(522631,'黎平縣',522600),(522632,'榕江縣',522600),(522633,'從江縣',522600),(522634,'雷山縣',522600),(522635,'麻江縣',522600),(522636,'丹寨縣',522600),(522700,'黔南布依族苗族自治州',520000),(522701,'都勻市',522700),(522702,'福泉市',522700),(522722,'荔波縣',522700),(522723,'貴定縣',522700),(522725,'甕安縣',522700),(522726,'獨山縣',522700),(522727,'平塘縣',522700),(522728,'羅甸縣',522700),(522729,'長順縣',522700),(522730,'龍里縣',522700),(522731,'惠水縣',522700),(522732,'三都水族自治縣',522700),(530000,'云南省',NULL),(530100,'昆明市',530000),(530101,'市轄區',530100),(530102,'五華區',530101),(530103,'盤龍區',530101),(530111,'官渡區',530101),(530112,'西山區',530101),(530113,'東川區',530101),(530121,'呈貢縣',530100),(530122,'晉寧縣',530100),(530124,'富民縣',530100),(530125,'宜良縣',530100),(530126,'石林彝族自治縣',530100),(530127,'嵩明縣',530100),(530128,'祿勸彝族苗族自治縣',530100),(530129,'尋甸回族彝族自治縣',530100),(530181,'安寧市',530100),(530300,'曲靖市',530000),(530301,'市轄區',530300),(530302,'麒麟區',530301),(530321,'馬龍縣',530300),(530322,'陸良縣',530300),(530323,'師宗縣',530300),(530324,'羅平縣',530300),(530325,'富源縣',530300),(530326,'會澤縣',530300),(530328,'沾益縣',530300),(530381,'宣威市',530300),(530400,'玉溪市',530000),(530401,'市轄區',530400),(530402,'紅塔區',530401),(530421,'江川縣',530400),(530422,'澄江縣',530400),(530423,'通海縣',530400),(530424,'華寧縣',530400),(530425,'易門縣',530400),(530426,'峨山彝族自治縣',530400),(530427,'新平彝族傣族自治縣',530400),(530428,'元江哈尼族彝族傣族自治縣',530400),(530500,'保山市',530000),(530501,'市轄區',530500),(530502,'隆陽區',530500),(530521,'施甸縣',530500),(530522,'騰沖縣',530500),(530523,'龍陵縣',530500),(530524,'昌寧縣',530500),(530600,'昭通市',530000),(530601,'市轄區',530600),(530602,'昭陽區',530601),(530621,'魯甸縣',530600),(530622,'巧家縣',530600),(530623,'鹽津縣',530600),(530624,'大關縣',530600),(530625,'永善縣',530600),(530626,'綏江縣',530600),(530627,'鎮雄縣',530600),(530628,'彝良縣',530600),(530629,'威信縣',530600),(530630,'水富縣',530600),(530700,'麗江市',530000),(530701,'市轄區',530700),(530702,'古城區',530701),(530721,'玉龍納西族自治縣',530700),(530722,'永勝縣',530700),(530723,'華坪縣',530700),(530724,'寧蒗彝族自治縣',530700),(530800,'普洱市',530000),(530801,'市轄區',530800),(530802,'翠云區',530801),(530821,'寧洱哈尼族彝族自治縣',530800),(530822,'墨江哈尼族自治縣',530800),(530823,'景東彝族自治縣',530800),(530824,'景谷傣族彝族自治縣',530800),(530825,'鎮沅彝族哈尼族拉祜族自治縣',530800),(530826,'江城哈尼族彝族自治縣',530800),(530827,'孟連傣族拉祜族佤族自治縣',530800),(530828,'瀾滄拉祜族自治縣',530800),(530829,'西盟佤族自治縣',530800),(530900,'臨滄市',530000),(530901,'市轄區',530900),(530902,'臨翔區',530901),(530921,'鳳慶縣',530900),(530922,'云縣',530900),(530923,'永德縣',530900),(530924,'鎮康縣',530900),(530925,'雙江拉祜族佤族布朗族傣族自治縣',530900),(530926,'耿馬傣族佤族自治縣',530900),(530927,'滄源佤族自治縣',530900),(532300,'楚雄彝族自治州',530000),(532301,'楚雄市',532300),(532322,'雙柏縣',532300),(532323,'牟定縣',532300),(532324,'南華縣',532300),(532325,'姚安縣',532300),(532326,'大姚縣',532300),(532327,'永仁縣',532300),(532328,'元謀縣',532300),(532329,'武定縣',532300),(532331,'祿豐縣',532300),(532500,'紅河哈尼族彝族自治州',530000),(532501,'個舊市',532500),(532502,'開遠市',532500),(532522,'蒙自市',532500),(532523,'屏邊苗族自治縣',532500),(532524,'建水縣',532500),(532525,'石屏縣',532500),(532526,'彌勒市',532500),(532527,'瀘西縣',532500),(532528,'元陽縣',532500),(532529,'紅河縣',532500),(532530,'金平苗族瑤族傣族自治縣',532500),(532531,'綠春縣',532500),(532532,'河口瑤族自治縣',532500),(532600,'文山壯族苗族自治州',530000),(532621,'文山市',532600),(532622,'硯山縣',532600),(532623,'西疇縣',532600),(532624,'麻栗坡縣',532600),(532625,'馬關縣',532600),(532626,'丘北縣',532600),(532627,'廣南縣',532600),(532628,'富寧縣',532600),(532800,'西雙版納傣族自治州',530000),(532801,'景洪市',532800),(532822,'勐海縣',532800),(532823,'勐臘縣',532800),(532900,'大理白族自治州',530000),(532901,'大理市',532900),(532922,'漾濞彝族自治縣',532900),(532923,'祥云縣',532900),(532924,'賓川縣',532900),(532925,'彌渡縣',532900),(532926,'南澗彝族自治縣',532900),(532927,'巍山彝族回族自治縣',532900),(532928,'永平縣',532900),(532929,'云龍縣',532900),(532930,'洱源縣',532900),(532931,'劍川縣',532900),(532932,'鶴慶縣',532900),(533100,'德宏傣族景頗族自治州',530000),(533102,'瑞麗市',533100),(533103,'潞西市',533100),(533122,'梁河縣',533100),(533123,'盈江縣',533100),(533124,'隴川縣',533100),(533300,'怒江傈僳族自治州',530000),(533321,'瀘水縣',533300),(533323,'福貢縣',533300),(533324,'貢山獨龍族怒族自治縣',533300),(533325,'蘭坪白族普米族自治縣',533300),(533400,'迪慶藏族自治州',530000),(533421,'香格里拉縣',533400),(533422,'德欽縣',533400),(533423,'維西傈僳族自治縣',533400),(540000,'西藏自治區',NULL),(540100,'拉薩市',540000),(540101,'市轄區',540100),(540102,'城關區',540101),(540121,'林周縣',540100),(540122,'當雄縣',540100),(540123,'尼木縣',540100),(540124,'曲水縣',540100),(540125,'堆龍德慶縣',540100),(540126,'達孜縣',540100),(540127,'墨竹工卡縣',540100),(542100,'昌都地區',540000),(542121,'昌都縣',542100),(542122,'江達縣',542100),(542123,'貢覺縣',542100),(542124,'類烏齊縣',542100),(542125,'丁青縣',542100),(542126,'察雅縣',542100),(542127,'八宿縣',542100),(542128,'左貢縣',542100),(542129,'芒康縣',542100),(542132,'洛隆縣',542100),(542133,'邊壩縣',542100),(542200,'山南地區',540000),(542221,'乃東縣',542200),(542222,'扎囊縣',542200),(542223,'貢嘎縣',542200),(542224,'桑日縣',542200),(542225,'瓊結縣',542200),(542226,'曲松縣',542200),(542227,'措美縣',542200),(542228,'洛扎縣',542200),(542229,'加查縣',542200),(542231,'隆子縣',542200),(542232,'錯那縣',542200),(542233,'浪卡子縣',542200),(542300,'日喀則地區',540000),(542301,'日喀則市',542300),(542322,'南木林縣',542300),(542323,'江孜縣',542300),(542324,'定日縣',542300),(542325,'薩迦縣',542300),(542326,'拉孜縣',542300),(542327,'昂仁縣',542300),(542328,'謝通門縣',542300),(542329,'白朗縣',542300),(542330,'仁布縣',542300),(542331,'康馬縣',542300),(542332,'定結縣',542300),(542333,'仲巴縣',542300),(542334,'亞東縣',542300),(542335,'吉隆縣',542300),(542336,'聶拉木縣',542300),(542337,'薩嘎縣',542300),(542338,'崗巴縣',542300),(542400,'那曲地區',540000),(542421,'那曲縣',542400),(542422,'嘉黎縣',542400),(542423,'比如縣',542400),(542424,'聶榮縣',542400),(542425,'安多縣',542400),(542426,'申扎縣',542400),(542427,'索縣',542400),(542428,'班戈縣',542400),(542429,'巴青縣',542400),(542430,'尼瑪縣',542400),(542500,'阿里地區',540000),(542521,'普蘭縣',542500),(542522,'札達縣',542500),(542523,'噶爾縣',542500),(542524,'日土縣',542500),(542525,'革吉縣',542500),(542526,'改則縣',542500),(542527,'措勤縣',542500),(542600,'林芝地區',540000),(542621,'林芝縣',542600),(542622,'工布江達縣',542600),(542623,'米林縣',542600),(542624,'墨脫縣',542600),(542625,'波密縣',542600),(542626,'察隅縣',542600),(542627,'朗縣',542600),(610000,'陜西省',NULL),(610100,'西安市',610000),(610101,'長安區',610100),(610102,'新城區',610100),(610103,'碑林區',610100),(610104,'蓮湖區',610100),(610111,'灞橋區',610100),(610112,'未央區',610100),(610113,'雁塔區',610100),(610114,'閻良區',610100),(610115,'臨潼區',610100),(610122,'藍田縣',610100),(610124,'周至縣',610100),(610125,'戶縣',610100),(610126,'高陵縣',610100),(610200,'銅川市',610000),(610201,'市轄區',610200),(610202,'王益區',610201),(610203,'印臺區',610201),(610204,'耀州區',610201),(610222,'宜君縣',610200),(610300,'寶雞市',610000),(610301,'市轄區',610300),(610302,'渭濱區',610301),(610303,'金臺區',610301),(610304,'陳倉區',610301),(610322,'鳳翔縣',610300),(610323,'岐山縣',610300),(610324,'扶風縣',610300),(610326,'眉縣',610300),(610327,'隴縣',610300),(610328,'千陽縣',610300),(610329,'麟游縣',610300),(610330,'鳳縣',610300),(610331,'太白縣',610300),(610400,'咸陽市',610000),(610401,'市轄區',610400),(610402,'秦都區',610401),(610404,'渭城區',610401),(610422,'三原縣',610400),(610423,'涇陽縣',610400),(610424,'乾縣',610400),(610425,'禮泉縣',610400),(610426,'永壽縣',610400),(610427,'彬縣',610400),(610428,'長武縣',610400),(610429,'旬邑縣',610400),(610430,'淳化縣',610400),(610431,'武功縣',610400),(610481,'興平市',610400),(610500,'渭南市',610000),(610501,'市轄區',610500),(610502,'臨渭區',610501),(610521,'華縣',610500),(610522,'潼關縣',610500),(610523,'大荔縣',610500),(610524,'合陽縣',610500),(610525,'澄城縣',610500),(610526,'蒲城縣',610500),(610527,'白水縣',610500),(610528,'富平縣',610500),(610581,'韓城市',610500),(610582,'華陰市',610500),(610600,'延安市',610000),(610601,'市轄區',610600),(610602,'寶塔區',610601),(610621,'延長縣',610600),(610622,'延川縣',610600),(610623,'子長縣',610600),(610624,'安塞縣',610600),(610625,'志丹縣',610600),(610626,'吳起縣',610600),(610627,'甘泉縣',610600),(610628,'富縣',610600),(610629,'洛川縣',610600),(610630,'宜川縣',610600),(610631,'黃龍縣',610600),(610632,'黃陵縣',610600),(610700,'漢中市',610000),(610701,'市轄區',610700),(610702,'漢臺區',610701),(610721,'南鄭縣',610700),(610722,'城固縣',610700),(610723,'洋縣',610700),(610724,'西鄉縣',610700),(610725,'勉縣',610700),(610726,'寧強縣',610700),(610727,'略陽縣',610700),(610728,'鎮巴縣',610700),(610729,'留壩縣',610700),(610730,'佛坪縣',610700),(610800,'榆林市',610000),(610801,'市轄區',610800),(610802,'榆陽區',610800),(610821,'神木縣',610800),(610822,'府谷縣',610800),(610823,'橫山縣',610800),(610824,'靖邊縣',610800),(610825,'定邊縣',610800),(610826,'綏德縣',610800),(610827,'米脂縣',610800),(610828,'佳縣',610800),(610829,'吳堡縣',610800),(610830,'清澗縣',610800),(610831,'子洲縣',610800),(610900,'安康市',610000),(610901,'市轄區',610900),(610902,'漢濱區',610901),(610921,'漢陰縣',610900),(610922,'石泉縣',610900),(610923,'寧陜縣',610900),(610924,'紫陽縣',610900),(610925,'嵐皋縣',610900),(610926,'平利縣',610900),(610927,'鎮坪縣',610900),(610928,'旬陽縣',610900),(610929,'白河縣',610900),(611000,'商洛市',610000),(611001,'市轄區',611000),(611002,'商州區',611001),(611021,'洛南縣',611000),(611022,'丹鳳縣',611000),(611023,'商南縣',611000),(611024,'山陽縣',611000),(611025,'鎮安縣',611000),(611026,'柞水縣',611000),(611100,'楊凌示范區',610000),(611103,'楊凌區',611100),(620000,'甘肅省',NULL),(620100,'蘭州市',620000),(620101,'市轄區',620100),(620102,'城關區',620101),(620103,'七里河區',620101),(620104,'西固區',620101),(620105,'安寧區',620101),(620111,'紅古區',620101),(620121,'永登縣',620100),(620122,'皋蘭縣',620100),(620123,'榆中縣',620100),(620200,'嘉峪關市',620000),(620201,'市轄區',620200),(620300,'金昌市',620000),(620301,'金川區',620300),(620321,'永昌縣',620300),(620400,'白銀市',620000),(620401,'市轄區',620400),(620402,'白銀區',620401),(620403,'平川區',620401),(620421,'靖遠縣',620400),(620422,'會寧縣',620400),(620423,'景泰縣',620400),(620500,'天水市',620000),(620501,'麥積區',620500),(620502,'秦州區',620500),(620521,'清水縣',620500),(620522,'秦安縣',620500),(620523,'甘谷縣',620500),(620524,'武山縣',620500),(620525,'張家川回族自治縣',620500),(620600,'武威市',620000),(620601,'市轄區',620600),(620602,'涼州區',620601),(620621,'民勤縣',620600),(620622,'古浪縣',620600),(620623,'天祝藏族自治縣',620600),(620700,'張掖市',620000),(620701,'市轄區',620700),(620702,'甘州區',620701),(620721,'肅南裕固族自治縣',620700),(620722,'民樂縣',620700),(620723,'臨澤縣',620700),(620724,'高臺縣',620700),(620725,'山丹縣',620700),(620800,'平涼市',620000),(620801,'市轄區',620800),(620802,'崆峒區',620801),(620821,'涇川縣',620800),(620822,'靈臺縣',620800),(620823,'崇信縣',620800),(620824,'華亭縣',620800),(620825,'莊浪縣',620800),(620826,'靜寧縣',620800),(620900,'酒泉市',620000),(620901,'市轄區',620900),(620902,'肅州區',620901),(620921,'金塔縣',620900),(620922,'瓜洲縣',620900),(620923,'肅北蒙古族自治縣',620900),(620924,'阿克塞哈薩克族自治縣',620900),(620981,'玉門市',620900),(620982,'敦煌市',620900),(621000,'慶陽市',620000),(621001,'市轄區',621000),(621002,'西峰區',621001),(621021,'慶城縣',621000),(621022,'環縣',621000),(621023,'華池縣',621000),(621024,'合水縣',621000),(621025,'正寧縣',621000),(621026,'寧縣',621000),(621027,'鎮原縣',621000),(621100,'定西市',620000),(621101,'市轄區',621100),(621102,'安定區',621101),(621121,'通渭縣',621100),(621122,'隴西縣',621100),(621123,'渭源縣',621100),(621124,'臨洮縣',621100),(621125,'漳縣',621100),(621126,'岷縣',621100),(621200,'隴南市',620000),(621201,'武都區',621200),(621221,'成縣',621200),(621222,'文縣',621200),(621223,'宕昌縣',621200),(621224,'康縣',621200),(621225,'西和縣',621200),(621226,'禮縣',621200),(621227,'徽縣',621200),(621228,'兩當縣',621200),(622900,'臨夏回族自治州',620000),(622901,'臨夏市',622900),(622921,'臨夏縣',622900),(622922,'康樂縣',622900),(622923,'永靖縣',622900),(622924,'廣河縣',622900),(622925,'和政縣',622900),(622926,'東鄉族自治縣',622900),(622927,'積石山保安族東鄉族撒拉族自治縣',622900),(623000,'甘南藏族自治州',620000),(623001,'合作市',623000),(623021,'臨潭縣',623000),(623022,'卓尼縣',623000),(623023,'舟曲縣',623000),(623024,'迭部縣',623000),(623025,'瑪曲縣',623000),(623026,'碌曲縣',623000),(623027,'夏河縣',623000),(630000,'青海省',NULL),(630100,'西寧市',630000),(630101,'市轄區',630100),(630102,'城東區',630101),(630103,'城中區',630101),(630104,'城西區',630101),(630105,'城北區',630101),(630121,'大通回族土族自治縣',630100),(630122,'湟中縣',630100),(630123,'湟源縣',630100),(632100,'海東市',630000),(632121,'平安縣',632100),(632122,'民和回族土族自治縣',632100),(632123,'樂都區',632100),(632126,'互助土族自治縣',632100),(632127,'化隆回族自治縣',632100),(632128,'循化撒拉族自治縣',632100),(632200,'海北藏族自治州',630000),(632221,'門源回族自治縣',632200),(632222,'祁連縣',632200),(632223,'海晏縣',632200),(632224,'剛察縣',632200),(632300,'黃南藏族自治州',630000),(632321,'同仁縣',632300),(632322,'尖扎縣',632300),(632323,'澤庫縣',632300),(632324,'河南蒙古族自治縣',632300),(632500,'海南藏族自治州',630000),(632521,'共和縣',632500),(632522,'同德縣',632500),(632523,'貴德縣',632500),(632524,'興海縣',632500),(632525,'貴南縣',632500),(632600,'果洛藏族自治州',630000),(632621,'瑪沁縣',632600),(632622,'班瑪縣',632600),(632623,'甘德縣',632600),(632624,'達日縣',632600),(632625,'久治縣',632600),(632626,'瑪多縣',632600),(632700,'玉樹藏族自治州',630000),(632721,'玉樹縣',632700),(632722,'雜多縣',632700),(632723,'稱多縣',632700),(632724,'治多縣',632700),(632725,'囊謙縣',632700),(632726,'曲麻萊縣',632700),(632800,'海西蒙古族藏族自治州',630000),(632801,'格爾木市',632800),(632802,'德令哈市',632800),(632821,'烏蘭縣',632800),(632822,'都蘭縣',632800),(632823,'天峻縣',632800),(640000,'寧夏回族自治區',NULL),(640100,'銀川市',640000),(640104,'興慶區',640100),(640105,'西夏區',640100),(640106,'金鳳區',640100),(640121,'永寧縣',640100),(640122,'賀蘭縣',640100),(640181,'靈武市',640100),(640200,'石嘴山市',640000),(640202,'大武口區',640200),(640205,'惠農縣',640200),(640221,'平羅縣',640200),(640300,'吳忠市',640000),(640301,'紅寺堡區',640300),(640302,'利通區',640300),(640323,'鹽池縣',640300),(640324,'同心縣',640300),(640381,'青銅峽市',640300),(640400,'固原市',640000),(640401,'市轄區',640400),(640402,'原州區',640400),(640422,'西吉縣',640400),(640423,'隆德縣',640400),(640424,'涇源縣',640400),(640425,'彭陽縣',640400),(640500,'中衛市',640000),(640501,'市轄區',640500),(640502,'沙坡頭區',640500),(640521,'中寧縣',640500),(640522,'海原縣',640500),(650000,'新疆維吾爾自治區',NULL),(650100,'烏魯木齊市',650000),(650101,'市轄區',650100),(650102,'天山區',650101),(650103,'沙依巴克區',650101),(650104,'新市區',650101),(650105,'水磨溝區',650101),(650106,'頭屯河區',650101),(650107,'達坂城區',650101),(650108,'東山區',650101),(650121,'烏魯木齊縣',650100),(650200,'克拉瑪依市',650000),(650201,'市轄區',650200),(650202,'獨山子區',650201),(650203,'克拉瑪依區',650201),(650204,'白堿灘區',650201),(650205,'烏爾禾區',650201),(652100,'吐魯番地區',650000),(652101,'吐魯番市',652100),(652122,'鄯善縣',652100),(652123,'托克遜縣',652100),(652200,'哈密地區',650000),(652201,'哈密市',652200),(652222,'巴里坤哈薩克自治縣',652200),(652223,'伊吾縣',652200),(652300,'昌吉回族自治州',650000),(652301,'昌吉市',652300),(652302,'阜康市',652300),(652303,'米泉市',652300),(652323,'呼圖壁縣',652300),(652324,'瑪納斯縣',652300),(652325,'奇臺縣',652300),(652327,'吉木薩爾縣',652300),(652328,'木壘哈薩克自治縣',652300),(652700,'博爾塔拉蒙古自治州',650000),(652701,'博樂市',652700),(652722,'精河縣',652700),(652723,'溫泉縣',652700),(652800,'巴音郭楞蒙古自治州',650000),(652801,'庫爾勒市',652800),(652822,'輪臺縣',652800),(652823,'尉犁縣',652800),(652824,'若羌縣',652800),(652825,'且末縣',652800),(652826,'焉耆回族自治縣',652800),(652827,'和靜縣',652800),(652828,'和碩縣',652800),(652829,'博湖縣',652800),(652900,'阿克蘇地區',650000),(652901,'阿克蘇市',652900),(652922,'溫宿縣',652900),(652923,'庫車縣',652900),(652924,'沙雅縣',652900),(652925,'新和縣',652900),(652926,'拜城縣',652900),(652927,'烏什縣',652900),(652928,'阿瓦提縣',652900),(652929,'柯坪縣',652900),(653000,'克孜勒蘇柯爾克孜自治州',650000),(653001,'阿圖什市',653000),(653022,'阿克陶縣',653000),(653023,'阿合奇縣',653000),(653024,'烏恰縣',653000),(653100,'喀什地區',650000),(653101,'喀什市',653100),(653121,'疏附縣',653100),(653122,'疏勒縣',653100),(653123,'英吉沙縣',653100),(653124,'澤普縣',653100),(653125,'莎車縣',653100),(653126,'葉城縣',653100),(653127,'麥蓋提縣',653100),(653128,'岳普湖縣',653100),(653129,'伽師縣',653100),(653130,'巴楚縣',653100),(653131,'塔什庫爾干塔吉克自治縣',653100),(653200,'和田地區',650000),(653201,'和田市',653200),(653221,'和田縣',653200),(653222,'墨玉縣',653200),(653223,'皮山縣',653200),(653224,'洛浦縣',653200),(653225,'策勒縣',653200),(653226,'于田縣',653200),(653227,'民豐縣',653200),(654000,'伊犁哈薩克自治州',650000),(654002,'伊寧市',654000),(654003,'奎屯市',654000),(654021,'伊寧縣',654000),(654022,'察布查爾錫伯自治縣',654000),(654023,'霍城縣',654000),(654024,'鞏留縣',654000),(654025,'新源縣',654000),(654026,'昭蘇縣',654000),(654027,'特克斯縣',654000),(654028,'尼勒克縣',654000),(654200,'塔城地區',650000),(654201,'塔城市',654200),(654202,'烏蘇市',654200),(654221,'額敏縣',654200),(654223,'沙灣縣',654200),(654224,'托里縣',654200),(654225,'裕民縣',654200),(654226,'和布克賽爾蒙古自治縣',654200),(654300,'阿勒泰地區',650000),(654301,'阿勒泰市',654300),(654321,'布爾津縣',654300),(654322,'富蘊縣',654300),(654323,'福海縣',654300),(654324,'哈巴河縣',654300),(654325,'青河縣',654300),(654326,'吉木乃縣',654300),(659000,'省直轄行政單位',650000),(659001,'石河子市',659000),(659002,'阿拉爾市',659000),(659003,'圖木舒克市',659000),(659004,'五家渠市',659000),(990000,'新疆建設兵團',NULL),(990100,'第一師',990000),(990200,'第二師',990000),(990300,'第三師',990000),(990400,'第四師',990000),(990500,'第五師',990000),(990600,'第六師',990000),(990700,'第七師',990000),(990800,'第八師',990000),(990900,'第九師',990000),(991000,'第十師',990000),(991100,'建工師',990000),(991200,'第十二師',990000),(991300,'第十三師',990000),(991400,'第十四師',990000);/*Table structure for table `hobby` */DROP TABLE IF EXISTS `hobby`;CREATE TABLE `hobby` (`hobby_id` int(11) NOT NULL AUTO_INCREMENT,`hobby_name` varchar(255) NOT NULL DEFAULT '',PRIMARY KEY (`hobby_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;/*Data for the table `hobby` */insert into `hobby`(`hobby_id`,`hobby_name`) values (1,'打游戲'),(2,'敲代碼'),(3,'打籃球'),(4,'打羽毛球'),(5,'吃零食'),(6,'睡覺'),(7,'看書'),(8,'寫字'),(9,'看電影'),(10,'看電視劇'),(11,'看動漫'),(12,'聽音樂');/*Table structure for table `pet` */DROP TABLE IF EXISTS `pet`;CREATE TABLE `pet` (`pet_id` int(11) NOT NULL AUTO_INCREMENT,`pet_name` varchar(255) DEFAULT NULL,`user_id` int(11) NOT NULL DEFAULT '0',PRIMARY KEY (`pet_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;/*Data for the table `pet` */insert into `pet`(`pet_id`,`pet_name`,`user_id`) values (1,'黑貓',2),(2,'黃貓',2),(3,'橘貓',3),(4,'花貓',3),(5,'白貓',3),(6,'藍貓',4),(7,'奶貓',4),(8,'無毛貓',5),(9,'波斯貓',6),(10,'加菲貓',8);/*Table structure for table `user` */DROP TABLE IF EXISTS `user`;CREATE TABLE `user` (`user_id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(255) NOT NULL DEFAULT '',`gender` char(4) NOT NULL DEFAULT '',`score` int(11) NOT NULL DEFAULT '0',PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;/*Data for the table `user` */insert into `user`(`user_id`,`username`,`gender`,`score`) values (1,'Jack','男',80),(2,'Tom','男',60),(3,'張三','男',70),(4,'李四','女',99),(5,'王五','女',60),(6,'趙六','女',80),(7,'小八','女',100),(8,'李小明','男',50);/*Table structure for table `user_hobby` */DROP TABLE IF EXISTS `user_hobby`;CREATE TABLE `user_hobby` (`user_id` int(11) NOT NULL,`hobby_id` int(11) NOT NULL DEFAULT '0',PRIMARY KEY (`user_id`,`hobby_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*Data for the table `user_hobby` */insert into `user_hobby`(`user_id`,`hobby_id`) values (1,1),(1,3),(1,8),(2,2),(2,4),(3,11),(3,12),(4,5),(5,6),(6,7),(6,9),(7,10),(8,1),(8,2),(8,3),(8,4),(8,5),(8,6),(8,7),(8,8),(8,9),(8,10),(8,11),(8,12);/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

測試實例

public static void main(String[] args) {SqlSession session = MyBatisUtils.getSession();UserDao userDao = session.getMapper(UserDao.class);HobbyDao hobbyDao = session.getMapper(HobbyDao.class);List<User> users = userDao.getUserListwithHobby();for(User user:users) {System.out.println(user);}List<Hobby> hobbies = hobbyDao.getHobbyListforUser();for(Hobby hobby:hobbies) {System.out.println(hobby);}}

?

public static void main(String[] args) {SqlSession session = MyBatisUtils.getSession();AreaDao areaDao = session.getMapper(AreaDao.class);System.out.println(areaDao.getAreaById(110000));//查詢帶子集的AreaArea area = areaDao.getAreawithChild(130000);System.out.println("本級: "+area.getAreaName());System.out.println("下級:");if (area.getChildAreaList()!=null&&area.getChildAreaList().size()>0) {for (Area a : area.getChildAreaList()) {System.out.println(a.getAreaName());if (a.getChildAreaList()!=null&&a.getChildAreaList().size()>0) {System.out.print("\t");for (Area a1 : a.getChildAreaList()) {System.out.print(" " + a1.getAreaName());} System.out.println();}} }session.commit();session.close();}

?

總結

以上是生活随笔為你收集整理的mybatis框架实现一对多、多对多关系查询，以及递归查询（单表多级分类：省市区三级地址查询）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。