前言
【课程设计】基于java的社区物业管理系统设计与实现
一、毕设目录
| 项目名 | 地址 |
|---|---|
1、【毕业设计】基于springboot的大学生综合素质测评管理系统 | http://t.csdn.cn/smVjL |
2、【毕业设计】基于springboot + vue微信小程序文创平台商城 | http://t.csdn.cn/rUQDg |
3、【毕业设计-免费获取】springboot+vue—酒店客房管理系统 | http://t.csdn.cn/4zBzE |
4、【毕业设计】springboot+vue前后端分离-考试报名管理系统 | http://t.csdn.cn/TpHxC |
二、系统介绍
社区物业管理系统是一个基于SSM（Spring+SpringMVC+MyBatis）开发的应用程序，旨在帮助社区物业管理人员更好地管理和维护小区的设施、服务和居民信息。以下是该系统的详细设计和实现介绍：
功能需求
小区信息管理：包括小区基本信息、房屋信息、业主信息、车位信息等管理；
报修管理：居民可以通过系统提交报修信息，物业人员可以查看并处理报修请求；
缴费管理：居民可以通过系统在线缴纳物业费、停车费等费用；
公告管理：物业人员可以发布小区公告，居民可以通过系统查看公告；
投诉管理：居民可以通过系统提交投诉信息，物业人员可以查看并处理投诉请求；
统计分析：物业人员可以通过系统统计小区各项数据并生成报表。
接口设计
该系统需要设计以下接口：
小区信息管理接口：包括添加小区信息、查询小区信息、修改小区信息、删除小区信息等接口；
房屋信息管理接口：包括添加房屋信息、查询房屋信息、修改房屋信息、删除房屋信息等接口；
业主信息管理接口：包括添加业主信息、查询业主信息、修改业主信息、删除业主信息等接口；
车位信息管理接口：包括添加车位信息、查询车位信息、修改车位信息、删除车位信息等接口；
报修管理接口：包括提交报修信息、查询报修信息、处理报修信息等接口；
缴费管理接口：包括在线缴纳物业费、停车费等费用的接口；
公告管理接口：包括发布公告信息、查询公告信息等接口；
投诉管理接口：包括提交投诉信息、查询投诉信息、处理投诉信息等接口。
部署方式
该系统可以使用Tomcat等Web服务器进行部署，需要将前端代码打包成静态文件，将后端代码打包成war包，然后将war包部署到Tomcat服务器中。同时需要在MySQL数据库中创建相关表，并配置好数据库连接信息和MyBatis的配置文件。
开发流程
需求分析：根据系统功能需求，对系统进行需求分析，确定系统功能和技术选型；
数据库设计：根据系统需求，设计数据库表结构；
前端开发：使用Bootstrap框架开发前端页面，实现系统的用户界面和交互功能；
后端开发：使用SSM框架开发后端代码，实现系统的业务逻辑和数据处理功能；
接口开发：根据系统需求，设计和开发相应的接口；
联调测试：前后端联合调试，进行系统测试和Bug修复；
部署上线：将系统部署到服务器上线，进行系统的正式运行。
注意事项
在系统开发过程中，需要注意以下事项：
设计数据库表时，需要考虑数据的完整性和一致性；
在接口开发过程中，需要考虑接口的安全性和数据的加密传输；
在系统部署上线之前，需要进行充分的测试和Bug修复，确保系统的稳定性和可靠性；
在系统上线之后，需要对系统进行日常维护和监控，及时处理系统故障和异常情况。
系统架构
该系统采用前后端分离的架构，前端使用Bootstrap框架开发，后端使用Spring+SpringMVC+MyBatis框架开发。前端通过RESTful API与后端进行通信，后端将数据存储在MySQL数据库中。
- 开发语言：Java；
- 开发框架：SSM（Spring+SpringMVC+MyBatis）；
- 数据库：MySQL；
四、系统环境
| 环境 | 版本 / 下载 |
|---|---|
| 系统 | win 10 /win 11 |
| JDK | 1.8.0_144 |
| Maven | 3.6.3 |
| JDK | 1.8.0_144 |
| IDEA | 2023 |
| Node | 14.16.0 + |
| npm | 6.14.11 + |
| MySQL | 5.6.42 / 5.7.x |
备注：以上版本为博主电脑配置，可点击进入官网下载
五、数据库表设计
数据库设计
该系统需要设计以下表：
小区信息表：包括小区名称、地址、开发商等信息；
房屋信息表：包括房屋编号、楼号、单元号、房间号等信息；
业主信息表：包括业主姓名、电话、身份证号、房屋编号等信息；
车位信息表：包括车位编号、车位类型、所属房屋编号等信息；
报修信息表：包括报修编号、报修人、报修时间、报修内容等信息；
缴费信息表：包括缴费编号、缴费人、缴费时间、缴费金额等信息；
公告信息表：包括公告编号、发布人、发布时间、公告内容等信息；
投诉信息表：包括投诉编号、投诉人、投诉时间、投诉内容等信息。
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : community
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 03/07/2023 23:00:19
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`numbers` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`uints` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remarks` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES (1, '16栋', '1单元', '无1');
INSERT INTO `building` VALUES (7, '17栋', '2单元', '无1');
INSERT INTO `building` VALUES (11, '18栋', '2单元', '无');
INSERT INTO `building` VALUES (12, '19栋', '1单元', '无');
INSERT INTO `building` VALUES (13, '20栋', '2单元', '无');
-- ----------------------------
-- Table structure for carcharge
-- ----------------------------
DROP TABLE IF EXISTS `carcharge`;
CREATE TABLE `carcharge` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`pay_date` datetime(0) NULL DEFAULT NULL,
`end_date` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`money` double(10, 2) NULL DEFAULT NULL,
`status` int(2) NULL DEFAULT NULL,
`owner_id` int(10) NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收费类型',
`park_id` int(10) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of carcharge
-- ----------------------------
INSERT INTO `carcharge` VALUES (2, '2020-09-30 16:00:00', '2020-12-31', 1200.00, 1, 1, '221', '停车费', 1);
INSERT INTO `carcharge` VALUES (3, '2020-09-30 16:00:00', '2020-12-31', 1200.00, 1, 2, '221', '停车费', 2);
INSERT INTO `carcharge` VALUES (8, '2020-10-31 16:00:00', '2020-11-30', 300.00, 0, 1, '112', '停车费', 1);
INSERT INTO `carcharge` VALUES (9, '2022-02-24 16:00:00', '2022-06-26', 50.00, 0, 1, '11', '停车费', 1);
INSERT INTO `carcharge` VALUES (10, '2022-02-24 16:00:00', '2022-06-26', 50.00, 0, 2, '11', '停车费', 2);
-- ----------------------------
-- Table structure for clockin
-- ----------------------------
DROP TABLE IF EXISTS `clockin`;
CREATE TABLE `clockin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clock_in_time` datetime(0) NULL DEFAULT NULL,
`owner_id` int(11) NULL DEFAULT NULL,
`house_id` int(11) NULL DEFAULT NULL,
`building_id` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of clockin
-- ----------------------------
INSERT INTO `clockin` VALUES (1, '2021-04-01 02:42:55', 1, 1, 1);
INSERT INTO `clockin` VALUES (4, '2021-04-20 14:59:13', 2, 2, 7);
INSERT INTO `clockin` VALUES (11, '2021-04-25 07:22:02', 1, 1, 1);
INSERT INTO `clockin` VALUES (12, '2021-04-26 07:22:29', 2, 2, 7);
INSERT INTO `clockin` VALUES (14, '2021-04-27 07:34:24', 1, 1, 1);
INSERT INTO `clockin` VALUES (15, '2021-04-27 07:35:23', 2, 2, 7);
-- ----------------------------
-- Table structure for clockinnew
-- ----------------------------
DROP TABLE IF EXISTS `clockinnew`;
CREATE TABLE `clockinnew` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`report_date` datetime(0) NULL DEFAULT NULL,
`owner_id` int(11) NULL DEFAULT NULL,
`type1` int(11) NULL DEFAULT NULL COMMENT '是否为疑似病例如咳嗽，发热（0或1）',
`type2` int(11) NULL DEFAULT NULL COMMENT '是否确诊为肺炎病例',
`today_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of clockinnew
-- ----------------------------
INSERT INTO `clockinnew` VALUES (1, '2021-04-26 13:20:32', 2, 0, 0, '江西省南昌市御景花园小区16栋1单元601', '无');
INSERT INTO `clockinnew` VALUES (6, '2021-04-26 16:00:00', 2, 0, 0, '测试', '');
INSERT INTO `clockinnew` VALUES (16, '2021-04-27 16:00:00', 2, 0, 0, '测试', '无');
INSERT INTO `clockinnew` VALUES (17, '2021-04-27 16:00:00', 1, 1, 0, '测试', 'v二十');
INSERT INTO `clockinnew` VALUES (18, '2021-10-29 16:00:00', 2, 0, 0, '江苏盐城', '无');
INSERT INTO `clockinnew` VALUES (19, '2021-10-29 16:00:00', 9, 0, 0, '深圳宝安', '无');
-- ----------------------------
-- Table structure for complaint
-- ----------------------------
DROP TABLE IF EXISTS `complaint`;
CREATE TABLE `complaint` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`com_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`com_date` datetime(0) NULL DEFAULT NULL,
`handle_date` datetime(0) NULL DEFAULT NULL,
`owner_id` int(11) NULL DEFAULT NULL,
`status` int(2) NULL DEFAULT NULL,
`clr` int(11) NULL DEFAULT NULL COMMENT '处理人',
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of complaint
-- ----------------------------
INSERT INTO `complaint` VALUES (1, '1', '2020-11-22 11:47:46', NULL, 1, 1, NULL, '垃圾经常乱放');
INSERT INTO `complaint` VALUES (2, '2', '2020-11-17 11:48:15', '2020-11-21 11:48:21', 1, 1, 111, '绿植被拔了');
INSERT INTO `complaint` VALUES (4, '1', '2020-11-24 14:21:01', NULL, 2, 0, NULL, '垃圾乱放没解决');
-- ----------------------------
-- Table structure for complaint_type
-- ----------------------------
DROP TABLE IF EXISTS `complaint_type`;
CREATE TABLE `complaint_type` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remarks` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` int(10) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of complaint_type
-- ----------------------------
INSERT INTO `complaint_type` VALUES (1, '垃圾乱放', NULL, NULL);
INSERT INTO `complaint_type` VALUES (2, '绿植太差', NULL, NULL);
-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`storey` int(5) NULL DEFAULT NULL,
`numbers` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` int(5) NULL DEFAULT NULL,
`into_date` datetime(0) NULL DEFAULT NULL,
`building_id` int(5) NULL DEFAULT NULL,
`remarks` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`area` double(10, 2) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES (1, NULL, '401', 1, '2020-10-01 09:27:52', 1, NULL, 80.00);
INSERT INTO `house` VALUES (2, NULL, '402', 1, '2020-11-04 16:00:00', 7, '', 90.00);
INSERT INTO `house` VALUES (3, NULL, '201', 1, '2020-11-17 15:52:58', 1, NULL, 100.00);
INSERT INTO `house` VALUES (4, NULL, '602', 1, '2021-05-05 16:00:00', 11, '', 98.00);
INSERT INTO `house` VALUES (5, NULL, '405', 1, '2022-02-27 16:00:00', 1, '', 100.00);
-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`topic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主题',
`content` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`fbr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`fbdate` datetime(0) NULL DEFAULT NULL,
`remarks` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (1, '测试主题1', '测试内容太1', 'admin', '2022-02-27 16:00:00', '');
-- ----------------------------
-- Table structure for owner
-- ----------------------------
DROP TABLE IF EXISTS `owner`;
CREATE TABLE `owner` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`tel` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`identity` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`house_id` int(11) NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`password` varchar(28) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of owner
-- ----------------------------
INSERT INTO `owner` VALUES (1, 'mary', '15270892323', '女', '433123456787', 1, NULL, '12345');
INSERT INTO `owner` VALUES (2, 'yx5411', '13767134678', '男', '433123456788', 2, NULL, '12345');
INSERT INTO `owner` VALUES (9, 'yx7845', '15270839876', '男', '587968932', 4, '', '123456');
-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`numbers` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` int(11) NULL DEFAULT NULL,
`owner_id` int(11) NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of parking
-- ----------------------------
INSERT INTO `parking` VALUES (1, 'A10001', 1, 1, '');
INSERT INTO `parking` VALUES (2, 'A10002', 1, 2, '');
-- ----------------------------
-- Table structure for property_info
-- ----------------------------
DROP TABLE IF EXISTS `property_info`;
CREATE TABLE `property_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type_id` int(11) NULL DEFAULT NULL,
`money` double(10, 2) NULL DEFAULT NULL,
`start_date` datetime(0) NULL DEFAULT NULL,
`end_date` datetime(0) NULL DEFAULT NULL,
`status` int(2) NULL DEFAULT NULL,
`house_id` int(11) NULL DEFAULT NULL,
`remarks` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of property_info
-- ----------------------------
INSERT INTO `property_info` VALUES (1, 2, 900.00, '2020-10-01 09:28:11', '2020-12-29 16:00:00', 1, 1, '啊水水');
INSERT INTO `property_info` VALUES (4, 1, 208.00, '2020-09-30 16:00:00', '2020-12-30 16:00:00', 1, 1, '物业费');
INSERT INTO `property_info` VALUES (5, 3, 100.00, '2020-11-13 16:00:00', '2020-11-13 16:00:00', 1, 1, 'wu ');
INSERT INTO `property_info` VALUES (23, 1, 208.00, '2020-09-30 16:00:00', '2020-12-30 16:00:00', 0, 1, 'ceshi');
INSERT INTO `property_info` VALUES (24, 1, 234.00, '2020-09-30 16:00:00', '2020-12-30 16:00:00', 0, 2, 'ceshi');
INSERT INTO `property_info` VALUES (32, 1, 208.00, '2022-02-24 16:00:00', '2022-05-26 16:00:00', 0, 1, '555');
INSERT INTO `property_info` VALUES (36, 1, 208.00, '2022-02-24 16:00:00', '2022-05-26 16:00:00', 0, 1, '111');
INSERT INTO `property_info` VALUES (37, 1, 234.00, '2022-02-24 16:00:00', '2022-05-26 16:00:00', 0, 2, '111');
INSERT INTO `property_info` VALUES (39, 1, 254.80, '2022-02-24 16:00:00', '2022-05-26 16:00:00', 0, 4, '111');
INSERT INTO `property_info` VALUES (40, 3, 20.00, '2022-02-24 16:00:00', '2022-02-24 16:00:00', 0, 1, 'ww');
-- ----------------------------
-- Table structure for property_type
-- ----------------------------
DROP TABLE IF EXISTS `property_type`;
CREATE TABLE `property_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`price` double(10, 2) NULL DEFAULT NULL,
`unit` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of property_type
-- ----------------------------
INSERT INTO `property_type` VALUES (1, '物业费', 2.60, '一平方', NULL);
INSERT INTO `property_type` VALUES (2, '水费', 4.50, '一吨', NULL);
INSERT INTO `property_type` VALUES (3, '电费', 0.50, '一度', NULL);
INSERT INTO `property_type` VALUES (4, '车位费', 260.00, '一个', NULL);
-- ----------------------------
-- Table structure for records
-- ----------------------------
DROP TABLE IF EXISTS `records`;
CREATE TABLE `records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type_id` int(11) NULL DEFAULT NULL,
`num` double(5, 2) NULL DEFAULT NULL,
`num2` double(5, 2) NULL DEFAULT NULL,
`house_id` int(11) NULL DEFAULT NULL,
`up_time` datetime(0) NULL DEFAULT NULL,
`on_time` datetime(0) NULL DEFAULT NULL,
`check_time` datetime(0) NULL DEFAULT NULL,
`meter` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of records
-- ----------------------------
INSERT INTO `records` VALUES (1, 2, 200.00, 300.00, 1, '2020-10-01 09:28:11', '2020-11-06 09:28:16', '2020-11-12 09:28:23', '张三', '无');
INSERT INTO `records` VALUES (2, 2, 100.00, 200.00, 1, '2020-09-23 10:34:48', '2020-10-31 10:34:57', '2020-10-30 10:35:05', 'yx', '');
INSERT INTO `records` VALUES (9, 3, 0.00, 123.00, 4, '2021-05-05 16:00:00', '2021-05-05 16:00:00', '2021-05-06 13:48:56', 'zhangsan', '');
INSERT INTO `records` VALUES (10, 3, 0.00, 40.00, 1, '2022-02-24 16:00:00', '2022-02-24 16:00:00', '2022-02-25 13:56:22', 'yx5411', 'ww');
-- ----------------------------
-- Table structure for repair
-- ----------------------------
DROP TABLE IF EXISTS `repair`;
CREATE TABLE `repair` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`com_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`com_date` datetime(0) NULL DEFAULT NULL,
`handle_date` datetime(0) NULL DEFAULT NULL,
`owner_id` int(11) NULL DEFAULT NULL,
`status` int(2) NULL DEFAULT NULL,
`clr` int(11) NULL DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of repair
-- ----------------------------
INSERT INTO `repair` VALUES (1, '1', '2020-11-19 11:47:37', '2020-11-21 11:47:41', 1, 1, 1, '11');
INSERT INTO `repair` VALUES (2, '1', '2020-11-18 11:48:02', '2020-11-27 11:48:06', 1, 0, 1, '11');
INSERT INTO `repair` VALUES (3, '2', '2020-11-10 11:48:45', '2020-11-27 11:48:48', 1, 1, 1, '11');
INSERT INTO `repair` VALUES (4, '3', '2020-11-11 14:56:31', '2020-11-27 14:56:35', 1, 0, 1, '22');
INSERT INTO `repair` VALUES (6, '3', '2020-11-11 14:56:31', '2020-11-22 06:14:52', 1, 0, 1, '22');
INSERT INTO `repair` VALUES (7, '3', '2020-11-11 14:56:31', '2020-11-27 14:56:35', 1, 1, 1, '22');
INSERT INTO `repair` VALUES (8, '4', '2020-11-23 10:00:07', '2020-11-25 10:00:13', 1, 1, 1, '33');
INSERT INTO `repair` VALUES (9, '4', '2020-11-23 10:00:07', '2020-11-25 10:00:13', 2, 1, 1, '33');
INSERT INTO `repair` VALUES (10, '4', '2020-11-23 10:00:07', '2020-11-25 10:00:13', 1, 1, 1, '33');
INSERT INTO `repair` VALUES (13, '7', '2020-11-05 10:00:59', '2020-11-28 10:01:03', 1, 1, 1, '22');
INSERT INTO `repair` VALUES (14, '3', '2021-04-29 10:54:02', NULL, 2, 0, NULL, '电梯坏了');
-- ----------------------------
-- Table structure for repairtype
-- ----------------------------
DROP TABLE IF EXISTS `repairtype`;
CREATE TABLE `repairtype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remarks` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of repairtype
-- ----------------------------
INSERT INTO `repairtype` VALUES (1, '公共部位维修', NULL, 1);
INSERT INTO `repairtype` VALUES (2, '共用设施设备 ', NULL, 1);
INSERT INTO `repairtype` VALUES (3, '电梯', NULL, 1);
INSERT INTO `repairtype` VALUES (4, '自用部位维修', NULL, 1);
INSERT INTO `repairtype` VALUES (5, '门窗维修', NULL, 1);
INSERT INTO `repairtype` VALUES (6, '电话维修', NULL, 1);
INSERT INTO `repairtype` VALUES (7, '电路维修', NULL, 1);
-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`type` int(11) NULL DEFAULT NULL,
`remarks` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES (1, 'admin', '123456', 1, NULL);
INSERT INTO `userinfo` VALUES (2, 'yx5411', '123456', 0, NULL);
INSERT INTO `userinfo` VALUES (3, 'mary', '123456', 0, NULL);
INSERT INTO `userinfo` VALUES (12, 'yx7845', '123456', 0, '');
SET FOREIGN_KEY_CHECKS = 1;
六、系统页面展示
视频展示
图片展示
业主
管理员
结语
以上便是本系统基本概览，本 专栏介绍源码均亲测运行可用，部分源码有偿获取。
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
