mysql运用.doc

摘要
在信息高度膨胀、计算机技术广泛应用的今天,各行业管理数据信息已经复杂无比,而且也不能仅以纸张的形式进行保存和管理,大多数行业都需要使用管理系统管理各类数据和处理各类业务,而BS的管理系统由于不受地域和时间限制,被越来越多的机构、企业采用。本文主要设计并实现了一个教学管理系统,基于B/S结构,采用jsp、html5、jquery等语言作为前台描述性语言,用springMVC+mybatis+mysql数据库实现后台管理,使用此系统可以进行常规的考勤、成绩、考试等基本数据管理,也对学校的学生、教师、教室等资源进行合理安排分配,并且对分班、排课等复杂的业务作智能自动化处理。
系统功能主要包括5个模块组成:基础管理、选课管理、分班管理、排课管理和考试管理,其中每个模块又由其子模块来完成它的功能,其中分班管理为本文重点。
关键词:sjsp;html5;jquery;springMVC;mybatis,mysql语言
Abstract
In information highly expansive, computer technology is widely used today, the industry data and information management is plex, but also can not only in the form of paper were preservation and management, most of the industry needs to use management system to manage all kinds of data and processing all kinds of business, and management system of BS is not limited by geographical and time constraints, more and more institutions and enterprises use. The main purpose of this paper is to design and realize the teaching management system, based on B / S structure, using JSP, HTML5, jQuery and other language as a front descriptive language, realized the backstage management with the database springMVC+mybatis+mysql. This system can be used to regular attendance, grades, test, basic data management, also to the school students, teachers, classrooms and other resources reasonable arrangements for the distribution of, and the classes, classes, and plex business intelligent automatic processing.
The function of the system mainly includes five modules: basic management, course management, grouping management, row class management and test management, in which each module and the sub module plete its function, including placement management is the focus of this paper.
Key word:sjsp;html5;jquery;springMVC;mybatis,mysql
目录
摘要 I
ABSTRACT II
目录 III
1 绪论 1
当前市场背景 1
教学管理系统绪论 2
2 实现本系统的主要技术和开发平台介绍 3
jsp、jquery介绍 3
mysql数据库库介绍 5
springMVC、mybatis介绍 7
html语言介绍 8
3 系统需求介绍与分析 12
需求分析 12
系统分析 12
权限分析 13
系统设计 13