cities.sql

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

县',NULL,'1',140700),(140726,'太谷县',NULL,'1',140700),(140727,'祁　县',NULL,'1',140700),(140728,'平遥县',NULL,'1',140700),(140729,'灵石县',NULL,'1',140700),(140781,'介休

市',NULL,'1',140700),(140800,'运城市',NULL,'0',140000),(140801,'市辖区',NULL,'1',140800),(140802,'盐湖区',NULL,'1',140800),(140821,'临猗县',NULL,'1',140800),(140822,'万荣

县',NULL,'1',140800),(140823,'闻喜县',NULL,'1',140800),(140824,'稷山县',NULL,'1',140800),(140825,'新绛县',NULL,'1',140800),(140826,'绛　县',NULL,'1',140800),(140827,'垣曲

县',NULL,'1',140800),(140828,'夏　县',NULL,'1',140800),(140829,'平陆县',NULL,'1',140800),(140830,'芮城县',NULL,'1',140800),(140881,'永济市',NULL,'1',140800),(140882,'河津

市',NULL,'1',140800),(140900,'忻州市',NULL,'0',140000),(140901,'市辖区',NULL,'1',140900),(140902,'忻府区',NULL,'1',140900),(140921,'定襄县',NULL,'1',140900),(140922,'五台

县',NULL,'1',140900),(140923,'代　县',NULL,'1',140900),(140924,'繁峙县',NULL,'1',140900),(140925,'宁武县',NULL,'1',140900),(140926,'静乐县',NULL,'1',140900),(140927,'神池

县',NULL,'1',140900),(140928,'五寨县',NULL,'1',140900),(140929,'岢岚县',NULL,'1',140900),(140930,'河曲县',NULL,'1',140900),(140931,'保德县',NULL,'1',140900),(140932,'偏关

县',NULL,'1',140900),(140981,'原平市',NULL,'1',140900),(141000,'临汾市',NULL,'0',140000),(141001,'市辖区',NULL,'1',141000),(141002,'尧都区',NULL,'1',141000),(141021,'曲沃

县',NULL,'1',141000),(141022,'翼城县',NULL,'1',141000),(141023,'襄汾县',NULL,'1',141000),(141024,'洪洞县',NULL,'1',141000),(141025,'古　县',NULL,'1',141000),(141026,'安泽

县',NULL,'1',141000),(141027,'浮山县',NULL,'1',141000),(141028,'吉　县',NULL,'1',141000),(141029,'乡宁县',NULL,'1',141000),(141030,'大宁县',NULL,'1',141000),(141031,'隰　

县',NULL,'1',141000),(141032,'永和县',NULL,'1',141000),(141033,'蒲　县',NULL,'1',141000),(141034,'汾西县',NULL,'1',141000),(141081,'侯马市',NULL,'1',141000),(141082,'霍州

市',NULL,'1',141000),(141100,'吕梁市',NULL,'0',140000),(141101,'市辖区',NULL,'1',141100),(141102,'离石区',NULL,'1',141100),(141121,'文水县',NULL,'1',141100),(141122,'交城

县',NULL,'1',141100),(141123,'兴　县',NULL,'1',141100),(141124,'临　县',NULL,'1',141100),(141125,'柳林县',NULL,'1',141100),(141126,'石楼县',NULL,'1',141100),(141127,'岚　

县',NULL,'1',141100),(141128,'方山县',NULL,'1',141100),(141129,'中阳县',NULL,'1',141100),(141130,'交口县',NULL,'1',141100),(141181,'孝义市',NULL,'1',141100),(141182,'汾阳

市',NULL,'1',141100),(150000,'内蒙古自治区',NULL,'0',NULL),(150100,'呼和浩特市',NULL,'0',150000),(150101,'市辖区',NULL,'1',150100),(150102,'新城区',NULL,'1',150100),(150103,'回

民区',NULL,'1',150100),(150104,'玉泉区',NULL,'1',150100),(150105,'赛罕区',NULL,'1',150100),(150121,'土默特左旗',NULL,'1',150100),(150122,'托克托县',NULL,'1',150100),(150123,'和

林格尔县',NULL,'1',150100),(150124,'清水河县',NULL,'1',150100),(150125,'武川县',NULL,'1',150100),(150200,'包头市',NULL,'0',150000),(150201,'市辖区',NULL,'1',150200),(150202,'东

河区',NULL,'1',150200),(150203,'昆都仑区',NULL,'1',150200),(150204,'青山区',NULL,'1',150200),(150205,'石拐区',NULL,'1',150200),(150206,'白云矿区',NULL,'1',150200),(150207,'九原

区',NULL,'1',150200),(150221,'土默特右旗',NULL,'1',150200),(150222,'固阳县',NULL,'1',150200),(150223,'达尔罕茂明安联合旗',NULL,'1',150200),(150300,'乌海市',NULL,'0',150000),

(150301,'市辖区',NULL,'1',150300),(150302,'海勃湾区',NULL,'1',150300),(150303,'海南区',NULL,'1',150300),(150304,'乌达区',NULL,'1',150300),(150400,'赤峰市',NULL,'0',150000),

(150401,'市辖区',NULL,'1',150400),(150402,'红山区',NULL,'1',150400),(150403,'元宝山区',NULL,'1',150400),(150404,'松山区',NULL,'1',150400),(150421,'阿鲁科尔沁

旗',NULL,'1',150400),(150422,'巴林左旗',NULL,'1',150400),(150423,'巴林右旗',NULL,'1',150400),(150424,'林西县',NULL,'1',150400),(150425,'克什克腾旗',NULL,'1',150400),(150426,'翁

牛特旗',NULL,'1',150400),(150428,'喀喇沁旗',NULL,'1',150400),(150429,'宁城县',NULL,'1',150400),(150430,'敖汉旗',NULL,'1',150400),(150500,'通辽市',NULL,'0',150000),(150501,'市辖

区',NULL,'1',150500),(150502,'科尔沁区',NULL,'1',150500),(150521,'科尔沁左翼中旗',NULL,'1',150500),(150522,'科尔沁左翼后旗',NULL,'1',150500),(150523,'开鲁县',NULL,'1',150500),

(150524,'库伦旗',NULL,'1',150500),(150525,'奈曼旗',NULL,'1',150500),(150526,'扎鲁特旗',NULL,'1',150500),(150581,'霍林郭勒市',NULL,'1',150500),(150600,'鄂尔多斯

市',NULL,'0',150000),(150602,'东胜区',NULL,'1',150600),(150621,'达拉特旗',NULL,'1',150600),(150622,'准格尔旗',NULL,'1',150600),(150623,'鄂托克前旗',NULL,'1',150600),(150624,'鄂

托克旗',NULL,'1',150600),(150625,'杭锦旗',NULL,'1',150600),(150626,'乌审旗',NULL,'1',150600),(150627,'伊金霍洛旗',NULL,'1',150600),(150700,'呼伦贝尔市',NULL,'0',150000),

(150701,'市辖区',NULL,'1',150700),(150702,'海拉尔区',NULL,'1',150700),(150721,'阿荣旗',NULL,'1',150700),(150722,'莫力达瓦达斡尔族自治旗',NULL,'1',150700),(150723,'鄂伦春自治

旗',NULL,'1',150700),(150724,'鄂温克族自治旗',NULL,'1',150700),(150725,'陈巴尔虎旗',NULL,'1',150700),(150726,'新巴尔虎左旗',NULL,'1',150700),(150727,'新巴尔虎右

旗',NULL,'1',150700),(150781,'满洲里市',NULL,'1',150700),(150782,'牙克石市',NULL,'1',150700),(150783,'扎兰屯市',NULL,'1',150700),(150784,'额尔古纳市',NULL,'1',150700),(150785,'

根河市',NULL,'1',150700),(150800,'巴彦淖尔市',NULL,'0',150000),(150801,'市辖区',NULL,'1',150800),(150802,'临河区',NULL,'1',150800),(150821,'五原县',NULL,'1',150800),(150822,'磴

口县',NULL,'1',150800),(150823,'乌拉特前旗',NULL,'1',150800),(150824,'乌拉特中旗',NULL,'1',150800),(150825,'乌拉特后旗',NULL,'1',150800),(150826,'杭锦后旗',NULL,'1',150800),

(150900,'乌兰察布市',NULL,'0',150000),(150901,'市辖区',NULL,'1',150900),(150902,'集宁区',NULL,'1',150900),(150921,'卓资县',NULL,'1',150900),(150922,'化德县',NULL,'1',150900),

(150923,'商都县',NULL,'1',150900),(150924,'兴和县',NULL,'1',150900),(150925,'凉城县',NULL,'1',150900),(150926,'察哈尔右翼前旗',NULL,'1',150900),(150927,'察哈尔右翼中

旗',NULL,'1',150900),(150928,'察哈尔右翼后旗',NULL,'1',150900),(150929,'四子王旗',NULL,'1',150900),(150981,'丰镇市',NULL,'1',150900),(152200,'兴安盟',NULL,'0',150000),(152201,'

乌兰浩特市',NULL,'1',152200),(152202,'阿尔山市',NULL,'1',152200),(152221,'科尔沁右翼前旗',NULL,'1',152200),(152222,'科尔沁右翼中旗',NULL,'1',152200),(152223,'扎赉特

旗',NULL,'1',152200),(152224,'突泉县',NULL,'1',152200),(152500,'锡林郭勒盟',NULL,'0',150000),(152501,'二连浩特市',NULL,'1',152500),(152502,'锡林浩特市',NULL,'1',152500),

(152522,'阿巴嘎旗',NULL,'1',152500),(152523,'苏尼特左旗',NULL,'1',152500),(152524,'苏尼特右旗',NULL,'1',152500),(152525,'东乌珠穆沁旗',NULL,'1',152500),(152526,'西乌珠穆沁

旗',NULL,'1',152500),(152527,'太仆寺旗',NULL,'1',152500),(152528,'镶黄旗',NULL,'1',152500),(152529,'正镶白旗',NULL,'1',152500),(152530,'正蓝旗',NULL,'1',152500),(152531,'多伦

县',NULL,'1',152500),(152900,'阿拉善盟',NULL,'0',150000),(152921,'阿拉善左旗',NULL,'1',152900),(152922,'阿拉善右旗',NULL,'1',152900),(152923,'额济纳旗',NULL,'1',152900),

(210000,'辽宁省',NULL,'0',NULL),(210100,'沈阳市',NULL,'0',210000),(210101,'市辖区',NULL,'1',210100),(210102,'和平区',NULL,'1',210100),(210103,'沈河区',NULL,'1',210100),(210104,'

大东区',NULL,'1',210100),(210105,'皇姑区',NULL,'1',210100),(210106,'铁西区',NULL,'1',210100),(210111,'苏家屯区',NULL,'1',210100),(210112,'东陵区',NULL,'1',210100),(210113,'新城

子区',NULL,'1',210100),(210114,'于洪区',NULL,'1',210100),(210122,'辽中县',NULL,'1',210100),(210123,'康平县',NULL,'1',210100),(210124,'法库县',NULL,'1',210100),(210181,'新民

市',NULL,'1',210100),(210200,'大连市',NULL,'0',210000),(210201,'市辖区',NULL,'1',210200),(210202,'中山区',NULL,'1',210200),(210203,'西岗区',NULL,'1',210200),(210204,'沙河口

区',NULL,'1',210200),(210211,'甘井子区',NULL,'1',210200),(210212,'旅顺口区',NULL,'1',210200),(210213,'金州区',NULL,'1',210200),(210224,'长海县',NULL,'1',210200),(210281,'瓦房店

市',NULL,'1',210200),(210282,'普兰店市',NULL,'1',210200),(210283,'庄河市',NULL,'1',210200),(210300,'鞍山市',NULL,'0',210000),(210301,'市辖区',NULL,'1',210300),(210302,'铁东

区',NULL,'1',210300),(210303,'铁西区',NULL,'1',210300),(210304,'立山区',NULL,'1',210300),(210311,'千山区',NULL,'1',210300),(210321,'台安县',NULL,'1',210300),(210323,'岫岩满族自

治县',NULL,'1',210300),(210381,'海城市',NULL,'1',210300),(210400,'抚顺市',NULL,'0',210000),(210401,'市辖区',NULL,'1',210400),(210402,'新抚区',NULL,'1',210400),(210403,'东洲

区',NULL,'1',210400),(210404,'望花区',NULL,'1',210400),(210411,'顺城区',NULL,'1',210400),(210421,'抚顺县',NULL,'1',210400),(210422,'新宾满族自治县',NULL,'1',210400),(210423,'清

原满族自治县',NULL,'1',210400),(210500,'本溪市',NULL,'0',210000),(210501,'市辖区',NULL,'1',210500),(210502,'平山区',NULL,'1',210500),(210503,'溪湖区',NULL,'1',210500),(210504,'

明山区',NULL,'1',210500),(210505,'南芬区',NULL,'1',210500),(210521,'本溪满族自治县',NULL,'1',210500),(210522,'桓仁满族自治县',NULL,'1',210500),(210600,'丹东

市',NULL,'0',210000),(210601,'市辖区',NULL,'1',210600),(210602,'元宝区',NULL,'1',210600),(210603,'振兴区',NULL,'1',210600),(210604,'振安区',NULL,'1',210600),(210624,'宽甸满族自

治县',NULL,'1',210600),(210681,'东港市',NULL,'1',210600),(210682,'凤城市',NULL,'1',210600),(210700,'锦州市',NULL,'0',210000),(210701,'市辖区',NULL,'1',210700),(210702,'古塔

区',NULL,'1',210700),(210703,'凌河区',NULL,'1',210700),(210711,'太和区',NULL,'1',210700),(210726,'黑山县',NULL,'1',210700),(210727,'义　县',NULL,'1',210700),(210781,'凌海

市',NULL,'1',210700),(210782,'北宁市',NULL,'1',210700),(210800,'营口市',NULL,'0',210000),(210801,'市辖区',NULL,'1',210800),(210802,'站前区',NULL,'1',210800),(210803,'西市

区',NULL,'1',210800),(210804,'鲅鱼圈区',NULL,'1',210800),(210811,'老边区',NULL,'1',210800),(210881,'盖州市',NULL,'1',210800),(210882,'大石桥市',NULL,'1',210800),(210900,'阜新

市',NULL,'0',210000),(210901,'市辖区',NULL,'1',210900),(210902,'海州区',NULL,'1',210900),(210903,'新邱区',NULL,'1',210900),(210904,'太平区',NULL,'1',210900),(210905,'清河门

区',NULL,'1',210900),(210911,'细河区',NULL,'1',210900),(210921,'阜新蒙古族自治县',NULL,'1',210900),(210922,'彰武县',NULL,'1',210900),(211000,'辽阳市',NULL,'0',210000),(211001,'

市辖区',NULL,'1',211000),(211002,'白塔区',NULL,'1',211000),(211003,'文圣区',NULL,'1',211000),(211004,'宏伟区',NULL,'1',211000),(211005,'弓长岭区',NULL,'1',211000),(211011,'太子

河区',NULL,'1',211000),(211021,'辽阳县',NULL,'1',211000),(211081,'灯塔市',NULL,'1',211000),(211100,'盘锦市',NULL,'0',210000),(211101,'市辖区',NULL,'1',211100),(211102,'双台子

区',NULL,'1',211100),(211103,'兴隆台区',NULL,'1',211100),(211121,'大洼县',NULL,'1',211100),(211122,'盘山县',NULL,'1',211100),(211200,'铁岭市',NULL,'0',210000),(211201,'市辖

区',NULL,'1',211200),(211202,'银州区',NULL,'1',211200),(211204,'清河区',NULL,'1',211200),(211221,'铁岭县',NULL,'1',211200),(211223,'西丰县',NULL,'1',211200),(211224,'昌图

县',NULL,'1',211200),(211281,'调兵山市',NULL,'1',211200),(211282,'开原市',NULL,'1',211200),(211300,'朝阳市',NULL,'0',210000),(211301,'市辖区',NULL,'1',211300),(211302,'双塔

区',NULL,'1',211300),(211303,'龙城区',NULL,'1',211300),(211321,'朝阳县',NULL,'1',211300),(211322,'建平县',NULL,'1',211300),(211324,'喀喇沁左翼蒙古族自治县',NULL,'1',211300),

(211381,'北票市',NULL,'1',211300),(211382,'凌源市',NULL,'1',211300),(211400,'葫芦岛市',NULL,'0',210000),(211401,'市辖区',NULL,'1',211400),(211402,'连山区',NULL,'1',211400),

(211403,'龙港区',NULL,'1',211400),(211404,'南票区',NULL,'1',211400),(211421,'绥中县',NULL,'1',211400),(211422,'建昌县',NULL,'1',211400),(211481,'兴城市',NULL,'1',211400),

(220000,'吉林省',NULL,'0',NULL),(220100,'长春市',NULL,'0',220000),(220101,'市辖区',NULL,'1',220100),(220102,'南关区',NULL,'1',220100),(220103,'宽城区',NULL,'1',220100),(220104,'

朝阳区',NULL,'1',220100),(220105,'二道区',NULL,'1',220100),(220106,'绿园区',NULL,'1',220100),(220112,'双阳区',NULL,'1',220100),(220122,'农安县',NULL,'1',220100),(220181,'九台

市',NULL,'1',220100),(220182,'榆树市',NULL,'1',220100),(220183,'德惠市',NULL,'1',220100),(220200,'吉林市',NULL,'0',220000),(220201,'市辖区',NULL,'1',220200),(220202,'昌邑

区',NULL,'1',220200),(220203,'龙潭区',NULL,'1',220200),(220204,'船营区',NULL,'1',220200),(220211,'丰满区',NULL,'1',220200),(220221,'永吉县',NULL,'1',220200),(220281,'蛟河