【计算机外文翻译】Construction of Computer Curriculum Resource Platform Based on SSM Framework-外文翻译

Construction of Computer Curriculum Resource Platform Based on SSM Framework

2021 IEEE International Conference on Power, Intelligent Computing and Systems (ICPICS)
Zhan Jun
Jingdezhen College, Jiangxi Province, Jingdezhen City 333000, China
460043469@qq.com

Abstract—The online teaching resource platform of “University Computer” course is designed based on JSP technology, using MySQL database and Tomcat server. SSM framework is adopted in the system development framework, and B/S technology is used to construct the platform resource organization mode. MySQL is used to persist the data in the database, and the online teaching resource platform database is gridded and managed according to the actual needs, and all kinds of data are stored in a standardized and orderly manner. Through further analysis of online teaching resources platform, the functions including online registration and login, browsing of learning resources, teaching video on demand, suggestion and feedback, and collecting resources are designed and implemented, and the platform is used to improve teaching efficiency and teaching methods.
Keywords—Online teaching resource platform, JSP technology, MySQL, SSM framework

I. INTRODUCTION
Driven by the rapid development of the Internet in today’s era, the new teaching mode of using the Internet for education has gradually begun to develop, and online education has quickly merged into the eyes of students. The online teaching resource platform of “university computer” course is an important development direction of network education. In the world, the teaching website has been in constant development. Some countries have made great achievements in the theoretical research and practical application of online teaching.
II. BACKGROUND
At present, China’s online teaching websites are in a stage of rapid development. Many schools and educational institutions have launched their own online teaching websites, including many colleges and universities that have built online teaching resource platforms by taking advantage of their own resources. In addition, online teaching websites of courses are also emerging in the market, such as MOOC massive open online course website, Superstar Erya and many other excellent teaching websites that we often use. Most of these websites combine and apply a variety of technologies and media, which give users a better experience, significantly improve their learning efficiency and bring great convenience to users.
III. SYSTEM REQUIREMENTS
According to the requirements of various educational theories, such as teaching students in accordance with their aptitude, constructivist learning theory and “optimization of teaching process” theory, combined with the analysis of informationization and intelligence of the current curriculum, the basic requirements of this course mainly include: A. Courses should be able to intelligently arrange suitable teaching contents for students according to their different situations.
Different students have different learning foundations and different learning abilities. If all students learn the same knowledge, some students will not have enough to eat and their learning abilities will not be brought into full play. However, some students may not keep up, and their learning effect is very poor. Therefore, the intelligent network course should be able to arrange teaching contents suitable for students’ learning situation and learning ability according to their different situations. In addition, for different learners, teaching the same knowledge points should be different in explanation style, explanation method and explanation detail. This is the concrete embodiment of the educational thought of teaching students in accordance with their aptitude, and it is also the embodiment of the student-centered educational thought in the constructivist learning theory.

B. Courses should be able to identify learners, master their learning status and control their learning process.
The teaching theory of “teaching process optimization” requires that the teaching process be controlled to ensure that the teaching process (within the scope of optimization) plays the most effective role according to certain standards. This requires that online courses should be able to identify learners’ identities and fully grasp their learning status, such as: what knowledge points the learners have learned, what knowledge points they have learned but the learning effect is not good, and how long the learners have studied. Then, the intelligent network course should be able to control the learning process of each learner, such as when to learn what content and when to take the test.

C. Courses should be able to evaluate and give feedback to learners’ learning situation.
Constructivist learning theory attaches great importance to the evaluation of learning, and periodic tests in the learning process and level tests after learning are essential. Intelligent network courses should be able to make a more accurate evaluation of students’ learning situation. This kind of evaluation result can be used as the basis for arranging the follow-up knowledge point learning in the learning process, and can play a role of spur, guidance, interaction and information feedback for learners. After the whole learning process, it is an objective identification of learners’ level.
IV. FRAMEWORK DESIGN
A. Application technology analysis
The front-end and back-end of the platform are mainly completed by B / S structure and MySQL database. In the development of this website, MyEclipse development tool, which is easy to build and has code assistance, is selected to write the Java source code of the website. Mysql database with good performance and reliability is selected as the database.
The full name of B / S architecture is browser / server, which is browser / server structure. Browser refers to a Webbrowser, in which very few transaction logics are implemented at the front end, while transaction logics are mainly implemented at the server end. The B/S architecture model is shown in Figure 1.

Figure 1 B/S architecture model diagram
SSM framework is the integration of Spring MVC, Spring and Mybatis framework, and it is a standard MVC pattern. Among them, Spring MVC is responsible for forwarding requests and view management, Spring is responsible for the implementation of business object management, and Mybatis is the persistence engine of data objects. The model diagram of SSM framework is shown in Figure 2.

Figure 2 SSM framework model diagram
B. The online teaching resource platform has two major functional modules: administrator and user
The administrator module includes account management, user information management, resource information management, test question bank management and test result management. User modules include: learning resources, suggestion feedback, message information management and test information management.
C. Function module design
The online teaching resource platform of “University Computer” course includes two role types: administrator and user. Both roles have login functions. Administrator authority functions include account management, information management and test question bank management. User rights include browsing learning resources, video on demand and online testing.
(1) Login function: In order to ensure the information security of this website, you must log in to this website with the correct account password.
(2) Registration function: The meaning of registration function is to enter a new user into the website. It should be emphasized that, firstly, it is necessary to judge whether this user already exists in the background database, and secondly, whether the registered user name and password meet the registration standards. In this website, user accounts can be added by self-registering or adding users by administrators, which is planned to increase the diversity and practicability of the website.
(3) User management: In this website, the administrator can add, delete, modify and check users and modify their basic information, while users can only modify their own basic information.
(4) Teaching resource management: The core module of this online teaching resource platform is teaching resource management, in which the types of resources managed include documents and videos. Administrators can upload teaching resources such as documents and videos through background login, and classify teaching resources. Only administrators can add, delete and modify resource classifications, and resources must belong to one classification, so existing resource classifications must be selected when uploading resources. However, users can only browse document resources and on-demand videos, and have no permission to add, delete or modify them.
(5) Test question bank management: Online testing is also an important part of online teaching resource platform. Testing the knowledge points of browsed documents and videos in time can effectively improve learning efficiency, so test question bank management is also an important part of this website. Administrators can set the corresponding test question bank through resources, or add test questions to the resources of the existing question bank, so as to add, delete and modify test questions in the question bank.
(6) Suggestion and feedback function: User’s suggestion and feedback is an important way to improve the user experience of this website, so it is also an essential module of this website. Users can click the suggestion and feedback button to fill in suggestions and feedback. After that, administrators can reply to their suggestions and feedback, and users can view their reply contents in the personal center. Users can also delete their own suggestions and feedback.
V. CONCLUSIONS
The design of the online teaching platform breaks through the limitation of teaching in time and space, realizes the real-time interaction and collaboration between teachers’ teaching and students’ learning, and the sharing of educational resources, which fully embodies the interactive, open, intelligent and adaptive characteristics of information-based teaching.
ACKNOWLEDGEMENT
Fund Project: Provincial Department of Education focus on science and technology projects, No. " GJJ202801".
REFERENCES
[1] Wu Xianjun. Design of University Computer Fundamental Course Resource Platform Based on Cloud Service [J]. Modern Information Technology, 2017,001(005):124-126.
[2] Cui Cong, Yang Ling, Wei Songjie. Design and implementation of a computer science curriculum practice cloud platform based on Android mobile technology [J]. Journal of East China Normal University: Natural Science Edition, 2015(S1): 72-78.
[3] Dai Yingru. The Significance and Plan of Cloud Service Application in University Computer Effective Teaching [J]. Journal of Changchun Institute of Education, 2014, 000(017): 97-98.
[4] Zang Zhuo, Li Jiping. The practice of university curriculum assessment reform based on cloud services——Taking the “Forestry System Engineering” course as an example [J]. Culture and Education Data, 2017(2):159-161.
[5] Li Jiahong, Liu Jiamin, Chang Yan, etc. Computer Professional Course Aided Learning System Based on SPOC [J]. Information Recording Materials, 2018.
[6] Liu Manlan, Li Jianhui, Guan Chengbin. Exploration of the hybrid teaching method of “Python Programming Language” based on OBE concept [J]. Computer Engineering and Science, 2019,41(1):203-206.

基于SSM框架的计算机课程资源平台的构建

2021年IEEE电力、智能计算和系统国际会议（ICPICS）
詹军
江西省景德镇学院，中国江西省景德镇市333000
460043469@qq.com

摘要——基于JSP技术，利用MySQL数据库和Tomcat服务器，设计了“大学计算机”课程的在线教学资源平台。系统开发框架采用SSM框架，采用B/S技术构建平台资源组织模式。采用MySQL将数据存入数据库中，根据实际需要对在线教学资源平台数据库进行网格管理，各类数据标准化有序存储。通过对在线教学资源平台的进一步分析，设计并实现了在线注册登录、学习资源浏览、教学视频点播、建议反馈、资源收集等功能，利用该平台提高教学效率和教学方法。
关键词-在线教学资源平台、JSP技术、MySQL、SSM框架

I.介绍
在当今互联网快速发展的推动下，利用互联网进行教育的新教学模式逐渐开始发展，网络教育迅速融入了学生的视野。“高校计算机”课程的在线教学资源平台是网络教育的一个重要发展方向。在世界上，教学网站一直在不断发展。一些国家在网络教学的理论研究和实践应用方面取得了巨大的成就。
微光背景
目前，我国的在线教学网站正处于快速发展的阶段。许多学校和教育机构都推出了自己的在线教学网站，包括许多学院和大学，它们利用自己的资源建立了在线教学资源平台。此外，课程的在线教学网站也在市场上出现，如MOOC大型开放在线课程网站、超级明星Erya等许多我们经常使用的优秀教学网站。这些网站大多结合并应用了各种技术和媒体，给用户提供了更好的体验，显著提高了他们的学习效率，为用户带来了极大的便利。
罗马数字 3系统要求
根据各种教育理论的要求，如根据学生的能力进行教学、建构主义学习理论和“教学过程优化”理论，结合当前课程的信息化和智能化分析，本课程的基本要求主要包括： A.课程应能够根据学生的不同情况智能地为学生安排合适的教学内容。
不同的学生有不同的学习基础和不同的学习能力。如果所有的学生都学习相同的知识，一些学生将没有足够的食物，他们的学习能力将不会得到充分发挥。然而，有些学生可能没有跟上，他们的学习效果很差。因此，智能网络课程应能够根据学生的不同情况，安排适合学生的学习情况和学习能力的教学内容。此外，对于不同的学习者，教学相同的知识点应该在解释风格、解释方法和解释细节上有所不同。这是根据学生的能力来进行教学的教育思想的具体体现，也是建构主义学习理论中以学生为中心的教育思想的体现。

B.课程应该能够识别学习者，掌握他们的学习状态，并控制他们的学习过程。
“教学过程优化”的教学理论要求对教学过程进行控制，以确保教学过程（在优化的范围内）在一定的标准下发挥最有效的作用。这就要求在线课程应该能够识别学习者的身份，充分掌握他们的学习状态，例如：学习者学了什么知识点，他们学了什么知识点，但学习效果不好，学习了多久。然后，智能网络课程应该能够控制每个学习者的学习过程，如何时学习什么内容，何时参加考试。

C. 课程应能够评估和反馈给学习者的学习情况。
建构主义学习理论非常重视对学习的评价，对学习过程中的定期测试和学习后的水平测试至关重要。智能网络课程应该能够对学生的学习情况进行更准确的评价。这种评价结果可以作为在学习过程中安排后续知识点学习的基础，并可以对学习者发挥激励、指导、互动和信息反馈的作用。经过整个学习过程，它是对学习者水平的客观识别。
增值框架设计
A.应用技术分析
该平台的前端和后端主要由B / S结构和MySQL数据库完成。在本网站的开发过程中，选择了易于构建且有代码辅助的MyEclipse开发工具来编写本网站的Java源代码。选择性能好、可靠性好的Mysql数据库作为数据库。
B / S体系结构的全名为浏览器/服务器，即浏览器/服务器结构。浏览器是指浏览器，其中事务逻辑在前端实现，而事务逻辑主要在服务器端实现。B/S体系结构模型如图1所示。

图1 B/S体系结构模型图
SSM框架是对Spring MVC、Spring和Mybatis框架的集成，它是一个标准的MVC模式。其中，Spring MVC负责转发请求和视图管理，Spring负责业务对象管理的实现，Mybatis是数据对象的持久性引擎。SSM框架的模型示图如图2所示。

图2：SSM框架模型示图
B.在线教学资源平台主要有管理员和用户两个功能模块
管理员模块包括账户管理、用户信息管理、资源信息管理、测试题库管理和测试结果管理。用户模块包括：学习资源、建议反馈、消息信息管理和测试信息管理。
C. 功能模块设计
“大学计算机”课程的在线教学资源平台包括管理员和用户两种角色类型。这两个角色都有登录功能。管理员权限职能包括账户管理、信息管理和试题库管理。用户权利包括浏览学习资源、视频点播和在线测试。
(1)登录功能：为保证本网站的信息安全，您必须使用正确的帐户密码登录本网站。
(2)注册功能：注册功能的含义是向网站中输入新用户。需要强调的是，首先，需要判断该用户是否已经存在于后台数据库中，其次，已注册的用户名和密码是否符合注册标准。在本网站中，用户账户可以通过管理员自行注册或添加用户来添加用户账户，旨在增加网站的多样性和实用性。
(3)用户管理：在本网站中，管理员可以添加、删除、修改、检查用户，并修改其基本信息，而用户只能修改自己的基本信息。
(4)教学资源管理：本在线教学资源平台的核心模块是教学资源管理，其中所管理的资源类型包括文档和视频。管理员可以通过后台登录上传文档、视频等教学资源，并对教学资源进行分类。只有管理员才能添加、删除和修改资源分类，并且资源必须属于一个分类，因此在上传资源时必须选择现有的资源分类。但是，用户只能浏览文档资源和点播视频，并且没有添加、删除或修改它们的权限。
(5)测试题库管理：在线测试也是在线教学资源平台的重要组成部分。及时测试浏览过的文档和视频的知识点，可以有效地提高学习效率，因此测试题库管理也是本网站的重要组成部分。管理员可以通过资源设置相应的测试题库，也可以将测试题添加到现有测试题库的资源中，从而在测试题库中添加、删除、修改测试题。
(6)建议和反馈功能：用户的建议和反馈是提高本网站用户体验的重要途径，也是本网站的一个重要模块。用户可以点击建议和反馈按钮，填写建议和反馈。之后，管理员可以回复他们的建议和反馈，用户可以在个人中心查看他们的回复内容。用户也可以删除他们自己的建议和反馈。
v.结论
在线教学平台的设计突破了时空教学的局限性，实现了教师教学与学生学习的实时互动与协作，以及教育资源的共享，充分体现了信息性教学的互动、开放、智能、自适应的特点。
致谢
基金项目：省教育部重点科技项目，No.“GJJ202801".
参考文献
[1]吴宪军。基于云服务的高校计算机基础课程资源平台的设计。《现代信息技术》，2017年，001（005）：124-126。
[2]崔聪，杨玲，魏松杰。基于安卓移动技术[J]的计算机科学课程实践云平台的设计与实现。华东师范大学学报：自然科学版，2015（S1）：72-78。
[3]戴Jingru。云服务在大学计算机有效教学中的应用意义与规划。长春教育学院期刊，2014,000（017）： 97-98。
[4]藏卓，李继平。以“林业系统工程”课程为例，基于云服务——的大学课程评估改革实践[J]。文化和教育数据，2017(2)：159-161。
[5]李家红、刘家民、常燕等。基于SPOC [J]的计算机专业课程辅助学习系统。信息记录材料，2018年。
[6]刘曼兰、李建辉、关成斌。基于OBE概念[J]的“Python编程语言”混合教学方法的探索。计算机工程与科学出版社，2019年，41(1)：203-206。