164基于springboot小区物业管理系统

项目描述

很完美的一个小区物业管理系统，房屋管理，车位管理，交费管理，社区服务等等
运行环境

tomcat7.0+jdk1.7或以上

eclipse或idea

项目技术

springboot+mybatis+mysql+maven+thymeleaf

数据库设计：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for admin

---

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
id int(10) NOT NULL COMMENT ‘管理员’,
username varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘用户名’,
password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘密码’,
phone varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘手机’,
sex int(10) NULL DEFAULT NULL COMMENT ‘性别’,
email varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘邮箱’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Table structure for building

---

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);
INSERT INTO danyuan VALUES (2, ‘A2单元’, 1);
INSERT INTO danyuan VALUES (3, ‘B1单元’, 2);
INSERT INTO danyuan VALUES (4, ‘B2单元’, 2);
INSERT INTO danyu