TomExam开源在线考试系统

最新推荐文章于 2025-04-11 17:56:54 发布
嘟嘟撸
最新推荐文章于 2025-04-11 17:56:54 发布
阅读量7.9k
点赞数
分类专栏： java
本文链接：https://blog.youkuaiyun.com/xcr530551426/article/details/96966123
版权
TomExam是一个开源的在线考试系统，适用于创建、管理和评估考试。它提供了管理员账户admin，密码admin，并且源码已在JDK8环境下编译通过。用户可以从指定链接下载源代码，官网提供更多信息。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
官网：http://www.tomexam.com/
源程序下载地址：https://download.youkuaiyun.com/download/xcr530551426/11339831
源码在jdk8下编译通过，管理员账户：admin admin
数据库脚本如下：
/*
Navicat MySQL Data Transfer

Source Server         : localhost4406
Source Server Version : 50547
Source Host           : localhost:4406
Source Database       : tomexam3_free

Target Server Type    : MYSQL
Target Server Version : 50547
File Encoding         : 65001

Date: 2017-05-27 11:30:19
*/

SET FOREIGN_KEY_CHECKS=0;

SET GLOBAL log_bin_trust_function_creators = 1;

-- ----------------------------
-- Table structure for `tm_admin`
-- ----------------------------
DROP TABLE IF EXISTS `tm_admin`;
CREATE TABLE `tm_admin` (
  `a_id` varchar(50) NOT NULL,
  `a_username` varchar(50) DEFAULT NULL,
  `a_userpass` varchar(50) DEFAULT NULL,
  `a_roleid` varchar(50) DEFAULT NULL,
  `a_realname` varchar(50) DEFAULT NULL,
  `a_photo` varchar(100) DEFAULT NULL,
  `a_phone` varchar(50) DEFAULT NULL,
  `a_email` varchar(50) DEFAULT NULL,
  `a_status` int(2) DEFAULT NULL,
  `a_createdate` datetime DEFAULT NULL,
  `a_salt` varchar(10) DEFAULT NULL,
  `a_remark` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`a_id`),
  KEY `FK_ref_admin_role` (`a_roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_admin
-- ----------------------------
INSERT INTO `tm_admin` VALUES ('898cefdf-d372-410d-b5d5-332e71b43e64', 'admin', '6FA02139601E4D8F578A2B5AAD015449', '7e33ecad-b7c5-4b93-a4ff-b13f12a067be', '管理员', '', '139231', 'admin@tomexam.com', '1', '2016-03-12 21:52:46', 't8kgmtbiom', 'This is administrator&#39;s account');

-- ----------------------------
-- Table structure for `tm_admin_addition`
-- ----------------------------
DROP TABLE IF EXISTS `tm_admin_addition`;
CREATE TABLE `tm_admin_addition` (
  `a_id` varchar(50) DEFAULT NULL,
  `a_logintimes` int(11) DEFAULT '0',
  `a_lastlogin` datetime DEFAULT NULL,
  KEY `FK_ref_admin_addtion` (`a_id`),
  CONSTRAINT `tm_admin_addition_ibfk_1` FOREIGN KEY (`a_id`) REFERENCES `tm_admin` (`a_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_admin_addition
-- ----------------------------
INSERT INTO `tm_admin_addition` VALUES ('898cefdf-d372-410d-b5d5-332e71b43e64', '99', '2017-05-27 11:24:20');

-- ----------------------------
-- Table structure for `tm_admin_role`
-- ----------------------------
DROP TABLE IF EXISTS `tm_admin_role`;
CREATE TABLE `tm_admin_role` (
  `r_id` varchar(50) NOT NULL,
  `r_name` varchar(50) DEFAULT NULL,
  `r_status` int(2) DEFAULT NULL,
  `r_createdate` datetime DEFAULT NULL,
  `r_privilege` text,
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_admin_role
-- ----------------------------
INSERT INTO `tm_admin_role` VALUES ('7e33ecad-b7c5-4b93-a4ff-b13f12a067be', '超级管理员', '1', '2016-03-11 22:48:03', 'M-QDB,F-QDB,P-QDB-ADD,P-QDB-DELETE,P-QDB-UPDATE,P-QDB-VIEW,F-QES,P-QES-ADD,P-QES-DELETE,P-QES-UPDATE,P-QES-VIEW,P-QES-IMPORT,M-PAPER,F-PAPER,P-PAPER-ADD,P-PAPER-DELETE,P-PAPER-CLONE,P-PAPER-EXPORTWORD,P-PAPER-UPDATE,P-PAPER-VIEW,P-PAPER-HISTORY-VIEW,P-PAPER-HISTORY-CHECK,P-PAPER-HISTORY-REMOVE,F-PAPER-CATE,P-PAPER-CATE-ADD,P-PAPER-CATE-DELETE,P-PAPER-CATE-UPDATE,P-PAPER-CATE-VIEW,M-SELFTEST,F-SELFTEST,P-SELFTEST-RECORDS-VIEW,P-SELFTEST-RECORDS-DELETE,M-ANALYSIS,F-ANALYSIS,P-ANA-EXAM,P-ANA-PAPER,P-ANA-SCORE,M-USERS,F-USERS,P-USER-ADD,P-USER-IMPORT,P-USER-DELETE,P-USER-UPDATE,P-USER-VIEW,P-USER-EXAMVIEW,F-BRANCH,P-BRANCH-ADD,P-BRANCH-DELETE,P-BRANCH-UPDATE,P-BRANCH-VIEW,F-UPOSITION,P-UPOSITION-ADD,P-UPOSITION-DELETE,P-UPOSITION-UPDATE,P-UPOSITION-VIEW,M-INTERACTION,F-NEWS,P-NEWS-ADD,P-NEWS-DELETE,P-NEWS-UPDATE,P-NEWS-VIEW,F-NEWSCATE,P-NEWSCATE-ADD,P-NEWSCATE-DELETE,P-NEWSCATE-UPDATE,P-NEWSCATE-VIEW,M-LEARNING,F-COURSE,P-COURSE-ADD,P-COURSE-DELETE,P-COURSE-UPDATE,P-COURSE-DATAVIEW,F-COURSE-CATEGORY,P-COURSE-CATEGORY-ADD,P-COURSE-CATEGORY-DELETE,P-COURSE-CATEGORY-UPDATE,F-COURSE-TEACHER,P-COURSE-TEACHER-ADD,P-COURSE-TEACHER-DELETE,P-COURSE-TEACHER-UPDATE,M-SYSTEM,F-SYS,P-SYS-CONFIG,P-SYS-LOG,F-ADMIN,P-ADMIN-ADD,P-ADMIN-DELETE,P-ADMIN-UPDATE,P-ADMIN-VIEW,F-ROLE,P-ROLE-ADD,P-ROLE-DELETE,P-ROLE-UPDATE,P-ROLE-VIEW,M-OTHER,F-SUPER,P-OTH-SUPER');

-- ----------------------------
-- Table structure for `tm_branch`
-- ----------------------------
DROP TABLE IF EXISTS `tm_branch`;
CREATE TABLE `tm_branch` (
  `b_id` varchar(50) NOT NULL,
  `b_name` varchar(50) DEFAULT NULL,
  `b_pid` varchar(50) DEFAULT NULL,
  `b_remark` varchar(50) DEFAULT NULL,
  `b_order` int(3) DEFAULT NULL,
  `b_status` int(2) DEFAULT NULL,
  `b_poster` varchar(50) DEFAULT NULL,
  `b_createdate` datetime DEFAULT NULL,
  `b_modifyor` varchar(50) DEFAULT NULL,
  `b_modifydate` datetime DEFAULT NULL,
  PRIMARY KEY (`b_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_branch
-- ----------------------------
INSERT INTO `tm_branch` VALUES ('827ea7bb-138d-425e-9fdf-13e97172b039', '测试部门', '0', '', '1', '1', 'admin', '2016-06-11 23:04:17', 'admin', '2016-06-11 23:04:17');

-- ----------------------------
-- Table structure for `tm_course`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course`;
CREATE TABLE `tm_course` (
  `c_id` varchar(50) NOT NULL,
  `c_name` varchar(100) DEFAULT NULL,
  `c_logo` varchar(100) DEFAULT NULL,
  `c_tid` varchar(50) DEFAULT NULL,
  `c_caid` varchar(50) DEFAULT NULL,
  `c_score` int(11) DEFAULT NULL,
  `c_type` int(2) DEFAULT NULL COMMENT '1必修，0选修',
  `c_introduce` text,
  `c_postdate` datetime DEFAULT NULL,
  `c_modifydate` datetime DEFAULT NULL,
  `c_status` int(2) DEFAULT '0' COMMENT '1正常，-9已删除，0待审核',
  `c_stars` int(11) DEFAULT NULL COMMENT '管理员给的分值，如：5代表5颗星',
  `c_data` longtext,
  `c_poster` varchar(50) DEFAULT NULL,
  `c_modifier` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_category`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_category`;
CREATE TABLE `tm_course_category` (
  `ca_id` varchar(50) NOT NULL,
  `ca_name` varchar(50) DEFAULT NULL,
  `ca_desc` text,
  `ca_logo` varchar(100) DEFAULT NULL,
  `ca_pid` varchar(50) DEFAULT NULL,
  `ca_status` int(2) DEFAULT NULL,
  `ca_order` int(11) DEFAULT NULL,
  `ca_postdate` datetime DEFAULT NULL,
  PRIMARY KEY (`ca_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_category
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_comments`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_comments`;
CREATE TABLE `tm_course_comments` (
  `c_id` varchar(50) NOT NULL,
  `c_cid` varchar(50) DEFAULT NULL,
  `c_uid` varchar(50) DEFAULT NULL,
  `c_content` text,
  `c_postdate` datetime DEFAULT NULL,
  `c_ip` varchar(50) DEFAULT NULL,
  `c_status` int(2) DEFAULT NULL COMMENT '1正常，-9已删除',
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_comments
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_favorites`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_favorites`;
CREATE TABLE `tm_course_favorites` (
  `f_id` varchar(50) NOT NULL,
  `f_cid` varchar(50) DEFAULT NULL,
  `f_uid` varchar(50) DEFAULT NULL,
  `f_favdate` datetime DEFAULT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_favorites
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_note`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_note`;
CREATE TABLE `tm_course_note` (
  `n_id` varchar(50) NOT NULL,
  `n_cid` varchar(50) DEFAULT NULL,
  `n_sid` varchar(50) DEFAULT NULL,
  `n_leid` varchar(50) DEFAULT NULL,
  `n_uid` varchar(50) DEFAULT NULL,
  `n_content` text,
  `n_postdate` datetime DEFAULT NULL,
  `n_status` int(2) DEFAULT NULL,
  PRIMARY KEY (`n_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_note
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_progress_history`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_progress_history`;
CREATE TABLE `tm_course_progress_history` (
  `p_id` varchar(50) NOT NULL,
  `p_cid` varchar(50) DEFAULT NULL,
  `p_sid` varchar(50) DEFAULT NULL,
  `p_leid` varchar(50) DEFAULT NULL,
  `p_uid` varchar(50) DEFAULT NULL,
  `p_startdate` datetime DEFAULT NULL COMMENT '1完成，0进行中',
  `p_enddate` datetime DEFAULT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_progress_history
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_qa`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_qa`;
CREATE TABLE `tm_course_qa` (
  `q_id` varchar(50) NOT NULL,
  `q_cid` varchar(50) DEFAULT NULL,
  `q_uid` varchar(50) DEFAULT NULL,
  `q_question` text,
  `q_answer` text,
  `q_postdate` datetime DEFAULT NULL,
  `q_answerdate` datetime DEFAULT NULL,
  `q_status` int(2) DEFAULT NULL COMMENT '0未回答，1已回答（正常），-9已删除',
  PRIMARY KEY (`q_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_qa
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_teacher`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_teacher`;
CREATE TABLE `tm_course_teacher` (
  `t_id` varchar(50) NOT NULL,
  `t_name` varchar(50) DEFAULT NULL,
  `t_phone` varchar(50) DEFAULT NULL,
  `t_email` varchar(50) DEFAULT NULL,
  `t_photo` varchar(100) DEFAULT NULL,
  `t_info` text,
  `t_createdate` datetime DEFAULT NULL,
  `t_modifydate` datetime DEFAULT NULL,
  PRIMARY KEY (`t_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_teacher
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_course_userscore_detail`
-- ----------------------------
DROP TABLE IF EXISTS `tm_course_userscore_detail`;
CREATE TABLE `tm_course_userscore_detail` (
  `d_id` varchar(50) NOT NULL,
  `d_cid` varchar(50) DEFAULT NULL,
  `d_uid` varchar(50) DEFAULT NULL,
  `d_passdate` datetime DEFAULT NULL,
  `d_score` int(11) DEFAULT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_course_userscore_detail
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_examdata`
-- ----------------------------
DROP TABLE IF EXISTS `tm_examdata`;
CREATE TABLE `tm_examdata` (
  `e_id` varchar(50) NOT NULL,
  `e_pid` varchar(50) DEFAULT NULL,
  `e_uid` varchar(50) DEFAULT NULL,
  `e_starttime` datetime DEFAULT NULL,
  `e_endtime` datetime DEFAULT NULL,
  `e_ip` varchar(50) DEFAULT NULL,
  `e_score` int(4) DEFAULT NULL,
  `e_status` int(2) DEFAULT NULL COMMENT '0未交卷，1已交卷待批改，2已批改',
  `e_data` longtext,
  `e_check` longtext,
  PRIMARY KEY (`e_id`),
  KEY `IDX_PID` (`e_pid`),
  KEY `IDX_UID` (`e_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_examdata
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_examdata_addition`
-- ----------------------------
DROP TABLE IF EXISTS `tm_examdata_addition`;
CREATE TABLE `tm_examdata_addition` (
  `e_id` int(11) NOT NULL,
  `e_pid` varchar(50) DEFAULT NULL,
  `e_uid` varchar(50) DEFAULT NULL,
  `e_remarker` varchar(50) DEFAULT NULL,
  `e_remark` text,
  `e_remarkdate` datetime DEFAULT NULL,
  PRIMARY KEY (`e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_examdata_addition
-- ----------------------------

-- ----------------------------
-- Table structure for `tm_news`
-- ----------------------------
DROP TABLE IF EXISTS `tm_news`;
CREATE TABLE `tm_news` (
  `n_id` varchar(50) NOT NULL,
  `n_title` varchar(100) DEFAULT NULL,
  `n_title_color` varchar(20) DEFAULT NULL,
  `n_classid` varchar(50) DEFAULT NULL,
  `n_content` text,
  `n_status` int(2) DEFAULT NULL,
  `n_totop` int(2) DEFAULT NULL,
  `n_visit` int(10) DEFAULT NULL,
  `n_photo` varchar(50) DEFAULT NULL,
  `n_author` varchar(20) DEFAULT NULL,
  `n_newsfrom` varchar(50) DEFAULT NULL,
  `n_poster` varchar(50) DEFAULT NULL,
  `n_createdate` datetime DEFAULT NULL,
  `n_modifyor` varchar(50) DEFAULT NULL,
  `n_modifydate` datetime DEFAULT NULL,
  PRIMARY KEY (`n_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tm_news
-- ----------------------------
INSERT INTO `tm_news` VALUES ('67e3806e-51e5-4b86-a161-8fa2245d2bb1', '欢迎使用TomExam3.0网络考试系统', '#000000', 'ec18ebd1-75f5-4a74-8be6-eba3efece1a4', '<p>TomExam第一版发布于2010年，在过去的数年中，它为数以万计的用户提供了良好的网络考试解决方案。</p>\r\n\r\n<p>TomExam是一款基于JAVA与MYSQL开发的网络考试系统，考生和管理人员可以通过浏览器直接进行操作，无需安装任何程序或插件。</p>\r\n\r\n<p>TomExam可以稳定、顺畅的运行在Windows与Linux平台上。考试组织者可以通过它快捷方便的创建题库，发布试卷，组织考试，并由系统自动批改。高度的可配置性和灵活性使得它可以被应用于很多领域。TomExam3.0版本新增试题批量导入，在线学习，断电数据保存等若干实用新功能。并对试卷自动批改，统计分析，试卷创建等功能进行功能和性能优化。</p>\r\n\r\n<p>TomExam网络考试系统基于B/S架构实现，考生和管理员通过浏览器即可管理系统和考试，无需安装任何程序或插件。</p>\r\n\r\n<p>系统支持普通试卷（随机混排模式）、随机试卷（每个考生的试卷各不相同）、单体模式、整卷模式等控制，有效防止考生作弊。系统采用对象化的题型模板，可以根据需要扩展新的题型。默认支持：单选题、多选题、判断题、填空题、问答题等题型。</p>\r\n', '1', '0', '3', '', '', '', 'admin', '2017-05-27 11:27:19', 'admin', '2017-05-27 11:28:46');

-- ----------------------------
-- Table structure for `tm_news_cateogry`
-- ----------------------------
DROP TABLE IF EXISTS `tm_news_cateogry`;
CREATE TABLE `tm_news_cateogry` (
  `c_id` varchar(50) NOT NULL,
  `c_name` varchar(50) DEFAULT NULL,
  `c_pid` varchar(50) DEFAULT NULL,
  `c_poster` varchar(50) DEFAULT NULL,
  `c_orderid`
最低0.47元/天解锁文章