个人博客说明书.doc

作品说明书一、作品名称：个人博客二、作品功能:游客时序图：管理员时序图：三、操作步骤:游客操作：1. 输入网址，进入主界面，主界面显示了blog主的日志内容2.点击测试的这篇日志：进入点击笔记本则弹出回复窗口输入内容点击回复3.回复成功：4.点击登录进入登录窗口5.输入用户名：admin 密码admin 点击提交，进入后台6点击发表日志并输入内容，点击发布7.点击更新日志输入日志id8输入内容点击提交，显示提交成功返回管理界面点击删除9点击退出登录，退出成功返回主界面：返回主界面四，数据说明表：basic_j002-ID：id网站标题：ws_name大标题：big_title小标题：small_title个人简介：bio-CREATE TABLE j002.basic_j002 (id BIGINT NOT NULL AUTO_INCREMENT ,ws_name VARCHAR( 30 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,big_title VARCHAR( 20 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,small_title VARCHAR( 20 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,bio VARCHAR( 500 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,PRIMARY KEY ( id ) ENGINE = INNODB;表：main_j002-ID：id文章标题：title发布时间：update主要内容：content类别：class-CREATE TABLE j002.main_j002 (id BIGINT NOT NULL AUTO_INCREMENT ,title VARCHAR( 40 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,update TIMESTAMP NOT NULL ,content VARCHAR( 5000 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,class VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,PRIMARY KEY ( id ) ENGINE = INNODB;表：reply_j002-ID：id回复名：rname回复内容：rcontent回复文章id：rid回复时间：rupdate-CREATE TABLE j002.reply_j002 (id BIGINT NOT NULL AUTO_INCREMENT ,rname VARCHAR( 20 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,rcontent VARCHAR( 200 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,rid BIGINT NOT NUL