社区 › 项目源码 › javaWeb在线考试系统SSH框架

changer 发表于 2017-6-26 21:57

感觉界面挺简洁的，比较容易懂。

Mr.Zhang 发表于 2017-6-28 20:52

很好，正需要，谢谢分享

zhaokejin 发表于 2017-7-2 09:25

javaWeb在线考试系统SSH框架

cxy729971396 发表于 2017-7-3 09:50

好好看一下，借鉴一二，

shilei13145208 发表于 2017-7-4 16:59

啦啦啦啦啊啦啦啦啦啦啦啦啦啦啦

xisole 发表于 2017-7-7 10:37

好东西，看看学习一下

暖暖 发表于 2017-7-7 13:17

是MYSQL 还是sql 啊 下来看看

暖暖 发表于 2017-7-9 11:31

数据库导入错误 求解答呜呜呜

暖暖 发表于 2017-7-9 11:32

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- MySQL Administrator dump 1.4
--
-- ---------------------------------------' at line 1
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version        5.5.15


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema onlinexam
--

CREATE DATABASE IF NOT EXISTS onlinexam;
USE onlinexam;

--
-- Definition of table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`adm_id` int(11) NOT NULL AUTO_INCREMENT,
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`adm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `admin`
--

/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
(1,'admin','52itstyle');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;


--
-- Definition of table `examtype`
--

DROP TABLE IF EXISTS `examtype`;
CREATE TABLE `examtype` (
`type_id` int(11) NOT NULL AUTO_INCREMENT,
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `examtype`
--

/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
(1,'语文','6'),
(2,'PHP','2011-10-26'),
(3,'ORACLE','120');
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;


--
-- Definition of table `question`
--

DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
`qu_id` int(11) NOT NULL AUTO_INCREMENT,
`type_id` int(11) NOT NULL,
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`quScore` int(11) NOT NULL,
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`qu_id`),
KEY `FKBE5CA00621011593` (`type_id`),
KEY `FKBE5CA006B04D67C1` (`type_id`),
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `question`
--

/*!40000 ALTER TABLE `question` DISABLE KEYS */;
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
(8,1,'欧的拼音','简单','单选题',1,'ou:ow:you','1'),
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
/*!40000 ALTER TABLE `question` ENABLE KEYS */;


--
-- Definition of table `student`
--

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`className` varchar(255) COLLATE utf8_unicode_c
Finished - Unsuccessfully

辉GE哥 发表于 2017-7-9 12:30

谢谢楼主哦:lol

查看完整版本: javaWeb在线考试系统SSH框架