vue2省市区三级联动,mysql,html/jsp,js/json

/* Navicat MySQL Data Transfer Source Server : test Source Server Version : 50173 Source Host : Source Database : Target Server Type : MYSQL Target Server Version : 50173 File Encoding : 65001 Date: 2017-12-18 13:45:31 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for sys_area -- ---------------------------- DROP TABLE IF EXISTS `sys_area`; CREATE TABLE `sys_area` ( `id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '编号', `parent_id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '父级编号', `parent_ids` varchar(2000) COLLATE utf8_bin NOT NULL COMMENT '所有父级编号', `name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '名称', `sort` decimal(10,0) NOT NULL COMMENT '排序', `code` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '区域编码', `type` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '区域类型', `create_by` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '创建者', `create_date` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '更新者', `update_date` datetime NOT NULL COMMENT '更新时间', `remarks` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注信息', `del_flag` char(1) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `sys_area_parent_id` (`parent_id`), KEY `sys_area_del_flag` (`del_flag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='区域表'; -- ---------------------------- -- Records of sys_area -- ---------------------------- INSERT INTO `sys_area` VALUES ('0087ab5160db4b048a7366d43e86a120', '114', '0,11,114', '南浔区', '100', '330503', '4', '0', '2017-11-30 13:59:16', '0', '2017-11-30 13:59:16', null, '0'); INSERT INTO `sys_area` VALUES ('0089cf32db0b4feab56b68965650a777', '43', '0,3,43', '桥西区', '100', '130703', '4', '0', '2017-11-30 14:01:14', '0', '2017-11-30 14:01:14', null, '0'); INSERT INTO `sys_area` VALUES ('009bb7890bef44e4b26355ee0324694b', '380', '0,24,380', '焉耆回族自治县', '100', '652826', '4', '0', '2017-11-30 14:00:45', '0', '2017-11-30 14:00:45', null, '0'); INSERT INTO `sys_area` VALUES ('00afb4e0a0d74e8895992fdf4bb62f72', '168', '0,15,168', '郯城县', '100', '371322', '4', '0', '2017-11-30 13:59:44', '0', '2017-11-30 13:59:44', null, '0'); INSERT INTO `sys_area` VALUES ('00bbbd7384ff4745a2b35bc28af488d4', '310', '0,30,310', '巧家县', '100', '530622', '4', '0', '2017-11-30 14:01:21', '0', '2017-11-30 14:01:21', null, '0'); INSERT INTO `sys_area` VALUES ('00d0edbaec0744e6b06aefa31136b86b', '78', '0,7,78', '珲春市', '100', '222404', '4', '0', '2017-11-30 14:01:54', '0', '2017-11-30 14:01:54', null, '0'); INSERT INTO `sys_area` VALUES ('0103943a0e004e4a86c35f079af063e7', '45', '0,3,45', '开平区', '100', '130205', '4', '0', '2017-11-30 14:01:16', '0', '2017-11-30 14:01:16', null, '0'); INSERT INTO `sys_area` VALUES ('0122c6f8dab34fd6b8537da777925a74', '162', '0,15,162', '博山区', '100', '370304', '4', '0', '2017-11-30 13:59:40', '0', '2017-11-30 13:59:40', null, '0'); INSERT INTO `sys_area` VALUES ('0148fb0c736c46ac8fbfff1a53b395a0', '267', '0,28,267', '邻水县', '100', '511623', '4', '0', '2017-11-30 14:00:56', '0', '2017-11-30 14:00:56', null, '0'); INSERT INTO `sys_area` VALUES ('017af725b4c04b8cb735258138c190d6', '318', '0,30,318', '禄丰县', '100', '532331', '4', '0', '2017-11-30 14:01:27', '0', '2017-11-30 14:01:27', null, '0'); INSERT INTO `sys_area` VALUES ('018eade9f9dd4479a4d1ae842b2e13cb', '164', '0,15,164', '栖霞市', '100', '370686', '4', '0', '2017-11-30 13:59:42', '0', '2017-11-30 13:59:42', null, '0'); INSERT INTO `sys_area` VALUES ('01a243ed5cc745dda951010321492587', '262', '0,28,262', '贡井区', '100', '510303', '4', '0', '2017-11-30 14:00:53', '0', '2017-11-30 14:00:53', null, '0'); INSERT INTO `sys_area` VALUES ('01ee76c8395f495e9bdf8ea297b2258a', '121', '0,11,121', '黄岩区', '100', '331003', '4', '0', '2017-11-30 13:59:19', '0', '2017-11-30 13:59:19', null, '0'); INSERT INTO `sys_area` VALUES ('01eff676eb6c4b3cb14e1b722eaf3b52', '65', '0,6,65', '海城市', '100', '210381', '4', '0', '2017-11-30 14:01:49', '0', '2017-11-30 14:01:49', null, '0'); INSERT INTO `sys_area` VALUES ('0208ed04bdff43c8b6f80b6b76e81445', '107', '0,10,107', '海州区', '100', '320706', '4', '0', '2017-11-30 13:59:11', '0', '2017-11-30 13:59:11', null, '0'); INSERT INTO `sys_area` VALUES ('020b50a4882249c9b4a7816cb17463a0', '325', '0,25,325', '城北区', '100', '630105', '4', '0', '2017-11-30 14:00:48', '0', '2017-11-30 14:00:48', null, '0'); INSERT INTO `sys_area` VALUES ('020c084cdadc4d6da7ef154aaa66ac04', '79', '0,7,79', '铁西区', '100', '220302', '4', '0', '2017-11-30 14:01:54', '0', '2017-11-30 14:01:54', null, '0'); INSERT INTO `sys_area` VALUES ('02100377a31d48f38c80b2f92ac30727', '347', '0,21,347', '永福县', '100', '450326', '4', '0', '2017-11-30 14:00:24', '0', '2017-11-30 14:00:24', null, '0'); INSERT INTO `sys_area` VALUES ('021fd9f7c46c49a79f1e615b226fc8d2', '120', '0,11,120', '义乌市', '100', '330782', '4', '0', '2017-11-30 13:59:19', '0', '2017-11-30 13:59:19', null, '0'); INSERT INTO `sys_area` VALUES ('0253fe5600b34f569e55d60e6ba0efd2', '161', '0,15,161', '崂山区', '100', '370212', '4', '0', '2017-11-30 13:59:39', '0', '2017-11-30 13:59:39', null, '0'); INSERT INTO `sys_area` VALUES ('0273e283ab974cf183c0f5f76554c1d3', '310', '0,30,310', '大关县', '100', '530624', '4', '0', '2017-11-30 14:01:21', '0', '2017-11-30 14:01:21', null, '0'); INSERT INTO `sys_area` VALUES ('0286581a2d394eeda603f6543d0c2475', '150', '0,14,150', '南昌县', '100', '360121', '4', '0', '2017-11-30 13:59:33', '0', '2017-11-30 13:59:33', null, '0'); INSERT INTO `sys_area` VALUES ('02a09517941f49e0b32cad2702137923', '314', '0,30,314', '富源县', '100', '530325', '4', '0', '2017-11-30 14:01:25', '0', '2017-11-30 14:01:25', null, '0'); INSERT INTO `sys_area` VALUES ('02a2a12ad2964989bdf75892452122d8', '109', '0,10,109', '泰兴市', '100', '321283', '4', '0', '2017-11-30 13:59:12', '0', '2017-11-30 13:59:12', null, '0'); INSERT INTO `sys_area` VALUES ('02a5b2030d0c4b88ba046643cf3e304d', '347', '0,21,347', '恭城瑶族自治县', '100', '450332', '4', '0', '2017-11-30 14:00:24', '0', '2017-11-30 14:00:24', null, '0'); INSERT INTO `sys_area` VALUES ('02b472aefd9e4e88840d5fe8e91a244f', '391', '0,5,391', '科尔沁区', '100', '150502', '4', '0', '2017-11-30 14:01:43', '0', '2017-11-30 14:01:43', null, '0'); INSERT INTO `sys_area` VALUES ('02f4a21293394fcfa3982acb8fb7c573', '377', '0,24,377', '阜康市', '100', '652302', '4', '0', '2017-11-30 14:00:44', '0', '2017-11-30 14:00:44', null, '0'); INSERT INTO `sys_area` VALUES ('032fb7ac409b46a599e6f7a4af5e3b99', '122', '0,12,122', '蜀山区', '100', '340104', '4', '0', '2017-11-30 13:59:20', '0', '2017-11-30 13:59:20', null, '0'); INSERT INTO `sys_area` VALUES ('0337ce12070646f5a580bcffcc95fee8', '284', '0,29,284', '贵定县', '100', '522723', '4', '0', '2017-11-30 14:01:07', '0', '2017-11-30 14:01:07', null, '0'); INSERT INTO `sys_area` VALUES ('0370dc8e2fe04a069f891bb02dd98b59', '203', '0,17,203', '来凤县', '100', '422827', '4', '0', '2017-11-30 14:00:04', '0', '2017-11-30 14:00:04', null, '0'); INSERT INTO `sys_area` VALUES ('039f83199f6d45aca4d218106fd21d16', '280', '0,28,280', '苍溪县', '100', '510824', '4', '0', '2017-11-30 14:01:05', '0', '2017-11-30 14:01:05', null, '0'); INSERT INTO `sys_area` VALUES ('03b887f2b8894a959ca31871fe52b0d5', '195', '0,17,195', '宜城市', '100', '420684', '4', '0', '2017-11-30 14:00:00', '0', '2017-11-30 14:00:00', null, '0'); INSERT INTO `sys_area` VALUES ('04075d834a4848d6be89033737092618', '202', '0,17,202', '兴山县', '100', '420526', '4', '0', '2017-11-30 14:00:03', '0', '2017-11-30 14:00:03', null, '0'); INSERT INTO `sys_area` VALUES ('0413695799db4ab2b0e2da2