![](https://csdnimg.cn/release/download_crawler_static/88601476/bg2.jpg)
目 录
一、系统开发概述 .........................................................................................................................................4
1.1 项目背景 ...........................................................................................................................................4
1.2 设计目的及其要求 ...........................................................................................................................4
二、系统规划 .................................................................................................................................................5
2.1 设计任务 ...........................................................................................................................................5
2.2 所用软件环境及工具 .......................................................................................................................5
三、需求分析 .................................................................................................................................................5
3.1 用户需求分析 ...................................................................................................................................5
3.1.1 数据需求 ...............................................................................................................................5
3.1.2 事务需求 ...............................................................................................................................6
3.2 系统需求说明 ..................................................................................................................................7
四、数据库概念设计和逻辑设计 .................................................................................................................8
4.1 E-R 图................................................................................................................................................8
4.2 关系表 ...............................................................................................................................................8
4.3 视图. ...............................................................................................................................................11
五、数据库物理设计 ...................................................................................................................................13
5.1 索引 ................................................................................................................................................13
5.3 安全机制 ........................................................................................................................................13
六、应用程序设计 .......................................................................................................................................14
6.1 格式约定 ........................................................................................................................................14
6.2 登陆模块和权限控制的实现 ........................................................................................................14
6.2.1 用户登录 .............................................................................................................................15
6.2.2 权限控制 ..............................................................................................................................15
6.3 注册模块实现 .................................................................................................................................16
6.4 用户部分实现 ...........................................................................................................................16
6.4.1 用户信息修改 ......................................................................................................................16
6.4.2 购买和购买记录查询 ..........................................................................................................16
6.4.3 图书搜索功能 ......................................................................................................................17
6.5 全局异常处理 ................................................................................................................................18