164基于springboot小区物业管理系统，面试题分享

INSERT INTO car VALUES (44, ‘车位44’, 1, 0);

INSERT INTO car VALUES (45, ‘车位45’, 1, 0);

INSERT INTO car VALUES (46, ‘车位46’, 1, 0);

INSERT INTO car VALUES (47, ‘车位47’, 1, 0);

INSERT INTO car VALUES (48, ‘车位48’, 1, 0);

INSERT INTO car VALUES (49, ‘车位49’, 1, 0);

INSERT INTO car VALUES (50, ‘车位50’, 1, 0);

INSERT INTO car VALUES (51, ‘车位51’, 1, 0);

INSERT INTO car VALUES (52, ‘车位52’, 1, 0);

INSERT INTO car VALUES (53, ‘车位53’, 1, 0);

INSERT INTO car VALUES (54, ‘车位54’, 1, 0);

INSERT INTO car VALUES (55, ‘车位55’, 1, 0);

INSERT INTO car VALUES (56, ‘车位56’, 1, 0);

INSERT INTO car VALUES (57, ‘车位57’, 1, 0);

INSERT INTO car VALUES (58, ‘车位58’, 1, 0);

INSERT INTO car VALUES (59, ‘车位59’, 1, 0);

INSERT INTO car VALUES (60, ‘车位60’, 1, 0);

---

– Table structure for danyuan

---

DROP TABLE IF EXISTS danyuan;

CREATE TABLE danyuan (

id int(10) NOT NULL AUTO_INCREMENT,

name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

building_id int(10) NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE,

INDEX building(building_id) USING BTREE,

CONSTRAINT building FOREIGN KEY (building_id) REFERENCES building (id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of danyuan

---

INSERT INTO danyuan VALUES (1, ‘A1单元’, 1);

INSERT INTO danyuan VALUES (2, ‘A2单元’, 1);

INSERT INTO danyuan VALUES (3, ‘B1单元’, 2);

INSERT INTO danyuan VALUES (4, ‘B2单元’, 2);

INSERT INTO danyuan VALUES (5, ‘C1单元’, 3);

INSERT INTO danyuan VALUES (6, ‘C2单元’, 3);

INSERT INTO danyuan VALUES (7, ‘D1单元’, 4);

INSERT INTO danyuan VALUES (8, ‘D2单元’, 4);

---

– Table structure for gonggao

---

DROP TABLE IF EXISTS gonggao;

CREATE TABLE gonggao (

id int(10) NOT NULL AUTO_INCREMENT,

title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘公告标题’,

content varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘公告内容’,

createBy int(10) NULL DEFAULT NULL COMMENT ‘创建者’,

createTime datetime(0) NULL DEFAULT NULL COMMENT ‘创建时间’,

updateBy int(10) NULL DEFAULT NULL COMMENT ‘修改者’,

updateTime datetime(0) NULL DEFAULT NULL COMMENT ‘修改时间’,

status int(10) NULL DEFAULT NULL COMMENT ‘是否展示’,

PRIMARY KEY (id) USING BTREE,

INDEX create(createBy) USING BTREE,

INDEX update(updateBy) USING BTREE,

CONSTRAINT create FOREIGN KEY (createBy) REFERENCES admin (id) ON DELETE SET NULL ON UPDATE CASCADE,

CONSTRAINT update FOREIGN KEY (updateBy) REFERENCES admin (id) ON DELETE SET NULL ON UPDATE CASCADE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of gonggao

---

INSERT INTO gonggao VALUES (1, ‘公告一’, ‘测试一下’, 1, ‘2020-03-03 09:39:46’, 1, ‘2020-03-03 06:11:25’, 0);

INSERT INTO gonggao VALUES (2, ‘公告二’, ‘再测试以下’, 1, ‘2020-03-03 09:40:06’, 1, ‘2020-03-03 01:59:44’, 1);

---

– Table structure for payment

---

DROP TABLE IF EXISTS payment;

CREATE TABLE payment (

id int(10) NOT NULL AUTO_INCREMENT,

name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of payment

---

INSERT INTO payment VALUES (1, ‘水电’);

INSERT INTO payment VALUES (2, ‘煤气’);

INSERT INTO payment VALUES (3, ‘物业’);

INSERT INTO payment VALUES (4, ‘停车费’);

---

– Table structure for repair

---

DROP TABLE IF EXISTS repair;

CREATE TABLE repair (

id int(10) NOT NULL AUTO_INCREMENT,

content varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

user_id int(10) NULL DEFAULT NULL,

status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘是否解决’,

time datetime(0) NULL DEFAULT NULL COMMENT ‘创建时间’,

result varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE,

INDEX 5(user_id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of repair

---

INSERT INTO repair VALUES (1, ‘测试1’, 1, ‘0’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (2, ‘测试2’, 2, ‘1’, ‘2020-03-03 03:34:40’, ‘完美解决’);

INSERT INTO repair VALUES (3, ‘测试3’, 3, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (4, ‘测试4’, 4, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (5, ‘测试5’, 5, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (6, ‘测试6’, 6, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (7, ‘测试7’, 7, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (8, ‘测试8’, 8, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (9, ‘测试9’, 9, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (10, ‘测试10’, 10, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (11, ‘测试11’, 11, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (12, ‘测试12’, 12, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (13, ‘测试13’, 13, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (14, ‘测试14’, 14, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (15, ‘测试15’, 15, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (16, ‘测试16’, 16, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (17, ‘测试17’, 17, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (18, ‘测试18’, 18, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (19, ‘测试19’, 19, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (20, ‘测试20’, 20, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (21, ‘测试21’, 21, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (22, ‘测试22’, 22, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (23, ‘测试23’, 23, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (24, ‘测试24’, 24, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (25, ‘测试25’, 25, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (26, ‘测试26’, 26, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (27, ‘测试27’, 27, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (28, ‘测试28’, 28, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (29, ‘测试29’, 29, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (30, ‘测试30’, 30, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (31, ‘测试31’, 31, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (32, ‘测试32’, 32, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (33, ‘测试33’, 33, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (34, ‘测试34’, 34, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (35, ‘测试35’, 35, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (36, ‘测试36’, 36, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (37, ‘测试37’, 37, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (38, ‘测试38’, 38, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (39, ‘测试39’, 39, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (40, ‘测试40’, 40, ‘1’, ‘2020-03-03 03:34:40’, NULL);

INSERT INTO repair VALUES (41, ‘我要维修水龙头。’, 1, NULL, NULL, NULL);

---

– Table structure for room

---

DROP TABLE IF EXISTS room;

CREATE TABLE room (

id int(10) NOT NULL AUTO_INCREMENT,

name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘房屋名称’,

area varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘房屋面积’,

status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘是否为空’,

danyuan_id int(10) NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE,

INDEX danyuan(danyuan_id) USING BTREE,

CONSTRAINT danyuan FOREIGN KEY (danyuan_id) REFERENCES danyuan (id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE = InnoDB AUTO_INCREMENT = 148 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of room

---

INSERT INTO room VALUES (50, ‘101’, ‘97’, ‘1’, 1);

INSERT INTO room VALUES (51, ‘102’, ‘96’, ‘1’, 1);

INSERT INTO room VALUES (52, ‘201’, ‘96’, ‘1’, 1);

INSERT INTO room VALUES (53, ‘202’, ‘96’, ‘1’, 1);

INSERT INTO room VALUES (54, ‘301’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (55, ‘302’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (56, ‘401’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (57, ‘402’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (58, ‘501’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (59, ‘502’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (60, ‘601’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (61, ‘602’, ‘96’, ‘0’, 1);

INSERT INTO room VALUES (62, ‘101’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (63, ‘102’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (64, ‘201’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (65, ‘202’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (66, ‘301’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (67, ‘302’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (68, ‘401’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (69, ‘402’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (70, ‘501’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (71, ‘502’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (72, ‘601’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (73, ‘602’, ‘96’, ‘0’, 2);

INSERT INTO room VALUES (74, ‘101’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (75, ‘102’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (76, ‘201’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (77, ‘202’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (78, ‘301’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (79, ‘302’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (80, ‘401’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (81, ‘402’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (82, ‘501’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (83, ‘502’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (84, ‘601’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (85, ‘602’, ‘96’, ‘0’, 3);

INSERT INTO room VALUES (86, ‘101’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (87, ‘102’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (88, ‘201’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (89, ‘202’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (90, ‘301’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (91, ‘302’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (92, ‘401’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (93, ‘402’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (94, ‘501’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (95, ‘502’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (96, ‘601’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (97, ‘602’, ‘96’, ‘0’, 4);

INSERT INTO room VALUES (98, ‘101’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (99, ‘102’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (100, ‘201’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (101, ‘202’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (102, ‘301’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (103, ‘302’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (104, ‘401’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (105, ‘402’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (106, ‘501’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (107, ‘502’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (108, ‘601’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (109, ‘602’, ‘96’, ‘0’, 5);

INSERT INTO room VALUES (110, ‘101’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (111, ‘102’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (112, ‘201’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (113, ‘202’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (114, ‘301’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (115, ‘302’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (116, ‘401’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (117, ‘402’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (118, ‘501’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (119, ‘502’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (120, ‘601’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (121, ‘602’, ‘96’, ‘0’, 6);

INSERT INTO room VALUES (122, ‘101’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (123, ‘102’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (124, ‘201’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (125, ‘202’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (126, ‘301’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (127, ‘302’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (128, ‘401’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (129, ‘402’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (130, ‘501’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (131, ‘502’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (132, ‘601’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (133, ‘602’, ‘96’, ‘0’, 7);

INSERT INTO room VALUES (134, ‘101’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (135, ‘102’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (136, ‘201’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (137, ‘202’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (138, ‘301’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (139, ‘302’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (140, ‘401’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (141, ‘402’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (142, ‘501’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (143, ‘502’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (144, ‘601’, ‘96’, ‘0’, 8);

INSERT INTO room VALUES (145, ‘602’, ‘96’, ‘0’, 8);

---

– Table structure for tousu

---

DROP TABLE IF EXISTS tousu;

CREATE TABLE tousu (

id int(10) NOT NULL AUTO_INCREMENT,

content varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

user_id int(10) NULL DEFAULT NULL,

status int(10) NULL DEFAULT NULL,

time datetime(0) NULL DEFAULT NULL,

result varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE,

INDEX 6(user_id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of tousu

---

INSERT INTO tousu VALUES (1, ‘测试1’, 1, 1, ‘2020-03-03 03:34:48’, ‘已经解决了’);

INSERT INTO tousu VALUES (2, ‘测试2’, 2, 1, ‘2020-03-03 03:34:48’, ‘213e131’);

INSERT INTO tousu VALUES (3, ‘测试3’, 3, 0, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (4, ‘测试4’, 4, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (5, ‘测试5’, 5, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (6, ‘测试6’, 6, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (7, ‘测试7’, 7, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (8, ‘测试8’, 8, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (9, ‘测试9’, 9, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (10, ‘测试10’, 10, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (11, ‘测试11’, 11, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (12, ‘测试12’, 12, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (13, ‘测试13’, 13, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (14, ‘测试14’, 14, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (15, ‘测试15’, 15, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (16, ‘测试16’, 16, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (17, ‘测试17’, 17, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (18, ‘测试18’, 18, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (19, ‘测试19’, 19, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (20, ‘测试20’, 20, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (21, ‘测试21’, 21, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (22, ‘测试22’, 22, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (23, ‘测试23’, 23, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (24, ‘测试24’, 24, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (25, ‘测试25’, 25, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (26, ‘测试26’, 26, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (27, ‘测试27’, 27, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (28, ‘测试28’, 28, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (29, ‘测试29’, 29, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (30, ‘测试30’, 30, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (31, ‘测试31’, 31, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (32, ‘测试32’, 32, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (33, ‘测试33’, 33, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (34, ‘测试34’, 34, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (35, ‘测试35’, 35, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (36, ‘测试36’, 36, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (37, ‘测试37’, 37, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (38, ‘测试38’, 38, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (39, ‘测试39’, 39, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (40, ‘测试40’, 40, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (42, ‘我要投诉！！’, 1, NULL, NULL, NULL);

---

– Table structure for user

小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

深知大多数初中级Java工程师，想要提升技能，往往是自己摸索成长，但自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！

因此收集整理了一份《2024年最新Java开发全套学习资料》送给大家，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。

由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频

如果你觉得这些内容对你有帮助，可以添加下面V无偿领取！（备注Java）

’, 39, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (40, ‘测试40’, 40, 1, ‘2020-03-03 03:34:48’, NULL);

INSERT INTO tousu VALUES (42, ‘我要投诉！！’, 1, NULL, NULL, NULL);

---

– Table structure for user

小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

深知大多数初中级Java工程师，想要提升技能，往往是自己摸索成长，但自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！

因此收集整理了一份《2024年最新Java开发全套学习资料》送给大家，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。
[外链图片转存中…(img-YdAFIbLc-1710865348788)]
[外链图片转存中…(img-uHfKqrOV-1710865348789)]
[外链图片转存中…(img-qMZpbFXY-1710865348789)]

由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频

如果你觉得这些内容对你有帮助，可以添加下面V无偿领取！（备注Java）
[外链图片转存中…(img-AblU8r97-1710865348790)]