javaWeb在线考试系统SSH框架

QQ账号登录	立即注册>>

辉GE哥

0 主题	0 听众	78 金钱

三袋弟子

该用户从未签到

200^#

发表于 2017-07-09 12:30:23 |只看该作者

谢谢楼主哦

使用道具举报

暖暖

2 主题	0 听众	100 金钱

三袋弟子

该用户从未签到

199^#

发表于 2017-07-09 11:32:57 |只看该作者

[Err] 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
[Err] -- 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

w: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
[Msg] Finished - Unsuccessfully

使用道具举报