毕业设计——基于JavaEE采用MVC模式结合SSM框架进行实现，小区物业管理系统

介绍

基于JavaEE小区物业管理系统，项目采用MVC模式结合SSM框架进行实现，前端页面使用Bootstrap进行实现。

功能

用户端

• (1)业主信息查询
• (2)房产信息查询
• (3)公告查询管理
• (4)收费管理
• (5)报修管理
• (6)修改用户密码

物业端

• (1)管理员信息管理，包括对管理员的增加、删除 、修改等
• (2)完善的用户信息，包括用户信息的录入、查询、修改等
• (3)房产信息管理，包括房产信息的录入、查询、修改等。
• (4)公告信息管理，包括公告信息的录入、查询、修改等。
• (5)报修管理，包括用户报修信息的录入、查询、修改等。
• (6)保安清洁，包括保安和清洁人员信息的录入、查询、修改等。

本系统的使用者分为用户（业主）和管理员（物业）两类，根据使用者不同，将有不同的主页，对应不同的功能权限。将本系统分为用户子系统和管理员子系统。
在用户子系统中，使用者通过账号密码（用户）登入系统，进入主页，通过主页链接，进入小区公告，业主信息查询，房产信息，收费管理，系统功能五个功能模块，在模块内可以完成报修，查看公告，查询房产相关信息，查询业主信息，查询缴费信息，修改密码，退出系统功能等。
在管理员子系统中，使用者通过帐号密码（管理员）登入系统，进入主页，通过主页链接进入管理员信息管理，物业管理，报修管理，保安保洁，公告管理，收费管理，系统功能七个功能模块：在管理员信息管理中可以对管理员使用者的信息进行管理；在物业管理模块中，可以对房产信息和业主信息进行管理；在报修管理中，可以查看报修记录并安排维修人员；在保安保洁模块中，可以对保安保洁模块中，可以对保安或保洁员的工作进行安排和记录；在公告管理模块中，可以发布公告，查看历史公告；在系统功能模块中可以进行密码管理和退出系统

运行环境

• jdk： 建议1.8以上。
• tomcat： 8.5版本（9以上有js文件乱码的现象，，还没搞明白什么情况0.0）
• 编写环境：Eclipse
• 数据库：Mysql

程序设置

• 配置mysql数据库链接信息

部署说明

• conf.xml是MyBatis核心配置文件，所有SQL语句统一放在userMapper.xml。（SQL语句不涉及多表查询）

SQL部分

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : management_room

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 13/08/2020 14:34:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `age` double NOT NULL,
  `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `addr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `memo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (12, 'admin', '4QrcOUm6Wau+VuBX8g+IPg==', '男', 30, '12233', '123', '123', '123');
INSERT INTO `admin` VALUES (20, '赵越超', '4QrcOUm6Wau+VuBX8g+IPg==', '男', 20, '66', '555', 'dd', '22');
INSERT INTO `admin` VALUES (36, '张三', '4QrcOUm6Wau+VuBX8g+IPg==', '男', 20, '111', '222', '333', '444');
INSERT INTO `admin` VALUES (42, '李四', '4QrcOUm6Wau+VuBX8g+IPg==', '男', 30, '', '', 'dddd', '');
INSERT INTO `admin` VALUES (43, 'vvvvvvvvvv', '4QrcOUm6Wau+VuBX8g+IPg==', '男', 30, '', '', 'ffffffffff', '');

-- ----------------------------
-- Table structure for charge
-- ----------------------------
DROP TABLE IF EXISTS `charge`;
CREATE TABLE `charge`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `metre` double NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `sdate` date NOT NULL,
  `rdate` date NULL DEFAULT NULL,
  `tcost` double NOT NULL,
  `scost` double NOT NULL,
  `smemo` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of charge
-- ----------------------------
INSERT INTO `charge` VALUES (1, 110, '赵越超02', '222222', '赵越超', '未支付', '2019-06-27', '2019-07-14', 2500, 3200, '021313');
INSERT INTO `charge` VALUES (2, 120, '赵越超01', '66666', '赵越超', '正在处理', '2019-06-26', '0000-00-00', 2500, 2000, '无');
INSERT INTO `charge` VALUES (3, 120, '赵越超03', '58888', '赵越超', '未支付', '2019-07-11', '0000-00-00', 8500, 8500, '220');
INSERT INTO `charge` VALUES (5, 6525, '赵越超04', '33333', '赵越超', '未支付', '2020-04-08', '0000-00-00', 62, 90, '9999');
INSERT INTO `charge` VALUES (7, 66, '55', '88', 'ggg', '未支付', '2020-04-15', '0000-00-00', 21, 33, '');
INSERT INTO `charge` VALUES (8, 3333, '赵越超07', '赵越超', '方法', '未支付', '2020-04-10', '0000-00-00', 66, 99, '');
INSERT INTO `charge` VALUES (12, 55, '赵越超06', '66', '赵越超', '未支付', '2020-04-09', '0000-00-00', 66, 66, '');
INSERT INTO `charge` VALUES (14, 66, '555', '66', '66', '未支付', '2020-04-16', '0000-00-00', 66, 99, '');
INSERT INTO `charge` VALUES (15, 66, '66', '66', '66', '未支付', '2020-04-10', '0000-00-00', 66, 66, '');
INSERT INTO `charge` VALUES (16, 20, '赵越超05', '20', '赵越超', '未支付', '2020-04-08', '0000-00-00', 55, 66, '');
INSERT INTO `charge` VALUES (17, 100, '赵越超', '10086', '赵越超', '未支付', '2020-04-01', '0000-00-00', 1234, 500, '无');

-- ----------------------------
-- Table structure for custom_account
-- ----------------------------
DROP TABLE IF EXISTS `custom_account`;
CREATE TABLE `custom_account`  (
  `accountid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ownerid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `carid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`accountid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of custom_account
-- ----------------------------
INSERT INTO `custom_account` VALUES (11, '赵越超', '4QrcOUm6Wau+VuBX8g+IPg==', '100000', '10086');
INSERT INTO `custom_account` VALUES (12, '赵越超1', '4QrcOUm6Wau+VuBX8g+IPg==', '100001', '');
INSERT INTO `custom_account` VALUES (13, '赵越超2', '4QrcOUm6Wau+VuBX8g+IPg==', '100002', '');
INSERT INTO `custom_account` VALUES (14, '赵越超3', '4QrcOUm6Wau+VuBX8g+IPg==', '100003', '');
INSERT INTO `custom_account` VALUES (15, '赵越超4', '4QrcOUm6Wau+VuBX8g+IPg==', '100004', '');

-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `dep` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `area` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sell` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `floor` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `direction` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `memo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ownerid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES (4, '601', '1号楼', '小高层', '和风区', '已售', '五单元', '3', '南', '无', '100000');
INSERT INTO `house` VALUES (5, '201', '2号楼', '多层', '和风区', '已售', '五单元', '4', '西', '无', '100000');
INSERT INTO `house` VALUES (6, '402', '3号楼', '小高层', '和风区', '已售', '八单元', '4', '南', '', '100002');

-- ----------------------------
-- Table structure for inspection
-- ----------------------------
DROP TABLE IF EXISTS `inspection`;
CREATE TABLE `inspection`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `itime` date NOT NULL,
  `conductor` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `party` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `result` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `memo` varchar(100) 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 inspection
-- ----------------------------
INSERT INTO `inspection` VALUES (1, '赵越超', '一级', '2019-08-02', '赵越超', '赵越超', '五', '啦啦啦啦啦啦啦啦啦啦啦啦3');
INSERT INTO `inspection` VALUES (2, '赵越超', '四级', '2020-04-16', '赵越超', '赵越超', '发现小偷一名', '');
INSERT INTO `inspection` VALUES (3, '赵越超', '四级', '2020-04-09', '赵越超', '赵越超', '无', '');
INSERT INTO `inspection` VALUES (4, '赵越超', '四级', '2020-04-01', '赵越超', '赵越超', '发现小区大门没关好', '');

-- ----------------------------
-- Table structure for maintain
-- ----------------------------
DROP TABLE IF EXISTS `maintain`;
CREATE TABLE `maintain`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thing` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `homesnumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sdate` date NOT NULL,
  `rdate` date NULL DEFAULT NULL,
  `tcost` double NOT NULL,
  `scost` double NULL DEFAULT NULL,
  `maintainer` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `smemo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of maintain
-- ----------------------------
INSERT INTO `maintain` VALUES (1, '大门', '正在处理', '10086', '2019-07-10', '2019-07-12', 8500, 5820, '赵越超', '');
INSERT INTO `maintain` VALUES (2, '大门', '等待处理', '201', '2019-07-03', '2019-07-06', 6200, 66663, '赵越超', '');
INSERT INTO `maintain` VALUES (3, '大门', '正在处理', '201', '2019-07-03', '2019-07-13', 250, 360, '赵越超', '');
INSERT INTO `maintain` VALUES (5, '把手', '等待处理', '201', '2019-07-11', '2020-04-13', 690, 0, '赵越超', '');
INSERT INTO `maintain` VALUES (6, '把手', '等待处理', '201', '2019-07-11', '0000-00-00', 63, 3, '赵越超', '');
INSERT INTO `maintain` VALUES (7, '把手', '等待处理', '401', '2019-07-11', '0000-00-00', 12, 5, '赵越超', '');
INSERT INTO `maintain` VALUES (8, '把手', '等待处理', '401', '2019-07-11', '0000-00-00', 26, 4, '赵越超', '');
INSERT INTO `maintain` VALUES (10, '把手', '等待处理', '401', '2019-07-11', '0000-00-00', 22, 6, '赵越超', '');
INSERT INTO `maintain` VALUES (11, 'jklo', '等待处理', '123', '2019-07-11', NULL, 200, 0, '赵五', '');
INSERT INTO `maintain` VALUES (13, '楼梯把手', '已完成', '203', '2019-08-06', '2019-08-09', 850, 500, '赵越超', '1号楼3单元2层楼梯把手坏了');
INSERT INTO `maintain` VALUES (14, '暖气', '正在处理', '201', '2019-08-02', '2019-08-09', 1234, 500, '赵越超', '暖气漏水');
INSERT INTO `maintain` VALUES (15, '二而呃呃', '等待处理', '123', '2019-08-01', NULL, 1234, 0, '李四', '无');
INSERT INTO `maintain` VALUES (17, 'ffffff', '等待处理', '123', '2019-08-01', NULL, 98520, 0, '李四', '32');
INSERT INTO `maintain` VALUES (19, '大米', '等待处理', '6980', '2020-04-13', NULL, 6800, NULL, '张三', '嘻嘻嘻嘻嘻嘻嘻嘻');
INSERT INTO `maintain` VALUES (26, 'kkkkkk', '等待处理', '9852', '2020-04-10', '0000-00-00', 30, NULL, '999', '');
INSERT INTO `maintain` VALUES (27, '哈哈哈7', '等待处理', '985', '2020-04-15', '0000-00-00', 825, NULL, '9666', '');

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ndate` date NOT NULL,
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `uper` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (4, '2020年04月01日23：00—4月02日06：30进行停电\r\n停电范围：1号楼到10号楼进行停电。\r\n停电原因：设备维修；', '2020-04-01', '2020年4月01日停电通知', '赵越超');
INSERT INTO `notice` VALUES (5, '请没有缴纳物业费的居民进行物业费缴纳。', '2020-04-02', '2020年4月02日物业费', '赵越超');
INSERT INTO `notice` VALUES (6, '2020年04月24日23：00—4月25日06：30\r\n停水范围：1号楼到10号楼\r\n停水原因：设备维修；', '2020-04-03', '2020年4月0日停水通知', '赵越超');

SET FOREIGN_KEY_CHECKS = 1;