摘 要
随着Internet的广泛应用，动态网页技术也应运而生。本文介绍了应用ASP动态网页技术开发博客系统的设计与实现。
博客系统主要为用户提供发表文章、浏览文章等功能，用户通过Internet可以发表一些自己撰写的文章以和其他网友进行交流。博客系统主要实现了文章管理的数字化、信息化、智能化，是打破传统报刊、杂志发表文章方式的新尝试。
本系统的开发设计实现采用ASP技术，系统后台使用Microsoft的Access 2000数据库，并通过使用ODBC技术访问。
本文对博客系统进行整体分析，明确了系统的可行性和用户需求；根据模块化原理，规划设计了系统功能模块；在数据库设计部分，详细说明了系统数据库的结构和数据库的完整性、安全性措施；程序设计则采用面向对象的程序设计思想，提出系统的程序设计思路，对前台与后台功能的程序实现进行了详细论述；系统测试部分，具体分析测试过程中出现的主要问题，并提出了解决方案，实现系统功能。最后，对系统作以客观、全面的评价，并对进一步改进提出了建议。
关键字：博客ASP Access 2000 ODBC
ABSTRACT
With the extensive application of the Internet, dynamic web technology has emerged. This text describes the application of ASP dynamic web technology and development the blog system.
Blog system is mainly to provide users with published articles, browse articles, and other functions，Users can express themselves by some articles and with other netizens to conduct exchanges. Blog system of the main article on the digital management, information, intelligence, is to break the way of Released an article by traditional newspapers and magazine published ,it make a new way to try.
The system is designed by ASP technology, backstage adoption Access 2000 database,and use the ODBC technology to visit.
In this text，it analysis the blog system by feasibility and the demand of the user. Under the modular theory, planning and design of the system functional modules; In the database design, a detailed description of the database structure and database integrity, security measures; Programming is used object-oriented programming design, system design ideas, background for the future and function of the program in detail; System testing, Analysis of the specific course of testing the key issues and proposed solutions to achieve system function. Finally, the system in an objective, comprehensive evaluation, as well as further improvements made.
Key words: blog ASP Access 2000 ODBC
目 录
第一章 系统概述 .................................................. 1 1.1 项目背景 ............................................................................................................................ 1 1.2 系统开发的意义 ................................................................................................................ 2 1.2.1发布想法 ............................................................ 2 1.2.2博客的用途 .......................................................... 2 1.3 系统开发的目标 ................................................................................................................ 2 1.3.1任何拥有博客的人都可以做到 .......................................... 2 1.3.2 访问博客系统的人，可以做到 .......................................... 3 1.4系统概述 ............................................................................................................................. 3 1.5 系统的开发方法 ................................................................................................................ 3 第二章 系统分析.................................................... 6 2.1 可行性分析 ........................................................................................................................ 6 2.2 需求分析 ............................................................................................................................ 6 2.2.1 管理员登录 .......................................................... 6 2.2.2 文章管理 ............................................................ 7 2.2.3 系统信息管理 ........................................................ 7 2.3 系统的主要技术分析 ........................................................................................................ 7 2.3.1 ASP技术概论 ........................................................ 7 2.3.2 ASP工作原理 ........................................................ 8 2.3.3 ODBC技术 ........................................................... 8 2.3.4 硬件设备及操作系统 .................................................. 9 2.3.5 系统开发平台 ........................................................ 9 2.4 数据分析 ............................................................................................................................ 9 2.5 数据流图 ............................................................................................................................ 9 第三章 数据库设计 ................................................. 11 3.1 数据库技术概述 ...............................................................................................................11 3.2 数据库选择 .......................................................................................................................11 3.3 数据库的概念结构设计 .................................................................................................. 13 3.3.1 实体与属性之间的关系 ............................................... 13 3.3.2 数据库的E-R图 ..................................................... 13 3.4 数据库逻辑结构设计 ...................................................................................................... 15 3.5 数据库的完整性和安全性 .............................................................................................. 16 3.5.1 数据库的完整性约束 ................................................. 16
3.5.2 数据库的安全性 ..................................................... 17 第四章 系统设计................................................... 18 4.1系统总体设计 ................................................................................................................... 18 4.2公用模块的编写 ............................................................................................................... 19 4.2.1数据库连接文件 ..................................................... 19 4.2.2用户登录和注销 ..................................................... 19 4.2.3地址栏和博客主题设置 ............................................... 19 4.3客户界面的设计与实现 ................................................................................................... 19 4.3.1 界面头设计 ......................................................... 19 4.3.2 界面尾设计 ......................................................... 20 4.3.3 首页设计与实现 ..................................................... 20 4.3.4用户注册模块设计 ................................................... 21 4.3.5给我留言模块 ....................................................... 22 4.3.6“文章评论”功能模块设计 ............................................ 22 4.4后台管理界面设计 ........................................................................................................... 22 4.4.1“添加分类”功能模块 ................................................ 22 4.4.2“分类管理”功能模块 ................................................ 23 4.4.3“添加文章”功能模块 ................................................ 23 4.4.4“文章管理”功能模块 ................................................ 24 4.4.5“留言管理”功能模块 ................................................ 24 4.4.6“基本设置”功能模块 ................................................ 25 4.4.7管理员密码模块 ..................................................... 25 4.4.8系统管理模块 ....................................................... 26 第五章 系统测试................................................... 27 5.1 测试目的 .......................................................................................................................... 27 5.2 测试方法 .......................................................................................................................... 27 5.3 测试实例 .......................................................................................................................... 27 5.3.1 后台管理权限测试 ......................................... 27 5.3.2 前台文章显示测试 ................................................... 27 5.3.3 前台显示文章详细内容测试 ........................................... 28 5.3.4 管理员登陆 ......................................................... 28 5.3.5 后台管理权限测试 ................................................... 28 5.3.6 文章管理 ........................................................... 29 5.3.7 系统信息管理 ....................................................... 31 结 论............................................................ 32