Shulou(Shulou.com)06/03 Report--

This article will explain in detail how to implement the online examination system in Java. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1. This system and some existing examination systems have the following advantages:

a. Compared with some existing systems, this system has the management of subjects, chapters, teachers, students, classes and other information, as well as marking the examination papers to see the approved examination papers and so on. The division of the traditional examination system is not detailed, and the business function is simple. b. Compared with the school examination system and the external examination system, this system is Bhand S structure, the school examination system is generally Cmax S structure, the performance is not as good as Bhand S structure, and the client interface needs to install the client, the client pressure is very great, my system only needs the computer to have the browser, can carry on the examination in the same local area network. c. In terms of architecture, our system is distributed, and the traditional examination system is not as reasonable as ours.

two。 Technical architecture of online examination system

Main technologies Spring, SpringMVC, MybatisJSP, JSTL, jQuery, HTML, CSS, JSMysqlbootstrap development tools and environment EclipseMavenTomcat 7JDK 1.8Mysql 5.6Win10 operating system traditional architecture traditional examination system adopts this architecture

Distributed architecture

The system adopts distributed architecture.

3. Introduction of system function

4. Database table relationship of this system

/ * in order to facilitate the query, it does not meet the paradigm requirements, but the query efficiency is very high * / / * because there are so many tables Therefore, the structural relationship between tables does not specify * /-administrator CREATE TABLE `admin` (`id` varchar (20) NOT NULL COMMENT 'administrator account id', `NAME` varchar (20) NOT NULL COMMENT' name', `sex`varchar (2) NOT NULL COMMENT 'gender', `age`int (11) DEFAULT NULL COMMENT 'age', `idcard`varchar (20) NOT NULL COMMENT'ID number', `phone`varchar (20) NOT NULL COMMENT 'cell phone number', `QQ`varchar (20) DEFAULT NULL COMMENT 'QQ'. `emai` varchar (20) DEFAULT NULL COMMENT 'mailbox', `PASSWORD` varchar (20) DEFAULT NULL COMMENT 'password', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8-- teacher CREATE TABLE `teacher` (`id`varchar (20) NOT NULL, `NAME` varchar (20) NOT NULL, `sex`varchar (2) NOT NULL, `age`int (11) email, `idcard` varchar (20) NOT NULL, `phone` varchar (20) NOT NULL, `Q` varchar (20) DEFAULT NULL, `email`varchar (20) DEFAULT NULL, `PASSWORD` varchar (20) DEFAULT NULL PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8-- student CREATE TABLE `student` (`id` varchar (20) NOT NULL, `classesId` int (11) DEFAULT NULL, `name` varchar (20) NOT NULL, `sex` varchar (2) NOT NULL, `age` int (11) DEFAULT NULL, `idcard` varchar (20) NOT NULL, `phone` varchar (20) NOT NULL, `Q` varchar (20) DEFAULT NULL, `email` varchar (20) DEFAULT NULL, `password` varchar (20) DEFAULT NULL, `classesName` varchar (20) DEFAULT NULL, PRIMARY KEY (`id`), `KEY FK_ study Classes` (`classesId`) CONSTRAINT `FK_ studentClasses` FOREIGN KEY (`classesId`) REFERENCES `classes` (`classesId`) ENGINE=InnoDB DEFAULT CHARSET=utf8-- subjects CREATE TABLE `classt` (`id` int (11) NOT NULL AUTO_INCREMENT, `NAME` varchar (20) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8-- chapter CREATE TABLE `chapter` (`id` int (11) NOT NULL AUTO_INCREMENT, `NAME` int (11) NOT NULL, `NAME` varchar (11) DEFAULT NULL, `title` varchar (255,255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_ SecrettChaper` (`sub_ id`) CONSTRAINT `FK_ classtChaper` FOREIGN KEY (`classesid`) REFERENCES `classt` (`id`) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8-- class CREATE TABLE `classes` (`classesId` int (11) NOT NULL AUTO_INCREMENT, `classesName` varchar (20) NOT NULL, `grade` varchar (20) NOT NULL, PRIMARY KEY (`classesId`) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8-- subject class mapping table CREATE TABLE `classes` (`classesId` int (11) NOT NULL, `id` int (11) NOT NULL, PRIMARY KEY (`classesId`, `id`), KEY `FK_ classtClasses2` (`id`), CONSTRAINT `FK_ classtClasses` FOREIGN KEY (`classesId`) REFERENCES `classes` (`classesId`) CONSTRAINT `FK_ classes2` FOREIGN KEY (`id`) REFERENCES `classt` (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8-- teacher's class schedule CREATE TABLE `classes` (`id` varchar (20) NOT NULL, `classesId` int (11) NOT NULL, `subId` int (11) NOT NULL, PRIMARY KEY (`id`, `classesId`, `subId`), KEY `classes2` (`classesId`), KEY `FK_teacher_ classes3` (`subId`), CONSTRAINT FK_teacher_ classes`FOREIGN KEY (`id`) REFERENCES `teacher` (`id`), CONSTRAINT `FK_teacher_ classes2` FOREIGN KEY (`classesId`) REFERENCES `classes` (`classesId`) CONSTRAINT `FK_teacher_ classes3` FOREIGN KEY (`subId`) REFERENCES `roomt` (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8-- teacher's catalogue CREATE TABLE `teacher_ account` (`id` varchar (20) NOT NULL, `sub_ id` int (11) NOT NULL, PRIMARY KEY (`id`, `sub_ id`), KEY `FK_teacher_ account2` (`sub_ id`), CONSTRAINT `FK_teacher_ account` FOREIGN KEY (`id`) REFERENCES `teacher` (`id`) CONSTRAINT `FK_teacher_ examt2` FOREIGN KEY (`examid`) REFERENCES `publist` (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8-- issues the examination form CREATE TABLE `publishexam` (`id`int (11) NOT NULL AUTO_INCREMENT, `admin_ id` varchar (20) NOT NULL, `publishTime` datetime NOT NULL, `subject_ id`int (11) NOT NULL, `examTime` datetime NOT NULL, `examtion`text, `exam` text, `exampe` varchar (20) DEFAULT NULL, `STATUS` int (11) DEFAULT NULL, `admin_ name` varchar (20) NOT NULL, `subject_ name` varchar (20) NOT NULL, `examexamth` int (11) NOT NULL PRIMARY KEY (`id`) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8-- student examination record table CREATE TABLE `examhis` (`studentId` varchar (20) NOT NULL, `studentName` varchar (20) DEFAULT NULL, `studtId` int (11) NOT NULL, `accountName` varchar (20) DEFAULT NULL, `classesId` int (11) DEFAULT NULL, `classesName` varchar (20) DEFAULT NULL, `examTime` datetime NOT NULL, `score` int (11) DEFAULT NULL, `examTest` text, `status` int (11) NOT NULL DEFAULT '0mm, `publishExamId` int (11) NOT NULL, PRIMARY KEY (`studentId`, `examtId`, `examTime`) CONSTRAINT `FK_stu_ his` FOREIGN KEY (`studentId`) REFERENCES `student` (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8-- examination questions module table (multiple choice questions) Fill in the blanks, etc.) CREATE TABLE `textmodel` (`id` int (11) NOT NULL AUTO_INCREMENT, `textType` varchar (20) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8-- examination question sheet CREATE TABLE `text` (`id`int (11) NOT NULL AUTO_INCREMENT, `Tex_ id` int (11) NOT NULL, `title`varchar (200) NOT NULL, `chapter` varchar (200) NOT NULL, `diffculty` int (11) NOT NULL, `modelName` varchar (200) DEFAULT NULL, `accountName` varchar (200) DEFAULT NULL, `chapterId` int (11) NOT NULL, `chapterID` int (11) DEFAULT NULL `chapterName` varchar (200) NOT NULL, `type1` varchar (200) DEFAULT NULL, `type2` varchar (200) DEFAULT NULL, `type3` varchar (200) DEFAULT NULL, `type4` varchar (200) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_text_ type` (`Tex_ id`), CONSTRAINT `FK_text_ type` FOREIGN KEY (`Tex_ id`) REFERENCES `textmodel` (`id`) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8

5.MAVEN system dependency and Engineering Architecture

This is the end of the implementation of the online examination system in Java. I hope the above content can be of some help to everyone and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.