1、码实现 .766.3 系统性能优化 .776.3.1 数据库的性能优化 .776.3.2 WEB 服务器性能优化 .806.3.3 应用程序性能优化 .807 结束语 .82参考文献 .84致谢 .85附录 .86 基于 B/S 模式的工程硕士教学与学籍管理系统的实现 数据库设计-4CONTENTS 1 EXORDIUM .71.1 PROJECT BACKGROUND .71.2 PROJECT CONTENT.71.3 PROJECT TARGET.82 MANAGEMENT INFORMATION SYSTEM .102.1 SUMMARY OF MIS .102.2 ORIGIN AN
2、D DEVELOPMENT OF MIS .112.3 DEVELOPMENT OF MIS .123 KEY TECHNOLOGIES .173.1 C/S AND B/S.173.1.1 C/S MODE .173.1.2 B/S MODE .173.1.3 DISTINCTION BETWEEN C/S AND B/S.193.1.4 COMPARISON BETWEEN C/S AND B/S.213.2 ASP AND JSP .233.2.1 APPLICATION COMPARISON BETWEEN ASP AND JSP .253.3 DATA BASE MANAGEMENT
3、 SYSTEM.263.3.1 MYSQL AND LAMP .263.3.2 CHARACTERISTICS OF SQL SERVER.274 FUNCTION DESIGN OF SYSTEM .294.1 INTRODUCTION.294.1.1 DEVEL OPMENT PRINCIPLE AND DESIGN IDEA .294.1.2 SELECTION OF DEVELOPING METHOD.304.1.3 SELECTION OF DEVELOPING PLATFORM AND TOOLS.31基于 B/S 模式的工程硕士教学与学籍管理系统的实现 数据库设计-54.1.4
4、FUNCTIONAL ARCHITECTURE .314.2 SYSTEM PARTITIONING .314.2.1 TEACHING SECRETARY SYSTEM .314.2.2 TEACHER SYSTEM.354.2.3 STUDENT SYSTEM.374.3 FUNCTION MODULE.394.3.1 TEACHER INFORMATION MANAGEMENT.394.3.2 STUDENT INFORMATION MANAGEMENT.414.3.3 CURRICULUM MANAGEMENT .444.3.4 SCORE MANAGEMENT .474.3.5 OT
5、HER MANAGEMENT.495 SYSTEM DATABASE DESIGN .515.1 CHARACTERISTICS OF DATABASE DESIGN .515.2 DESIGN METHOD OF DATABASE .525.3 BASIC STEPS OF DATABASE DESIGN .525.4 CONSTRUCTION OF TABLES .535.4.1 TABLE OF STUDENT INFORMATION.535.4.2 TABLE OF TEACHER INFORMATION.545.4.3 TABLE OF TEACHING SECRETARY INFO
6、RMATION .555.4.4 TABLE OF COURSE PLANNING.555.4.5 TABLE OF COURSE SCHEME .565.4.6 TABLE OF COURSE SCHEME DETAIL.575.4.7 TABLE OF MANAGEMENT OF ELECTIVE COURSE STATUS.575.4.8 TABLE OF STUDENTS WHO CHOSE ELECTIVE COURSE .585.4.9 TABLE OF CORRESPONDING RELATIONSHIP BUTWEEN TUTOR AND STUDENT.585.4.10 TA
7、BLE OF STUDENT GRADE .595.4.11 TABLE OF MESSAGE INFORMATION .59基于 B/S 模式的工程硕士教学与学籍管理系统的实现 数据库设计-基于 Java 的学习管理系统(LMS) 后台程序设计I基于 JAVA的学习管理系统（LMS）后台程序设计摘要 E-learning 又称电子化学习，是指通过计算机、网络等数字化方法进行学习与教学的活动。它充分利用 IT 技术为教学活动提供具有全新沟通机制与丰富资源的学习环境，实现了一种新的学习方式。学习管理系统(Learning Management System)是一个 E-learning 平台。基
8、于 Java 的学习管理系统是在 Java 平台上实现的一个电子化学习平台，主要提供了学生，老师交流学习的环境，使得管理教学方便，高效。该系统主要采用了 Struts 开源框架，MVC 模式实现。系统分为前台和后台部分。前台部分即 Web 界面部分，提供系统与用户交流的用户接口，采用模块化的方法设计和开发，各个功能模块之间既相互独立又相互有数据参数传递。系统后台部分主要完成系统业务逻辑，响应用户请求。本文首先对系统采用的 J2EE，STRUTS 和 MVC 技术的概念，组织架构等进行了简单的介绍，接着对详细介绍了系统总体设计，包括对系统目标，系统特性的描述，接下来再对系统模块的划分作了大致的介
9、绍。其次，对系统的详细设计进行了描述。系统主要可划分为四个模块，即控制器模块，FORMBEAN 模块，安全模块和数据库模块，本文对上述四个模块的设计和实现进行了详细的说明。最后，本文展示了系统运行结果，并对运行结果作了详细的介绍。关键词学习管理系统 STRUTS J2EE MVC基于 Java 的学习管理系统(LMS) 后台程序设计IIJAVA based learn management system (LMS)background module design Abstract E-learning implements a nearly new way to study through c
10、omputer，network and so on digital method to do teaching and studying activity. E-learning relies on IT technology. this supplies students and teachers a environment with rich resources and convenient way to communicate each other. Learning Management is a subset of E-learning systems. Our project is
11、 “Java Bases Learning Management System”. This system is running on java platform, it supplies a environment that students and teachers can communicate with each other conveniently, this system help them studying and teaching more efficiently.This system is implemented on Struts framework and MVC de
12、sign pattern. It can divided into two parts， foreground and background. The first part mainly supplies the web user interface, so the user can interact with this system. The second part mainly completes the userss requests, and sends the responses to the web part and displays the information to the
13、user in web pages. This system is high modularization, It can be divided into several separated model, every model is separated, but some data and arguments transformed among them.This article first introduces the concept and architecture of J2EE，STRUTS and MVC which used in this system. And then de
14、scribes the globle designing of this system.Secondly, the background part of this system is consisted of four models, Controller model, FormBean Model, Security Model and Database Model. Each of them was introduced in this article.Last, the running result of this system was introduced.Keywords Learn
15、ing Management J2EE STRUTS MVC基于 Java 的学习管理系统(LMS) 后台程序设计III目录引言 .1第一章 J2EE,STRUTS,MVC 介绍 .21.1 J2EE 平台的介绍 .21.1.1 J2EE 的概念 .21.1.2 J2EE 的优势 .31.1.3 J2EE 体系架构概述 .41.1.4 J2EE 主要技术 .61.2 STRUTS框架的介绍 .71.2.1 Struts 的概念和体系结构 .71.2.2 Struts 框架的工作原理和组件 .91.2.3 Struts 标签库 .151.3 MVC 模式的介绍 .161.3.1 MVC 的概念和体系结构 .161.3.2 为什么使用 MVC .171.3.3 MVC 的优缺点 .18第二章 系统总体设计 .192.1 系统目标 .192.2 系统特性 .嬀(焿倂耀唀唁甁蜂弃螋顥潶顨腟搀漀挀砀螋顥潶顨
