cities.sql

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

drop database if exists bank;
create database bank;
use bank;

DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `url` varchar(50) default NULL,
  `leaf` char(1) default NULL,
  `parentId` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `parentId` (`parentId`),
  CONSTRAINT `cities_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `cities` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=820001 DEFAULT CHARSET=gbk;

INSERT INTO `cities` VALUES (110000,'北京市',NULL,'0',NULL),(110100,'市辖区',NULL,'0',110000),(110101,'东城区',NULL,'1',110100),(110102,'西城区',NULL,'1',110100),(110103,'崇文区

',NULL,'1',110100),(110104,'宣武区',NULL,'1',110100),(110105,'朝阳区',NULL,'1',110100),(110106,'丰台区',NULL,'1',110100),(110107,'石景山区',NULL,'1',110100),(110108,'海淀

区',NULL,'1',110100),(110109,'门头沟区',NULL,'1',110100),(110111,'房山区',NULL,'1',110100),(110112,'通州区',NULL,'1',110100),(110113,'顺义区',NULL,'1',110100),(110114,'昌平

区',NULL,'1',110100),(110115,'大兴区',NULL,'1',110100),(110116,'怀柔区',NULL,'1',110100),(110117,'平谷区',NULL,'1',110100),(110200,'县',NULL,'0',110000),(110228,'密云

县',NULL,'1',110200),(110229,'延庆县',NULL,'1',110200),(120000,'天津市',NULL,'0',NULL),(120100,'市辖区',NULL,'0',120000),(120101,'和平区',NULL,'1',120100),(120102,'河东

区',NULL,'1',120100),(120103,'河西区',NULL,'1',120100),(120104,'南开区',NULL,'1',120100),(120105,'河北区',NULL,'1',120100),(120106,'红桥区',NULL,'1',120100),(120107,'塘沽

区',NULL,'1',120100),(120108,'汉沽区',NULL,'1',120100),(120109,'大港区',NULL,'1',120100),(120110,'东丽区',NULL,'1',120100),(120111,'西青区',NULL,'1',120100),(120112,'津南

区',NULL,'1',120100),(120113,'北辰区',NULL,'1',120100),(120114,'武清区',NULL,'1',120100),(120115,'宝坻区',NULL,'1',120100),(120200,'县',NULL,'0',120000),(120221,'宁河

县',NULL,'1',120200),(120223,'静海县',NULL,'1',120200),(120225,'蓟　县',NULL,'1',120200),(130000,'河北省',NULL,'0',NULL),(130100,'石家庄市',NULL,'0',130000),(130101,'市辖

区',NULL,'1',130100),(130102,'长安区',NULL,'1',130100),(130103,'桥东区',NULL,'1',130100),(130104,'桥西区',NULL,'1',130100),(130105,'新华区',NULL,'1',130100),(130107,'井陉矿

区',NULL,'1',130100),(130108,'裕华区',NULL,'1',130100),(130121,'井陉县',NULL,'1',130100),(130123,'正定县',NULL,'1',130100),(130124,'栾城县',NULL,'1',130100),(130125,'行唐

县',NULL,'1',130100),(130126,'灵寿县',NULL,'1',130100),(130127,'高邑县',NULL,'1',130100),(130128,'深泽县',NULL,'1',130100),(130129,'赞皇县',NULL,'1',130100),(130130,'无极

县',NULL,'1',130100),(130131,'平山县',NULL,'1',130100),(130132,'元氏县',NULL,'1',130100),(130133,'赵　县',NULL,'1',130100),(130181,'辛集市',NULL,'1',130100),(130182,'藁城

市',NULL,'1',130100),(130183,'晋州市',NULL,'1',130100),(130184,'新乐市',NULL,'1',130100),(130185,'鹿泉市',NULL,'1',130100),(130200,'唐山市',NULL,'0',130000),(130201,'市辖

区',NULL,'1',130200),(130202,'路南区',NULL,'1',130200),(130203,'路北区',NULL,'1',130200),(130204,'古冶区',NULL,'1',130200),(130205,'开平区',NULL,'1',130200),(130207,'丰南

区',NULL,'1',130200),(130208,'丰润区',NULL,'1',130200),(130223,'滦　县',NULL,'1',130200),(130224,'滦南县',NULL,'1',130200),(130225,'乐亭县',NULL,'1',130200),(130227,'迁西

县',NULL,'1',130200),(130229,'玉田县',NULL,'1',130200),(130230,'唐海县',NULL,'1',130200),(130281,'遵化市',NULL,'1',130200),(130283,'迁安市',NULL,'1',130200),(130300,'秦皇岛

市',NULL,'0',130000),(130301,'市辖区',NULL,'1',130300),(130302,'海港区',NULL,'1',130300),(130303,'山海关区',NULL,'1',130300),(130304,'北戴河区',NULL,'1',130300),(130321,'青龙满

族自治县',NULL,'1',130300),(130322,'昌黎县',NULL,'1',130300),(130323,'抚宁县',NULL,'1',130300),(130324,'卢龙县',NULL,'1',130300),(130400,'邯郸市',NULL,'0',130000),(130401,'市辖

区',NULL,'1',130400),(130402,'邯山区',NULL,'1',130400),(130403,'丛台区',NULL,'1',130400),(130404,'复兴区',NULL,'1',130400),(130406,'峰峰矿区',NULL,'1',130400),(130421,'邯郸

县',NULL,'1',130400),(130423,'临漳县',NULL,'1',130400),(130424,'成安县',NULL,'1',130400),(130425,'大名县',NULL,'1',130400),(130426,'涉　县',NULL,'1',130400),(130427,'磁　

县',NULL,'1',130400),(130428,'肥乡县',NULL,'1',130400),(130429,'永年县',NULL,'1',130400),(130430,'邱　县',NULL,'1',130400),(130431,'鸡泽县',NULL,'1',130400),(130432,'广平

县',NULL,'1',130400),(130433,'馆陶县',NULL,'1',130400),(130434,'魏　县',NULL,'1',130400),(130435,'曲周县',NULL,'1',130400),(130481,'武安市',NULL,'1',130400),(130500,'邢台

市',NULL,'0',130000),(130501,'市辖区',NULL,'1',130500),(130502,'桥东区',NULL,'1',130500),(130503,'桥西区',NULL,'1',130500),(130521,'邢台县',NULL,'1',130500),(130522,'临城

县',NULL,'1',130500),(130523,'内丘县',NULL,'1',130500),(130524,'柏乡县',NULL,'1',130500),(130525,'隆尧县',NULL,'1',130500),(130526,'任　县',NULL,'1',130500),(130527,'南和

县',NULL,'1',130500),(130528,'宁晋县',NULL,'1',130500),(130529,'巨鹿县',NULL,'1',130500),(130530,'新河县',NULL,'1',130500),(130531,'广宗县',NULL,'1',130500),(130532,'平乡

县',NULL,'1',130500),(130533,'威　县',NULL,'1',130500),(130534,'清河县',NULL,'1',130500),(130535,'临西县',NULL,'1',130500),(130581,'南宫市',NULL,'1',130500),(130582,'沙河

市',NULL,'1',130500),(130600,'保定市',NULL,'0',130000),(130601,'市辖区',NULL,'1',130600),(130602,'新市区',NULL,'1',130600),(130603,'北市区',NULL,'1',130600),(130604,'南市

区',NULL,'1',130600),(130621,'满城县',NULL,'1',130600),(130622,'清苑县',NULL,'1',130600),(130623,'涞水县',NULL,'1',130600),(130624,'阜平县',NULL,'1',130600),(130625,'徐水

县',NULL,'1',130600),(130626,'定兴县',NULL,'1',130600),(130627,'唐　县',NULL,'1',130600),(130628,'高阳县',NULL,'1',130600),(130629,'容城县',NULL,'1',130600),(130630,'涞源

县',NULL,'1',130600),(130631,'望都县',NULL,'1',130600),(130632,'安新县',NULL,'1',130600),(130633,'易　县',NULL,'1',130600),(130634,'曲阳县',NULL,'1',130600),(130635,'蠡　

县',NULL,'1',130600),(130636,'顺平县',NULL,'1',130600),(130637,'博野县',NULL,'1',130600),(130638,'雄　县',NULL,'1',130600),(130681,'涿州市',NULL,'1',130600),(130682,'定州

市',NULL,'1',130600),(130683,'安国市',NULL,'1',130600),(130684,'高碑店市',NULL,'1',130600),(130700,'张家口市',NULL,'0',130000),(130701,'市辖区',NULL,'1',130700),(130702,'桥东

区',NULL,'1',130700),(130703,'桥西区',NULL,'1',130700),(130705,'宣化区',NULL,'1',130700),(130706,'下花园区',NULL,'1',130700),(130721,'宣化县',NULL,'1',130700),(130722,'张北

县',NULL,'1',130700),(130723,'康保县',NULL,'1',130700),(130724,'沽源县',NULL,'1',130700),(130725,'尚义县',NULL,'1',130700),(130726,'蔚　县',NULL,'1',130700),(130727,'阳原

县',NULL,'1',130700),(130728,'怀安县',NULL,'1',130700),(130729,'万全县',NULL,'1',130700),(130730,'怀来县',NULL,'1',130700),(130731,'涿鹿县',NULL,'1',130700),(130732,'赤城

县',NULL,'1',130700),(130733,'崇礼县',NULL,'1',130700),(130800,'承德市',NULL,'0',130000),(130801,'市辖区',NULL,'1',130800),(130802,'双桥区',NULL,'1',130800),(130803,'双滦

区',NULL,'1',130800),(130804,'鹰手营子矿区',NULL,'1',130800),(130821,'承德县',NULL,'1',130800),(130822,'兴隆县',NULL,'1',130800),(130823,'平泉县',NULL,'1',130800),(130824,'滦平

县',NULL,'1',130800),(130825,'隆化县',NULL,'1',130800),(130826,'丰宁满族自治县',NULL,'1',130800),(130827,'宽城满族自治县',NULL,'1',130800),(130828,'围场满族蒙古族自治

县',NULL,'1',130800),(130900,'沧州市',NULL,'0',130000),(130901,'市辖区',NULL,'1',130900),(130902,'新华区',NULL,'1',130900),(130903,'运河区',NULL,'1',130900),(130921,'沧　

县',NULL,'1',130900),(130922,'青　县',NULL,'1',130900),(130923,'东光县',NULL,'1',130900),(130924,'海兴县',NULL,'1',130900),(130925,'盐山县',NULL,'1',130900),(130926,'肃宁

县',NULL,'1',130900),(130927,'南皮县',NULL,'1',130900),(130928,'吴桥县',NULL,'1',130900),(130929,'献　县',NULL,'1',130900),(130930,'孟村回族自治县',NULL,'1',130900),(130981,'泊

头市',NULL,'1',130900),(130982,'任丘市',NULL,'1',130900),(130983,'黄骅市',NULL,'1',130900),(130984,'河间市',NULL,'1',130900),(131000,'廊坊市',NULL,'0',130000),(131001,'市辖

区',NULL,'1',131000),(131002,'安次区',NULL,'1',131000),(131003,'广阳区',NULL,'1',131000),(131022,'固安县',NULL,'1',131000),(131023,'永清县',NULL,'1',131000),(131024,'香河

县',NULL,'1',131000),(131025,'大城县',NULL,'1',131000),(131026,'文安县',NULL,'1',131000),(131028,'大厂回族自治县',NULL,'1',131000),(131081,'霸州市',NULL,'1',131000),(131082,'三

河市',NULL,'1',131000),(131100,'衡水市',NULL,'0',130000),(131101,'市辖区',NULL,'1',131100),(131102,'桃城区',NULL,'1',131100),(131121,'枣强县',NULL,'1',131100),(131122,'武邑

县',NULL,'1',131100),(131123,'武强县',NULL,'1',131100),(131124,'饶阳县',NULL,'1',131100),(131125,'安平县',NULL,'1',131100),(131126,'故城县',NULL,'1',131100),(131127,'景　

县',NULL,'1',131100),(131128,'阜城县',NULL,'1',131100),(131181,'冀州市',NULL,'1',131100),(131182,'深州市',NULL,'1',131100),(140000,'山西省',NULL,'0',NULL),(140100,'太原

市',NULL,'0',140000),(140101,'市辖区',NULL,'1',140100),(140105,'小店区',NULL,'1',140100),(140106,'迎泽区',NULL,'1',140100),(140107,'杏花岭区',NULL,'1',140100),(140108,'尖草坪

区',NULL,'1',140100),(140109,'万柏林区',NULL,'1',140100),(140110,'晋源区',NULL,'1',140100),(140121,'清徐县',NULL,'1',140100),(140122,'阳曲县',NULL,'1',140100),(140123,'娄烦

县',NULL,'1',140100),(140181,'古交市',NULL,'1',140100),(140200,'大同市',NULL,'0',140000),(140201,'市辖区',NULL,'1',140200),(140202,'城　区',NULL,'1',140200),(140203,'矿　

区',NULL,'1',140200),(140211,'南郊区',NULL,'1',140200),(140212,'新荣区',NULL,'1',140200),(140221,'阳高县',NULL,'1',140200),(140222,'天镇县',NULL,'1',140200),(140223,'广灵

县',NULL,'1',140200),(140224,'灵丘县',NULL,'1',140200),(140225,'浑源县',NULL,'1',140200),(140226,'左云县',NULL,'1',140200),(140227,'大同县',NULL,'1',140200),(140300,'阳泉

市',NULL,'0',140000),(140301,'市辖区',NULL,'1',140300),(140302,'城　区',NULL,'1',140300),(140303,'矿　区',NULL,'1',140300),(140311,'郊　区',NULL,'1',140300),(140321,'平定

县',NULL,'1',140300),(140322,'盂　县',NULL,'1',140300),(140400,'长治市',NULL,'0',140000),(140401,'市辖区',NULL,'1',140400),(140402,'城　区',NULL,'1',140400),(140411,'郊　

区',NULL,'1',140400),(140421,'长治县',NULL,'1',140400),(140423,'襄垣县',NULL,'1',140400),(140424,'屯留县',NULL,'1',140400),(140425,'平顺县',NULL,'1',140400),(140426,'黎城

县',NULL,'1',140400),(140427,'壶关县',NULL,'1',140400),(140428,'长子县',NULL,'1',140400),(140429,'武乡县',NULL,'1',140400),(140430,'沁　县',NULL,'1',140400),(140431,'沁源

县',NULL,'1',140400),(140481,'潞城市',NULL,'1',140400),(140500,'晋城市',NULL,'0',140000),(140501,'市辖区',NULL,'1',140500),(140502,'城　区',NULL,'1',140500),(140521,'沁水

县',NULL,'1',140500),(140522,'阳城县',NULL,'1',140500),(140524,'陵川县',NULL,'1',140500),(140525,'泽州县',NULL,'1',140500),(140581,'高平市',NULL,'1',140500),(140600,'朔州

市',NULL,'0',140000),(140601,'市辖区',NULL,'1',140600),(140602,'朔城区',NULL,'1',140600),(140603,'平鲁区',NULL,'1',140600),(140621,'山阴县',NULL,'1',140600),(140622,'应　

县',NULL,'1',140600),(140623,'右玉县',NULL,'1',140600),(140624,'怀仁县',NULL,'1',140600),(140700,'晋中市',NULL,'0',140000),(140701,'市辖区',NULL,'1',140700),(140702,'榆次

区',NULL,'1',140700),(140721,'榆社县',NULL,'1',140700),(140722,'左权县',NULL,'1',140700),(140723,'和顺县',NULL,'1',140700),(140724,'昔阳县',NULL,'1',140700),(140725,'寿阳