java jsp 毕业设计 师生交流管理系统

/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50096 Source Host : localhost:3306 Source Database : zxdy Target Server Type : MYSQL Target Server Version : 50096 File Encoding : 65001 Date: 2015-03-13 17:23:23 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `dy_apply` -- ---------------------------- DROP TABLE IF EXISTS `dy_apply`; CREATE TABLE `dy_apply` ( `AID` int(11) NOT NULL auto_increment, `UID` int(11) default NULL, `TGID` int(11) default NULL, `AReason` varchar(200) NOT NULL, `AFlag` int(11) default '0', `AStatus` char(10) default '申请中', PRIMARY KEY (`AID`), KEY `UID` (`UID`), KEY `TGID` (`TGID`), CONSTRAINT `dy_apply_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `dy_user` (`UID`) ON DELETE CASCADE, CONSTRAINT `dy_apply_ibfk_2` FOREIGN KEY (`TGID`) REFERENCES `dy_topic_group` (`TGID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of dy_apply -- ---------------------------- -- ---------------------------- -- Table structure for `dy_revert` -- ---------------------------- DROP TABLE IF EXISTS `dy_revert`; CREATE TABLE `dy_revert` ( `RID` int(11) NOT NULL auto_increment, `TID` int(11) default NULL, `UID` int(11) default NULL, `RTitle` varchar(200) default NULL, `RContent` text NOT NULL, `RDate` datetime NOT NULL, PRIMARY KEY (`RID`), KEY `TID` (`TID`), KEY `UID` (`UID`), CONSTRAINT `dy_revert_ibfk_1` FOREIGN KEY (`TID`) REFERENCES `dy_topic` (`TID`) ON DELETE CASCADE, CONSTRAINT `dy_revert_ibfk_2` FOREIGN KEY (`UID`) REFERENCES `dy_user` (`UID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of dy_revert -- ---------------------------- INSERT INTO `dy_revert` VALUES ('1', '2', '3', '', '看书，上网问问题', '2015-03-09 11:39:48'); INSERT INTO `dy_revert` VALUES ('2', '1', '3', '', '传说新版本的JAVA 会自动缓存BYTE范围内的值.', '2015-03-09 11:39:48'); INSERT INTO `dy_revert` VALUES ('3', '1', '3', '', '楼主懂了吗？可以参考Java里的源代码', '2015-03-09 11:39:48'); INSERT INTO `dy_revert` VALUES ('4', '1', '3', '', '谢谢大家指教', '2015-03-09 11:39:48'); INSERT INTO `dy_revert` VALUES ('5', '3', '3', '', '认真学习，专心研究的话就好学', '2015-03-09 11:39:48'); INSERT INTO `dy_revert` VALUES ('6', '12', '2', 'dfgf', 'gdfhftddfhb', '2015-03-12 20:19:58'); -- ---------------------------- -- Table structure for `dy_topic` -- ---------------------------- DROP TABLE IF EXISTS `dy_topic`; CREATE TABLE `dy_topic` ( `TID` int(11) NOT NULL auto_increment, `UID` int(11) default NULL, `TGID` int(11) default NULL, `TTitle` varchar(200) NOT NULL, `TContent` text NOT NULL, `TDate` datetime NOT NULL, `TReadCount` int(11) default '0', PRIMARY KEY (`TID`), KEY `UID` (`UID`), KEY `TGID` (`TGID`), CONSTRAINT `dy_topic_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `dy_user` (`UID`) ON DELETE CASCADE, CONSTRAINT `dy_topic_ibfk_2` FOREIGN KEY (`TGID`) REFERENCES `dy_topic_group` (`TGID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of dy_topic -- ---------------------------- INSERT INTO `dy_topic` VALUES ('1', '1', '10001', 'Integer类的一个小问题 ==比较', 'Integer内的值的大小在Byte范围内时，==比较返回true 在那范围之外返回false \r\n这是为什么呢，为什么会这样》？ ', '2015-03-09 11:39:47', '20'); INSERT INTO `dy_topic` VALUES ('2', '1', '10001', '怎样学习框架ssh', '学习struts spring hibernate 的顺序是ssh吗 顺便根据我的情况推荐几本书', '2015-03-09 11:39:47', '17'); INSERT INTO `dy_topic` VALUES ('3', '2', '10003', 'C++很难吗？应该怎么样学习呢', '请给我推荐几本C++的书，给我讲些学习方法谢谢', '2015-03-09 11:39:47', '13'); INSERT INTO `dy_topic` VALUES ('4', '2', '10001', '测试', '测试测试测试测试测试测试测试测试测试', '2015-03-09 11:39:48', '12'); INSERT INTO `dy_topic` VALUES ('5', '1', '10001', 'JAVA很难吗？应该怎么样学习呢', '请给我推荐几本JAVA的书，给我讲些学习方法谢谢', '2015-03-09 11:39:48', '13'); INSERT INTO `dy_topic` VALUES ('6', '1', '10002', '请教一句SQL这么写。。', '这个SQL好难啊，应该怎么学呢', '2015-03-09 11:39:48', '12'); INSERT INTO `dy_topic` VALUES ('7', '1', '10002', '测试71', '测试测试测试测试测试测试测试测试测试7', '2015-03-09 11:39:48', '12'); INSERT INTO `dy_topic` VALUES ('8', '1', '10001', '测试81', '测试测试测试测试测试测试测试测试测试8', '2015-03-09 11:39:48', '13'); INSERT INTO `dy_topic` VALUES ('9', '1', '10002', '测试91', '测试测试测试测试测试测试测试测试测试9', '2015-03-09 11:39:48', '12'); INSERT INTO `dy_topic` VALUES ('10', '1', '10001', '测试101', '测试测试测试测试测试测试测试测试测试10', '2015-03-09 11:39:48', '13'); INSERT INTO `dy_topic` VALUES ('11', '1', '10002', '测试111', '测试测试测试测试测试测试测试测试测试11', '2015-03-09 11:39:48', '12'); INSERT INTO `dy_topic` VALUES ('12', '1', '10001', '测试121', '测试测试测试测试测试测试测试测试测试12', '2015-03-09 11:39:48', '16'); INSERT INTO `dy_topic` VALUES ('13', '1', '10001', 'aaaa', 'bbbb', '2015-03-12 20:48:44', '0'); -- ---------------------------- -- Table structure for `dy_topic_group` -- ---------------------------- DROP TABLE IF EXISTS `dy_topic_group`; CREATE TABLE `dy_topic_group` ( `TGID` int(11) NOT NULL auto_increment, `TGName` varchar(50) NOT NULL, `TDetail` varchar(200) NOT NULL, PRIMARY KEY (`TGID`) ) ENGINE=InnoDB AUTO_INCREMENT=10009 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of dy_topic_group -- ---------------------------- INSERT INTO `dy_topic_group` VALUES ('10000', 'Java网络编程', '计算机与自动控制学院'); INSERT INTO `dy_topic_group` VALUES ('10001', '数据库系统概论', '计算机与自动控制学院'); INSERT INTO `dy_topic_group` VALUES ('10002', 'C语言程序设计', '计算机与自动控制学院'); INSERT INTO `dy_topic_group` VALUES ('10003', '高等数学', '理学院'); INSERT INTO `dy_topic_group` VALUES ('10004', '线性代数', '理学院'); INSERT INTO `dy_topic_group` VALUES ('10005', '自动控制原理', '机械学院'); INSERT INTO `dy_topic_group` VALUES ('10006', '大学英语1', '外国语学院'); INSERT INTO `dy_topic_group` VALUES ('10007', '运筹学', '经济管理学院'); INSERT INTO `dy_topic_group` VALUES ('10008', 'xxx', 'xxxx'); -- ---------------------------- -- Table structure for `dy_tu` -- ---------------------------- DROP TABLE IF EXISTS `dy_tu`; CREATE TABLE `dy_tu` ( `TUID` int(11) NOT NULL auto_increment, `UID` int(11) default NULL, `TGID` int(11) default NULL, PRIMARY KEY (`TUID`), KEY `UID` (`UID`), KEY `TGID` (`TGID`), CONSTRAINT `dy_tu_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `dy_user` (`UID`) ON DELETE CASCADE, CONSTRAINT `dy_tu_ibfk_2` FOREIGN KEY (`TGID`) REFERENCES `dy_topic_group` (`TGID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of dy_tu -- ---------------------------- INSERT INTO `dy_tu` VALUES ('1', '2', '10000'); INSERT INTO `dy_tu` VALUES ('2', '2', '10001'); INSERT INTO `dy_tu` VALUES ('3', '2', '10002'); INSERT INTO `dy_tu` VALUES ('4', '1', '10001'); INSERT INTO `dy_tu` VALUES ('5', '1', '10003'); INSERT INTO `dy_tu` VALUES ('6', '1', '10005'); -- ---------------------------- -- Table structure for `dy_user` -- ---------------------------- DROP TABLE IF EXISTS `dy_user`; CREATE TABLE `dy_user` ( `UID` int