哈 尔 滨 工 业 大 学 大 学 毕 业 设 计 (论 文 )用 纸
目 录
摘要 i
Abstract ii
1 绪 论 .......................................................................................................................................................1
2 系统分析 ...................................................................................................................................................2
2.1 功能需求分析 ...............................................................................................................................2
2.2 本系统采用的关键技术 ...............................................................................................................3
2.2.1 JSP 技术 ............................................................................................................................3
2.2.2 JavaBean 技术 ..................................................................................................................4
2.2.3 JDBC 技术 ..........................................................................................................................5
2.2.4 用 JDBC 访问数据库 .........................................................................................................8
2.3 可行性分析 ...................................................................................................................................10
2.4 系统运行环境 ...............................................................................................................................10
3 系统概要设计 .........................................................................................................................................12
3.1 总体功能 ......................................................................................................................................12
3.2 E-R 图.........................................................................................................................................13
4 系统详细设计 .........................................................................................................................................14
4.1 后台数据库设计 ..........................................................................................................................14
4.1.1 Sqlserver 介绍 .............................................................................................................14
4.1.2 数据库 SQL 语句 .............................................................................................................14
4.1.3 数据库表结构 .................................................................................................................15
4.2 处理流程设计 ..............................................................................................................................17
4.2.1 系统操作流程 .........................................................................................................................17
4.2.2 数据增加流程 .................................................................................................................18
4.2.3 数据修改流程 .................................................................................................................19
4.2.4 数据删除流程 .................................................................................................................20
4.3 网站首页页面设计 .......................................................................................................................21
4.4 系统模块设计 ...............................................................................................................................24
4.4.1 管理员登陆 .....................................................................................................................24
4.4.2 资讯管理 .........................................................................................................................26
4.4.3 过滤词语管理 .................................................................................................................28
5 系统调试与测试 .....................................................................................................................................30
5.1 程序调试 ......................................................................................................................................30
5.2 程序的测试 ..................................................................................................................................30
5.2.1 测试的重要性及目的 .....................................................................................................30
5.2.2 测试的步骤 .....................................................................................................................31
5.2.3 测试的主要内容 .............................................................................................................31
6 结束语 .....................................................................................................................................................38
6.1 系统评价 .....................................................................................................................................38
6.2 安全性问题 .................................................................................................................................38
参考文献 .......................................................................................................................................................41
致 谢 .........................................................................................................................................................42
