cities.sql

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

县',NULL,'1',350700),(350723,'光泽县',NULL,'1',350700),(350724,'松溪县',NULL,'1',350700),(350725,'政和县',NULL,'1',350700),(350781,'邵武市',NULL,'1',350700),(350782,'武夷山

市',NULL,'1',350700),(350783,'建瓯市',NULL,'1',350700),(350784,'建阳市',NULL,'1',350700),(350800,'龙岩市',NULL,'0',350000),(350801,'市辖区',NULL,'1',350800),(350802,'新罗

区',NULL,'1',350800),(350821,'长汀县',NULL,'1',350800),(350822,'永定县',NULL,'1',350800),(350823,'上杭县',NULL,'1',350800),(350824,'武平县',NULL,'1',350800),(350825,'连城

县',NULL,'1',350800),(350881,'漳平市',NULL,'1',350800),(350900,'宁德市',NULL,'0',350000),(350901,'市辖区',NULL,'1',350900),(350902,'蕉城区',NULL,'1',350900),(350921,'霞浦

县',NULL,'1',350900),(350922,'古田县',NULL,'1',350900),(350923,'屏南县',NULL,'1',350900),(350924,'寿宁县',NULL,'1',350900),(350925,'周宁县',NULL,'1',350900),(350926,'柘荣

县',NULL,'1',350900),(350981,'福安市',NULL,'1',350900),(350982,'福鼎市',NULL,'1',350900),(360000,'江西省',NULL,'0',NULL),(360100,'南昌市',NULL,'0',360000),(360101,'市辖

区',NULL,'1',360100),(360102,'东湖区',NULL,'1',360100),(360103,'西湖区',NULL,'1',360100),(360104,'青云谱区',NULL,'1',360100),(360105,'湾里区',NULL,'1',360100),(360111,'青山湖

区',NULL,'1',360100),(360121,'南昌县',NULL,'1',360100),(360122,'新建县',NULL,'1',360100),(360123,'安义县',NULL,'1',360100),(360124,'进贤县',NULL,'1',360100),(360200,'景德镇

市',NULL,'0',360000),(360201,'市辖区',NULL,'1',360200),(360202,'昌江区',NULL,'1',360200),(360203,'珠山区',NULL,'1',360200),(360222,'浮梁县',NULL,'1',360200),(360281,'乐平

市',NULL,'1',360200),(360300,'萍乡市',NULL,'0',360000),(360301,'市辖区',NULL,'1',360300),(360302,'安源区',NULL,'1',360300),(360313,'湘东区',NULL,'1',360300),(360321,'莲花

县',NULL,'1',360300),(360322,'上栗县',NULL,'1',360300),(360323,'芦溪县',NULL,'1',360300),(360400,'九江市',NULL,'0',360000),(360401,'市辖区',NULL,'1',360400),(360402,'庐山

区',NULL,'1',360400),(360403,'浔阳区',NULL,'1',360400),(360421,'九江县',NULL,'1',360400),(360423,'武宁县',NULL,'1',360400),(360424,'修水县',NULL,'1',360400),(360425,'永修

县',NULL,'1',360400),(360426,'德安县',NULL,'1',360400),(360427,'星子县',NULL,'1',360400),(360428,'都昌县',NULL,'1',360400),(360429,'湖口县',NULL,'1',360400),(360430,'彭泽

县',NULL,'1',360400),(360481,'瑞昌市',NULL,'1',360400),(360500,'新余市',NULL,'0',360000),(360501,'市辖区',NULL,'1',360500),(360502,'渝水区',NULL,'1',360500),(360521,'分宜

县',NULL,'1',360500),(360600,'鹰潭市',NULL,'0',360000),(360601,'市辖区',NULL,'1',360600),(360602,'月湖区',NULL,'1',360600),(360622,'余江县',NULL,'1',360600),(360681,'贵溪

市',NULL,'1',360600),(360700,'赣州市',NULL,'0',360000),(360701,'市辖区',NULL,'1',360700),(360702,'章贡区',NULL,'1',360700),(360721,'赣　县',NULL,'1',360700),(360722,'信丰

县',NULL,'1',360700),(360723,'大余县',NULL,'1',360700),(360724,'上犹县',NULL,'1',360700),(360725,'崇义县',NULL,'1',360700),(360726,'安远县',NULL,'1',360700),(360727,'龙南

县',NULL,'1',360700),(360728,'定南县',NULL,'1',360700),(360729,'全南县',NULL,'1',360700),(360730,'宁都县',NULL,'1',360700),(360731,'于都县',NULL,'1',360700),(360732,'兴国

县',NULL,'1',360700),(360733,'会昌县',NULL,'1',360700),(360734,'寻乌县',NULL,'1',360700),(360735,'石城县',NULL,'1',360700),(360781,'瑞金市',NULL,'1',360700),(360782,'南康

市',NULL,'1',360700),(360800,'吉安市',NULL,'0',360000),(360801,'市辖区',NULL,'1',360800),(360802,'吉州区',NULL,'1',360800),(360803,'青原区',NULL,'1',360800),(360821,'吉安

县',NULL,'1',360800),(360822,'吉水县',NULL,'1',360800),(360823,'峡江县',NULL,'1',360800),(360824,'新干县',NULL,'1',360800),(360825,'永丰县',NULL,'1',360800),(360826,'泰和

县',NULL,'1',360800),(360827,'遂川县',NULL,'1',360800),(360828,'万安县',NULL,'1',360800),(360829,'安福县',NULL,'1',360800),(360830,'永新县',NULL,'1',360800),(360881,'井冈山

市',NULL,'1',360800),(360900,'宜春市',NULL,'0',360000),(360901,'市辖区',NULL,'1',360900),(360902,'袁州区',NULL,'1',360900),(360921,'奉新县',NULL,'1',360900),(360922,'万载

县',NULL,'1',360900),(360923,'上高县',NULL,'1',360900),(360924,'宜丰县',NULL,'1',360900),(360925,'靖安县',NULL,'1',360900),(360926,'铜鼓县',NULL,'1',360900),(360981,'丰城

市',NULL,'1',360900),(360982,'樟树市',NULL,'1',360900),(360983,'高安市',NULL,'1',360900),(361000,'抚州市',NULL,'0',360000),(361001,'市辖区',NULL,'1',361000),(361002,'临川

区',NULL,'1',361000),(361021,'南城县',NULL,'1',361000),(361022,'黎川县',NULL,'1',361000),(361023,'南丰县',NULL,'1',361000),(361024,'崇仁县',NULL,'1',361000),(361025,'乐安

县',NULL,'1',361000),(361026,'宜黄县',NULL,'1',361000),(361027,'金溪县',NULL,'1',361000),(361028,'资溪县',NULL,'1',361000),(361029,'东乡县',NULL,'1',361000),(361030,'广昌

县',NULL,'1',361000),(361100,'上饶市',NULL,'0',360000),(361101,'市辖区',NULL,'1',361100),(361102,'信州区',NULL,'1',361100),(361121,'上饶县',NULL,'1',361100),(361122,'广丰

县',NULL,'1',361100),(361123,'玉山县',NULL,'1',361100),(361124,'铅山县',NULL,'1',361100),(361125,'横峰县',NULL,'1',361100),(361126,'弋阳县',NULL,'1',361100),(361127,'余干

县',NULL,'1',361100),(361128,'鄱阳县',NULL,'1',361100),(361129,'万年县',NULL,'1',361100),(361130,'婺源县',NULL,'1',361100),(361181,'德兴市',NULL,'1',361100),(370000,'山东

省',NULL,'0',NULL),(370100,'济南市',NULL,'0',370000),(370101,'市辖区',NULL,'1',370100),(370102,'历下区',NULL,'1',370100),(370103,'市中区',NULL,'1',370100),(370104,'槐荫

区',NULL,'1',370100),(370105,'天桥区',NULL,'1',370100),(370112,'历城区',NULL,'1',370100),(370113,'长清区',NULL,'1',370100),(370124,'平阴县',NULL,'1',370100),(370125,'济阳

县',NULL,'1',370100),(370126,'商河县',NULL,'1',370100),(370181,'章丘市',NULL,'1',370100),(370200,'青岛市',NULL,'0',370000),(370201,'市辖区',NULL,'1',370200),(370202,'市南

区',NULL,'1',370200),(370203,'市北区',NULL,'1',370200),(370205,'四方区',NULL,'1',370200),(370211,'黄岛区',NULL,'1',370200),(370212,'崂山区',NULL,'1',370200),(370213,'李沧

区',NULL,'1',370200),(370214,'城阳区',NULL,'1',370200),(370281,'胶州市',NULL,'1',370200),(370282,'即墨市',NULL,'1',370200),(370283,'平度市',NULL,'1',370200),(370284,'胶南

市',NULL,'1',370200),(370285,'莱西市',NULL,'1',370200),(370300,'淄博市',NULL,'0',370000),(370301,'市辖区',NULL,'1',370300),(370302,'淄川区',NULL,'1',370300),(370303,'张店

区',NULL,'1',370300),(370304,'博山区',NULL,'1',370300),(370305,'临淄区',NULL,'1',370300),(370306,'周村区',NULL,'1',370300),(370321,'桓台县',NULL,'1',370300),(370322,'高青

县',NULL,'1',370300),(370323,'沂源县',NULL,'1',370300),(370400,'枣庄市',NULL,'0',370000),(370401,'市辖区',NULL,'1',370400),(370402,'市中区',NULL,'1',370400),(370403,'薛城

区',NULL,'1',370400),(370404,'峄城区',NULL,'1',370400),(370405,'台儿庄区',NULL,'1',370400),(370406,'山亭区',NULL,'1',370400),(370481,'滕州市',NULL,'1',370400),(370500,'东营

市',NULL,'0',370000),(370501,'市辖区',NULL,'1',370500),(370502,'东营区',NULL,'1',370500),(370503,'河口区',NULL,'1',370500),(370521,'垦利县',NULL,'1',370500),(370522,'利津

县',NULL,'1',370500),(370523,'广饶县',NULL,'1',370500),(370600,'烟台市',NULL,'0',370000),(370601,'市辖区',NULL,'1',370600),(370602,'芝罘区',NULL,'1',370600),(370611,'福山

区',NULL,'1',370600),(370612,'牟平区',NULL,'1',370600),(370613,'莱山区',NULL,'1',370600),(370634,'长岛县',NULL,'1',370600),(370681,'龙口市',NULL,'1',370600),(370682,'莱阳

市',NULL,'1',370600),(370683,'莱州市',NULL,'1',370600),(370684,'蓬莱市',NULL,'1',370600),(370685,'招远市',NULL,'1',370600),(370686,'栖霞市',NULL,'1',370600),(370687,'海阳

市',NULL,'1',370600),(370700,'潍坊市',NULL,'0',370000),(370701,'市辖区',NULL,'1',370700),(370702,'潍城区',NULL,'1',370700),(370703,'寒亭区',NULL,'1',370700),(370704,'坊子

区',NULL,'1',370700),(370705,'奎文区',NULL,'1',370700),(370724,'临朐县',NULL,'1',370700),(370725,'昌乐县',NULL,'1',370700),(370781,'青州市',NULL,'1',370700),(370782,'诸城

市',NULL,'1',370700),(370783,'寿光市',NULL,'1',370700),(370784,'安丘市',NULL,'1',370700),(370785,'高密市',NULL,'1',370700),(370786,'昌邑市',NULL,'1',370700),(370800,'济宁

市',NULL,'0',370000),(370801,'市辖区',NULL,'1',370800),(370802,'市中区',NULL,'1',370800),(370811,'任城区',NULL,'1',370800),(370826,'微山县',NULL,'1',370800),(370827,'鱼台

县',NULL,'1',370800),(370828,'金乡县',NULL,'1',370800),(370829,'嘉祥县',NULL,'1',370800),(370830,'汶上县',NULL,'1',370800),(370831,'泗水县',NULL,'1',370800),(370832,'梁山

县',NULL,'1',370800),(370881,'曲阜市',NULL,'1',370800),(370882,'兖州市',NULL,'1',370800),(370883,'邹城市',NULL,'1',370800),(370900,'泰安市',NULL,'0',370000),(370901,'市辖

区',NULL,'1',370900),(370902,'泰山区',NULL,'1',370900),(370903,'岱岳区',NULL,'1',370900),(370921,'宁阳县',NULL,'1',370900),(370923,'东平县',NULL,'1',370900),(370982,'新泰

市',NULL,'1',370900),(370983,'肥城市',NULL,'1',370900),(371000,'威海市',NULL,'0',370000),(371001,'市辖区',NULL,'1',371000),(371002,'环翠区',NULL,'1',371000),(371081,'文登

市',NULL,'1',371000),(371082,'荣成市',NULL,'1',371000),(371083,'乳山市',NULL,'1',371000),(371100,'日照市',NULL,'0',370000),(371101,'市辖区',NULL,'1',371100),(371102,'东港

区',NULL,'1',371100),(371103,'岚山区',NULL,'1',371100),(371121,'五莲县',NULL,'1',371100),(371122,'莒　县',NULL,'1',371100),(371200,'莱芜市',NULL,'0',370000),(371201,'市辖

区',NULL,'1',371200),(371202,'莱城区',NULL,'1',371200),(371203,'钢城区',NULL,'1',371200),(371300,'临沂市',NULL,'0',370000),(371301,'市辖区',NULL,'1',371300),(371302,'兰山

区',NULL,'1',371300),(371311,'罗庄区',NULL,'1',371300),(371312,'河东区',NULL,'1',371300),(371321,'沂南县',NULL,'1',371300),(371322,'郯城县',NULL,'1',371300),(371323,'沂水

县',NULL,'1',371300),(371324,'苍山县',NULL,'1',371300),(371325,'费　县',NULL,'1',371300),(371326,'平邑县',NULL,'1',371300),(371327,'莒南县',NULL,'1',371300),(371328,'蒙阴

县',NULL,'1',371300),(371329,'临沭县',NULL,'1',371300),(371400,'德州市',NULL,'0',370000),(371401,'市辖区',NULL,'1',371400),(371402,'德城区',NULL,'1',371400),(371421,'陵　

县',NULL,'1',371400),(371422,'宁津县',NULL,'1',371400),(371423,'庆云县',NULL,'1',371400),(371424,'临邑县',NULL,'1',371400),(371425,'齐河县',NULL,'1',371400),(371426,'平原

县',NULL,'1',371400),(371427,'夏津县',NULL,'1',371400),(371428,'武城县',NULL,'1',371400),(371481,'乐陵市',NULL,'1',371400),(371482,'禹城市',NULL,'1',371400),(371500,'聊城

市',NULL,'0',370000),(371501,'市辖区',NULL,'1',371500),(371502,'东昌府区',NULL,'1',371500),(371521,'阳谷县',NULL,'1',371500),(371522,'莘　县',NULL,'1',371500),(371523,'茌平

县',NULL,'1',371500),(371524,'东阿县',NULL,'1',371500),(371525,'冠　县',NULL,'1',371500),(371526,'高唐县',NULL,'1',371500),(371581,'临清市',NULL,'1',371500),(371600,'滨州

市',NULL,'0',370000),(371601,'市辖区',NULL,'1',371600),(371602,'滨城区',NULL,'1',371600),(371621,'惠民县',NULL,'1',371600),(371622,'阳信县',NULL,'1',371600),(371623,'无棣

县',NULL,'1',371600),(371624,'沾化县',NULL,'1',371600),(371625,'博兴县',NULL,'1',371600),(371626,'邹平县',NULL,'1',371600),(371700,'荷泽市',NULL,'0',370000),(371701,'市辖

区',NULL,'1',371700),(371702,'牡丹区',NULL,'1',371700),(371721,'曹　县',NULL,'1',371700),(371722,'单　县',NULL,'1',371700),(371723,'成武县',NULL,'1',371700),(371724,'巨野

县',NULL,'1',371700),(371725,'郓城县',NULL,'1',371700),(371726,'鄄城县',NULL,'1',371700),(371727,'定陶县',NULL,'1',371700),(371728,'东明县',NULL,'1',371700),(410000,'河南

省',NULL,'0',NULL),(410100,'郑州市',NULL,'0',410000),(410101,'市辖区',NULL,'1',410100),(410102,'中原区',NULL,'1',410100),(410103,'二七区',NULL,'1',410100),(410104,'管城回族

区',NULL,'1',410100),(410105,'金水区',NULL,'1',410100),(410106,'上街区',NULL,'1',410100),(410108,'邙山区',NULL,'1',410100),(410122,'中牟县',NULL,'1',410100),(410181,'巩义

市',NULL,'1',410100),(410182,'荥阳市',NULL,'1',410100),(410183,'新密市',NULL,'1',410100),(410184,'新郑市',NULL,'1',410100),(410185,'登封市',NULL,'1',410100),(410200,'开封

市',NULL,'0',410000),(410201,'市辖区',NULL,'1',410200),(410202,'龙亭区',NULL,'1',410200),(410203,'顺河回族区',NULL,'1',410200),(410204,'鼓楼区',NULL,'1',410200),(410205,'南关

区',NULL,'1',410200),(41