jsp812 online examination system sqlserver graduation project

Free installation

Technical implementation

Development language: jsp. Framework: jsp+servlet. Mode: B/S. Database: sqlserver. Development tools: myeclipse or eclipse. The word count of the paper: about 10,000.

Function realization

client

Login service: Responsible for the customer's login input and server-side verification. If you log in again, you need to re-login the password.

Question download: Responsible for reading test question data from the database and downloading it to the client.

Customer answering questions: Responsible for displaying downloaded questions in the user's browser for customers to answer questions.

Question upload: Responsible for uploading answers to questions answered by users to the server.

Management side

Generate test questions: Responsible for generating corresponding test questions for the on-site exam from the test question source.

Test question initialization: Responsible for clearing test question recycling information before each exam.

Candidate Monitoring: Responsible for managing and monitoring the exam status of each candidate during the exam.

Test Paper Recycling: Responsible for uploading the answers submitted by candidates to the database server after the exam.

Test paper review: Responsible for automatically reviewing and recycling test papers (objective questions).

Database connection service: Responsible for receiving relevant database connection, query, modification and other services from each common service layer module, and returning relevant data.

Data access layer exception management: responsible for exceptions that occur in the database connection service.

Detailed details of each module:

1) Candidate login module:

At the user level, candidates enter their customer name and password through the main login page.

In the web layer, the customer name and password obtained from the customer input are compared with the corresponding customer name and password returned from the business layer. If the customer has a correct password and has not yet logged in, log in to the main exam page. Otherwise, jump to the error page and ask to log in again. .

At the business layer, obtain the connection to the mssql database and retrieve all customer name and password information. Pass this information into the web layer.

At the EIS layer, it corresponds to the students table in the mssql database.

2) Question module:

(1) Multiple choice questions:

At the user level, the test questions corresponding to each candidate are displayed in the browser, and candidates are required to enter test answers. There is also a submit button for candidates to upload the questions after completing them.

In the Web layer, jsp is responsible for obtaining the questions from the business layer and organizing the questions together to display to the user.

In the business layer, obtain the connection to the database and retrieve the multiple-choice questions.

At the EIS layer, it corresponds to the choose table in the database.

(2) Word questions:

At the user level, the word question requirements are displayed in the textarea area of ​​the applet in the browser, and the applett digital signature technology is used to break through the restrictions on accessing the local file system and open word to do the questions.

In the Web layer, the servlet file upload and download technology is used to download the read word file to the local disk.

At the business layer, obtain the database connection and retrieve the word question. The word question stores the word file in the database in the form of a binary stream.

At the EIS layer, it corresponds to the word table in the database.

3) Answer upload module:

At the user level, click the submit button in the browser to submit the completed answers to the corresponding page.

In the Web layer, the answers submitted by customers are submitted to the corresponding javabean components, and reminder information is displayed on the user side.

At the business layer, the submitted answers are stored in the corresponding database.

At the EIS layer, the students table in the database has two corresponding fields used to store the submitted answers corresponding to the customer.

System screenshot