CN108364246A - A kind of Student Information Management System - Google Patents

Abstract

The present invention relates to a kind of Student Information Management Systems, and using Java as language core, SQL Server are database, and Eclipse is developing instrument, and Power Designer are Database Modeling tool, and Java Server Page establish dynamic page；Wherein, user management module is used for management of the manager to system；Claass management module is for the modification to the addition of class, the deletion of class and class；Student information management module is used to carry out the inquiry of personal information, the inquiry of courses taken and course achievement for student；Teacher information management module is used for inquiry, the inquiry of taught journey and the typing of achievement of teacher's personal information；Course management module is for manager and teacher to the management that is opened a course and to the modification of course；Inquiry of the student's score management module for teacher to the modification and student of achievement to the achievement after make-up examination of failing.The present invention realizes the omnibearing management to student information.

Description

A student information management system

technical field

The invention relates to the technical field of student information management, in particular to a student information management system.

Background technique

With the rapid development of economy and society, education is becoming more and more important. To this end, colleges and universities are constantly improving the management level at all levels. All-round management refers to the overall management of the operation of the school. As the most important thing in school management—student management, it is related to the stable development of the school and the cultivation of students. The continuous expansion of the enrollment scale of higher education has made student management more difficult, and the workload of student information management has soared. The previous method of paper management files can no longer meet the needs of modern big data development. Therefore, it is particularly important to design a system suitable for school student management using modern methods.

The gradual maturity of modern computer and information technology objectively drives the informatization of education and realizes the networkization of student management work. As a part of modern technology, it has advantages that cannot be replaced by traditional manual management: fast query, safe and reliable, convenient update, large storage capacity, easy storage and low cost. It can not only improve the efficiency of management work, but also reduce unnecessary waste of resources. The computer-supported student information system needs to have the following characteristics: first, have a good information database about student management; second, ensure the security of the information database and data consistency; third, an intelligent user interface; fourth, have a complete query , modification, deletion and addition, etc. maintenance system, and play the role of computer-aided management; fifth, it has report and output functions. The student management information system is of great significance to the management and decision-making work. Due to the different design standards required by each school for student management work, information cannot be shared. For this reason, how to improve management, make good use of existing resources, make full use of teacher resources, provide an easy-to-operate, unified interface, train more talents, and develop a certain practical value and good compatibility. The student management information system has certain practical significance.

Contents of the invention

The technical problem to be solved by the present invention is to provide a student information management system to realize all-round management of student information.

The technical scheme that the present invention adopts to solve its technical problem is: provide a kind of student information management system, take Java as the language core, SQL Server is the database, Eclipse is the development tool, Power Designer is the database modeling tool, Java Server Page establishes dynamic page, including user management module, class management module, student information management module, teacher information management module, course management module and student performance management module; the user management module is used for the administrator to manage the system; the class management module is used for For adding classes, deleting classes, and modifying classes; the student information management module is used to inquire about personal information, courses learned and course grades for students; the teacher information management module is used for teachers’ personal information Inquiry of courses taught, inquiry of courses taught, and entry of grades; the course management module is used for managers and teachers to manage courses and modify courses; the student achievement management module is used for teachers to modify grades and Student inquiries about grades after failing make-up exams.

Described class management module comprises TeamAction class, TeamDAO class, TeamDAOImpl class, TeamForm class and Team class, and wherein, TeamAction class, TeamDAO class, TeamDAOImpl class are respectively used for adding, deleting and revising to realize class; Query of information; the Team class is the entity class of the user, and saves a class information table, and the class information table includes a class number ID and a class name.

Described student information management module comprises StudentAction class, StudentDAO class, StudentDAOImpl class, StudentForm class and Student class, wherein, StudentAction class, StudentDAO class, StudentDAOImpl class are respectively used to realize the addition, deletion and modification of student information; StudentForm class is used to realize To the inquiry of achievement; Described Student class is the entity of student personal information, preserves student information form, and described student information form comprises student number ID, name, student number, class, enrollment time, date of birth and sex.

Described teacher information management module comprises TeacherAction class, TeacherDAO class, TeacherDAOImpl class, TeacherForm class and Teacher class, wherein, TeacherAction class, TeacherDAO class, TeacherDAOImpl class are respectively used to realize the addition, deletion and modification of teacher information; TeacherForm class is used to realize Inquiry about teachers' courses; the Teacher class is an entity of teachers' personal information, and holds a teacher's information table, which includes a teacher's ID and name.

Described course management module comprises CourseAction class, CourseDAO class, CourseDAOImpl class, CourseForm class and Course class, wherein, CourseAction class, CourseDAO class, CourseDAOImpl class are respectively used to realize the addition, deletion and modification of course management; CourseForm class is used to realize course Inquiry about course offerings; the Course class is an entity of course management, and holds a course information table, which includes course information number ID, course name, class, credits, teacher number ID and credits.

Described student achievement management module comprises MarkAction class, MarkDAO class, MarkDAOImpl class, MarkForm class and Mark class, wherein, MarkAction class, MarkDAO class, MarkDAOImpl class are respectively used to realize the addition, deletion and modification of student achievement; MarkForm class is used to realize Supplementary exam results query; the Mark class is an entity of student grades, which saves the student grade table, and the student grade table includes grade number ID, course name, name, score and student number.

Beneficial effect

Due to the adoption of the above-mentioned technical scheme, the present invention has the following advantages and positive effects compared with the prior art: the present invention is based on the Java language and utilizes modular design to realize the collection of information such as students and teachers in the system, Delete and add items, etc., to provide a practical platform for schools to realize paperless office, with the advantages of cost saving, easy operation and high efficiency.

Description of drawings

Fig. 1 is a structural block diagram of the present invention.

Detailed ways

Below in conjunction with specific embodiment, further illustrate the present invention. It should be understood that these examples are only used to illustrate the present invention and are not intended to limit the scope of the present invention. In addition, it should be understood that after reading the teachings of the present invention, those skilled in the art can make various changes or modifications to the present invention, and these equivalent forms also fall within the scope defined by the appended claims of the present application.

The embodiment of the present invention relates to a student information management system, which uses Java as the language core, SQL Server as the database, Eclipse as the development tool, Power Designer as the database modeling tool, and Java Server Page to establish dynamic pages.

A total of 8 entities are planned for this system application, which are course entity, course information entity, student achievement entity, student information entity, system user entity, teacher information entity, and class entity. Each entity saves its own information, uses the E-R structure to describe each entity, implements it in language, and makes it into a dynamic interface for users to use.

With language as the scripting language, the sub-level content is embedded in the page, the Java and Java script d codes in Jsp are parsed by the WEB container to generate a servlet, and the Java code is converted into a file through the generated servlet, and the file is parsed by the browser, and the user gets returned page. At the same time, set each information table, data type and field, use Hibernate to connect to the database, and configure the code. Due to the large amount of data entered, use the Page Model class and Base DispatchAction class for page display.

The database logic design of this system is as follows:

1.courser (course name list)

The course name table is mainly used to save the course name, such as: course number ID, course name, and course name. The structure is as follows:

Table 1 Course Name Table

field name type of data Is it empty Whether primary key describe id Nvarchar(255) no Yes Course ID name Nvarchar(255) Yes no Course Title

2. courses schedule (course information table)

Course information is mainly used to save course information, such as: course information number ID, course name, class, credits, teacher ID, credits, etc. The structure of the course information table is as follows:

Table 2 Course Information Form

3.mark (student score sheet)

The student grade table is mainly used to save student grades, such as: grade number ID, course name, name, score, student number, etc. The structure of the student grade table is as follows:

Table 3 Student score sheet

4.student (student information form)

The student information table is mainly used to save the personal information of each student, such as: student ID, name, student number, class, enrollment time, date of birth, gender, etc. The structure of the student information table is as follows:

Form 4 Student Information Form

5.t_user (system user table)

The system user table is mainly used to save system user information, such as: system user ID, user name, password, etc. The structure of the system user table is as follows:

Table 5 System user table

6.teacher (teacher information form)

The teacher information table is mainly used to save teacher information, such as: teacher ID, name. The structure of the teacher information table is as follows:

Table 6 Teacher Information Form

7.team (class information table)

The class information table is mainly used to save class information, such as: class number ID, class name. The structure of the class information table is as follows:

Table 7 Class information table

The system includes user management module, class management module, student information management module, teacher information management module, course management module and student achievement management module. The user management module is used for administrators to manage the system; the class management module is used for adding classes, deleting classes and modifying classes; the student information management module is used for querying personal information of students, Inquiry of the courses learned and course grades; the teacher information management module is used for the inquiry of teachers' personal information, the inquiry of the courses taught and the entry of grades; the course management module is used for the management of the courses opened by managers and teachers and modification of courses; the student performance management module is used for teachers to modify grades and students to inquire about grades after failed re-examinations.

The user management module is used to realize user login and logout.

The class management function module mainly implements functions such as adding, deleting, and modifying classes. It mainly includes TeamAction class, TeamDAO class, TeamDAOImpl class, TeamForm class and Team class. Among them, TeamAction class, TeamDAO class, TeamDAOImpl class are used to add, delete and modify classes respectively; TeamForm class is used to realize class information query ; The Team class is the entity class of the user, and holds a class information table, and the class information table includes a class number ID and a class name.

The student information management module mainly implements the functions of adding student personal information, deleting student personal information, and modifying student personal information. It includes StudentAction class, StudentDAO class, StudentDAOImpl class, StudentForm class and Student class, among which, StudentAction class, StudentDAO class, StudentDAOImpl class are used to add, delete and modify student information respectively; StudentForm class is used to realize the query of grades; The Student class is an entity of student personal information, and has a student information table, which includes student ID, name, student ID, class, enrollment time, date of birth and gender.

Teacher information module The module mainly realizes the addition of teacher information, the deletion of teacher information, and the modification of teacher information. It includes TeacherAction class, TeacherDAO class, TeacherDAOImpl class, TeacherForm class and Teacher class, among which, TeacherAction class, TeacherDAO class, TeacherDAOImpl class are used to add, delete and modify teacher information respectively; TeacherForm class is used to realize teacher course query; The Teacher class is the entity of the teacher's personal information, and holds a teacher information table, and the teacher information table includes the teacher ID and name.

Course Management Module The module mainly realizes the addition of course management, the deletion of courses, and the modification of courses. It includes CourseAction class, CourseDAO class, CourseDAOImpl class, CourseForm class and Course class. Among them, CourseAction class, CourseDAO class and CourseDAOImpl class are respectively used to realize the addition, deletion and modification of course management; CourseForm class is used to realize the query of course opening status ; The Course class is an entity of course management, and holds a course information table, which includes course information number ID, course name, class, credits, teacher number ID and credits.

Student grade management module The module mainly realizes the addition of student grades, the deletion of student grades, and the modification of student grades. It includes MarkAction class, MarkDAO class, MarkDAOImpl class, MarkForm class and Mark class. Among them, MarkAction class, MarkDAO class, and MarkDAOImpl class are used to add, delete and modify student grades respectively; MarkForm class is used to realize re-examination results query; Mark A class is an entity of student grades, and holds a student grade table, which includes grade number ID, course name, name, score, and student number.

It is not difficult to find that the present invention is based on the Java language and uses modular design to realize the collection, deletion, and addition of items in the system for information such as students and teachers, and provides a practical platform for schools to realize paperless office, saving costs, and is easy to use. The advantages of high operation and efficiency.

Claims (6)

1. A student information management system is characterized in that, with Java as language core, SQL Server as database, Eclipse as development tool, Power Designer as database modeling tool, Java Server Page sets up dynamic pages, including user management module, class Management module, student information management module, teacher information management module, course management module and student performance management module; Described user management module is used for the manager to the management of system; Described class management module is used for adding class, class Deletion and class modification; the student information management module is used to inquire about personal information, courses learned and course grades for students; the teacher information management module is used to inquire about teachers' personal information and courses taught and the entry of grades; the course management module is used for managers and teachers to manage the courses offered and to modify the courses; the student performance management module is used for teachers to modify grades and students to fail the re-examination grades query. 2. student information management system according to claim 1, is characterized in that, described class management module comprises TeamAction class, TeamDAO class, TeamDAOImpl class, TeamForm class and Team class, wherein, TeamAction class, TeamDAO class, TeamDAOImpl class respectively It is used to add, delete and modify classes; the TeamForm class is used to query class information; the Team class is an entity class of a user, which stores a class information table, and the class information table includes a class number ID and a class name. 3. student information management system according to claim 1, is characterized in that, described student information management module comprises StudentAction class, StudentDAO class, StudentDAOImpl class, StudentForm class and Student class, wherein, StudentAction class, StudentDAO class, StudentDAOImpl class Respectively be used to realize the addition, deletion and modification of student information; StudentForm class is used to realize the query to achievement; Described Student class is the entity of student personal information, preserves student information form, and described student information form comprises student serial number ID, Name, student number, class, enrollment time, date of birth and gender. 4. student information management system according to claim 1, is characterized in that, described teacher information management module comprises TeacherAction class, TeacherDAO class, TeacherDAOImpl class, TeacherForm class and Teacher class, wherein, TeacherAction class, TeacherDAO class, TeacherDAOImpl class They are respectively used to add, delete and modify teacher information; the TeacherForm class is used to inquire about teacher courses; the Teacher class is the entity of the teacher's personal information, and holds a teacher information table, which includes the teacher ID and name. 5. The student information management system according to claim 1, wherein said course management module includes CourseAction class, CourseDAO class, CourseDAOImpl class, CourseForm class and Course class, wherein, CourseAction class, CourseDAO class, CourseDAOImpl class respectively It is used to realize the addition, deletion and modification of course management; the CourseForm class is used to realize the query of the course opening situation; the Course class is an entity of course management, and holds a course information table, which includes course information number ID, course name , Class, Credits, Teacher ID and Credits. 6. the student information management system according to claim 1, is characterized in that, described student achievement management module comprises MarkAction class, MarkDAO class, MarkDAOImpl class, MarkForm class and Mark class, wherein, MarkAction class, MarkDAO class, MarkDAOImpl class They are respectively used to add, delete, and modify student grades; the MarkForm class is used to realize the query of re-examination results; the MarkForm class is the entity of student grades, and saves the student grade table. The student grade table includes grade number ID, course name, and name , grades and student numbers.