基于springboot mybatis物业管理系统源码java物业管理系统

最新推荐文章于 2024-06-15 23:42:03 发布

q_q1262330535

最新推荐文章于 2024-06-15 23:42:03 发布

阅读量350

点赞数

分类专栏： springboot 计算机毕业设计文章标签： java eclipse 数据库

本文链接：https://blog.csdn.net/q_q1262330535/article/details/120012922

版权

计算机毕业设计同时被 2 个专栏收录

910 篇文章 110 订阅

订阅专栏

springboot

154 篇文章 1 订阅

订阅专栏

技术：springboot mybatis eclipse mysql

登录地址：

http://localhost:8080/user/login

角色：

物业管理员 ：admin  123456 

普通业主用户：aa  111111

实际账号密码以数据库表user为准

##开发环境

工具： eclipse或idea mysql5.X jdk1.8

技术：springboot mybatis 前端jsp

在eclipse中如何导入springboot项目

截图：
在这里插入图片描述

数据库：
CREATE TABLE car (
id int(11) NOT NULL AUTO_INCREMENT,
plateNum varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT ‘车牌号’,
parkNum int(11) DEFAULT NULL COMMENT ‘停车位号码’,
brand varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘品牌’,
color varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘颜色’,
startTime varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘入驻时间’,
serialNumber varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘序列号’,
endTime varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘迁出时间’,
userId int(11) DEFAULT NULL COMMENT ‘用户id’,
realName varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘真实姓名’,
roomId int(11) DEFAULT NULL COMMENT ‘户号’,
status int(255) DEFAULT NULL COMMENT ‘状态’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

– Records of car

INSERT INTO car VALUES (‘1’, ‘京P456V4’, ‘1’, ‘现代’, ‘白色’, ‘2018-12-01 11:28:55’, ‘1111111111’, ‘2017-12-31 11:29:01’, ‘1’, ‘admin’, ‘1’, ‘0’);
INSERT INTO car VALUES (‘2’, ‘鲁C520GF’, ‘2’, ‘玛莎拉蒂’, ‘黑色’, ‘2019-02-24 11:32:41’, ‘1111111112’, ‘2018-02-24 11:32:45’, ‘3’, ‘王五’, ‘3’, ‘0’);
INSERT INTO car VALUES (‘3’, ‘京A111AA’, ‘3’, ‘宝马’, ‘棕色’, ‘2019-02-24 11:32:41’, ‘1111111113’, ‘2018-02-24 11:32:45’, ‘2’, ‘赵四’, ‘2’, ‘0’);
INSERT INTO car VALUES (‘4’, ‘鲁A1314A’, ‘4’, ‘奔驰’, ‘白色’, ‘2019-02-27 11:37:38’, ‘1111111114’, ‘2019-01-27 11:37:52’, ‘5’, ‘乐富’, ‘4’, ‘1’);
INSERT INTO car VALUES (‘10’, ‘鲁A1314G’, ‘10’, ‘凯迪拉克’, ‘红色’, ‘2019-01-27 13:12:12’, ‘1111111115’, ‘2022-01-27 13:12:12’, ‘9’, ‘乐富支付’, ‘5’, ‘1’);
INSERT INTO car VALUES (‘11’, ‘鲁A00000’, ‘11’, ‘法拉利’, ‘红色’, ‘2019-01-27 00:00:00’, ‘1111111116’, ‘2022-01-27 00:00:00’, ‘12’, ‘企鹅’, ‘5’, ‘0’);

– Table structure for complain

DROP TABLE IF EXISTS complain;
CREATE TABLE complain (
id int(11) NOT NULL AUTO_INCREMENT,
createTime varchar(222) COLLATE utf8_bin DEFAULT NULL COMMENT ‘创建时间’,
userId int(11) DEFAULT NULL COMMENT ‘用户id’,
realName varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘真实姓名’,
phone varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘手机’,
dealTime varchar(22) COLLATE utf8_bin DEFAULT NULL COMMENT ‘处理时间’,
operaterName varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘处理人姓名’,
operaterUserId int(11) DEFAULT NULL COMMENT ‘处理人用户id’,
content varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘投诉内容’,
agreement int(11) DEFAULT NULL COMMENT ‘是否接受’,
status varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT ‘状态’,
comments varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘回复内容或者备注’,
updateTime varchar(222) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

– Records of complain

INSERT INTO complain VALUES (‘1’, ‘2017-02-15 15:52:26’, ‘2’, ‘赵四’, ‘18429375837’, ‘2019-02-16 00:00:00’, ‘admin’, ‘1’, ‘绿化不完善’, ‘1’, ‘已处理’, ‘会尽快解决’, ‘2017-02-16 10:57:15’);
INSERT INTO complain VALUES (‘7’, ‘2017-02-16 13:45:23’, ‘3’, ‘王五’, ‘18364738463’, ‘2019-02-17 00:00:00’, ‘admin’, ‘1’, ‘小区流浪狗多’, ‘1’, ‘已处理’, ‘会尽快解决’, ‘2017-02-17 11:17:28’);
INSERT INTO complain VALUES (‘10’, ‘2017-02-22 15:25:09’, ‘3’, ‘王五’, ‘18364738463’, ‘2019-02-22 00:00:00’, ‘admin’, ‘1’, ‘楼道不卫生’, ‘1’, ‘已处理’, ‘会尽快解决’, ‘2017-02-22 17:20:09’);
INSERT INTO complain VALUES (‘32’, ‘2017-03-02 12:03:43’, ‘9’, ‘乐富支付’, ‘18638217282’, ‘2019-03-02 00:00:00’, ‘admin’, ‘1’, ‘楼道不卫生’, ‘1’, ‘已处理’, ‘会尽快解决’, ‘2017-03-02 12:04:19’);
INSERT INTO complain VALUES (‘41’, ‘2017-03-02 18:00:39’, ‘9’, ‘乐富支付’, ‘18638217282’, ‘2019-11-08 10:11:12’, ‘admin’, ‘1’, ‘处理’, ‘1’, ‘已处理’, ‘qqq’, ‘2019-09-08 10:11:12’);
INSERT INTO complain VALUES (‘42’, ‘2017-03-02 18:01:39’, ‘9’, ‘乐富支付’, ‘18638217282’, ‘2019-03-03 00:00:00’, ‘admin’, ‘1’, ‘吃了’, ‘1’, ‘已处理’, ‘好的’, ‘2017-03-03 17:01:41’);
INSERT INTO complain VALUES (‘43’, ‘2019-09-08 11:03:50’, ‘3’, ‘王五’, ‘18638217283’, null, null, null, ‘邻居是坏人’, null, ‘等待处理’, null, null);

– Table structure for equipment

DROP TABLE IF EXISTS equipment;
CREATE TABLE equipment (
id int(11) NOT NULL AUTO_INCREMENT,
equipmentName varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘设备名称’,
location varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘位置’,
serialNumber varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘序列号’,
boughtDate varchar(222) COLLATE utf8_bin DEFAULT NULL COMMENT ‘购买日期’,
type varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘型号’,
brand varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘品牌’,
status varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT ‘状态’,
conditiona varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘使用状况’,
createTime varchar(222) COLLATE utf8_bin DEFAULT NULL COMMENT ‘创建时间’,
price decimal(10,0) DEFAULT NULL COMMENT ‘价格’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;