javaWeb在线考试系统SSH框架

changer

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

Mr.Zhang

很好，正需要，谢谢分享

zhaokejin

javaWeb在线考试系统SSH框架

cxy729971396

好好看一下，借鉴一二，

shilei13145208

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

xisole

好东西，看看学习一下

暖暖

是MYSQL 还是sql 啊 下来看看

暖暖

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

暖暖

[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
) d+ q& Q; X# v& \# e( a) Y. }[Err] -- MySQL Administrator dump 1.4
--
7 G% l1 t$ r; P4 I-- ------------------------------------------------------
-- Server version        5.5.15


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
: d' S; F1 {. q) n- O/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
! L0 j, r7 ]" F4 ~6 G: K/*!40101 SET NAMES utf8 */;
  @$ }) I3 j2 f
" N+ }" m8 H4 M& Z# @  `# P. o/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3 [4 q2 N# V) h- |/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
0 w8 U$ e+ ?* m$ a/ f$ C/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

6 L+ B; W; m4 p1 i0 l
--
$ m8 m; c7 V5 J  Q, c7 E5 t. n0 B-- Create schema onlinexam
--
% }  r0 \% Y, S" F6 s
CREATE DATABASE IF NOT EXISTS onlinexam;
3 ?0 z$ E( r+ aUSE onlinexam;

--
3 }4 L: {$ p7 `: ?3 O( s4 l( z4 h-- Definition of table `admin`
--
, p0 ~' G  |: s
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
5 P& \6 h- \* x) M  `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,
+ @# X7 g0 |% _4 `' v6 g! {7 f$ X5 i  PRIMARY KEY (`adm_id`)
* J; U- W& ?2 @9 h) T- i- s) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  d/ O( F2 H, b- @
. e: ]) |: A! O# I2 g& e4 i# `9 H( u--
* n4 b5 d7 c: ^$ [# a1 x  M0 @-- Dumping data for table `admin`
--

/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
, \2 }! L5 i; @' @! `5 f3 ^ (1,'admin','52itstyle');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
2 G; e9 A* |) n5 `' X. b4 @

2 H* b% l5 u9 W3 K--
-- Definition of table `examtype`
' T1 q( W/ r) L2 \  n--

DROP TABLE IF EXISTS `examtype`;
) K4 G/ |4 t' y/ v9 `5 i8 q$ eCREATE TABLE `examtype` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
( h  n6 ~) b, x3 U- l3 ]' P1 q3 L/ b. ?  `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; b! G) q0 `. P/ I; S7 i6 ~  `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ C/ i& e, u3 S- `" T  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
0 H% x; ^# o9 F) g- M% T-- 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'),
! ]& j& l5 a/ x' y5 q: N1 S (3,'ORACLE','120');
, L" j! }# G9 R( R1 }; _, g/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;

8 F" W1 w* m2 A9 l: g/ s
--
2 b% n: L6 ]/ |-- Definition of table `question`
--

DROP TABLE IF EXISTS `question`;
% t5 U! h, ]% b, b3 O( B* ~CREATE TABLE `question` (
  `qu_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
1 J" B$ A  K" w  `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
. j  e4 l2 G7 e. j% ]  `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quScore` int(11) NOT NULL,
6 J' A0 Z  Q' U& A  `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
' J+ Z3 a7 D# W$ ]% g0 A* s# l  `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
: n+ ~* G( Z( f( R0 |% ?3 {  PRIMARY KEY (`qu_id`),
, f# J* I* V, c. e7 S( A  KEY `FKBE5CA00621011593` (`type_id`),
% _) g! I1 v! a: h3 x* w" x  KEY `FKBE5CA006B04D67C1` (`type_id`),
  CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
  CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
2 q) s  A9 j3 z4 u- f, g5 g! z6 J3 {  CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
/ X# J2 Q7 F& j% C+ S- }8 M4 O) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
8 ~; n5 d& l' Y& S/ W, @8 }6 S" ~0 v
--
9 P7 Z; w$ Q# w/ m! o-- Dumping data for table `question`
8 v3 w3 x) a! `: b--
$ b! W. F. T6 T9 X& g" E0 f1 [
/*!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'),
$ O! f- L5 t( E8 r; K1 | (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
* G+ y( d4 _' N( n (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
1 _( m4 S( c5 _5 v9 A! C (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
+ P' {+ d* p. M (8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),
! A6 z/ }6 [" y; L9 P (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
) b+ ~0 ]) w- y  Z* W; M+ E3 _+ Z8 a (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
" W! M1 Z( B3 F (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
/ R  n9 u" D5 w (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
/*!40000 ALTER TABLE `question` ENABLE KEYS */;

$ t  {: i# k* i, f) T$ G
: e$ l( M5 r9 W3 D( {--
-- Definition of table `student`
' \5 h: w3 O2 T7 {7 V/ z--
1 S3 z) h0 ?9 O' y
1 W- `: r* S0 k6 g% vDROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `stu_id` int(11) NOT NULL AUTO_INCREMENT,
% t1 D; f2 {' M& S8 J6 k  `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- K$ F/ j0 `) t; T. }0 m, u  `className` varchar(255) COLLATE utf8_unicode_c
[Msg] Finished - Unsuccessfully

辉GE哥

谢谢楼主哦