毕 业 设 计（论 文）
题目：在线画展系统设计与实现
I
摘 要
互联网发展到如今也近 20 年之久，在线画展系统一直作为互联网发展中的
一个重要角色在不断更新进化。在线画展系统从最初的文本显示到现在集文字、
视频、音频与一体，成为一种网络多媒体浏览网站。作为一种媒体传输媒介，在
线画展系统如今也分各个类别，各种形式。本文着重对在线画展系统进行分析和
研究，浅析在线画展系统的现状和存在的一些问题并对此进行研究，通过对问题
和现状的分析研究和对用户需求的一个简单整理建模，设计并且实现一个在线画
展系统。
在线画展系统采用的开发框架为 SSM 框架，也就是 Spring mvc、Spring、
MyBatis 这三个框架，页面设计用的是 jsp 技术作为动态页面文件设计，jsp 文件
里可以对实现 html 等界面布局的代码，采用 SpringMVC 替代传统的 struts2 框架，
主要对 jsp 访问的拦截和控制，Spring 作为整个控制的核心，通过控制反转技术
和面向切面技术，让 Spring 自动对使用的类文件进行调用和导入，MyBatis 主要
作为底层操作数据库，不牵扯业务逻辑，开发工具采用 Eclipse，服务器用的是
tomcat。编码语言是 Java，数据库采用 Mysql。
关键词：在线画展系统；Java；MySQL；SSM 框架；VUE 框架
II
Abstract
It has been nearly 20 years since the development of the Internet, and the online art
exhibition system has been constantly updating and evolving as an important role in
the development of the Internet. From the initial text display, the online art exhibition
system now integrates text, video, and audio, and becomes a network multimedia
browsing website. As a media transmission medium, online art exhibition systems are
now divided into various categories and forms. This article focuses on the analysis
and research of the online art exhibition system, analyzes the current situation of the
online art exhibition system and some existing problems, and conducts research on it.
Through the analysis and research of the problems and the status quo, and a simple
modeling of user needs, design and Realize an online painting exhibition system.
The development framework adopted by the online art exhibition system is the SSM
framework, that is, Spring mvc, Spring, and MyBatis. The page design uses jsp
technology as a dynamic page file design. The code that implements the interface
layout such as html can be used in the jsp file. Using SpringMVC instead of the
traditional struts2 framework, it mainly intercepts and controls JSP access. Spring is
the core of the entire control. Through the inversion of control technology and the
aspect-oriented technology, Spring can automatically call and import the used class
files. MyBatis is mainly used as The underlying operation database does not involve
business logic, the development tool uses Eclipse, and the server uses tomcat. The
coding language is Java, and the database uses Mysql.
Key Words ： Online painting exhibition system; Java; MySQL; SSM framework;
VUE framework
III
目 录
目 录 ..............................................III
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................4
2.1 SSM 框架介绍 .................................................................................................4
2.2 B/S 架构介绍 ...................................................................................................4
2.3 MYSQL 数据库介绍........................................................................................5
2.4 JAVA 语言介绍 ...............................................................................................6
2.5 VUE 框架 .........................................................................................................6
3 系统分析............................................7
3.1 系统可行性分析 ..............................................................................................7
3.1.1 技术可行性分析 ..................................................................................7
3.1.2 经济可行性分析 ..................................................................................7
3.1.3 运行可行性分析 ..................................................................................7
3.2 系统性能分析 ..................................................................................................8
3.2.1 系统安全性 ..........................................................................................8
3.2.2 数据完整性 ..........................................................................................8
3.2.3 系统可扩展性 .......................................................................................9
3.3 系统流程分析 ..................................................................................................9
3.3.1 系统登录流程 .....................................................................................10
3.3.2 信息添加流程 .....................................................................................11
3.3.3 信息删除流程 .....................................................................................11
4 系统设计...........................................13
IV
4.1 系统概要设计 ................................................................................................13
4.2 系统功能结构设计 ........................................................................................13
4.3 数据库设计 ....................................................................................................14
4.3.1 数据库 E-R 图设计.............................................................................14
4.3.2 数据库表结构设计 ............................................................................15
5 系统实现...........................................21
5.1 作家信息管理 ...............................................................................................21
5.2 作品分类管理 ...............................................................................................21
5.3 用户管理 ........................................................................................................22
5.4 首页信息 .......................................................................................................22
6 系统测试 ...........................................24
6.1 本系统测试 .................................................................................................24
6.1.1 登录功能测试 .....................................................................................24
6.1.2 修改密码功能测试 .............................................................................25
6.2 测试结果分析 ................................................................................................25
结 论...............................................26
参考文献.............................................28
致 谢...............................................29
