基于JSP技术开发BBS论坛系统的设计与实现 毕业设计

/* MySQL Data Transfer Source Host: localhost Source Database: hello2 Target Host: localhost Target Database: hello2 Date: 2009-2-22 10:55:52 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admininfo -- ---------------------------- CREATE TABLE `admininfo` ( `admname` varchar(20) NOT NULL, `admpwd` varchar(20) NOT NULL, `admemail` varchar(50) NOT NULL, `admstate` varchar(50) default NULL, `admtime` datetime NOT NULL, `admsay` varchar(150) default NULL, `admright` int(10) NOT NULL, PRIMARY KEY (`admname`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for foruminfo -- ---------------------------- CREATE TABLE `foruminfo` ( `mid` int(10) NOT NULL auto_increment, `name` varchar(80) NOT NULL, `isparent` int(2) NOT NULL, `sortid` int(3) NOT NULL, `adminauthor` varchar(60) default NULL, `totaltopic` int(10) default NULL, `totalpost` int(11) default NULL, `description` varchar(160) default NULL, PRIMARY KEY (`mid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for replyinfo -- ---------------------------- CREATE TABLE `replyinfo` ( `id` int(11) NOT NULL auto_increment, `topicid` int(11) NOT NULL, `replyuserid` varchar(20) NOT NULL, `replytime` datetime NOT NULL, `replycontent` varchar(300) NOT NULL, PRIMARY KEY (`id`), KEY `repuid` (`replyuserid`), KEY `topicid` (`topicid`), CONSTRAINT `replyinfo_ibfk_1` FOREIGN KEY (`topicid`) REFERENCES `topicinfo` (`topicid`) ON DELETE CASCADE, CONSTRAINT `repuid` FOREIGN KEY (`replyuserid`) REFERENCES `userinfo` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for topicinfo -- ---------------------------- CREATE TABLE `topicinfo` ( `topicid` int(11) NOT NULL auto_increment, `topictitle` varchar(60) NOT NULL, `topicuserid` varchar(20) NOT NULL, `topiccontent` varchar(300) NOT NULL, `topictime` datetime NOT NULL, `replynum` int(10) NOT NULL, `forumid` int(10) NOT NULL, `groupid` int(2) default NULL, PRIMARY KEY (`topicid`), KEY `topuid` (`topicuserid`), KEY `fid` (`forumid`), CONSTRAINT `fid` FOREIGN KEY (`forumid`) REFERENCES `foruminfo` (`mid`), CONSTRAINT `topuid` FOREIGN KEY (`topicuserid`) REFERENCES `userinfo` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for userinfo -- ---------------------------- CREATE TABLE `userinfo` ( `userid` varchar(20) NOT NULL, `userpwd` varchar(20) NOT NULL, `username` varchar(30) NOT NULL, `useremail` varchar(50) NOT NULL, `userlevel` int(20) NOT NULL, `usersay` varchar(150) default NULL, `userstate` varchar(20) default NULL, `right` int(10) default NULL, PRIMARY KEY (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `admininfo` VALUES ('123', 'a', 'cc@163.com', 'outstanding', '2008-10-21 17:04:51', 'It is a wonderful!', '0'); INSERT INTO `admininfo` VALUES ('aaa', '1', 'chenchao@163.com', 'very good ', '2008-10-21 10:59:17', 'hahaha', '0'); INSERT INTO `admininfo` VALUES ('admin', 'admin', 'admin1986@126.com', '我是超级管理员', '2008-10-22 11:06:13', '希望每个人到此论坛都能开心。', '1'); INSERT INTO `admininfo` VALUES ('cw', '1', 'cw1985@163.com', '我是一个出色的软件设计师', '2008-10-07 11:02:43', '希望此论坛要越办越好，人气越来越旺！', '0'); INSERT INTO `admininfo` VALUES ('wls', '123', 'wsl@hytc.edu.cn', '我们的毕业设计指导老师', '2008-10-01 10:57:44', '希望每个人的毕业设计都很出色。', '0'); INSERT INTO `foruminfo` VALUES ('1', '学习宝地', '1', '1', 'abc', '3', '3', null); INSERT INTO `foruminfo` VALUES ('2', '休闲娱乐', '1', '2', 'fox', '3', '5', null); INSERT INTO `foruminfo` VALUES ('3', '体坛风云', '1', '3', 'bobo', '2', '3', null); INSERT INTO `foruminfo` VALUES ('4', '衣食住行', '1', '4', 'xxx', '2', '5', null); INSERT INTO `foruminfo` VALUES ('5', '外语交流', '1', '5', 'tao', '5', '7', null); INSERT INTO `foruminfo` VALUES ('6', '以书会友', '0', '1', 'abc', '2', '3', '书中自有黄金屋、书中自有颜如玉 '); INSERT INTO `foruminfo` VALUES ('7', '考研考博', '0', '1', 'abc', '2', '3', '考研一族,考博一族 '); INSERT INTO `foruminfo` VALUES ('8', '外语考级', '0', '1', 'abc', '2', '3', '英语四六八级,日语,韩语,法语......'); INSERT INTO `foruminfo` VALUES ('9', '心有所宠', '0', '2', 'fox', '2', '5', '爱宠物，爱自己!'); INSERT INTO `foruminfo` VALUES ('10', '八卦中心', '0', '2', 'fox', '2', '5', '过客如(风)，发帖似(水).闲话成(宝)，八卦铺(地). '); INSERT INTO `foruminfo` VALUES ('11', '至善美食', '0', '2', 'fox', '5', '5', '美味无处不在,永远吸引你的胃 '); INSERT INTO `foruminfo` VALUES ('12', '篮球联盟', '0', '3', 'bobo', '2', '3', '我们凝聚着银屏中的一个个身影，我们在操场和街头挥汗如雨，因为那是我们热爱的运动——叫做篮球!'); INSERT INTO `foruminfo` VALUES ('13', '驰骋球场', '0', '3', 'bobo', '2', '3', '足球迷爱好者俱乐部 '); INSERT INTO `foruminfo` VALUES ('14', '工作人生', '0', '4', 'xxx', '2', '5', '工作人生也是门学问!欢迎大家共同沟通学习!'); INSERT INTO `foruminfo` VALUES ('15', '流行时尚', '0', '4', 'xxx', '2', '5', '不止是吸引 '); INSERT INTO `foruminfo` VALUES ('17', '欢你最爱', '0', '5', 'tao', '2', '6', '你的选择是对的'); INSERT INTO `foruminfo` VALUES ('18', '琐碎小事', '0', '5', 'tao', '5', '6', '记录生活中的点点滴滴'); INSERT INTO `foruminfo` VALUES ('19', '出国风采', '0', '1', 'abc', '2', '3', '大家来分享一下出国心情'); INSERT INTO `foruminfo` VALUES ('20', '时尚短语', '0', '5', 'tao', '2', '3', '在与外国人交流时经常运用的简洁短语'); INSERT INTO `replyinfo` VALUES ('1', '21313', 'cc', '2008-10-06 21:01:00', '王力宏'); INSERT INTO `replyinfo` VALUES ('2', '21313', 'chenchao', '2008-10-06 20:01:37', '梁静茹'); INSERT INTO `replyinfo` VALUES ('3', '21314', '123', '2008-10-07 22:02:19', '食堂的伙食太差劲了'); INSERT INTO `replyinfo` VALUES ('4', '21315', 'chenchao', '2008-10-05 11:03:23', '没有热门的，只有冷门的'); INSERT INTO `replyinfo` VALUES ('5', '21315', '123', '2008-10-07 21:04:52', '同意楼上的说法，顶啊，哈'); INSERT INTO `replyinfo` VALUES ('6', '21315', 'cc', '2008-10-06 17:06:22', '像金融拉，还有电子类专业比较热门'); INSERT INTO `replyinfo` VALUES ('7', '21316', 'cc', '2008-10-08 17:08:17', '最爱吃的水果啊，我个人觉得还是苹果好啊'); INSERT INTO `replyinfo` VALUES ('8', '21316', 'chenchao', '2008-10-09 21:09:43', '我喜欢吃西瓜'); INSERT INTO `replyinfo` VALUES ('9', '21317', 'chenchao', '2008-10-08 22:12:47', '我最喜欢养狗了，因为他们忠诚'); INSERT INTO `replyinfo` VALUES ('10', '21313', 'cc', '2008-10-12 20:13:48', '刘德华'); INSERT INTO `replyinfo` VALUES ('11', '21313', 'chen', '2008-10-12 20:14:24', '我还是喜欢摇滚小魔女艾薇儿'); INSERT INTO `replyinfo` VALUES ('12', '21317', 'cc', '2008-10-13 17:16:07', '喜欢养鱼，希望像他们一样自由的游来游去'); INSERT INTO `replyinfo` VALUES ('13', '21317', 'chen', '2008-10-15 20:17:39', '我喜欢养鸟，总觉得他们比我们自由'); INSERT INTO `replyinfo` VALUES ('14', '21315', 'cc', '2008-10-14 12:18:36', '我个人觉得还是计算机比较热门'); INSERT INTO `replyinfo` VALUES ('15', '21313', 'chenwei', '2008-10-16 20:19:52', '我喜欢后街男孩！'); INSERT INTO `replyinfo` VALUES ('16', '21318', 'cc', '2008-10-16 21:20:40', 'Thanks ,And you'); INSERT INTO `replyinfo` VALUES ('17', '21318', 'chen', '2008-10