摘 要
随着汽车租赁业务的迅速发展,迫切需要加快汽车租赁信息管理的自动化的步伐,而汽车租赁管理系统可以减少汽车租赁管理的重复性和低效性,提高汽车租赁的管理业务处理效率。汽车出租管理系统主要功能模块有基本信息的管理、客户会员管理、日常业务管理、系统用户管理。基本信息的管理主要包括车辆类型和车辆保险类型的管理,车辆管理,保险公司管理等;客户会员管理主要包括客户信息管理、会员信息管理、会员类型信息管理;不同类型的会员可享受不同的优惠;日常业务管理包括汽车租约和归还管理,包括租约车的类型,租约时间,租约方式,租约费用等。
运用软件工程的知识和方法从问题定义入手进行可行性研究,在可行性分析的基础上确定需求分析的内容,然后进行系统概要设计与详细设计,能够熟练使用编程语言进行系统开发。在掌握数据库基本知识的基础上,进行数据库的设计,使用SQL语句和存储过程进行系统中数据库部分的编程,实现系统功能。并结合需求分析的内容进行单元测试和综合测试,使系统能够稳定运行。
关键词:汽车租赁;管理系统;Java;sql
ABSTRACT
With the rapid development of car rental business, it is urgent to speed up the automation of car rental information management, and the car rental management system can reduce the repeatability and inefficiency of car rental management, and improve the efficiency of car rental management business processing. The main function modules of car rental management system are basic information management, customer member management, daily business management, system user management. The basic information management mainly includes the vehicle type and the vehicle insurance type management, the vehicle management, the insurance company management and so on; the customer member management mainly includes the customer information management, the member information management, the member type information management; different classes Members can enjoy different concessions; daily business management includes car rental and return management, including rental car type, lease time, lease method, lease fee, etc.
Using the knowledge and method of software engineering to carry on the feasibility study from the problem definition, determine the content of the requirement analysis on the basis of the feasibility analysis, then carry on the system outline design and the detailed design, can skillfully use the programming language to carry on the system development. Based on the basic knowledge of the database, the design of the database is carried out, and the SQL statements and stored procedures are used to program the database part of the system to realize the system function. And combined with the content of requirements analysis for unit testing and comprehensive testing, so that the system can run stably.
Keywords: car rental; management system; Java;sql;
目录
第一章 系统概述 1
1.1背景 1
1.2发展现状 1
第二章 需求分析 2
2.1 功能需求 2
2.2 数据需求 3
第三章 系统设计 5
3.1系统结构 5
3.2 数据库设计 5
3.2.1 ER图 6
3.2.2 逻辑结构 6
3.2.3 数据库物理结构 7
3.2.4 数据库实现 9
3.3用户控制系统 9
3.4模块设计 10
3.4.1 汽车管理模块设计 10
3.4.2 基本设置模块设计 11
第四章 系统实现 11
4.1用户登录模块 11
4.2汽车管理模块实现 12
4.3汽车预租模块实现 17
第五章 后记 19
5.1完善计划 19
5.2个人总结 19
参考文献 20