cities.sql

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

市',NULL,'1',220200),(220282,'桦甸市',NULL,'1',220200),(220283,'舒兰市',NULL,'1',220200),(220284,'磐石市',NULL,'1',220200),(220300,'四平市',NULL,'0',220000),(220301,'市辖

区',NULL,'1',220300),(220302,'铁西区',NULL,'1',220300),(220303,'铁东区',NULL,'1',220300),(220322,'梨树县',NULL,'1',220300),(220323,'伊通满族自治县',NULL,'1',220300),(220381,'公

主岭市',NULL,'1',220300),(220382,'双辽市',NULL,'1',220300),(220400,'辽源市',NULL,'0',220000),(220401,'市辖区',NULL,'1',220400),(220402,'龙山区',NULL,'1',220400),(220403,'西安

区',NULL,'1',220400),(220421,'东丰县',NULL,'1',220400),(220422,'东辽县',NULL,'1',220400),(220500,'通化市',NULL,'0',220000),(220501,'市辖区',NULL,'1',220500),(220502,'东昌

区',NULL,'1',220500),(220503,'二道江区',NULL,'1',220500),(220521,'通化县',NULL,'1',220500),(220523,'辉南县',NULL,'1',220500),(220524,'柳河县',NULL,'1',220500),(220581,'梅河口

市',NULL,'1',220500),(220582,'集安市',NULL,'1',220500),(220600,'白山市',NULL,'0',220000),(220601,'市辖区',NULL,'1',220600),(220602,'八道江区',NULL,'1',220600),(220621,'抚松

县',NULL,'1',220600),(220622,'靖宇县',NULL,'1',220600),(220623,'长白朝鲜族自治县',NULL,'1',220600),(220625,'江源县',NULL,'1',220600),(220681,'临江市',NULL,'1',220600),(220700,'

松原市',NULL,'0',220000),(220701,'市辖区',NULL,'1',220700),(220702,'宁江区',NULL,'1',220700),(220721,'前郭尔罗斯蒙古族自治县',NULL,'1',220700),(220722,'长岭

县',NULL,'1',220700),(220723,'乾安县',NULL,'1',220700),(220724,'扶余县',NULL,'1',220700),(220800,'白城市',NULL,'0',220000),(220801,'市辖区',NULL,'1',220800),(220802,'洮北

区',NULL,'1',220800),(220821,'镇赉县',NULL,'1',220800),(220822,'通榆县',NULL,'1',220800),(220881,'洮南市',NULL,'1',220800),(220882,'大安市',NULL,'1',220800),(222400,'延边朝鲜族

自治州',NULL,'0',220000),(222401,'延吉市',NULL,'1',222400),(222402,'图们市',NULL,'1',222400),(222403,'敦化市',NULL,'1',222400),(222404,'珲春市',NULL,'1',222400),(222405,'龙井

市',NULL,'1',222400),(222406,'和龙市',NULL,'1',222400),(222424,'汪清县',NULL,'1',222400),(222426,'安图县',NULL,'1',222400),(230000,'黑龙江省',NULL,'0',NULL),(230100,'哈尔滨

市',NULL,'0',230000),(230101,'市辖区',NULL,'1',230100),(230102,'道里区',NULL,'1',230100),(230103,'南岗区',NULL,'1',230100),(230104,'道外区',NULL,'1',230100),(230106,'香坊

区',NULL,'1',230100),(230107,'动力区',NULL,'1',230100),(230108,'平房区',NULL,'1',230100),(230109,'松北区',NULL,'1',230100),(230111,'呼兰区',NULL,'1',230100),(230123,'依兰

县',NULL,'1',230100),(230124,'方正县',NULL,'1',230100),(230125,'宾　县',NULL,'1',230100),(230126,'巴彦县',NULL,'1',230100),(230127,'木兰县',NULL,'1',230100),(230128,'通河

县',NULL,'1',230100),(230129,'延寿县',NULL,'1',230100),(230181,'阿城市',NULL,'1',230100),(230182,'双城市',NULL,'1',230100),(230183,'尚志市',NULL,'1',230100),(230184,'五常

市',NULL,'1',230100),(230200,'齐齐哈尔市',NULL,'0',230000),(230201,'市辖区',NULL,'1',230200),(230202,'龙沙区',NULL,'1',230200),(230203,'建华区',NULL,'1',230200),(230204,'铁锋

区',NULL,'1',230200),(230205,'昂昂溪区',NULL,'1',230200),(230206,'富拉尔基区',NULL,'1',230200),(230207,'碾子山区',NULL,'1',230200),(230208,'梅里斯达斡尔族区',NULL,'1',230200),

(230221,'龙江县',NULL,'1',230200),(230223,'依安县',NULL,'1',230200),(230224,'泰来县',NULL,'1',230200),(230225,'甘南县',NULL,'1',230200),(230227,'富裕县',NULL,'1',230200),

(230229,'克山县',NULL,'1',230200),(230230,'克东县',NULL,'1',230200),(230231,'拜泉县',NULL,'1',230200),(230281,'讷河市',NULL,'1',230200),(230300,'鸡西市',NULL,'0',230000),

(230301,'市辖区',NULL,'1',230300),(230302,'鸡冠区',NULL,'1',230300),(230303,'恒山区',NULL,'1',230300),(230304,'滴道区',NULL,'1',230300),(230305,'梨树区',NULL,'1',230300),

(230306,'城子河区',NULL,'1',230300),(230307,'麻山区',NULL,'1',230300),(230321,'鸡东县',NULL,'1',230300),(230381,'虎林市',NULL,'1',230300),(230382,'密山市',NULL,'1',230300),

(230400,'鹤岗市',NULL,'0',230000),(230401,'市辖区',NULL,'1',230400),(230402,'向阳区',NULL,'1',230400),(230403,'工农区',NULL,'1',230400),(230404,'南山区',NULL,'1',230400),

(230405,'兴安区',NULL,'1',230400),(230406,'东山区',NULL,'1',230400),(230407,'兴山区',NULL,'1',230400),(230421,'萝北县',NULL,'1',230400),(230422,'绥滨县',NULL,'1',230400),

(230500,'双鸭山市',NULL,'0',230000),(230501,'市辖区',NULL,'1',230500),(230502,'尖山区',NULL,'1',230500),(230503,'岭东区',NULL,'1',230500),(230505,'四方台区',NULL,'1',230500),

(230506,'宝山区',NULL,'1',230500),(230521,'集贤县',NULL,'1',230500),(230522,'友谊县',NULL,'1',230500),(230523,'宝清县',NULL,'1',230500),(230524,'饶河县',NULL,'1',230500),

(230600,'大庆市',NULL,'0',230000),(230601,'市辖区',NULL,'1',230600),(230602,'萨尔图区',NULL,'1',230600),(230603,'龙凤区',NULL,'1',230600),(230604,'让胡路区',NULL,'1',230600),

(230605,'红岗区',NULL,'1',230600),(230606,'大同区',NULL,'1',230600),(230621,'肇州县',NULL,'1',230600),(230622,'肇源县',NULL,'1',230600),(230623,'林甸县',NULL,'1',230600),

(230624,'杜尔伯特蒙古族自治县',NULL,'1',230600),(230700,'伊春市',NULL,'0',230000),(230701,'市辖区',NULL,'1',230700),(230702,'伊春区',NULL,'1',230700),(230703,'南岔

区',NULL,'1',230700),(230704,'友好区',NULL,'1',230700),(230705,'西林区',NULL,'1',230700),(230706,'翠峦区',NULL,'1',230700),(230707,'新青区',NULL,'1',230700),(230708,'美溪

区',NULL,'1',230700),(230709,'金山屯区',NULL,'1',230700),(230710,'五营区',NULL,'1',230700),(230711,'乌马河区',NULL,'1',230700),(230712,'汤旺河区',NULL,'1',230700),(230713,'带岭

区',NULL,'1',230700),(230714,'乌伊岭区',NULL,'1',230700),(230715,'红星区',NULL,'1',230700),(230716,'上甘岭区',NULL,'1',230700),(230722,'嘉荫县',NULL,'1',230700),(230781,'铁力

市',NULL,'1',230700),(230800,'佳木斯市',NULL,'0',230000),(230801,'市辖区',NULL,'1',230800),(230802,'永红区',NULL,'1',230800),(230803,'向阳区',NULL,'1',230800),(230804,'前进

区',NULL,'1',230800),(230805,'东风区',NULL,'1',230800),(230811,'郊　区',NULL,'1',230800),(230822,'桦南县',NULL,'1',230800),(230826,'桦川县',NULL,'1',230800),(230828,'汤原

县',NULL,'1',230800),(230833,'抚远县',NULL,'1',230800),(230881,'同江市',NULL,'1',230800),(230882,'富锦市',NULL,'1',230800),(230900,'七台河市',NULL,'0',230000),(230901,'市辖

区',NULL,'1',230900),(230902,'新兴区',NULL,'1',230900),(230903,'桃山区',NULL,'1',230900),(230904,'茄子河区',NULL,'1',230900),(230921,'勃利县',NULL,'1',230900),(231000,'牡丹江

市',NULL,'0',230000),(231001,'市辖区',NULL,'1',231000),(231002,'东安区',NULL,'1',231000),(231003,'阳明区',NULL,'1',231000),(231004,'爱民区',NULL,'1',231000),(231005,'西安

区',NULL,'1',231000),(231024,'东宁县',NULL,'1',231000),(231025,'林口县',NULL,'1',231000),(231081,'绥芬河市',NULL,'1',231000),(231083,'海林市',NULL,'1',231000),(231084,'宁安

市',NULL,'1',231000),(231085,'穆棱市',NULL,'1',231000),(231100,'黑河市',NULL,'0',230000),(231101,'市辖区',NULL,'1',231100),(231102,'爱辉区',NULL,'1',231100),(231121,'嫩江

县',NULL,'1',231100),(231123,'逊克县',NULL,'1',231100),(231124,'孙吴县',NULL,'1',231100),(231181,'北安市',NULL,'1',231100),(231182,'五大连池市',NULL,'1',231100),(231200,'绥化

市',NULL,'0',230000),(231201,'市辖区',NULL,'1',231200),(231202,'北林区',NULL,'1',231200),(231221,'望奎县',NULL,'1',231200),(231222,'兰西县',NULL,'1',231200),(231223,'青冈

县',NULL,'1',231200),(231224,'庆安县',NULL,'1',231200),(231225,'明水县',NULL,'1',231200),(231226,'绥棱县',NULL,'1',231200),(231281,'安达市',NULL,'1',231200),(231282,'肇东

市',NULL,'1',231200),(231283,'海伦市',NULL,'1',231200),(232700,'大兴安岭地区',NULL,'0',230000),(232721,'呼玛县',NULL,'1',232700),(232722,'塔河县',NULL,'1',232700),(232723,'漠河

县',NULL,'1',232700),(310000,'上海市',NULL,'0',NULL),(310100,'市辖区',NULL,'0',310000),(310101,'黄浦区',NULL,'1',310100),(310103,'卢湾区',NULL,'1',310100),(310104,'徐汇

区',NULL,'1',310100),(310105,'长宁区',NULL,'1',310100),(310106,'静安区',NULL,'1',310100),(310107,'普陀区',NULL,'1',310100),(310108,'闸北区',NULL,'1',310100),(310109,'虹口

区',NULL,'1',310100),(310110,'杨浦区',NULL,'1',310100),(310112,'闵行区',NULL,'1',310100),(310113,'宝山区',NULL,'1',310100),(310114,'嘉定区',NULL,'1',310100),(310115,'浦东新

区',NULL,'1',310100),(310116,'金山区',NULL,'1',310100),(310117,'松江区',NULL,'1',310100),(310118,'青浦区',NULL,'1',310100),(310119,'南汇区',NULL,'1',310100),(310120,'奉贤

区',NULL,'1',310100),(310200,'县',NULL,'0',310000),(310230,'崇明县',NULL,'1',310200),(320000,'江苏省',NULL,'0',NULL),(320100,'南京市',NULL,'0',320000),(320101,'市辖

区',NULL,'1',320100),(320102,'玄武区',NULL,'1',320100),(320103,'白下区',NULL,'1',320100),(320104,'秦淮区',NULL,'1',320100),(320105,'建邺区',NULL,'1',320100),(320106,'鼓楼

区',NULL,'1',320100),(320107,'下关区',NULL,'1',320100),(320111,'浦口区',NULL,'1',320100),(320113,'栖霞区',NULL,'1',320100),(320114,'雨花台区',NULL,'1',320100),(320115,'江宁

区',NULL,'1',320100),(320116,'六合区',NULL,'1',320100),(320124,'溧水县',NULL,'1',320100),(320125,'高淳县',NULL,'1',320100),(320200,'无锡市',NULL,'0',320000),(320201,'市辖

区',NULL,'1',320200),(320202,'崇安区',NULL,'1',320200),(320203,'南长区',NULL,'1',320200),(320204,'北塘区',NULL,'1',320200),(320205,'锡山区',NULL,'1',320200),(320206,'惠山

区',NULL,'1',320200),(320211,'滨湖区',NULL,'1',320200),(320281,'江阴市',NULL,'1',320200),(320282,'宜兴市',NULL,'1',320200),(320300,'徐州市',NULL,'0',320000),(320301,'市辖

区',NULL,'1',320300),(320302,'鼓楼区',NULL,'1',320300),(320303,'云龙区',NULL,'1',320300),(320304,'九里区',NULL,'1',320300),(320305,'贾汪区',NULL,'1',320300),(320311,'泉山

区',NULL,'1',320300),(320321,'丰　县',NULL,'1',320300),(320322,'沛　县',NULL,'1',320300),(320323,'铜山县',NULL,'1',320300),(320324,'睢宁县',NULL,'1',320300),(320381,'新沂

市',NULL,'1',320300),(320382,'邳州市',NULL,'1',320300),(320400,'常州市',NULL,'0',320000),(320401,'市辖区',NULL,'1',320400),(320402,'天宁区',NULL,'1',320400),(320404,'钟楼

区',NULL,'1',320400),(320405,'戚墅堰区',NULL,'1',320400),(320411,'新北区',NULL,'1',320400),(320412,'武进区',NULL,'1',320400),(320481,'溧阳市',NULL,'1',320400),(320482,'金坛

市',NULL,'1',320400),(320500,'苏州市',NULL,'0',320000),(320501,'市辖区',NULL,'1',320500),(320502,'沧浪区',NULL,'1',320500),(320503,'平江区',NULL,'1',320500),(320504,'金阊

区',NULL,'1',320500),(320505,'虎丘区',NULL,'1',320500),(320506,'吴中区',NULL,'1',320500),(320507,'相城区',NULL,'1',320500),(320581,'常熟市',NULL,'1',320500),(320582,'张家港

市',NULL,'1',320500),(320583,'昆山市',NULL,'1',320500),(320584,'吴江市',NULL,'1',320500),(320585,'太仓市',NULL,'1',320500),(320600,'南通市',NULL,'0',320000),(320601,'市辖

区',NULL,'1',320600),(320602,'崇川区',NULL,'1',320600),(320611,'港闸区',NULL,'1',320600),(320621,'海安县',NULL,'1',320600),(320623,'如东县',NULL,'1',320600),(320681,'启东

市',NULL,'1',320600),(320682,'如皋市',NULL,'1',320600),(320683,'通州市',NULL,'1',320600),(320684,'海门市',NULL,'1',320600),(320700,'连云港市',NULL,'0',320000),(320701,'市辖

区',NULL,'1',320700),(320703,'连云区',NULL,'1',320700),(320705,'新浦区',NULL,'1',320700),(320706,'海州区',NULL,'1',320700),(320721,'赣榆县',NULL,'1',320700),(320722,'东海

县',NULL,'1',320700),(320723,'灌云县',NULL,'1',320700),(320724,'灌南县',NULL,'1',320700),(320800,'淮安市',NULL,'0',320000),(320801,'市辖区',NULL,'1',320800),(320802,'清河

区',NULL,'1',320800),(320803,'楚州区',NULL,'1',320800),(320804,'淮阴区',NULL,'1',320800),(320811,'清浦区',NULL,'1',320800),(320826,'涟水县',NULL,'1',320800),(320829,'洪泽

县',NULL,'1',320800),(320830,'盱眙县',NULL,'1',320800),(320831,'金湖县',NULL,'1',320800),(320900,'盐城市',NULL,'0',320000),(320901,'市辖区',NULL,'1',320900),(320902,'亭湖

区',NULL,'1',320900),(320903,'盐都区',NULL,'1',320900),(320921,'响水县',NULL,'1',320900),(320922,'滨海县',NULL,'1',320900),(320923,'阜宁县',NULL,'1',320900),(320924,'射阳

县',NULL,'1',320900),(320925,'建湖县',NULL,'1',320900),(320981,'东台市',NULL,'1',320900),(320982,'大丰市',NULL,'1',320900),(321000,'扬州市',NULL,'0',320000),(321001,'市辖

区',NULL,'1',321000),(321002,'广陵区',NULL,'1',321000),(321003,'邗江区',NULL,'1',321000),(321011,'郊　区',NULL,'1',321000),(321023,'宝应县',NULL,'1',321000),(321081,'仪征

市',NULL,'1',321000),(321084,'高邮市',NULL,'1',321000),(321088,'江都市',NULL,'1',321000),(321100,'镇江市',NULL,'0',320000),(321101,'市辖区',NULL,'1',321100),(321102,'京口