JSP个人网站留言板课程设计

1JIANGXIAGRICULTURALUNIVERSITYJSP课程设计报告题目：个人网站留言板系统程序设计学院：姓名：学号：专业：班级：指导教师：二0一二年九月2摘要个人网站留言板及用户注册系统是一个针对个人而开发的网站系统，个人网站是一个可以发布个人信息及相关内容。通俗理解个人网站：就是指网站内容是介绍自己的或是以自己的信息为中心的网站，访客可以在网站注册后留言。本网站是一个典型的简单的个人网站系统,其开发主要包括后台数据库的建立和维护以及前端WEB页面的设计两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库，不会出现增加，删除，修改的异常。而对于后者则要求应用功能完备,易使用，界面友好等特点。另外，本文还着重论述了留言板和用户注册系统的功能与实现，包括数据流程及存储、注册用户管理、留言板信息管理、用户权限管理、用户密码管理、留言信息和用户的增加、留言信息的删除、留言信息的查询、注册用户的查询、等。本系统提供管理员、访客的登录。管理员可以查看用户注册信息和留言信息，可对其进行删除修改等功能。访客登录可以在留言板上留言。关键词：个人网站；访客；管理员；留言板3AbstractPersonalwebsitemessageboardanduserregistrationsystemarewebsitedevelopedforindividualsystems,personalWebsitecanpublishapersonalinformationandrelatedcontent.Popularunderstandingofwebsite:thatthecontentofasiteistointroducetheirowninformation,ortothecenterofthesite,visitorscanleaveamessageafterthesiteup.Thissiteisatypicalsimplepersonalwebsitesystem,whichmainlyincludestheestablishmentandmaintenanceofback-enddatabaseandfronttwoaspectsofthedesignofWEBpages.Requestfortheestablishmentofdataconsistencyandintegrity,datasecurityandgoodlibraries,doesnotappeartoadd,delete,modifytheexception.Forthelatterrequirestheapplicationoffunctions,easytouse,friendlyinterfaceandsoon.Inaddition,thispaperfocusesonthemessageboardsanduserregistrationsystemfunctionandimplementation,includingdataflowandstorage,theregisteredusermanagement,messageboardinformationmanagement,userrightsmanagement,userpasswordmanagement,messageinformationanduserincreases,voicemessagesdelete,themessageinformationquery,thequeryregisteredusers,andsoon.Thesystemadministrator,visitorlogin.Administratorscanviewtheuserregistrationinformationandmessageinformation,canbemodifiedtodeleteitsfunctions.Visitorscansignupforcasualusersloginandusetheuseramessage.Keywords:Personalwebsite;Visitor;Managor;Messageboard4目录1．第一章课题背景............................................................................................................................51.1课程要求......................................................................................................................................................51.2设计概要.......................................................................................................................................................51.3工具及环境简介...........................................................................................................................................52．第二章设计简介及设计方案论述.................................................................................................52.1系统功能概述.............................................................................................................................................52.1.1用户类型............................................................................................................................62.1.2管理员...............................................................................................................................62.1.3普通用户............................................................................................................................62.2数据库设计.................................................................................................................................................72.2.1管理员息表：.....................................................................................................................72.2.2注册用户留言信息表：.....................................................................................................73．第三章详细设计............................................................................................................................73.1首页设计.....................................................................................................................................................73.1.1管理员登录....................................................................................................................143.2管理员审核留言信息...............................................................................................................................174．第四章设计结果及分析...............................................................................................................184.1首页界面结果............................................................................................................................................184.1.1首页界面如下：..............................................................................................................184.1.2管理员登录....................................................................................................................184.2留言板信息管理........................................................................................................................................194.2.1留言内容信息................................................................................................................194.2.2删除用户信息................................................................................................................194.2.3审核通过用户信息............................................................