icyheart
- 浏览: 779563 次
- 性别:
- 来自: 北京
-
文章分类
- 全部博客 (258)
- J2SE (18)
- J2EE (33)
- AJAX (4)
- JQuery (1)
- DWR (3)
- Linux/Unix (32)
- PHP (1)
- JSF (8)
- Oracle (34)
- JavaScript (17)
- 批处理 (13)
- ASP (7)
- VBScript (3)
- SqlServer (9)
- Ant (1)
- JDBC (1)
- XML (0)
- MySql (0)
- hibernate (9)
- windows (6)
- .net (0)
- 测试 (2)
- 汇编 (2)
- 网络 (13)
- 其它 (11)
- IDE工具 (6)
- freemarker (4)
- 存储过程 (1)
- 生活 (9)
- python (11)
最新评论
-
d99520y：
hdd unlock我这直接提示can't open driv ...
用PC3000和HDD Unlock解笔记本硬盘密码 -
javaersu：
几个学习Shell的不错网站：shell为您提供了对UNIX系 ...
shell脚本实例 -
zh89233：
一段恶意脚本的分析及思考 -
tiancaicao：
hdd unlock老要联网，一联网就说我这破解不了，让我付费 ...
用PC3000和HDD Unlock解笔记本硬盘密码 -
pythoner126com：
不错，学习了，跟这个作者写的有点像，http://www.yi ...
python对文件进行读写操作
创建表
create table Zone ( ZoneId int not null, Nm varchar(128) null, ParentId int null, constraint PK_ZONE primary key (ZoneId) )
sqlserver数据库的插入
INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(1, '北京', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(2, '上海', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(3, '天津', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(4, '重庆', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(5, '广东', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(6, '广西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(7, '湖北', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(8, '湖南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(9, '山东', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(10, '山西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(11, '河北', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(12, '河南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(13, '四川', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(14, '浙江', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(15, '江苏', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(16, '福建', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(17, '江西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(18, '安徽', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(19, '海南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(20, '云南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(21, '青海', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(22, '陕西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(23, '甘肃', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(24, '贵州', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(25, '宁夏', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(26, '黑龙江', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(27, '吉林', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(28, '辽宁', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(29, '西藏', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(30, '***', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(31, '内蒙古', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(32, '香港', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(33, '澳门', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(34, '台湾', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(100, '北京', 1);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(101, '上海', 2);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(102, '天津', 3);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(103, '重庆', 4);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(104, '广州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(105, '深圳', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(106, '珠海', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(107, '汕头', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(108, '韶关', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(109, '佛山', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(110, '江门', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(111, '湛江', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(112, '茂名', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(113, '肇庆', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(114, '惠州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(115, '梅州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(116, '汕尾', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(117, '河源', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(118, '阳江', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(119, '清远', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(120, '东莞', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(121, '中山', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(122, '潮州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(123, '揭阳', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(124, '云浮', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(125, '南宁', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(126, '柳州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(127, '桂林', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(128, '梧州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(129, '北海', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(130, '防城港', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(131, '钦州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(132, '贵港', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(133, '玉林', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(134, '百色', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(135, '贺州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(136, '河池', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(137, '来宾', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(138, '崇左', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(139, '武汉', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(140, '黄石', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(141, '襄樊', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(142, '十堰', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(143, '荆州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(144, '宜昌', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(145, '荆门', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(146, '鄂州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(147, '孝感', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(148, '黄冈', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(149, '咸宁', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(150, '随州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(151, '仙桃', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(152, '天门', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(153, '潜江', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(154, '神农架', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(155, '恩施土家族苗族自治州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(156, '长沙', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(157, '株洲', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(158, '湘潭', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(159, '衡阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(160, '邵阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(161, '岳阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(162, '常德', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(163, '张家界', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(164, '益阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(165, '郴州', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(166, '怀化', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(167, '娄底', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(168, '湘西土家族苗族自治州', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(169, '永州', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(170, '济南', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(171, '青岛', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(172, '淄博', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(173, '枣庄', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(174, '东营', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(175, '潍坊', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(176, '烟台', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(177, '威海', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(178, '济宁', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(179, '泰安', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(180, '日照', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(181, '莱芜', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(182, '德州', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(183, '临沂', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(184, '聊城', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(185, '滨州', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(186, '菏泽', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(187, '太原', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(188, '大同', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(189, '阳泉', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(190, '长治', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(191, '晋城', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(192, '朔州', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(193, '普中', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(194, '运城', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(195, '忻州', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(196, '临汾', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(197, '吕梁', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(198, '石家庄', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(199, '唐山', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(200, '秦皇岛', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(201, '邯郸', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(202, '邢台', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(203, '保定', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(204, '张家口', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(205, '承德', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(206, '沧州', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(207, '廊坊', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(208, '衡水', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(209, '郑州', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(210, '开封', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(211, '洛阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(212, '平顶山', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(213, '焦作', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(214, '鹤壁', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(215, '新乡', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(216, '安阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(217, '濮阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(218, '许昌', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(219, '漯河', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(220, '三门峡', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(221, '南阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(222, '商丘', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(223, '信阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(224, '周口', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(225, '驻马店', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(226, '济源', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(227, '成都', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(228, '自贡', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(229, '攀枝花', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(230, '泸州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(231, '德阳', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(232, '绵阳', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(233, '广元', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(234, '遂宁', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(235, '内江', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(236, '乐山', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(237, '南充', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(238, '宜宾', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(239, '广安', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(240, '达州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(241, '眉山', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(242, '雅安', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(243, '巴中', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(244, '资阳', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(245, '阿坝藏族羌族自治州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(246, '甘孜藏族自治州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(247, '凉山彝族自治州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(248, '杭州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(249, '宁波', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(250, '温州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(251, '嘉兴', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(252, '湖州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(253, '绍兴', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(254, '金华', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(255, '衢州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(256, '舟山', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(257, '台州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(258, '丽水', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(259, '南京', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(260, '无锡', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(261, '徐州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(262, '常州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(263, '苏州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(264, '南通', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(265, '连云港', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(266, '淮安', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(267, '盐城', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(268, '扬州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(269, '镇江', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(270, '泰州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(271, '宿迁', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(272, '福州', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(273, '厦门', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(274, '莆田', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(275, '三明', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(276, '泉州', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(277, '漳州', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(278, '南平', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(279, '龙岩', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(280, '宁德', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(281, '南昌', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(282, '景德镇', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(283, '萍乡', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(284, '新余', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(285, '九江', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(286, '鹰潭', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(287, '赣州', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(288, '吉安', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(289, '宜春', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(290, '抚州', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(291, '上饶', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(292, '合肥', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(293, '芜湖', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(294, '蚌埠', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(295, '淮南', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(296, '马鞍山', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(297, '淮北', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(298, '铜陵', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(299, '安庆', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(300, '黄山', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(301, '滁州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(302, '阜阳', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(303, '宿州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(304, '巢湖', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(305, '六安', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(306, '毫州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(307, '池州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(308, '宣城', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(309, '海口', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(310, '三亚', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(311, '五指山', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(312, '琼海', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(313, '儋州', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(314, '文昌', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(315, '万宁', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(316, '东方', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(317, '澄迈', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(318, '定安', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(319, '屯昌', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(320, '临高', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(321, '白沙黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(322, '昌江黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(323, '乐东黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(324, '陵水黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(325, '保亭黎族苗族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(326, '琼中黎族苗族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(327, '昆明', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(328, '曲靖', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(329, '玉溪', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(330, '保山', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(331, '昭通', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(332, '丽江', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(333, '思茅', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(334, '临沧', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(335, '文山壮族苗族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(336, '红河哈尼族彝族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(337, '西双版纳傣族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(338, '楚雄彝族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(339, '大理白族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(340, '德宏傣族景颇族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(341, '怒江傈僳族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(342, '迪庆藏族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(343, '西宁', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(344, '海东', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(345, '海北藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(346, '黄南藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(347, '海南藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(348, '果洛藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(349, '玉树藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(350, '海西蒙古族藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(351, '西安', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(352, '铜川', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(353, '宝鸡', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(354, '咸阳', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(355, '渭南', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(356, '延安', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(357, '汉中', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(358, '榆林', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(359, '安康', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(360, '商洛', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(361, '兰州', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(362, '金昌', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(363, '白银', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(364, '天水', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(365, '嘉峪关', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(366, '武威', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(367, '张掖', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(368, '平凉', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(369, '酒泉', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(370, '庆阳', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(371, '定西', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(372, '陇南', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(373, '临夏回族自治州', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(374, '甘南藏族自治州', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(375, '贵阳', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(376, '六盘水', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(377, '遵义', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(378, '安顺', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(379, '铜仁', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(380, '毕节', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(381, '黔西南而布依族苗族自治州', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(382, '黔东南而苗族侗族自治州', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(383, '黔南而布依族苗族自治州', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(384, '银川', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(385, '石嘴山', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(386, '吴忠', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(387, '固原', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(388, '哈尔滨', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(389, '齐齐哈尔', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(390, '鹤岗', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(391, '双鸭山', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(392, '鸡西', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(393, '大庆', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(394, '伊春', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(395, '牡丹江', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(396, '佳木斯', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(397, '七台河', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(398, '黑河', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(399, '绥化', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(400, '大兴安岭', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(401, '长春', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(402, '吉林市', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(403, '四平', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(404, '辽源', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(405, '通化', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(406, '白山', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(407, '松原', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(408, '白城', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(409, '延边朝鲜族自治州', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(410, '沈阳', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(411, '大连', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(412, '鞍山', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(413, '抚顺', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(414, '本溪', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(415, '丹东', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(416, '锦州', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(417, '葫芦岛', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(418, '营口', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(419, '盘锦', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(420, '阜新', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(421, '辽阳', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(422, '铁岭', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(423, '朝阳', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(424, '拉萨', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(425, '那曲', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(426, '昌都', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(427, '山南', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(428, '日喀则', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(429, '阿里', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(430, '林芝', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(431, '乌鲁木齐', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(432, '克拉玛依', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(433, '石河子', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(434, '阿拉尔', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(435, '图木舒克', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(436, '五家渠', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(437, '吐鲁番', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(438, '哈密', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(439, '和田', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(440, '阿克苏', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(441, '喀什', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(442, '克孜勒苏柯尔克孜自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(443, '巴音郭楞蒙古自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(444, '昌吉回族自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(445, '博尔塔拉蒙古自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(446, '伊犁哈萨克自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(447, '呼和浩特', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(448, '包头', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(449, '乌海', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(450, '赤峰', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(451, '通辽', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(452, '鄂尔多斯', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(453, '呼伦贝尔', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(454, '乌兰察布盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(455, '锡林郭勒盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(456, '巴彦淖尔盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(457, '阿拉善盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(458, '兴安盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(459, '香港', 32);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(460, '澳门', 33);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
(461, '台北', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(462, '高雄', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(463, '基隆', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(464, '台中', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(465, '台南', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(466, '新竹', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(467, '嘉义', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(468, '台北县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(469, '宜兰县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(470, '新竹县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(471, '桃园县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(472, '苗栗县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(473, '台中县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(474, '彰化县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(475, '南投县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(476, '嘉义县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(477, '云林县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(478, '台南县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(479, '高雄县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(480, '屏东县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(481, '台东县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(482, '花莲县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(483, '澎湖县', 34);
oracle数据库的插入
INSERT INTO Zone ('ZoneId', 'Nm', 'ParentId') VALUES
(1, '北京', 0),
(2, '上海', 0),
(3, '天津', 0),
(4, '重庆', 0),
(5, '广东', 0),
(6, '广西', 0),
(7, '湖北', 0),
(8, '湖南', 0),
(9, '山东', 0),
(10, '山西', 0),
(11, '河北', 0),
(12, '河南', 0),
(13, '四川', 0),
(14, '浙江', 0),
(15, '江苏', 0),
(16, '福建', 0),
(17, '江西', 0),
(18, '安徽', 0),
(19, '海南', 0),
(20, '云南', 0),
(21, '青海', 0),
(22, '陕西', 0),
(23, '甘肃', 0),
(24, '贵州', 0),
(25, '宁夏', 0),
(26, '黑龙江', 0),
(27, '吉林', 0),
(28, '辽宁', 0),
(29, '西藏', 0),
(30, '***', 0),
(31, '内蒙古', 0),
(32, '香港', 0),
(33, '澳门', 0),
(34, '台湾', 0),
(100, '北京', 1),(101, '上海', 2),(102, '天津', 3),(103, '重庆', 4),
(104, '广州', 5),(105, '深圳', 5),(106, '珠海', 5),(107, '汕头', 5),(108, '韶关', 5),(109, '佛山', 5),(110, '江门', 5),(111, '湛江', 5),(112, '茂名', 5),(113, '肇庆', 5),(114, '惠州', 5),(115, '梅州', 5),(116, '汕尾', 5),(117, '河源', 5),(118, '阳江', 5),(119, '清远', 5),(120, '东莞', 5),(121, '中山', 5),(122, '潮州', 5),(123, '揭阳', 5),(124, '云浮', 5),
(125, '南宁', 6),(126, '柳州', 6),(127, '桂林', 6),(128, '梧州', 6),(129, '北海', 6),(130, '防城港', 6),(131, '钦州', 6),(132, '贵港', 6),(133, '玉林', 6),(134, '百色', 6),(135, '贺州', 6),(136, '河池', 6),(137, '来宾', 6),(138, '崇左', 6),
(139, '武汉', 7),(140, '黄石', 7),(141, '襄樊', 7),(142, '十堰', 7),(143, '荆州', 7),(144, '宜昌', 7),(145, '荆门', 7),(146, '鄂州', 7),(147, '孝感', 7),(148, '黄冈', 7),(149, '咸宁', 7),(150, '随州', 7),(151, '仙桃', 7),(152, '天门', 7),(153, '潜江', 7),(154, '神农架', 7),(155, '恩施土家族苗族自治州', 7),
(156, '长沙', 8),(157, '株洲', 8),(158, '湘潭', 8),(159, '衡阳', 8),(160, '邵阳', 8),(161, '岳阳', 8),(162, '常德', 8),(163, '张家界', 8),(164, '益阳', 8),(165, '郴州', 8),(166, '怀化', 8),(167, '娄底', 8),(168, '湘西土家族苗族自治州', 8),(169, '永州', 8),
(170, '济南', 9),(171, '青岛', 9),(172, '淄博', 9),(173, '枣庄', 9),(174, '东营', 9),(175, '潍坊', 9),(176, '烟台', 9),(177, '威海', 9),(178, '济宁', 9),(179, '泰安', 9),(180, '日照', 9),(181, '莱芜', 9),(182, '德州', 9),(183, '临沂', 9),(184, '聊城', 9),(185, '滨州', 9),(186, '菏泽', 9),
(187, '太原', 10),(188, '大同', 10),(189, '阳泉', 10),(190, '长治', 10),(191, '晋城', 10),(192, '朔州', 10),(193, '普中', 10),(194, '运城', 10),(195, '忻州', 10),(196, '临汾', 10),(197, '吕梁', 10),
(198, '石家庄', 11),(199, '唐山', 11),(200, '秦皇岛', 11),(201, '邯郸', 11),(202, '邢台', 11),(203, '保定', 11),(204, '张家口', 11),(205, '承德', 11),(206, '沧州', 11),(207, '廊坊', 11),(208, '衡水', 11),
(209, '郑州', 12),(210, '开封', 12),(211, '洛阳', 12),(212, '平顶山', 12),(213, '焦作', 12),(214, '鹤壁', 12),(215, '新乡', 12),(216, '安阳', 12),(217, '濮阳', 12),(218, '许昌', 12),(219, '漯河', 12),(220, '三门峡', 12),(221, '南阳', 12),(222, '商丘', 12),(223, '信阳', 12),(224, '周口', 12),(225, '驻马店', 12),(226, '济源', 12),
(227, '成都', 13),(228, '自贡', 13),(229, '攀枝花', 13),(230, '泸州', 13),(231, '德阳', 13),(232, '绵阳', 13),(233, '广元', 13),(234, '遂宁', 13),(235, '内江', 13),(236, '乐山', 13),(237, '南充', 13),(238, '宜宾', 13),(239, '广安', 13),(240, '达州', 13),(241, '眉山', 13),(242, '雅安', 13),(243, '巴中', 13),(244, '资阳', 13),(245, '阿坝藏族羌族自治州', 13),(246, '甘孜藏族自治州', 13),(247, '凉山彝族自治州', 13),
(248, '杭州', 14),(249, '宁波', 14),(250, '温州', 14),(251, '嘉兴', 14),(252, '湖州', 14),(253, '绍兴', 14),(254, '金华', 14),(255, '衢州', 14),(256, '舟山', 14),(257, '台州', 14),(258, '丽水', 14),
(259, '南京', 15),(260, '无锡', 15),(261, '徐州', 15),(262, '常州', 15),(263, '苏州', 15),(264, '南通', 15),(265, '连云港', 15),(266, '淮安', 15),(267, '盐城', 15),(268, '扬州', 15),(269, '镇江', 15),(270, '泰州', 15),(271, '宿迁', 15),
(272, '福州', 16),(273, '厦门', 16),(274, '莆田', 16),(275, '三明', 16),(276, '泉州', 16),(277, '漳州', 16),(278, '南平', 16),(279, '龙岩', 16),(280, '宁德', 16),
(281, '南昌', 17),(282, '景德镇', 17),(283, '萍乡', 17),(284, '新余', 17),(285, '九江', 17),(286, '鹰潭', 17),(287, '赣州', 17),(288, '吉安', 17),(289, '宜春', 17),(290, '抚州', 17),(291, '上饶', 17),
(292, '合肥', 18),(293, '芜湖', 18),(294, '蚌埠', 18),(295, '淮南', 18),(296, '马鞍山', 18),(297, '淮北', 18),(298, '铜陵', 18),(299, '安庆', 18),(300, '黄山', 18),(301, '滁州', 18),(302, '阜阳', 18),(303, '宿州', 18),(304, '巢湖', 18),(305, '六安', 18),(306, '毫州', 18),(307, '池州', 18),(308, '宣城', 18),
(309, '海口', 19),(310, '三亚', 19),(311, '五指山', 19),(312, '琼海', 19),(313, '儋州', 19),(314, '文昌', 19),(315, '万宁', 19),(316, '东方', 19),(317, '澄迈', 19),(318, '定安', 19),(319, '屯昌', 19),(320, '临高', 19),(321, '白沙黎族自治县', 19),(322, '昌江黎族自治县', 19),(323, '乐东黎族自治县', 19),(324, '陵水黎族自治县', 19),(325, '保亭黎族苗族自治县', 19),(326, '琼中黎族苗族自治县', 19),
(327, '昆明', 20),(328, '曲靖', 20),(329, '玉溪', 20),(330, '保山', 20),(331, '昭通', 20),(332, '丽江', 20),(333, '思茅', 20),(334, '临沧', 20),(335, '文山壮族苗族自治州', 20),(336, '红河哈尼族彝族自治州', 20),(337, '西双版纳傣族自治州', 20),(338, '楚雄彝族自治州', 20),(339, '大理白族自治州', 20),(340, '德宏傣族景颇族自治州', 20),(341, '怒江傈僳族自治州', 20),(342, '迪庆藏族自治州', 20),
(343, '西宁', 21),(344, '海东', 21),(345, '海北藏族自治区', 21),(346, '黄南藏族自治区', 21),(347, '海南藏族自治区', 21),(348, '果洛藏族自治区', 21),(349, '玉树藏族自治区', 21),(350, '海西蒙古族藏族自治区', 21),
(351, '西安', 22),(352, '铜川', 22),(353, '宝鸡', 22),(354, '咸阳', 22),(355, '渭南', 22),(356, '延安', 22),(357, '汉中', 22),(358, '榆林', 22),(359, '安康', 22),(360, '商洛', 22),
(361, '兰州', 23),(362, '金昌', 23),(363, '白银', 23),(364, '天水', 23),(365, '嘉峪关', 23),(366, '武威', 23),(367, '张掖', 23),(368, '平凉', 23),(369, '酒泉', 23),(370, '庆阳', 23),(371, '定西', 23),(372, '陇南', 23),(373, '临夏回族自治州', 23),(374, '甘南藏族自治州', 23),
(375, '贵阳', 24),(376, '六盘水', 24),(377, '遵义', 24),(378, '安顺', 24),(379, '铜仁', 24),(380, '毕节', 24),(381, '黔西南而布依族苗族自治州', 24),(382, '黔东南而苗族侗族自治州', 24),(383, '黔南而布依族苗族自治州', 24),
(384, '银川', 25),(385, '石嘴山', 25),(386, '吴忠', 25),(387, '固原', 25),
(388, '哈尔滨', 26),(389, '齐齐哈尔', 26),(390, '鹤岗', 26),(391, '双鸭山', 26),(392, '鸡西', 26),(393, '大庆', 26),(394, '伊春', 26),(395, '牡丹江', 26),(396, '佳木斯', 26),(397, '七台河', 26),(398, '黑河', 26),(399, '绥化', 26),(400, '大兴安岭', 26),
(401, '长春', 27),(402, '吉林市', 27),(403, '四平', 27),(404, '辽源', 27),(405, '通化', 27),(406, '白山', 27),(407, '松原', 27),(408, '白城', 27),(409, '延边朝鲜族自治州', 27),
(410, '沈阳', 28),(411, '大连', 28),(412, '鞍山', 28),(413, '抚顺', 28),(414, '本溪', 28),(415, '丹东', 28),(416, '锦州', 28),(417, '葫芦岛', 28),(418, '营口', 28),(419, '盘锦', 28),(420, '阜新', 28),(421, '辽阳', 28),(422, '铁岭', 28),(423, '朝阳', 28),
(424, '拉萨', 29),(425, '那曲', 29),(426, '昌都', 29),(427, '山南', 29),(428, '日喀则', 29),(429, '阿里', 29),(430, '林芝', 29),
(431, '乌鲁木齐', 30),(432, '克拉玛依', 30),(433, '石河子', 30),(434, '阿拉尔', 30),(435, '图木舒克', 30),(436, '五家渠', 30),(437, '吐鲁番', 30),(438, '哈密', 30),(439, '和田', 30),(440, '阿克苏', 30),(441, '喀什', 30),(442, '克孜勒苏柯尔克孜自治州', 30),(443, '巴音郭楞蒙古自治州', 30),(444, '昌吉回族自治州', 30),(445, '博尔塔拉蒙古自治州', 30),(446, '伊犁哈萨克自治州', 30),
(447, '呼和浩特', 31),(448, '包头', 31),(449, '乌海', 31),(450, '赤峰', 31),(451, '通辽', 31),(452, '鄂尔多斯', 31),(453, '呼伦贝尔', 31),(454, '乌兰察布盟', 31),(455, '锡林郭勒盟', 31),(456, '巴彦淖尔盟', 31),(457, '阿拉善盟', 31),(458, '兴安盟', 31),
(459, '香港', 32),
(460, '澳门', 33),
(461, '台北', 34),(462, '高雄', 34),(463, '基隆', 34),(464, '台中', 34),(465, '台南', 34),(466, '新竹', 34),(467, '嘉义', 34),(468, '台北县', 34),(469, '宜兰县', 34),(470, '新竹县', 34),(471, '桃园县', 34),(472, '苗栗县', 34),(473, '台中县', 34),(474, '彰化县', 34),(475, '南投县', 34),(476, '嘉义县', 34),(477, '云林县', 34),(478, '台南县', 34),(479, '高雄县', 34),(480, '屏东县', 34),(481, '台东县', 34),(482, '花莲县', 34),(483, '澎湖县', 34);
数据虽然有些乱但是不影响使用，sqlserver的数据我试过了没有问题，oracle的数据没有测试。
2
顶
顶
1
踩
踩
分享到：
发表评论
-
SQL Server安装时提示程序挂起解决方法
2010-05-05 09:12 1421具体方法：进入注册表编辑器，删除HKEY_LOCAL_MACH ... -
org.hibernate.exception.JDBCConnectionException: Cannot open connection
2010-05-04 20:31 4869org.hibernate.exception.JDBCCon ... -
sqlServer中with replace、move...to的使用例子
2010-04-29 11:17 6941今天在做数据库还原的时候提示不能还原，没办法，只能用命令就进行 ... -
sql 2005 解除用户锁定(SA帐户被锁定)
2009-11-11 11:28 6969SQL Server 2005 sa 用户被锁定的问题Sql ... -
修改sqlserver数据库sa密码
2009-08-25 11:42 1913以windows身份登陆后在查询分析器里面输入以下内容： s ... -
如何写高效率的SQL
2009-08-07 12:42 1464看看这个你就都明白了 -
SQLServer2005中的数据同步到Oracle中
2009-07-23 09:11 1661有时由于项目开发的需要，必须将SQLServer2005中的某 ... -
提高SQL执行性能方案：如何让你的SQL运行得更快
2009-05-13 14:53 2234---- 人们在使用SQL时往 ...
相关推荐
全国省市数据SQL脚本，全国省市数据SQL脚本，全国省市数据SQL脚本
全国省市数据JS文件，包含三个JSON对象： 1.CHINA_PROVINCE_JSON，全国省份列表； 2.CHINA_CITY_JSON，全国城市列表，key为省份的行政区划代码，value为省份对应的城市列表JSON； 3.CHINA_DISTRICT_JSON：全国省市...
标题 "MySql全国省市数据" 暗示我们讨论的主题是关于MySQL数据库中存储的中国所有省份和城市的详细信息。这种数据通常用于地理定位、数据分析、统计报告或任何需要地域信息的应用程序。在这个压缩包中，包含了一个名...
MySQL全国省市数据表是数据库设计中常见的资源，用于存储中国各个省份和城市的详细信息。这些数据通常被广泛应用于各种需要地域信息的系统，如电商、物流、地图服务、数据分析等。下面将详细介绍这个主题。 首先，`...
https://blog.csdn.net/xiaoerbuyu1233/article/details/130511733 全国省市数据
标题中的“全国省市数据带经纬度”指的是一个包含中国所有省份、城市和区县的数据集，这个数据集的独特之处在于它包含了每个行政区域的经纬度坐标。这些坐标通常是用来表示地理上的位置，对于地理信息系统（GIS）...
### 全国省市数据SQL脚本解析与知识点详解 #### SQL脚本背景介绍 根据给定的文件信息，我们可以了解到这是一份包含了中国各省份及其下属城市的SQL脚本。该脚本通过一系列的SQL命令来创建数据库表并插入相应的数据。...
和天气全国省市数据,包含中英文名，城市代码、身份证代码，城市经纬度。
全国省市数据脚本。。。。。。。。。。。。。。。。。。。。。。。。
级联选择器下的省市区初始js数据
从给定的文件信息来看，我们正在探讨一个与全国省市数据库相关的知识点，这涉及到了数据库设计、数据存储以及中国地理信息的基本概念。以下是对这些知识点的深入解析： ### 数据库设计与结构 #### 表格定义 在...
全国省市区数据库是一个重要的资源，尤其对于开发人员和数据分析者来说，它提供了中国所有行政区域的详细信息。这个数据库包含了中国的省级行政单位、地级行政单位以及县级行政单位，覆盖了中国大陆以及香港特别行政...
中国省市乡镇行政区划代码采集程序。 VS2013开发，MSSQL数据库。 文件中已有数据库建表语句，请创建数据库并修改相应的数据库连接即可直接运行。 生成的数据约70多万条。
[ { "value": "110000", "label": "北京市", "children": [ { "value": "110100", "label": "直辖市", "children": [ { "value": "110101", "label": "东城区" }, { "value": "110102", ... {
全国省市JSON数据，包含code level
很全的省市区数据字典表，mysql
全国省市区数据SQL - 省市区
微信小程序自定义省市区资源数据