jsp+servlet+javabean+mysqlbbs.rar_MySQL+JSP+servlet_javabean mys

/*说明：为保证icefish.sql有较好的兼容性，没有在原文件中加注释*/ /*创建数据库 icefish*/ drop database if exists icefish; CREATE DATABASE icefish DEFAULT CHARACTER SET gb2312; use icefish; /*创建用户信箱表 icefish_msg*/ CREATE TABLE `icefish_msg` ( `msg_id` int(11) NOT NULL auto_increment, `msg_from` char(50) default NULL, `msg_to` char(50) NOT NULL, `msg_topic` char(100) NOT NULL, `msg_words` mediumtext NOT NULL, `msg_time` datetime NOT NULL, `msg_new` enum('true','false') NOT NULL default 'true', `msg_belong` enum('true','false') NOT NULL default 'true', `msg_del` tinyint(1) NOT NULL default '0', `msg_del_msgbin` enum('0','1') NOT NULL default '1', `msg_del_forebin` enum('0','1') NOT NULL default '1', PRIMARY KEY (`msg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建管理员表 icefish_admin*/ CREATE TABLE icefish_admin ( admin_id int(11) auto_increment PRIMARY KEY, admin_name char(50) , admin_password char(25) , admin_user char(50) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建论坛版块管理表 icefish_board*/ CREATE TABLE icefish_board ( board_id int(11) auto_increment PRIMARY KEY, board_isMother ENUM('true','false') DEFAULT 'false', /*是否主板块*/ board_bid int(11) , board_name char(50) , board_info text , board_master char(50), board_img char(100), board_postnum int(11), board_topicnum int(11), board_todaynum int(11), board_lastreply int(11) /*最新回复帖的ID*/ ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建友情链接表 icefish_link*/ CREATE TABLE icefish_link ( link_id int(11) auto_increment PRIMARY KEY, link_name char(50) , link_url char(100) , link_info text, link_logo char(100), link_islogo enum('true','false') NOT NULL default 'false', link_pass enum('true','false') NOT NULL default 'false' ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建帖子管理表 icefish_post*/ CREATE TABLE icefish_post ( post_id int(11) auto_increment PRIMARY KEY, post_boardid int(11) , post_user char(50) , post_topicid int(11), post_replyid int(11), post_content text, post_time datetime , post_edittime datetime, post_ip char(15) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建论坛基本设置表 icefish_setting*/ CREATE TABLE icefish_setting ( setting_id int(11) auto_increment PRIMARY KEY, setting_copyrights text, setting_author text, setting_open ENUM('false','true') DEFAULT 'true', /*论坛是否处于开放状态,false为论坛关闭,true为开放*/ setting_offwords text, setting_badwords text, setting_bbsname char(100), setting_bbsurl char(100), setting_bbslogo char(100), setting_info text, setting_maxonlinetime datetime, setting_maxonline int(11), setting_todaynum int(11), setting_yesterdaynum int(11), setting_maxnum int(11), setting_totaltopic int(11), setting_totalpost int(11), setting_totaluser int(11) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建话题管理表 icefish_topic*/ CREATE TABLE icefish_topic ( topic_id int(11) auto_increment PRIMARY KEY, topic_boardid int(11) , topic_user char(50) , topic_name char(100) , topic_time datetime , topic_hits int(11), topic_replynum int(11), topic_lastreplyid int(11), topic_top ENUM("false","true") DEFAULT 'false', /*是否为置顶帖*/ topic_best ENUM("false","true") DEFAULT 'false', /*是否为精华帖*/ topic_del ENUM("false","true") DEFAULT 'false', /*是否为删除帖*/ topic_hot ENUM("false","true") DEFAULT 'false' /*是否为热门帖*/ ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建用户管理表 icefish_user*/ CREATE TABLE icefish_user ( user_id int(11) auto_increment PRIMARY KEY, user_name char(50) , user_password char(100), user_sex char(2), user_birthda datetime, user_QQ int(11), user_Email char(50), user_tel char(50), user_face char(100), user_sign text, user_grade char(50), user_mark int(11), user_topic int(11), user_wealth int(11), user_post int(11), user_group char(50), user_lastip char(15), user_delnum int(11), user_friends text, user_regtime datetime, user_lasttime datetime, user_locked ENUM("false","true") DEFAULT 'false', /*用户是否被锁定*/ user_admin ENUM("false","true") DEFAULT 'false', /*是否为后台管理员*/ user_password_a char(100), user_password_q char(100), user_age int(11), user_secondname char(50), user_truename char(50), user_blood char(10), user_shengxiao char(10), user_nation char(50), user_province char(50), user_city char(50) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; # # Table structure for table icefish_friend # CREATE TABLE `icefish_help` ( `help_id` int(11) auto_increment PRIMARY KEY, `help_name` char(100) default Null, `help_info` text ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; # # Dumping data for table icefish_friend # # # Table structure for table icefish_friend # CREATE TABLE `icefish_friend` ( `user_id` int(11) default NULL, `friend_id` int(11) default NULL, `friend_name` char(50) default NULL, `friend_addtime` varchar(20) default NULL, `friend_Email` varchar(20) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; /*创建广告表 icefish_ad*/ CREATE TABLE `icefish_ad` ( `ad_id` int(11) NOT NULL , `ad_img` char(100) NULL, `ad_url` char(100) NULL, `ad_title` char(100) NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; # # Dumping data for table icefish_friend # INSERT INTO `icefish_ad` VALUES (1,'','',''); INSERT INTO `icefish_ad` VALUES (2,'','',''); INSERT INTO `icefish_ad` VALUES (3,'','',''); INSERT INTO `icefish_friend` VALUES (7,7,'ye',NULL,NULL); INSERT INTO `icefish_friend` VALUES (2,2,'jjr','2006-06-12 16:14:28','4535rwer@163.com'); INSERT INTO `icefish_friend` VALUES (1,1,'juuyu','2006-06-12 16:17:45','1111@163.com'); INSERT INTO `icefish_friend` VALUES (1,1,'juuyu','2006-06-12 16:56:11','1111@163.com'); INSERT INTO `icefish_friend` VALUES (4,4,'4535','2006-06-12 21:21:24','8'); INSERT INTO `icefish_friend` VALUES (3,3,'uu','2006-06-12 21:24:20','45633@163.com'); INSERT INTO `icefish_friend` VALUES (5,5,'t54','2006-06-12 22:14:04','retwt@163.com'); INSERT INTO `icefish_friend` VALUES (6,6,'tt','2006-06-12 22:17:22','tre'); INSERT INTO `icefish_friend` VALUES (3,3,'uu','2006-06-13 02:16:56','45633@163.com'); INSERT INTO `icefish_friend` VALUES (1,1,'juuyu','2006-06-13 07:53:19','3333@163.com'); INSERT INTO `icefish_friend` VALUES (6,6,'tt','2006-06-13 07:54:04','tre'); INSERT INTO `icefish_friend` VALUES (6,6,'tt','2006-06-13 07:54:46','tre'); INSERT INTO `icefish_friend` VALUES (2,2,'jjr','2006-06-13 13:32:49','453577rwer@163.com'); INSERT INTO `icefish_friend` VALUES (2,2,'jjr','2006-06-13 13:37:40','453577rwer@163.com'); INSERT INTO `icefish_friend` VALUES (4,4,'4535','2006-06-13 13:41:21','8'); INSERT INTO `icefish_friend` VALUES (3,3,'uu','2006-06-13 13:44:05','45633@163.com'); INSERT INTO `icefish_friend` VALUES (4,4,'4535','2006-06-13 16:42:00','8'); INSERT INTO `icefish_friend` VALUES (4,4,'4535','2006-06-13 16:43:22','8'); INSERT INTO `icefish_board` SET `board_isMother`='true', `board_name`='校园生活', `board_master`='龙龙'; INSERT INTO `icefish_board` SET `board_isMother`='true', `board_name`='交流区', `board_master`='龙龙'; INSERT INTO `icefish_board` SET `board_bid`=1, `board_name`='师大的ＧＧＭＭ', `board_info`='无病呻吟的人儿啊~~来这里发飙吧~~', `board_master`='龙龙'; INSERT INTO `icefish_board` SET `board_bid`=1, `board_name`='情感专区', `board_info`='情感越过时空的界线，你我相聚在这里。曾经伤心的你，今天还好吗？！', `board_master`='龙龙'; INSERT INTO `icefish_board` SET `board_bid`=1, `board_name`='师大婚介所', `board_info`='寂寞的人们啊……表害羞……', `board_master`='龙龙'; INSERT INTO `icefish_board` SET `board_bid`=1, `board_name`='美食窝棚', `board_info`='食...乃口中的幸福...也能像爱一样甜蜜...', `board_