重庆大学计算机分级考试管理毕业论文

重庆大学本科学生毕业设计（论文）

计算机分级考试管理系统的设计与实现

学 生：陈西 学 号：20115484 指导教师：刘慧君 专 业：信息安全

重庆大学计算机学院

二O一五年六月

Graduation Design (Thesis) of Chongqing University

Design and implementation of computer grade examination system management

Undergraduate: Chen Xi Student ID: 20115484 Supervisor: Liu Huijun Major: Computer Security

College of Computer Science

Chongqing University

June 2015

重庆大学本科学生毕业设计（论文） 中文摘要

摘 要

当今，互联网技术和电脑的广泛使用，软件也越来越受到重视。软件的使用，极大程度上方便了生活及工作。本软件是一个使用JSP技术和SQL Server数据库开发的一个计算机分级考试管理系统。在此软件之前，高校老师安排班级以及考场，需手动挨个分班，非常费时。现在，可以通过软件方便快捷得进行考场安排并处理分班信息，十分直观，提高了学校的办学效率，对于现在学生数量庞大的学校是十分必要的。

本系统在已有研究的基础上，使用JSP作为开发工具，数据库采用SQL server ，通过使用JSP语言实现动态网页，达到对数据库的操作以完成使用者的要求。这个系统可以实现管理员，老师，学生的权限分配，管理员可以处理学生信息，教师信息，教室信息，分配考场信息，以及excel表导入学生信息和将分班情况导出至excel表；老师可以查询自己监考考场和录入学生成绩，学生可以查询自己考场与成绩。此系统最主要的功能集中在管理员上，但对于三个用户来说，系统界面友好，操作简单，基本适用于广大的师生。

关键词：考表安排，excel，JSP，权限，SQL Server

I

重庆大学本科学生毕业设计（论文） ABSTRACT

ABSTRACT

Today, with the widespread use of Internet technology and computers, people pay more and more attention to software. It is convenient to the life and work in some degree on use of the software. This software is a computer grading examination system which is developed by JSP technology and Server SQL database. Before the software, when university teacher arrange class and examination, they need to manually turn the placement, which is very time-consuming. Now, the software can quickly test arrangement and can handle placement information. It is very intuitive, and improves the school efficiency. It is very necessary for now the number of students a large school.

The software is on the base of existing research, the use of JSP as development tools, database using SQL server, through the use of JSP language to achieve dynamic web pages to the operation of the database to complete the user‘s requirements. This system can realize the administrator, teacher, students assign permissions, administrators can allocate examination information and excel table into the student information and the placement of export to excel table, and students and teachers can query their examination and performance management. It is friendly interface, simple operation, basically for the majority of teachers and students.

Key words：Examination arrangement, excel, JSP, limit of authority, SQL Server

II