I
百色学院创新实践学分认定系统设计与实现
摘 要
本百色学院创新实践学分认定系统是针对目前实践学分认定的实际需求，从实际工
作出发，对过去的实践学分认定系统存在的问题进行分析，结合计算机系统的结构、概
念、模型、原理、方法，在计算机各种优势的情况下，采用目前最流行的 B/S 结构和 java
中流行的 MVC 三层设计模式和 eclipse 编辑器、MySQL 数据库设计并实现的 。本实践
学分认定系统主要包括系统用户管理模块、教师信息管理模块、申报信息管理、留言管
理、登录模块、和退出模块等多个模块。它帮助实践学分认定实现了信息化、网络化，
通过测试，实现了系统设计目标，相比传统的管理模式，本系统合理的利用了实践学分
认定数据资源，有效的减少了实践学分认定的经济投入，大大提高了实践学分认定的效
率。
关键词：实践学分认定；MVC 模式；MySQL 数据库
II
ABSTRACT
The innovation practice credit recognition system of Ben-Baise College is based on the
actual needs of the current practice credit recognition. From the actual work, the problems
existing in the past practice credit recognition system are analyzed, and the structure, concept,
model, principle, and method of the computer system are combined. Under the various
advantages of the computer, the most popular B/S structure and the popular MVC three-layer
design model in Java and the clipse editor, MySQL database design and implementation are
used. This practice credit recognition system mainly includes system user management
module, teacher information management module, report information management, message
management, login module, and exit module. It has helped practice credit recognition to
realize informatization and networking, and has achieved the goal of system design through
testing. Compared with the traditional management model, the system has reasonably used the
data resources of practice credit recognition, and effectively reduced the economic investment
of practice credit recognition. Has greatly improved the efficiency of practice credit
recognition.
key words：Practice Credit Recognition; MVC mode; MySQL database
III
目 录
百色学院创新实践学分认定系统设计与实现 .................................................................I
摘 要 ...................................................................................................................................I
ABSTRACT ........................................................................................................................I
目 录...............................................................................................................................III
第 1 章 绪论.......................................................................................................................1
1.1 开发背景................................................................................................................1
1.2 开发意义................................................................................................................1
1.3 研究内容................................................................................................................1
第 2 章 主要技术和工具介绍...........................................................................................1
2.1 JSP 语言.................................................................................................................1
2.2 MySQL 数据库...................................................................................................1
2.3 jsp 技术 ..................................................................................................................2
2.4ssm 简介 .................................................................................................................3
第 3 章 系统分析...............................................................................................................1
3.1 可行性分析............................................................................................................1
3.1.1 经济可行性..................................................................................................1
3.1.2 技术可行性..................................................................................................1
3.1.3 操作可行性..................................................................................................1
3.2 需求分析................................................................................................................1
3.3 业务流程分析........................................................................................................2
3.4 数据流程分析........................................................................................................3
第 4 章 系统设计...............................................................................................................5
4.1 系统结构设计........................................................................................................5
4.2 功能模块设计........................................................................................................5
IV
4.3 数据库设计............................................................................................................6
4.3.1 数据库设计概述..........................................................................................6
4.3.1 概念设计......................................................................................................6
4.3.2 表设计..........................................................................................................7
第 5 章 系统实现...........................................................................................................11
5.1 基本任务..............................................................................................................11
5.2 登录模块的实现..................................................................................................11
5.2.1 首页实现....................................................................................................11
5.2.2 管理员后台登录........................................................................................12
5.3 用户模块的实现..................................................................................................15
5.3.1 注册模块及登录的实现............................................................................15
5.2.2 留言模块的实现........................................................................................17
5.2.3 申报模块的实现........................................................................................18
5.4 管理员模块的实现..............................................................................................20
5.4.1 用户管理模块的实现................................................................................20
5.4.2 通知公告管理模块的实现........................................................................22
5.4.3 申报信息管理模块的实现........................................................................24
5.4.5 教师信息管理实现....................................................................................26
第 6 章 系统测试...........................................................................................................28
6.1 测试目的..............................................................................................................28
6.2 测试概述..............................................................................................................28
6.3 单元测试..............................................................................................................28
6.3.1 注册测试....................................................................................................28
6.3.2 登录测试....................................................................................................29
6.4 集成测试..............................................................................................................30
V
第 7 章 总结...................................................................................................................31
致 谢...............................................................................................................................32
参考文献...........................................................................................................................32
