I
社区住户信息管理系统设计与实现
摘 要
本社区住户信息管理系统是针对目前平台的实际需求，从实际工作出发，对过去的
社区住户信息管理系统存在的问题进行分析，结合计算机系统的结构、概念、模型、原
理、方法，在计算机各种优势的情况下，采用目前最流行的 ssm 框架和 eclipse 编辑器、
mysql 数据库设计并实现的 。本社区住户信息管理系统主要包括登录模块、站内新闻管
理模块、报修与投诉管理模块、短信信息管理模块、和退出模块等多个模块。它帮助社
区住户信息管理实现了信息化、网络化，通过测试，实现了系统设计目标，相比传统的
管理模式，本系统合理的利用了网络数据资源，有效的减少了社区住户信息管理的经济
投入，大大提高了社区住户信息管理的效率。
关键词：ssm；mysql；社区住户信息管理系统
II
ABSTRACT
The community household information management system is based on the actual needs
of the current platform. Starting from the actual work, the problems existing in the past
community household information management system are analyzed, and the structure,
concept, model, principle, and method of the computer system are combined with various
advantages of the computer system. Under the circumstances, Designed and implemented
using the most popular SSM framework and eclipse editor and MySQL database. The
community household information management system mainly includes the login module, the
station news management module, the report repair and complaint management module, the
SMS information management module, and the exit module. It has helped community
household information management to realize informatization and networking. Through
testing, it has achieved the goal of system design. Compared with the traditional management
model, the system has reasonably used network data resources and effectively reduced the
economic investment in community household information management. Significant
efficiency in community household information management.
KEY WORDS：ssm;mysql;Community Household Information Management System
III
目 录
摘 要 ...................................................................................................................................I
ABSTRACT ........................................................................................................................I
目 录...............................................................................................................................III
第 1 章 绪论.......................................................................................................................1
1.1 开发背景................................................................................................................1
1.2 开发意义................................................................................................................1
1.3 研究内容................................................................................................................1
第 2 章 主要技术和工具介绍...........................................................................................2
2.1 SSM 框架..............................................................................................................2
2.1.1. Spring 框架 ................................................................................................2
2.1.2 SpringMVC..................................................................................................3
2.1.3. MyBatis 的选用.........................................................................................3
2.2 mysql 数据库.........................................................................................................3
2.3 eclipse 与 Tomcat 简介 .........................................................................................5
第 3 章 系统分析...............................................................................................................4
3.1 可行性分析............................................................................................................4
3.1.1 经济可行性..................................................................................................4
3.1.2 技术可行性..................................................................................................4
3.1.3 操作可行性..................................................................................................4
3.2 需求分析................................................................................................................4
3.3 业务流程分析........................................................................................................5
3.4 数据流程分析........................................................................................................6
第 4 章 系统设计...............................................................................................................8
4.1 系统结构设计........................................................................................................8
IV
4.2 功能模块设计........................................................................................................8
4.3 数据库设计............................................................................................................9
4.3.1 数据库设计概述..........................................................................................9
4.3.1 概念设计......................................................................................................9
4.3.2 表设计........................................................................................................11
第 5 章 系统实现...........................................................................................................16
5.1 基本论坛..............................................................................................................16
5.2 主页面的实现......................................................................................................16
5.3 注册模块的实现..................................................................................................16
5.3 登录模块的实现..................................................................................................17
5.4 站内新闻管理模块的实现..................................................................................19
5.6 报修信息管理模块的实现..................................................................................20
5.6 投诉信息管理模块的实现..................................................................................21
5.7 住户信息管理模块的实现..................................................................................22
5.8 短信信息管理模块的实现..................................................................................23
5.9 论坛模块的实现..................................................................................................24
第 6 章 系统测试...........................................................................................................27
6.1 测试目的..............................................................................................................27
6.2 测试概述..............................................................................................................27
6.3 单元测试..............................................................................................................27
6.3.1 登录测试....................................................................................................27
6.3.2 站内新闻测试............................................................................................28
6.4 集成测试..............................................................................................................29
第 7 章 总结...................................................................................................................30
致 谢...............................................................................................................................31
