全国省市县区三级联动数据
全国省、市县、区三级联动数据
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('110000', '北京市');
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('120000', '天津市');
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('130000', '河北省');
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('140000', '山西省');
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('150000', '内蒙古自治区');
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('210000', '辽宁省');
INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('220000', '吉林省');
------------------------------------------------------
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('110100', '110000', '区');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('110200', '110000', '县');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('120100', '120000', '区');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('120200', '120000', '县');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130100', '130000', '石家庄市');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130200', '130000', '唐山市');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130300', '130000', '秦皇岛市');
INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130400', '130000', '邯郸市');
------------------------------------------------
INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110103', '110100', '崇文区');
INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110104', '110100', '宣武区');
INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110105', '110100', '朝阳区');
INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110106', '110100', '丰台区');
INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110107', '110100', '石景山区');
INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110108', '110100', '海淀区');
身份证归属地数据(sql文件)
INSERT INTO area_code_info VALUES('110100','北京市市辖区')
INSERT INTO area_code_info VALUES('110101','北京市东城区')
INSERT INTO area_code_info VALUES('110102','北京市西城区')
INSERT INTO area_code_info VALUES('110103','北京市崇文区')
INSERT INTO area_code_info VALUES('110104','北京市宣武区')
INSERT INTO area_code_info VALUES('110105','北京市朝阳区')
INSERT INTO area_code_info VALUES('110106','北京市丰台区')
INSERT INTO area_code_info VALUES('110107','北京市石景山区')
INSERT INTO area_code_info VALUES('110108','北京市海淀区')
INSERT INTO area_code_info VALUES('110109','北京市门头沟区')
INSERT INTO area_code_info VALUES('110111','北京市房山区')
INSERT INTO area_code_info VALUES('110112','北京市通州区')
INSERT INTO area_code_info VALUES('110113','北京市顺义区')
……………………
JCreator3.5.01
简洁的JAVA编程工具!内含注册码!专业版是一款适合于各个 Java 语言编程开发人员的IDE工具。