留言板的设计与实现(毕业论文)

本 科 毕 业 论 文

论 文 题 目指 导 老 师学 生 姓 名学 号院 系专 业毕 业 时 间

W440909121300001 2011年6月

I

：留言板的设计与实现 ：林伟伟 ： ： ：网络教育学院 ：计算机科学与技术 ：原 创 承 诺 书

我承诺所呈交的毕业论文是本人在老师指导下进行的研究工作及取得的研究成果。据我查证，除了文中特别加以标注和致谢的地方外，论文中不包含其他人已经发表或撰写过的研究成果。若本论文及资料与以上承诺内容不符，本人愿意承担一切责任。

毕业论文作者签名：___ _____

日期：2011 年 2 月 10 日

II

摘要 随着Internet的发展，网站的作用越来越重要，被称之

为继广播、报纸、杂志、电视后的第五种媒体——数字媒体，拥有众多优势，所以现在不少企业都有或正在建设自己的网站。而留言板作为网站重要的一个部分，从来就是一个大家交流的平台！留言板是一种最为简单的BBS应用，借助留言板，浏览者可以张贴留言的方式给站长、版主或其他浏览者进行留言和提问。

人类进入21世纪的今天，科学技术的突飞猛进，信息技术和网络技术的的迅速发展和广泛应用，人们的工作、生活、学习和交流方式也发生羞巨大改变，信息的获取、处理、交流和应用能力已经成为最重要的能力之一，本留言板是基于ASP和Access的，利用 ADO 数据库访问技术实现对数据库的各种管理操作，实现留言板的留言及管理功能。从而使得后台操作更加方便、快捷、的现实用户的注册、留言的回复和删除等。

本系统从构思、规划、设计到相关技术，结合常用的HTML、ASP技术，详细设计时不断地修正和完善，经过测试阶段地反复调试和验证，最终形成达到用户设计要求的可行系统。

关键词： 留言板 ASP 数据库 Access ADO

III

Abstract Along with the Internet development, the

function of the website is more and more important, was called it as after broadcast, newspaper, magazine, television behind of the fifth media- numerical media, own numerous advantages, so not a few business enterprises of present all have or just constuct own website.But the message board be a fraction of the website importance, have always been is a platform of everyone alternating current, AC!The message board is the most simple BBS the one who apply, ask for help the message board, browse can paste up the message of mode give station-master, webmaster or other browsingses carries on the message sum's lift to ask.

The mankind enter today for 21 centuries, science advances by leaps and bounds technically, information technology and network technique of quick development sum extensive pplication, the people's work, life, the study sum intersection streaming mode also takes place the huge change, the acquisition of the information, handle and communicate sum application the capability have already become one of the most important capabilities, this message board is according to ASP and Access of, make use of the ADO data base, DB access technique implementation to operate to various management of the data base, DB, carry out the message and the management function of the message board.Thus make the background operation more convenient, fast, of the revovery sum delete of the log-in, log-on, message of the realistic consumer etc..

This system from conceive outline, program, design the related technique, combine the in common use HTML, technique of ASP, the hour of detailed design revises the sum constantly perfect, through the test phase earth iteration debug sum verification, the end forming attains the consumer design to request of can go the system.

Keyword: Message board ASP data base, DB Access ADO

IV

目录

摘要................................................................................................................................................. III Abstract ......................................................................................................................................... IV 绪论................................................................................................................................................... 6 第一章 系统开发技术与环境 ......................................................................................................... 7

1.1开发所需的硬件环境与软件环境 .................................................................................... 7 1.2.1所需软件环境 ................................................................................................................ 7 2.1开发工具简介 .................................................................................................................... 8 2.1.1 ASP简介 ........................................................................................................................ 8 2.1.2 IIS简介 ........................................................................................................................ 8 2.1.3 Access简介 ................................................................................................................ 9 2.2开发模式 ............................................................................................................................ 9 第二章 系统分析与设计 ............................................................................................................... 10

2.1需求分析 .......................................................................................................................... 10 2.2模块设计 .......................................................................................................................... 10 2.3数据库结构设计 .............................................................................................................. 11 2.3.1系统 E-R图 ................................................................................................................. 11 2.3.2数据库表的设计 .......................................................................................................... 12 第三章 系统实现 ......................................................................................................................... 15

3.1创建与连接数据库 .......................................................................................................... 15 3.1.1数据库的连接 .............................................................................................................. 15 3.1.2 数据添加 ..................................................................................................................... 16 3.1.3数据删除 ...................................................................................................................... 17 3.1.4数据加密 ...................................................................................................................... 19 3.2 留言信息页面模块设计 ................................................................................................. 21 3.2.1查看留言模块 .............................................................................................................. 21 3.2.2留言发布模块 .............................................................................................................. 24 3.3留言管理模块设计 .......................................................................................................... 28 3.3.1管理员登录模块 .......................................................................................................... 28 3.3.2版面管理模块 .............................................................................................................. 31 3.3.3参数设置模块 .............................................................................................................. 34 第四章 系统测试 ......................................................................................................................... 39

4.1系统测试(环境) ............................................................................................................... 39 4.1.1系统服务端测试环境 .................................................................................................. 39 4.1.2系统客户端测试环境 .................................................................................................. 39 4.2测试项目 ........................................................................................................................... 39 4.2.1系统功能测试 .............................................................................................................. 39 4.2.2用户界面测试 .............................................................................................................. 40 总结................................................................................................................................................. 41 致谢................................................................................................................................................. 42 参考文献 ......................................................................................................................................... 43

V