164基于springboot小区物业管理系统，Java基础面试题库

---

DROP TABLE IF EXISTS building;

CREATE TABLE building (

id int(10) NOT NULL AUTO_INCREMENT,

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

type int(10) NULL DEFAULT NULL COMMENT ‘0：电梯；1：楼梯’,

PRIMARY KEY (id) USING BTREE

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

---

– Records of building

---

INSERT INTO building VALUES (1, ‘A’, 0);

INSERT INTO building VALUES (2, ‘B’, 0);

INSERT INTO building VALUES (3, ‘C’, 1);

INSERT INTO building VALUES (4, ‘D’, 1);

---

– Table structure for car

---

DROP TABLE IF EXISTS car;

CREATE TABLE car (

id int(10) NOT NULL AUTO_INCREMENT,

name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘停车位名称’,

type int(10) NULL DEFAULT NULL COMMENT ‘地面或者地下’,

status int(10) NULL DEFAULT NULL COMMENT ‘是否为空’,

PRIMARY KEY (id) USING BTREE

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

---

– Records of car

---

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);