JSP基于SSH2的网络在线问答系统 | 毕业设计

-- phpMyAdmin SQL Dump -- version 3.5.2.2 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2012 年 11 月 23 日 11:15 -- 服务器版本: 5.00.15 -- PHP 版本: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- 数据库: `project` -- -- -------------------------------------------------------- -- -- 表的结构 `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL auto_increment, `adminid` varchar(40) collate gb2312_bin NOT NULL, `adminpwd` varchar(40) collate gb2312_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin AUTO_INCREMENT=2 ; -- -- 转存表中的数据 `admin` -- INSERT INTO `admin` (`id`, `adminid`, `adminpwd`) VALUES (1, 'admin', '21232F297A57A5A743894A0E4A801FC3'); -- -------------------------------------------------------- -- -- 表的结构 `answer` -- CREATE TABLE IF NOT EXISTS `answer` ( `id` int(11) NOT NULL auto_increment, `grade` varchar(255) collate gb2312_bin default NULL, `anstime` datetime default NULL, `status` int(11) default NULL, `quesans` longtext collate gb2312_bin, `userid` int(11) default NULL, `qid` int(11) default NULL, PRIMARY KEY (`id`), KEY `FKABCA3FBE9A2FC8F9` (`qid`), KEY `FKABCA3FBEDEC6F138` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- 表的结构 `item` -- CREATE TABLE IF NOT EXISTS `item` ( `id` int(11) NOT NULL auto_increment, `itemname` varchar(40) collate gb2312_bin NOT NULL, `itemcode` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin AUTO_INCREMENT=6 ; -- -- 转存表中的数据 `item` -- INSERT INTO `item` (`id`, `itemname`, `itemcode`) VALUES (1, 'j2ee', 1), (2, 'j2se', 2), (3, 'c', 3), (4, 'jsp', 4), (5, 'asp', 5); -- -------------------------------------------------------- -- -- 表的结构 `question` -- CREATE TABLE IF NOT EXISTS `question` ( `id` int(11) NOT NULL auto_increment, `title` varchar(40) collate gb2312_bin default NULL, `content` longtext collate gb2312_bin, `offerscore` int(11) default NULL, `status` int(11) default NULL, `questiontime` datetime default NULL, `clickcount` int(11) default NULL, `acceptflag` int(11) default NULL, `commonflag` int(11) default NULL, `itemid` int(11) default NULL, `subitemid` int(11) default NULL, `userid` int(11) default NULL, PRIMARY KEY (`id`), KEY `FKBA823BE6CA555DC8` (`itemid`), KEY `FKBA823BE6644B3E7A` (`subitemid`), KEY `FKBA823BE6DEC6F138` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin AUTO_INCREMENT=2 ; -- -- 转存表中的数据 `question` -- INSERT INTO `question` (`id`, `title`, `content`, `offerscore`, `status`, `questiontime`, `clickcount`, `acceptflag`, `commonflag`, `itemid`, `subitemid`, `userid`) VALUES (1, 'title', 'mvc框架是什么意思啊！', 2, 1, '2012-11-23 18:59:36', 1, 2, 1, 1, 1, 1); -- -------------------------------------------------------- -- -- 表的结构 `subitem` -- CREATE TABLE IF NOT EXISTS `subitem` ( `id` int(11) NOT NULL auto_increment, `subname` varchar(255) collate gb2312_bin default NULL, `subcode` int(11) default NULL, `itemid` int(11) default NULL, PRIMARY KEY (`id`), KEY `FK90AA1953CA555DC8` (`itemid`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin AUTO_INCREMENT=6 ; -- -- 转存表中的数据 `subitem` -- INSERT INTO `subitem` (`id`, `subname`, `subcode`, `itemid`) VALUES (1, 'jsp技术', 1, 1), (2, '接口编程', 2, 2), (3, '面向对象', 3, 3), (4, '网络技术', 4, 4), (5, '框架', 5, 5); -- -------------------------------------------------------- -- -- 表的结构 `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL auto_increment, `userid` varchar(20) collate gb2312_bin default NULL, `userpwd` varchar(60) collate gb2312_bin default NULL, `userques` varchar(255) collate gb2312_bin default NULL, `userans` varchar(255) collate gb2312_bin default NULL, `integral` int(11) default NULL, `grade` int(11) default NULL, `sex` varchar(2) collate gb2312_bin default NULL, `realname` varchar(20) collate gb2312_bin default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `user` -- INSERT INTO `user` (`id`, `userid`, `userpwd`, `userques`, `userans`, `integral`, `grade`, `sex`, `realname`) VALUES (1, 'linlin', 'E10ADC3949BA59ABBE56E057F20F883E', NULL, NULL, 0, 1, NULL, NULL), (2, 'wangwang', 'E10ADC3949BA59ABBE56E057F20F883E', NULL, NULL, 5, 1, NULL, NULL); -- -- 限制导出的表 -- -- -- 限制表 `answer` -- ALTER TABLE `answer` ADD CONSTRAINT `FKABCA3FBEDEC6F138` FOREIGN KEY (`userid`) REFERENCES `user` (`id`), ADD CONSTRAINT `FKABCA3FBE9A2FC8F9` FOREIGN KEY (`qid`) REFERENCES `question` (`id`); -- -- 限制表 `question` -- ALTER TABLE `question` ADD CONSTRAINT `FKBA823BE6DEC6F138` FOREIGN KEY (`userid`) REFERENCES `user` (`id`), ADD CONSTRAINT `FKBA823BE6644B3E7A` FOREIGN KEY (`subitemid`) REFERENCES `subitem` (`id`), ADD CONSTRAINT `FKBA823BE6CA555DC8` FOREIGN KEY (`itemid`) REFERENCES `item` (`id`); -- -- 限制表 `subitem` -- ALTER TABLE `subitem` ADD CONSTRAINT `FK90AA1953CA555DC8` FOREIGN KEY (`itemid`) REFERENCES `item` (`id`);