cities.sql

DWR 3级联动代码 基于DWR 的整合 是一个不错的例子

区',NULL,'1',321100),(321111,'润州区',NULL,'1',321100),(321112,'丹徒区',NULL,'1',321100),(321181,'丹阳市',NULL,'1',321100),(321182,'扬中市',NULL,'1',321100),(321183,'句容

市',NULL,'1',321100),(321200,'泰州市',NULL,'0',320000),(321201,'市辖区',NULL,'1',321200),(321202,'海陵区',NULL,'1',321200),(321203,'高港区',NULL,'1',321200),(321281,'兴化

市',NULL,'1',321200),(321282,'靖江市',NULL,'1',321200),(321283,'泰兴市',NULL,'1',321200),(321284,'姜堰市',NULL,'1',321200),(321300,'宿迁市',NULL,'0',320000),(321301,'市辖

区',NULL,'1',321300),(321302,'宿城区',NULL,'1',321300),(321311,'宿豫区',NULL,'1',321300),(321322,'沭阳县',NULL,'1',321300),(321323,'泗阳县',NULL,'1',321300),(321324,'泗洪

县',NULL,'1',321300),(330000,'浙江省',NULL,'0',NULL),(330100,'杭州市',NULL,'0',330000),(330101,'市辖区',NULL,'1',330100),(330102,'上城区',NULL,'1',330100),(330103,'下城

区',NULL,'1',330100),(330104,'江干区',NULL,'1',330100),(330105,'拱墅区',NULL,'1',330100),(330106,'西湖区',NULL,'1',330100),(330108,'滨江区',NULL,'1',330100),(330109,'萧山

区',NULL,'1',330100),(330110,'余杭区',NULL,'1',330100),(330122,'桐庐县',NULL,'1',330100),(330127,'淳安县',NULL,'1',330100),(330182,'建德市',NULL,'1',330100),(330183,'富阳

市',NULL,'1',330100),(330185,'临安市',NULL,'1',330100),(330200,'宁波市',NULL,'0',330000),(330201,'市辖区',NULL,'1',330200),(330203,'海曙区',NULL,'1',330200),(330204,'江东

区',NULL,'1',330200),(330205,'江北区',NULL,'1',330200),(330206,'北仑区',NULL,'1',330200),(330211,'镇海区',NULL,'1',330200),(330212,'鄞州区',NULL,'1',330200),(330225,'象山

县',NULL,'1',330200),(330226,'宁海县',NULL,'1',330200),(330281,'余姚市',NULL,'1',330200),(330282,'慈溪市',NULL,'1',330200),(330283,'奉化市',NULL,'1',330200),(330300,'温州

市',NULL,'0',330000),(330301,'市辖区',NULL,'1',330300),(330302,'鹿城区',NULL,'1',330300),(330303,'龙湾区',NULL,'1',330300),(330304,'瓯海区',NULL,'1',330300),(330322,'洞头

县',NULL,'1',330300),(330324,'永嘉县',NULL,'1',330300),(330326,'平阳县',NULL,'1',330300),(330327,'苍南县',NULL,'1',330300),(330328,'文成县',NULL,'1',330300),(330329,'泰顺

县',NULL,'1',330300),(330381,'瑞安市',NULL,'1',330300),(330382,'乐清市',NULL,'1',330300),(330400,'嘉兴市',NULL,'0',330000),(330401,'市辖区',NULL,'1',330400),(330402,'秀城

区',NULL,'1',330400),(330411,'秀洲区',NULL,'1',330400),(330421,'嘉善县',NULL,'1',330400),(330424,'海盐县',NULL,'1',330400),(330481,'海宁市',NULL,'1',330400),(330482,'平湖

市',NULL,'1',330400),(330483,'桐乡市',NULL,'1',330400),(330500,'湖州市',NULL,'0',330000),(330501,'市辖区',NULL,'1',330500),(330502,'吴兴区',NULL,'1',330500),(330503,'南浔

区',NULL,'1',330500),(330521,'德清县',NULL,'1',330500),(330522,'长兴县',NULL,'1',330500),(330523,'安吉县',NULL,'1',330500),(330600,'绍兴市',NULL,'0',330000),(330601,'市辖

区',NULL,'1',330600),(330602,'越城区',NULL,'1',330600),(330621,'绍兴县',NULL,'1',330600),(330624,'新昌县',NULL,'1',330600),(330681,'诸暨市',NULL,'1',330600),(330682,'上虞

市',NULL,'1',330600),(330683,'嵊州市',NULL,'1',330600),(330700,'金华市',NULL,'0',330000),(330701,'市辖区',NULL,'1',330700),(330702,'婺城区',NULL,'1',330700),(330703,'金东

区',NULL,'1',330700),(330723,'武义县',NULL,'1',330700),(330726,'浦江县',NULL,'1',330700),(330727,'磐安县',NULL,'1',330700),(330781,'兰溪市',NULL,'1',330700),(330782,'义乌

市',NULL,'1',330700),(330783,'东阳市',NULL,'1',330700),(330784,'永康市',NULL,'1',330700),(330800,'衢州市',NULL,'0',330000),(330801,'市辖区',NULL,'1',330800),(330802,'柯城

区',NULL,'1',330800),(330803,'衢江区',NULL,'1',330800),(330822,'常山县',NULL,'1',330800),(330824,'开化县',NULL,'1',330800),(330825,'龙游县',NULL,'1',330800),(330881,'江山

市',NULL,'1',330800),(330900,'舟山市',NULL,'0',330000),(330901,'市辖区',NULL,'1',330900),(330902,'定海区',NULL,'1',330900),(330903,'普陀区',NULL,'1',330900),(330921,'岱山

县',NULL,'1',330900),(330922,'嵊泗县',NULL,'1',330900),(331000,'台州市',NULL,'0',330000),(331001,'市辖区',NULL,'1',331000),(331002,'椒江区',NULL,'1',331000),(331003,'黄岩

区',NULL,'1',331000),(331004,'路桥区',NULL,'1',331000),(331021,'玉环县',NULL,'1',331000),(331022,'三门县',NULL,'1',331000),(331023,'天台县',NULL,'1',331000),(331024,'仙居

县',NULL,'1',331000),(331081,'温岭市',NULL,'1',331000),(331082,'临海市',NULL,'1',331000),(331100,'丽水市',NULL,'0',330000),(331101,'市辖区',NULL,'1',331100),(331102,'莲都

区',NULL,'1',331100),(331121,'青田县',NULL,'1',331100),(331122,'缙云县',NULL,'1',331100),(331123,'遂昌县',NULL,'1',331100),(331124,'松阳县',NULL,'1',331100),(331125,'云和

县',NULL,'1',331100),(331126,'庆元县',NULL,'1',331100),(331127,'景宁畲族自治县',NULL,'1',331100),(331181,'龙泉市',NULL,'1',331100),(340000,'安徽省',NULL,'0',NULL),(340100,'合肥

市',NULL,'0',340000),(340101,'市辖区',NULL,'1',340100),(340102,'瑶海区',NULL,'1',340100),(340103,'庐阳区',NULL,'1',340100),(340104,'蜀山区',NULL,'1',340100),(340111,'包河

区',NULL,'1',340100),(340121,'长丰县',NULL,'1',340100),(340122,'肥东县',NULL,'1',340100),(340123,'肥西县',NULL,'1',340100),(340200,'芜湖市',NULL,'0',340000),(340201,'市辖

区',NULL,'1',340200),(340202,'镜湖区',NULL,'1',340200),(340203,'马塘区',NULL,'1',340200),(340204,'新芜区',NULL,'1',340200),(340207,'鸠江区',NULL,'1',340200),(340221,'芜湖

县',NULL,'1',340200),(340222,'繁昌县',NULL,'1',340200),(340223,'南陵县',NULL,'1',340200),(340300,'蚌埠市',NULL,'0',340000),(340301,'市辖区',NULL,'1',340300),(340302,'龙子湖

区',NULL,'1',340300),(340303,'蚌山区',NULL,'1',340300),(340304,'禹会区',NULL,'1',340300),(340311,'淮上区',NULL,'1',340300),(340321,'怀远县',NULL,'1',340300),(340322,'五河

县',NULL,'1',340300),(340323,'固镇县',NULL,'1',340300),(340400,'淮南市',NULL,'0',340000),(340401,'市辖区',NULL,'1',340400),(340402,'大通区',NULL,'1',340400),(340403,'田家庵

区',NULL,'1',340400),(340404,'谢家集区',NULL,'1',340400),(340405,'八公山区',NULL,'1',340400),(340406,'潘集区',NULL,'1',340400),(340421,'凤台县',NULL,'1',340400),(340500,'马鞍山

市',NULL,'0',340000),(340501,'市辖区',NULL,'1',340500),(340502,'金家庄区',NULL,'1',340500),(340503,'花山区',NULL,'1',340500),(340504,'雨山区',NULL,'1',340500),(340521,'当涂

县',NULL,'1',340500),(340600,'淮北市',NULL,'0',340000),(340601,'市辖区',NULL,'1',340600),(340602,'杜集区',NULL,'1',340600),(340603,'相山区',NULL,'1',340600),(340604,'烈山

区',NULL,'1',340600),(340621,'濉溪县',NULL,'1',340600),(340700,'铜陵市',NULL,'0',340000),(340701,'市辖区',NULL,'1',340700),(340702,'铜官山区',NULL,'1',340700),(340703,'狮子山

区',NULL,'1',340700),(340711,'郊　区',NULL,'1',340700),(340721,'铜陵县',NULL,'1',340700),(340800,'安庆市',NULL,'0',340000),(340801,'市辖区',NULL,'1',340800),(340802,'迎江

区',NULL,'1',340800),(340803,'大观区',NULL,'1',340800),(340811,'郊　区',NULL,'1',340800),(340822,'怀宁县',NULL,'1',340800),(340823,'枞阳县',NULL,'1',340800),(340824,'潜山

县',NULL,'1',340800),(340825,'太湖县',NULL,'1',340800),(340826,'宿松县',NULL,'1',340800),(340827,'望江县',NULL,'1',340800),(340828,'岳西县',NULL,'1',340800),(340881,'桐城

市',NULL,'1',340800),(341000,'黄山市',NULL,'0',340000),(341001,'市辖区',NULL,'1',341000),(341002,'屯溪区',NULL,'1',341000),(341003,'黄山区',NULL,'1',341000),(341004,'徽州

区',NULL,'1',341000),(341021,'歙　县',NULL,'1',341000),(341022,'休宁县',NULL,'1',341000),(341023,'黟　县',NULL,'1',341000),(341024,'祁门县',NULL,'1',341000),(341100,'滁州

市',NULL,'0',340000),(341101,'市辖区',NULL,'1',341100),(341102,'琅琊区',NULL,'1',341100),(341103,'南谯区',NULL,'1',341100),(341122,'来安县',NULL,'1',341100),(341124,'全椒

县',NULL,'1',341100),(341125,'定远县',NULL,'1',341100),(341126,'凤阳县',NULL,'1',341100),(341181,'天长市',NULL,'1',341100),(341182,'明光市',NULL,'1',341100),(341200,'阜阳

市',NULL,'0',340000),(341201,'市辖区',NULL,'1',341200),(341202,'颍州区',NULL,'1',341200),(341203,'颍东区',NULL,'1',341200),(341204,'颍泉区',NULL,'1',341200),(341221,'临泉

县',NULL,'1',341200),(341222,'太和县',NULL,'1',341200),(341225,'阜南县',NULL,'1',341200),(341226,'颍上县',NULL,'1',341200),(341282,'界首市',NULL,'1',341200),(341300,'宿州

市',NULL,'0',340000),(341301,'市辖区',NULL,'1',341300),(341302,'墉桥区',NULL,'1',341300),(341321,'砀山县',NULL,'1',341300),(341322,'萧　县',NULL,'1',341300),(341323,'灵璧

县',NULL,'1',341300),(341324,'泗　县',NULL,'1',341300),(341400,'巢湖市',NULL,'0',340000),(341401,'市辖区',NULL,'1',341400),(341402,'居巢区',NULL,'1',341400),(341421,'庐江

县',NULL,'1',341400),(341422,'无为县',NULL,'1',341400),(341423,'含山县',NULL,'1',341400),(341424,'和　县',NULL,'1',341400),(341500,'六安市',NULL,'0',340000),(341501,'市辖

区',NULL,'1',341500),(341502,'金安区',NULL,'1',341500),(341503,'裕安区',NULL,'1',341500),(341521,'寿　县',NULL,'1',341500),(341522,'霍邱县',NULL,'1',341500),(341523,'舒城

县',NULL,'1',341500),(341524,'金寨县',NULL,'1',341500),(341525,'霍山县',NULL,'1',341500),(341600,'亳州市',NULL,'0',340000),(341601,'市辖区',NULL,'1',341600),(341602,'谯城

区',NULL,'1',341600),(341621,'涡阳县',NULL,'1',341600),(341622,'蒙城县',NULL,'1',341600),(341623,'利辛县',NULL,'1',341600),(341700,'池州市',NULL,'0',340000),(341701,'市辖

区',NULL,'1',341700),(341702,'贵池区',NULL,'1',341700),(341721,'东至县',NULL,'1',341700),(341722,'石台县',NULL,'1',341700),(341723,'青阳县',NULL,'1',341700),(341800,'宣城

市',NULL,'0',340000),(341801,'市辖区',NULL,'1',341800),(341802,'宣州区',NULL,'1',341800),(341821,'郎溪县',NULL,'1',341800),(341822,'广德县',NULL,'1',341800),(341823,'泾　

县',NULL,'1',341800),(341824,'绩溪县',NULL,'1',341800),(341825,'旌德县',NULL,'1',341800),(341881,'宁国市',NULL,'1',341800),(350000,'福建省',NULL,'0',NULL),(350100,'福州

市',NULL,'0',350000),(350101,'市辖区',NULL,'1',350100),(350102,'鼓楼区',NULL,'1',350100),(350103,'台江区',NULL,'1',350100),(350104,'仓山区',NULL,'1',350100),(350105,'马尾

区',NULL,'1',350100),(350111,'晋安区',NULL,'1',350100),(350121,'闽侯县',NULL,'1',350100),(350122,'连江县',NULL,'1',350100),(350123,'罗源县',NULL,'1',350100),(350124,'闽清

县',NULL,'1',350100),(350125,'永泰县',NULL,'1',350100),(350128,'平潭县',NULL,'1',350100),(350181,'福清市',NULL,'1',350100),(350182,'长乐市',NULL,'1',350100),(350200,'厦门

市',NULL,'0',350000),(350201,'市辖区',NULL,'1',350200),(350203,'思明区',NULL,'1',350200),(350205,'海沧区',NULL,'1',350200),(350206,'湖里区',NULL,'1',350200),(350211,'集美

区',NULL,'1',350200),(350212,'同安区',NULL,'1',350200),(350213,'翔安区',NULL,'1',350200),(350300,'莆田市',NULL,'0',350000),(350301,'市辖区',NULL,'1',350300),(350302,'城厢

区',NULL,'1',350300),(350303,'涵江区',NULL,'1',350300),(350304,'荔城区',NULL,'1',350300),(350305,'秀屿区',NULL,'1',350300),(350322,'仙游县',NULL,'1',350300),(350400,'三明

市',NULL,'0',350000),(350401,'市辖区',NULL,'1',350400),(350402,'梅列区',NULL,'1',350400),(350403,'三元区',NULL,'1',350400),(350421,'明溪县',NULL,'1',350400),(350423,'清流

县',NULL,'1',350400),(350424,'宁化县',NULL,'1',350400),(350425,'大田县',NULL,'1',350400),(350426,'尤溪县',NULL,'1',350400),(350427,'沙　县',NULL,'1',350400),(350428,'将乐

县',NULL,'1',350400),(350429,'泰宁县',NULL,'1',350400),(350430,'建宁县',NULL,'1',350400),(350481,'永安市',NULL,'1',350400),(350500,'泉州市',NULL,'0',350000),(350501,'市辖

区',NULL,'1',350500),(350502,'鲤城区',NULL,'1',350500),(350503,'丰泽区',NULL,'1',350500),(350504,'洛江区',NULL,'1',350500),(350505,'泉港区',NULL,'1',350500),(350521,'惠安

县',NULL,'1',350500),(350524,'安溪县',NULL,'1',350500),(350525,'永春县',NULL,'1',350500),(350526,'德化县',NULL,'1',350500),(350527,'金门县',NULL,'1',350500),(350581,'石狮

市',NULL,'1',350500),(350582,'晋江市',NULL,'1',350500),(350583,'南安市',NULL,'1',350500),(350600,'漳州市',NULL,'0',350000),(350601,'市辖区',NULL,'1',350600),(350602,'芗城

区',NULL,'1',350600),(350603,'龙文区',NULL,'1',350600),(350622,'云霄县',NULL,'1',350600),(350623,'漳浦县',NULL,'1',350600),(350624,'诏安县',NULL,'1',350600),(350625,'长泰

县',NULL,'1',350600),(350626,'东山县',NULL,'1',350600),(350627,'南靖县',NULL,'1',350600),(350628,'平和县',NULL,'1',350600),(350629,'华安县',NULL,'1',350600),(350681,'龙海

市',NULL,'1',350600),(350700,'南平市',NULL,'0',350000),(350701,'市辖区',NULL,'1',350700),(350702,'延平区',NULL,'1',350700),(350721,'顺昌县',NULL,'1',350700),(350722,'浦城