摘 要

现代社会，日常生活中越来越离不开网络获得信息，除了高精尖的计算机技术在不断进步以外，许多适用于日常生活的技术也在默默的发展着，潜移默化的融入于我们的生活，许多年轻人也会更喜欢通过网络来获取信息，驾校管理系统就是利用网络向所有网民提供驾校信息的信息平台，旨在为驾校和想学车的学员提供更好的信息交流服务。

本平台不仅向想学车的学员开放，想要推广和吸引学员的驾校或者教练也可以使用本平台，不需要通过中介，学员可以和驾校，甚至教练直接进行交流，分享信息。网友们能够在驾校信息平台上自主寻找，搜索，查看，发布信息，是和以往的驾校中介有很大差异的。想学车的学员能够自主查看搜索网站上的信息，选择时间地点和学车条件符合理想的驾校和教练，并且还可以练习理论考试。学过的学员或者正在学习的学员还可以在网页上发布对驾校和教练的评价，这些评价既可以作为对驾校的反馈，也可以帮助难以抉择的用户做出更好的选择。

我选择的课题要求是基于B/S模式完成一个功能完善，使用方便的驾校管理系统，采用了ASP.NET技术和C＃语言，我选择了Visual Studio 2010，和SQL Server 2008，网站的使用者可以在网页上查看信息或者操作，而储存信息数据则通过数据库管理系统来完成，以此实现驾校管理系统的各项功能。

关键词：驾校管理；B/S；数据库；ASP.NET；SQL

Driving School Management System

ABSTRACT

In modern society, the daily life is more and more inseparable from the network to obtain information. With the rapid development of computer science and technology, it is more convenient and fast to obtain information from the network. The driving school management system is an information platform that provides driving school information to all netizens by using the network, aiming at providing better information exchange services for driving schools and students who want to learn to drive.

This platform is not only open to students who want to learn to drive, but also to driving schools and coaches. They can exchange information through this platform.Netizens can independently search, search, view and publish information on the driving school information platform, which is quite different from previous driving school intermediaries. Students who want to learn a car can independently view the information on the search website, choose the time and place and the driving school and coach who meet the ideal conditions for learning a car, and also can practice the theoretical exam.Students who have learnt or are learning can also post comments on driving schools and coaches on the website, which can be used as feedback to driving schools, and also help users who are difficult to choose to make better choices.

The task of this project is to use some new technologies to develop a complete driving school management information system, mainly based on B/S mode, using ASP.NET technology and C# language. The development environment I choose is Visual Studio 2010, while the background database uses SQL Server 2008, the function of the system is very complete, users can view information or operation on the web page, and the storage of information and data is completed through the database management system, in order to achieve the functions of the driving school management system.

Key words: ASP.NET；SQL；Database；Driving School Management；B/S；

目 录

1 引言…………………………….........……………………………………............……………………1

1.1 课题的研究背景..................…………………………………………........……………………1

1.2 研究目的及意义………………………………………………………...........…………………1

1.3 系统设计思想...............................……………………………….............…………………1

2 网站需求分析………………….....…………………………………………….................………………3

2.1 功能需求分析……….................……………....………………………………..........………………3

2.2 网站管理员用例图………………………………...……………………………..............……………3

2.3 业务流程分析….....................…………………………………….......................…………4

2.4 数据流程图……….........…..............................…………………........……………………5

2.5 数据字典………………...……..................................................……………………………6

2.6系统可行性分析…......……..........………….........................………………………………8

2.6系统的经济性…......….....…..........…………….......................……………………………8

2.6技术性…...............……..........………………….................................………………………9

2.6可操作性…...................……..........……………………...................................……………………9

3 网站总体设计……………………………………………………………….........................………………10

3.1 开发工具及技术……………………...........…………………………………..........……………10

3.2 网站结构图设计……………………………...………………………………....……………10

3.2.1网站前台功能结构图……………...……………………………...….....................…………11

3.2.2网站后台功能结构图……………..………………….....................………………………11

4 数据库设计…………………………………………………………..........................……………………13

4.1 数据库介绍……………….........……..........………………………….........……………………13

4.2 实体联系模型…………………………..........………………………….............……………………13

4.3 E-R实体图设计……………………………..........………………………..........……………………13

4.4 逻辑数据库设计……………………………….........……………………..……………………15

5 系统详细设计……………………………………………………………....................…………………20

5.1 网站首页设计……………………………………………………...................………………20