javaWeb在线考试系统SSH框架

changer

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

Mr.Zhang

很好，正需要，谢谢分享

zhaokejin

javaWeb在线考试系统SSH框架

cxy729971396

4 m; @0 g# j+ Q3 b0 y1 x, F好好看一下，借鉴一二，

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
[Err] -- MySQL Administrator dump 1.4
--
: o( z2 m5 X+ {# Y! X-- ------------------------------------------------------
6 l  Z; t: a% x* c-- Server version        5.5.15
2 A/ J/ w, N: l0 ?% e
! _# j2 q  b& N2 O$ I
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- M4 g$ C' b$ n% }/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
- N( ]* _; m5 ?
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
8 @/ g2 c- k9 o- V- U9 u+ j/*!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;

  I% W8 ^$ J4 F! |, Q1 u--
# \: X# q; |, V8 k7 o+ j2 B4 O) a-- Definition of table `admin`
--
. O- b& N& A% V+ Z( {5 Z2 Z0 z
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
1 N1 d# h2 y9 k( E3 g  `adm_id` int(11) NOT NULL AUTO_INCREMENT,
5 n- a& R8 P% N/ z* m8 ^  `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`adm_id`)
* X: f: @/ A1 a7 }: J3 a$ T) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
3 L& }& v2 ?. f$ c4 w-- Dumping data for table `admin`
--
: c" Z9 Z; ^' j$ k6 Q  y
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
$ Z! K$ W1 g4 F2 M5 i  {% XINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
: W0 @! c5 @  A0 J: B/ j! l (1,'admin','52itstyle');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;


. S0 m2 Y" C& c5 [& K$ ~--
-- Definition of table `examtype`
4 `( j/ s: v& N- o--

( G! y  I3 X8 n' N- U3 ~3 |; tDROP TABLE IF EXISTS `examtype`;
% n3 V8 E4 c. J3 G  v; B: ~CREATE TABLE `examtype` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
& E- }: z2 r7 P; h- o  `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
( E* a* K1 z: t  `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;

--
$ @! O4 m; Q  _7 p# F+ V' w7 [-- Dumping data for table `examtype`
; S3 k7 C. g( [8 c! |--

5 V0 p, [; ]& B6 @, R/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
  N. L  c% J# I/ g5 QINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
(1,'语文','6'),
(2,'PHP','2011-10-26'),
# a" l% @+ N, G! P# q8 K6 r2 i (3,'ORACLE','120');
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;

& b# G) h' z/ {2 u$ F1 ~
1 T: f" n, x* z: E  E! B, f--
-- Definition of table `question`
--

DROP TABLE IF EXISTS `question`;
! z2 j2 O4 M. VCREATE TABLE `question` (
  `qu_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
4 d/ C" L' |1 x3 z5 @# B  k  `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 O5 y, g9 b9 r% s! z; ^7 o  `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
$ H% V( w  C5 H& d5 p$ E  `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; [( w4 s* O$ h& B7 L* K6 k- n: Z  `quScore` int(11) NOT NULL,
  `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
* U* f5 H3 w5 M2 _) f1 N  PRIMARY KEY (`qu_id`),
  KEY `FKBE5CA00621011593` (`type_id`),
( `1 P9 c) g7 J3 g+ q! K) a  KEY `FKBE5CA006B04D67C1` (`type_id`),
, f7 ]; c1 J* _# G9 V  CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
  CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
% f0 T* I6 Y- ?7 B3 c  CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
6 ]5 e( ~3 J8 g3 N6 p$ z7 J; _) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `question`
2 c% c1 z5 l2 H0 Y$ @' L2 I--
9 a: @( ^4 Q3 o2 D2 Q
4 Q6 S* w( P% B/*!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'),
7 @' E2 V! Z# J6 ?6 X$ g (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
(8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
3 u' c( a* l& a$ n (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
2 I8 W) K. P' \  }8 ]# m (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
& k- O, @7 I# u5 L0 s) X  h& {/ F  Y" ]5 I (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
& Z  r: l5 |( P0 c3 T  y; v% Y/*!40000 ALTER TABLE `question` ENABLE KEYS */;


--
-- Definition of table `student`
--
! {9 h9 s4 H- v  z6 m
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,
/ r- m! L" d7 y. z1 \- e0 s# S  `className` varchar(255) COLLATE utf8_unicode_c
0 J! b! N8 X+ @( r- s, t+ \+ Z3 ?[Msg] Finished - Unsuccessfully

辉GE哥

谢谢楼主哦