提出了基于VCT-EIS开发模式的教务管理系统的设计思路,该模式由视图层View、管理层CT及数据库层EIS组成。根据VCT-EIS模式将系统分为表现层、业务逻辑管理层和数据库层:表现层通过请求获取并展示相关数据,实现模块的具体功能;业务逻辑管理层中采用功能编码对应SQL语句(或存储过程)构建配置文件,通过执行不同的SQL语句(或存储过程)获得数据库层的相关数据,然后将这些数据封装成JSON数据返回给表现层;数据库层通过构建中间表,设置触发器,使用存储过程等技术保证数据逻辑的正确性。这3层结构彼此独立,使得系统更容易被维护。通过使用该系统,用户能降低日常教务管理工作的复杂性,最终实现简便、高效的信息化教务管理。
Aiming at Educational Administration System in digital campus, this paper presents a design idea based onVCT-EIS development mode of educational administration system, The model is made up of the view layer (V),management layer (CT) and database layer (EIS). This paper introduces the system's main function module, thestructure and main module realization process. In this paper, according to VCT-EIS model, system can be divided intothe presentation layer, business logic management layer and database. The presentation layer can realize the function ofspecific modules by using the request to capture and display the data. The business logic management layer uses functioncode corresponding to the SQL statement or stored procedure to build configuration files, and obtains the data in thedatabase layer by performing a different SQL statements or stored procedures, then encapsulates the data into a JSONdata which is returned to the presentation layer finally. The database layer builds the middle table, sets up the trigger oruses stored procedures, to ensure the correctness of the data logic. The three layer structures are independent of eachother, so that making the system easier to be maintained. By using this system, users can reduce the complexity of thedaily educational administration work, and finally realize convenient and efficient information educational administration.