dbscript.sql

1、在Eclipse中导入工程

 (2,18,NULL,NULL,NULL,NULL),
 (2,19,NULL,NULL,NULL,NULL),
 (2,21,NULL,NULL,NULL,NULL),
 (4,2,NULL,NULL,NULL,NULL),
 (4,5,NULL,NULL,NULL,NULL),
 (4,7,NULL,NULL,NULL,NULL),
 (4,8,NULL,NULL,NULL,NULL),
 (4,9,NULL,NULL,NULL,NULL),
 (4,10,NULL,NULL,NULL,NULL),
 (4,11,NULL,NULL,NULL,NULL),
 (4,12,NULL,NULL,NULL,NULL),
 (4,15,NULL,NULL,NULL,NULL),
 (4,16,NULL,NULL,NULL,NULL),
 (4,17,NULL,NULL,NULL,NULL),
 (4,18,NULL,NULL,NULL,NULL),
 (4,20,NULL,NULL,NULL,NULL),
 (4,21,NULL,NULL,NULL,NULL),
 (4,22,NULL,NULL,NULL,NULL),
 (4,23,NULL,NULL,NULL,NULL);
CREATE TABLE `ex_examinee` (
  `EXAMINEE_ID` varchar(8) NOT NULL default '',
  `PASSWORD` varchar(10) default NULL,
  `NAME` varchar(20) default NULL,
  `SEX` varchar(3) default NULL,
  `AGE` int(10) unsigned default NULL,
  `ORGANIZATION_ID` varchar(9) default NULL,
  `POST_INDEX` int(10) unsigned default NULL,
  `STATE` varchar(3) default NULL,
  `OPERATION` varchar(3) default NULL,
  `EDUCATION_INDEX` int(10) unsigned default NULL,
  `ADDRESS` varchar(80) default NULL,
  `PHONE` varchar(40) default NULL,
  `MOBILE` varchar(40) default NULL,
  `EMAIL` varchar(40) default NULL,
  `REMARK` varchar(200) default NULL,
  PRIMARY KEY  (`EXAMINEE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_examinee` (`EXAMINEE_ID`,`PASSWORD`,`NAME`,`SEX`,`AGE`,`ORGANIZATION_ID`,`POST_INDEX`,`STATE`,`OPERATION`,`EDUCATION_INDEX`,`ADDRESS`,`PHONE`,`MOBILE`,`EMAIL`,`REMARK`) VALUES 
 ('s0001','s0001','张三','056',23,'1',7,'063','105',4,'北京大学','',NULL,'',''),
 ('s0002','s0002','李四','057',34,'2',1,'063','104',1,'','',NULL,'',''),
 ('s0003','s0003','王五','056',24,'3',3,'063','103',4,'','',NULL,'',''),
 ('s0004','s0004','李二','056',23,'3',3,'063','103',5,'','',NULL,'','');
CREATE TABLE `ex_question` (
  `Q_ID` int(10) unsigned NOT NULL auto_increment,
  `Q_CLASS` varchar(3) default NULL,
  `Q_KNOWLEDGE` varchar(3) default NULL,
  `Q_VALUE` float default NULL,
  `Q_TYPE` varchar(3) default NULL,
  `Q_DIFFICULTY` varchar(3) default NULL,
  `Q_CONTENT` text,
  `Q_ANSWER` text,
  `Q_STANDARD` text,
  `Q_PICTURE` varchar(100) default NULL,
  PRIMARY KEY  (`Q_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_question` (`Q_ID`,`Q_CLASS`,`Q_KNOWLEDGE`,`Q_VALUE`,`Q_TYPE`,`Q_DIFFICULTY`,`Q_CONTENT`,`Q_ANSWER`,`Q_STANDARD`,`Q_PICTURE`) VALUES 
 (1,'070','077',5,'047','086','JSP是哪个技术中的核心技术？','.NET##J2EE##VC++##JavaScript','B',''),
 (2,'070','077',5,'048','085','Java语言是哪个公司出品的？','SUN##太阳公司##微软公司##中科院##清华大学','AB',''),
 (3,'070','077',5,'047','085','Java语言以前叫什么？','OAK语言##C++语言##C语言##Basic语言','A',''),
 (4,'070','077',5,'047','087','JSP是哪几个单词缩写是？','Java Service Profession##Java Server Pages##不是缩写##不知道','B',''),
 (5,'070','077',5,'047','085','sin(PI)=? ps:PI=3.1415926......','1##-1##0##2','B',''),
 (6,'070','077',5,'047','086','北京奥运会是哪年举行？','2007##2008##2009##2010','C',''),
 (7,'070','078',5,'047','086','抗日战争打了几年？','1##2##9##8','D',''),
 (8,'070','077',5,'047','087','Struts是一种什么东西？','MVC框架##语言##编译器##虚拟机','A',''),
 (9,'070','077',5,'048','086','哪几种是常用的B/S结构编程语言？','ASP##JSP##C++##PHP##Basic','ABD',''),
 (10,'070','077',5,'048','085','哪些是J2EE的技术？','JDBC##Java##JNDI##JSTL##EL','AC','');
INSERT INTO `ex_question` (`Q_ID`,`Q_CLASS`,`Q_KNOWLEDGE`,`Q_VALUE`,`Q_TYPE`,`Q_DIFFICULTY`,`Q_CONTENT`,`Q_ANSWER`,`Q_STANDARD`,`Q_PICTURE`) VALUES 
 (11,'070','077',5,'048','085','下列哪些是J2EE中的技术？','JSP##Servlet##XML##IIS##ADO','ABC',''),
 (12,'070','077',5,'048','086','Java常用的开发环境包括：','Eclipse##J2EE##JBuilder##JSP##JDK？','AC',''),
 (13,'070','079',5,'048','085','喝什么茶对身体的帮助是最好？','绿茶##红茶##龙井##冰红茶##奶茶','AC',''),
 (14,'070','078',5,'048','085','以下是笔记本电脑生产商的是？','联想公司##雀巢##方正##三精##TCL','ACE',''),
 (15,'070','078',5,'049','085','synchronized关键字有什么功能','','处理同步与异步的操作。',''),
 (16,'070','077',10,'049','085','out对象有什么功能，out.print和document.write有什么区别','','一个是服务器端一个是客户端的',''),
 (17,'070','077',5,'050','085','Hibernate是用来干什么的，简单描述其特点？','','OR-Mapping产品，用来进行数据库持久层处理。','hibernate_logo_1.gif'),
 (18,'070','077',5,'049','086','Java包含哪三个版本 ','','J2EE、J2ME和J2SE','');
INSERT INTO `ex_question` (`Q_ID`,`Q_CLASS`,`Q_KNOWLEDGE`,`Q_VALUE`,`Q_TYPE`,`Q_DIFFICULTY`,`Q_CONTENT`,`Q_ANSWER`,`Q_STANDARD`,`Q_PICTURE`) VALUES 
 (19,'070','079',10,'049','085','实现服务器端保存信息的方法有？','','Session方法、Cookie方法以及Application方法',''),
 (20,'070','077',8,'050','085','ORM的优点是？','','可以提高生产率，增加程序的可维护性，提供更好的性能。',''),
 (21,'070','077',20,'050','085','显示XML文件常见的有三种方式','','使用CSS样式表，使用XSL样式单和使用XML的数据岛技术。',''),
 (22,'070','077',5,'047','085','MyEcipse是一种什么软件？','文本编辑器##J2EE开发插件##Java开花工具##服务器','B',''),
 (23,'070','077',5,'047','085','Hibernate的功能是？','开发工具##ORM工具##浏览器##编辑器','B','');
CREATE TABLE `ex_testpaper` (
  `t_id` int(10) unsigned NOT NULL auto_increment,
  `EXAMINEE_ID` char(8) default NULL,
  `E_ID` int(10) unsigned default NULL,
  `T_BEGIN` datetime default NULL,
  `T_END` datetime default NULL,
  `T_PASSVALUE` float default NULL,
  `E_AUTOVALUE` int(10) unsigned default NULL,
  `E_MANUALVALUE` int(10) unsigned default NULL,
  `T_TOTAL` float default NULL,
  `T_STATE` char(3) default NULL,
  PRIMARY KEY  (`t_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_testpaper` (`t_id`,`EXAMINEE_ID`,`E_ID`,`T_BEGIN`,`T_END`,`T_PASSVALUE`,`E_AUTOVALUE`,`E_MANUALVALUE`,`T_TOTAL`,`T_STATE`) VALUES 
 (4,'s0001',2,'2006-02-17 18:02:00','2006-02-17 18:04:03',60,60,18,78,'097'),
 (5,'s0002',2,'2006-02-17 17:56:21',NULL,60,0,0,-1,'096'),
 (6,'s0003',2,NULL,NULL,60,NULL,NULL,-1,'096'),
 (17,'s0001',4,'2006-02-19 17:37:14','2006-02-19 17:37:44',60,50,29,79,'097'),
 (18,'s0002',4,'2006-02-19 17:37:55','2006-02-19 17:38:21',60,50,43,93,'097'),
 (19,'s0003',4,'2006-02-19 17:38:32','2006-02-19 17:38:56',60,50,30,80,'097'),
 (20,'s0004',4,'2006-02-19 17:39:16','2006-02-19 17:39:42',60,45,30,75,'097');
CREATE TABLE `ex_testpaperdetail` (
  `T_ID` int(10) unsigned NOT NULL default '0',
  `Q_ID` int(10) unsigned NOT NULL default '0',
  `T_ANSWER` text,
  `T_VALUE` float default '0',
  PRIMARY KEY  (`T_ID`,`Q_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_testpaperdetail` (`T_ID`,`Q_ID`,`T_ANSWER`,`T_VALUE`) VALUES 
 (4,3,'A',5),
 (4,4,'B',5),
 (4,5,'B',5),
 (4,6,'C',5),
 (4,7,'D',5),
 (4,8,'A',5),
 (4,9,'ABD',5),
 (4,10,'AC',5),
 (4,11,'ABC',5),
 (4,12,'AC',5),
 (4,13,'AC',5),
 (4,14,'ACE',5),
 (4,15,'6,2005',5),
 (4,16,'xxx,xxx,',0),
 (4,18,'2002,0',5),
 (4,19,'china,8',8),
 (4,21,'xxxxxx',0),
 (5,3,NULL,-1),
 (5,4,NULL,-1),
 (5,5,NULL,-1),
 (5,6,NULL,-1),
 (5,7,NULL,-1),
 (5,8,NULL,-1),
 (5,9,NULL,-1),
 (5,10,NULL,-1),
 (5,11,NULL,-1),
 (5,12,NULL,-1),
 (5,13,NULL,-1),
 (5,14,NULL,-1),
 (5,15,NULL,-1),
 (5,16,NULL,-1),
 (5,18,NULL,-1),
 (5,19,NULL,-1),
 (5,21,NULL,-1),
 (6,3,NULL,-1),
 (6,4,NULL,-1),
 (6,5,NULL,-1),
 (6,6,NULL,-1),
 (6,7,NULL,-1),
 (6,8,NULL,-1),
 (6,9,NULL,-1),
 (6,10,NULL,-1),
 (6,11,NULL,-1),
 (6,12,NULL,-1),
 (6,13,NULL,-1),
 (6,14,NULL,-1),
 (6,15,NULL,-1),
 (6,16,NULL,-1),
 (6,18,NULL,-1),
 (6,19,NULL,-1),
 (6,21,NULL,-1),
 (17,2,'AB',5),
 (17,5,'B',5),
 (17,7,'D',5),
 (17,8,'A',5),
 (17,9,'ABD',5),
 (17,10,'AC',5);
INSERT INTO `ex_testpaperdetail` (`T_ID`,`Q_ID`,`T_ANSWER`,`T_VALUE`) VALUES 
 (17,11,'ABC',5),
 (17,12,'AC',5),
 (17,15,'',3),
 (17,16,'',8),
 (17,17,'',5),
 (17,18,'',5),
 (17,20,'',8),
 (17,21,'',0),
 (17,22,'B',5),
 (17,23,'B',5),
 (18,2,'AB',5),
 (18,5,'B',5),
 (18,7,'D',5),
 (18,8,'A',5),
 (18,9,'ABD',5),
 (18,10,'AC',5),
 (18,11,'ABC',5),
 (18,12,'AC',5),
 (18,15,'',5),
 (18,16,'',5),
 (18,17,'',5),
 (18,18,'',5),
 (18,20,'',8),
 (18,21,'',15),
 (18,22,'B',5),
 (18,23,'B',5),
 (19,2,'AB',5),
 (19,5,'B',5),
 (19,7,'D',5),
 (19,8,'A',5),
 (19,9,'ABD',5),
 (19,10,'AC',5),
 (19,11,'ABC',5),
 (19,12,'AC',5),
 (19,15,'',5),
 (19,16,'',8),
 (19,17,'',5),
 (19,18,'',5),
 (19,20,'',5),
 (19,21,'',2),
 (19,22,'B',5),
 (19,23,'B',5),
 (20,2,'AB',5),
 (20,5,'B',5),
 (20,7,'D',5),
 (20,8,'A',5),
 (20,9,'ABDE',0),
 (20,10,'AC',5),
 (20,11,'ABC',5),
 (20,12,'AC',5),
 (20,15,'',5),
 (20,16,'',5),
 (20,17,'',5),
 (20,18,'',5),
 (20,20,'',5),
 (20,21,'',5),
 (20,22,'B',5),
 (20,23,'B',5);
CREATE TABLE `test` (
  `test` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`test`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;