Online course selection management system based on SSM framework: a powerful tool to improve the efficiency of educational administration management in colleges and universities

Other projectsDesign and implementation of Linux-based seismic data processing software, click on the author’s homepage

Table of Contents

1System Introduction

With the development of the information ageDesign and implementation of Linux-based earthquake data processing software, the Internet has made people's lives more and more convenient. In recent years, in the face of the new enrollment expansion policies of major colleges and universities, the number of middle school students in various colleges and universities has suddenly increased, and the corresponding school academic staff will also face a shortage. This has reduced the difficulty for academic staff in managing the course selection information of middle school students. , the traditional course selection in previous years was gradually eliminated because it was a waste of manpower and material resources. At this time, the emergence of online course selection management systems will promote the increasingly standardized course selection management behavior of middle schools, thus greatly reducing the arbitrariness of middle school course selection management in previous years, and greatly improving the real-time and accuracy of information management. Academic staff The system can also check the course selection status of middle school students anytime and anywhere. Middle school students can also make course selections anytime and anywhere. Therefore, the online course selection system greatly facilitates academic teaching management. This online course selection management system based on the SSM framework uses Eclipse as the main development tool, is developed in Java language, and uses SSM framework technology. The database uses MySQL and the server is Tomcat. Through the shoe factory model and the chain of responsibility model Complete the system coding work, conduct system checks, and finally implement and successfully run the system. Only with this system can educational resources be fully utilized, reducing the burden on academic staff.

2 Introduction to system related technologies 2.1J2EE platform

Java was released by Sun in 1995. At that time, its scope of application was to convert Applet into a dynamic website. JavaEE software design architecture technology requires a multi-layer architecture in the software development process, which mainly defines the software design into four levels, namely client display logic, business logic and database. The traditional JavaEE lightweight framework, referred to as the SSH framework, and with the continuous development and updating of new technologies, the SSH framework has long been abandoned by many enterprises and replaced by the increasingly flexible and convenient SSM framework [2].

2.2 Web application development technology based on J2EE 2.2.1 Database

MySQL database is a relational DBMS. In the process of applying MySQL database, backup and recovery are a very important link and are the key to ensuring data security. The version of the database intelligent management system selected by this system is MySQL5.3. The database system consists of a series of corresponding products, which can not only meet the requirements of most data processing systems, but also be able to store medium-level characteristic data information on various business websites. requirements. Can you also provide some data storage services related to business processes that are easier to operate for individuals or medium and large enterprises? However, because MySQL is an open source project, the total cost can be significantly increased.

2.2.2Servlet and JSP

JSP is a technology for dynamic interaction in web pages. It supports cross-platform, while Servlet technology is mainly used to receive data input from users on the page. JSP technology can be defined as a method of separating static and dynamic web pages. These methods simplify the entire operation process and prevent multiple compilations of the code, thereby improving its own efficiency, safety and reliability during operation.

2.2.3 Application of MVC and framework

The Spring framework hopes to provide solutions that are not focused on a certain layer, but provide solutions for all layers in JavaEE application development [6]. SSM is a typical MVC framework, and the entire system is defined as four layers: presentation layer, control layer, service layer, and database access layer [7]. The core of SpringMVC is the back-end controller, which is the scheduling manager between various levels. It can be distributed to the corresponding page controller for processing according to the request mapping rules [8].

​​​​​​2.3J2EE Application Server (Tomcat)

As a lightweight large-scale Web application container, Tomcat is widely used in small and medium-sized projects and when there are not many user accounts. It has been recognized by many manufacturers, making it popular in the Web application server industry [9]. Tomcat is currently a popular server system. The main reason is not only its size, but also its openness and convenient application. Therefore, it has been increasingly widely accepted in the construction of actual enterprise-level application systems. People's attention, especially in the current professional education process related to various universities, middle school students will basically choose Tomcat as the application server for development.

​​​​​​2.4MyBatis related overview

Mybatis is an excellent persistence layer framework that supports ordinary SQL queries, stored procedures, dynamic SQL, cache management and intermediate mapping. Programmers can use simple XML or annotations to configure and map basic data types and map sockets to JAVAPOJO into database records, and complete operations such as adding, deleting, modifying, and querying database tables [10].

3 Demand Analysis

Requirements analysis describes the functional requirements of the user system, and the core goal of requirements analysis is to create a balanced mechanism between system developers and those who provide functional needs. Therefore, an excellent requirements analysis has a positive impact on the development of the system. And design is very critical.

​​​​​​3.1 Analysis of non-functional requirements

During software development and design, in order to best fulfill the customer's business needs, features other than functional requirements are called non-functional requirements. Software will be damaged by many other environmental factors, so the criteria for non-functional requirements in software will be very wide, so the ease of use and convenience of the software must be taken into consideration.

3.1.1 System requirements description

The specific development and design work of this operating system includes the product development of application systems with corresponding functions, and naturally also the design of its backend management database. In the design process, in order to make the actual operation more convenient, for the application system, first of all, it must have a simple and elegant operation interface; secondly, the relevant study selection management functions must be complete; finally , can be easily operated and used. That way it's convenient and easy to use. When designing a database, it is also necessary to ensure the integrity and consistency of the data in the database. Only in this way can it truly comply with the standards of database design and ensure the good operation of the database. Therefore, in the process of designing the course selection system, you must consider the following two aspects: First, the back-end interface of the course selection system should be as unique as possible, and the layout of elements should be effective; second, the side of the course selection system should be The design requires that the system function is effective and easy to use.

3.1.2 System implementation goals

In the development and design process of this course selection system software, the development environment is mainly Ec1ipse. First, after creating the corresponding project, create the SSM architecture and test the environment. All functional modules of the system are interactive dynamic applications based on web servers developed using languages ​​such as JAVA and JSP, fulfilling the main function of the course selection system of colleges and universities. The key functional modules of the system include middle school student login and registration, course selection query, online course selection, administrator login, query and publication of course content, query of middle school students for course selection, etc. This course selection system considers that it can truly provide students with a convenient and practical system when selecting courses, thereby saving all students' course selection time and fully meeting most of the requirements of all teachers and students for course selection management.

3.2 Analysis of functional requirements 3.2.1 Functional requirements

(1)Basic function description: Registration function for middle school students and administrators. Middle school students or administrators click the registration button on their respective login interfaces to register information.

Login for middle school students and administrators: By asking middle school students or administrators to enter their account number and password, it is determined whether the information they entered is consistent with that in the database. If they are consistent, they will jump to the system function interface. If they are inconsistent, re-enter them.

(2) Administrator function description:

Course List: Administrators can view basic information about courses.

Add courses: Administrators can add basic information about courses.

Middle school student list: Administrators can see the basic information of all middle school students.

Add middle school students: Administrators can add middle school students.

(3) Function description for middle school students:

My information: Middle school students can view personal information.

Update information: Middle school students can change their personal information.

Online course selection: Middle school students can choose courses released by administrators.

Course selection preview: Middle school students can view the selected course information.

3.2.2 Performance requirements

The main purpose of performance requirements is to make mutual message transmission smoother. The transport layer contract parsing is accurate, the page design is simple and elegant, and the running time is short, which can meet the application needs, and high stability can ensure security. As far as the actual situation is concerned, when we use it, we can directly enter the Tomcat URL through the browser to access the system interface. In fact, if we join the paid server later, it will not be limited to personal computers, but can be used on any device that can access the Internet. Visit this page. In fact, during the staged process of system development, we need to consider the friendliness of the interface and whether the interconnection and coordination between various functions are in place.

3.2.3 Analysis of Administrator Function Module

The administrator module must first include the most basic functions. Its main functions include clicking to view the course list, clicking to add courses, student lists, adding middle school students, etc. The click on course list function here mainly refers to the administrator who can use this module to query Information on teaching courses offered by secondary schools. The click-to-reduce course function allows administrators to use this module to reduce teaching course information, including basic information about middle school teaching courses, lecture locations and class time information, etc. The middle school student information list function is mainly for administrators to use this module to query the personal information of middle school students. If it does not meet the requirements of the university, the course selection information of middle school students can be deleted. Adding middle school students: This module can mainly add middle school students. The detailed functional module diagram is shown in Figure 3-1:

Figure 3-1 Analysis of administrator functional requirements

3.2.4 Analysis of functional modules for middle school students

The middle school student module must first include the most basic functions. Its main functions include viewing my information, updating information, personal online course selection, and personal course selection preview. The view my information module is mainly for middle school students to view through this module. Whether your personal information is true, if not, you can modify the information by updating the information module. The update information module allows middle school students to update some of their personal information. The personal online course selection module is mainly for middle school students to see the courses released by the administrator and select them. The main content of the personal course selection preview module is that middle school students can see the information of individual courses they have already selected in this functional module to prevent wrong selections. The detailed module diagram of the functional module for middle school students is shown in Figure 3-2:

Figure 3-2 Analysis of functional requirements of middle school students

3.2.5 Database Analysis

This system uses MySQL version 5.3, which is characterized by simple operation and easy maintenance. When designing the database, you must also design the security of the database. Database security is an important part of system security, so a sound database backup and recovery plan must be designed. MySQL provides a variety of tools for Linux software downloads that can be used together to make database backup and recovery easy.

​​​​​​3.3 System Feasibility Analysis

(1) Technical feasibility: This system does not have high requirements for the equipment used for programming. It can run Eclipse. The database is MySQL and the server is Tomcat. Most of the current computers can meet the requirements.

(2) Economic feasibility: This operating system is an operating system used for middle school course selection management. By entering the Tomcat website in the browser, you can enter the middle school course selection management system. The economic benefits of this operating system far exceed The production costs of the development are completely economically justified.

(3) Operational feasibility: The interface design is very simple and elegant, the data processing is very fast, the later scalability is very good, and the later maintenance is also very convenient.

4 System Design​​​​​​4.1 System Design

For this system development, Eclipse and MySQL were chosen as the front-end and back-end of development. I chose Eclipse because it is completely open source and free. Its background control layer code and back-end code are completely separated. The background uses JAVA language and the back-end uses JSP language. MySQL is a powerful database that can be used in conjunction with Eclipse to give full play to its powerful advantages. This system is designed based on JAVA language and does not have high requirements on the user's development environment.

4.2 System function module design 4.2.1 Database design

When starting to design the database, you must first clarify the character encoding and a series of most basic requirements such as whether the format of each array is nullable, thickness, uniqueness, etc. Based on this, you can design the ER diagram of each data table in the database. This enables developers to better understand the relationship between various arrays in the database.

The system data ER diagram is as follows:

(1) ER diagram for middle school students, as shown in Figure 4-1:

Figure 4-1 ER diagram of middle school students

(2) Administrator ER diagram, as shown in Figure 4-2:

Figure 4-2 Administrator ER diagram

(3) Course selection information ER diagram, as shown in Figure 4-3:

Figure 4-3 ER diagram of course selection information

5 system implementation 5.1 system login module implementation

The first thing that strikes your eye after entering the home page of the management system is the administrator page, which is the adminLogin.jsp interface. The interface is simple and elegant. This is one of the main pages of the system. In fact, you can also choose to click on the student terminal in the upper right corner. The login therefore switches directly to the middle school student login page. After entering the administrator login page, the administrator needs to enter the same account number and password as in the back-end database to successfully log in. If the input is incorrect, it needs to be re-entered. After successful login You can enter the main management function page of the administrator system. In the process of realizing system login, through the login interface, the controller obtains the entered account password and uses JavaScript to determine the format. The data is controlled through the AdminLogin.java file. The corresponding page design flow chart is shown in Figure 5-1:

Figure 5-1 Administrator system login operation diagram

As soon as you enter the administrator's operation interface, you will be greeted by its simple and elegant interface style, allowing users to find the entrance to the system at a glance. The effect diagram is shown in Figure 5-2:

Figure 5-2 Administrator login effect picture

​​​​​​​5.2 Implementation of system course selection module

After middle school students log in, they can click the online course selection button to select courses. After completing the course selection, click the course selection preview to view the course selection information. The same middle school student can only select a course once. The page corresponding to the online course selection function is displayed in the back-end interface SelectCourses.jsp. The implementation process is that the system is controlled through the file SelectCourseServlet.java, and the CourseDao.java file queries the Dao layer file for existing optional course information. Send the course information to the back-end page, and the process of online course selection is shown in Figure 5-3:

Figure 5-3 Course selection flow chart

The operation effect of the course selection function is shown in Figure 5-4:

Figure 5-4 Curriculum Selection Process Effectiveness Chart

​​​​​5.3 Implementation of adding course functions

After the administrator logs in, he can click the Add Course button to add a course. After adding the course, click the course list to view the course information just added. Duplication of course IDs is not allowed. The page corresponding to the added course is displayed in AddCourses.jsp. The implementation process is that the front desk sends the request to the Controller layer, the file uses the Service layer file to send the request to the Dao layer file, and the obtained data is returned to the control layer to determine whether The addition is successful. The process of adding a course is shown in Figure 5-5:

Figure 5-5 Add course flow chart

The effect of adding course function is shown in Figure 5-6:

Figure 5-6 Adding courses to achieve efficacy diagram

The course list implementation effect diagram is shown in Figure 5-7:

Figure 5-7 Check the course list to achieve the effect diagram

​​​​​5.4 Add the implementation of middle school student function

The administrator can add the basic information of middle school students. The administrator can click the Add Middle School Student button on the administrator operation interface to add the basic information of the middle school student. After adding, click the Middle School Student List button to view the information of the middle school student just added. In order to maintain For the uniqueness of middle school student information, duplicate numbers of middle school students are not allowed. The page corresponding to the function of adding middle school students is displayed in the back-end interface AddStudents.jsp. The implementation process is that the web page sends the request to the controller, and the controller calls the AddStudentServlet.java file to return the data returned by the web.xml file to the front-end web page. The system is controlled through the AddStudentServlet.java file. The process of adding middle school students is shown in Figure 5-8:

図5-8 中学生向けのフローチャートを追加

中学生向けの機能追加の効果を図 5-9 に示します。

図5-9 中学生の実施図を追加

中学生向けリストの実施効果図を図5-10に示します。

図5-10 中学生リスト実施効果図

5.5 中学生向け更新情報機能実装

中学生はログイン後、原則を維持するために「情報更新」ボタンをクリックして変更した個人情報を確認することができます。中学生の学生証は変更できません。更新情報関数に対応するページは、バックエンド インターフェイス UpdateStudent.jsp に表示されます。システム関数は、UpdateStudentServlet.java ファイルによって制御されます。更新情報のプロセスを図 5-11 に示します。

図5-11 更新された中学生情報のフローチャート

更新情報機能の運用効果を図 5-12 に示します。

図5-12 有効性グラフを実現するために中学生の情報を更新する

6 まとめ

このシステムは、SSMをベースとしたオンラインコース選択システムであり、バックエンドシステムはJspテクノロジーによって論理的に実装されており、プログラミングソフトウェアはバックエンドデータとしてEclipseを使用しています。ストレージ。 。

ソースコード + プロセスドキュメント + 書類

The above is the detailed content of Online course selection management system based on SSM framework: a powerful tool to improve the efficiency of educational administration management in colleges and universities. For more information, please follow other related articles on the PHP Chinese website!