摘 要
网络的发展带动了小说这一行业的快速发展,各大网站都能看到小说阅读的
身影,读者的增加进一步抑制了市场消费的提升,随着市场竞争的日益激烈,虽然
许多作者主动选用信用销售模式,但却缺乏对其充分的重视与质量的良性控制,
一些作者没有建立独立的信用实践管理,无法在交易前期准确获取读者资信情况
而是轻易的履行授信,令其始终无法得到良性提升。
小说阅读网站，主要的模块包括查看；管理员；首页、个人中心、读者管理、
作者管理、小说信息管理、小说分类管理、余额充值管理、购买小说管理、下载
小说管理、系统管理，读者；个人中心、余额充值管理、购买小说管理、下载小
说管理、我的收藏管理等，作者：个人中心、小说信息管理、小说分类管理、余
额充值管理、购买小说管理、下载小说管理、我的收藏管理。首页：小说信息、
我的、跳转到后台功能。系统中管理员主要是为了安全有效地存储和管理各类信
息，还可以对系统进行管理与更新维护等操作，并且对前后台有相应的操作权限。
要想实现小说阅读网站的各项功能，需要后台数据库的大力支持。管理员验
证注册信息，收集的读者信息，并由此分析得出的关联信息等大量的数据都由数
据库管理。本文中数据库服务器端采用了 Mysql 作为后台数据库，使 Web 与数
据库紧密联系起来。在设计过程中，充分保证了系统代码的良好可读性、实用性、
易扩展性、通用性、便于后期维护、操作方便以及页面简洁等特点。
本系统的开发使获取小说阅读网站信息能够更加方便快捷，同时也使小说阅
读网站信息变的更加系统化、有序化。系统界面较友好，易于操作。
关键词：小说阅读网站 ；jsp ；Mysql
Abstract
The development of the network has led to the rapid development of the
novel industry. The appearance of novel reading can be seen on all major
websites. The increase of readers further inhibits the promotion of market
consumption. With the increasingly fierce market competition, although
many authors actively choose credit sales mode, they lack of full
attention and good control of quality, Some authors do not establish
independent credit practice management, and can not accurately obtain the
credit situation of readers in the early stage of the transaction, but
easily perform the credit, which makes them unable to get a benign
promotion.
The main modules of novel reading website include: viewing;
administrator; home page, personal center, reader management, author
management, novel information management, novel classification
management, balance recharge management, purchase novel management,
download novel management, system management, readers; personal center,
balance recharge management, purchase novel management, download novel
management, my collection management, etc, Author: personal center, novel
information management, novel classification management, balance
recharge management, purchase novel management, download novel
management, my collection management. Home page: novel information, my,
jump to background function. The administrator in the system mainly stores
and manages all kinds of information safely and effectively, and can also
manage and update the system and maintain the system, and has
corresponding operation rights to the front and rear stations.
In order to realize the functions of the novel reading website, the
support of the backstage database is needed. The administrator verifies
the registration information, collects the reader information, and the
related information and other large amount of data are managed by the
database. MySQL is used as the background database in the database server
side in this paper, which makes the web and database closely linked. In
the design process, the system code is fully guaranteed with good
readability, practicability, easy to expand, universality, convenient
maintenance, easy operation and simple page.
The development of this system makes it more convenient and quick to
obtain the information of the novel reading website, and also makes the
information of the novel reading website more systematic and orderly. The
system interface is friendly and easy to operate.
Keywords: novel reading website; JSP; MySQL
目 录
摘 要 ..........................................................................................................................................1
Abstract.........................................................................................................................................1
1 系统概述 ..................................................................................................................................4
1.1 概述................................................................................................................................4
1.2 课题意义.........................................................................................................................4
1.3 主要内容........................................................................................................................4
2 系统开发环境 ..........................................................................................................................5
2. 1 JSP 技术介绍..................................................................................................................5
2. 2 JAVA 简介 .....................................................................................................................5
2.3 访问数据库实现方法.....................................................................................................5
2.4 系统对 MySQL 数据库的两种连接方式.........................................................................6
2.5 MySql 数据库.................................................................................................................6
3 需求分析 ..................................................................................................................................7
3.1 技术可行性：技术背景 .............................................................................7
3.2 经济可行性.....................................................................................................................7
3.3 操作可行性： .............................................................................................................8
3.4 系统设计规则.................................................................................................................8
3.5 系统流程和逻辑.............................................................................................................8
4 系统概要设计 .........................................................................................................................12
4.1 概述..............................................................................................................................12
4.2 系统结构......................................................................................................................12
4.3. 数据库设计................................................................................................................14
4.3.1 数据库实体.......................................................................................................14
4.3.2 数据库设计表...................................................................................................16
4.4 数据表...........................................................................................................................16
第 5 章 系统详细设计 ..............................................................................................................19
5.1 管理员功能模块...........................................................................................................21
5.2 前台能模块...................................................................................................................25
5.1 读者后台功能模块.......................................................................................................21
5.2 作者后台功能模块.......................................................................................................25
6 系统测试 ................................................................................................................................27
6.1 系统测试的目的...........................................................................................................27
6.2 系统测试方法...............................................................................................................28
6.3 测试结果......................................................................................................................28
结论 ............................................................................................................................................29
致 谢 ........................................................................................................................................30
