【正文】 用品 入庫管理，場地管理，租借管理 ， 丟失故障 管理，用戶信息管理，系統(tǒng)信息管理等功能，以滿足對體育用品的各種處理。在開發(fā)此系統(tǒng)時首先對所要設計的內容作了詳細的準備，分析系統(tǒng)功能，確定基本框架。系統(tǒng)功能的實現(xiàn) ,大大提高了 體育用品租借 管理的合理性以及效率性 。管理人 員 只需在用 戶 界面上 輸 入 用品 信息 ，場地信息就可以實現(xiàn)對用品和場地進行入庫、租借等信息的管理 。本系 統(tǒng)還 提供 了對用品和場地進行丟失和故障的管理 。 關鍵詞 ： 體育用品租借管理系 統(tǒng) , c,Sql server 2 Abstract A practical and good sporting goods rental management system should be able to sporting goods for a full range of rental management, its main function should include sporting goods storage management, venue management, lease management, loss, fault management, the user information management, information management, to meet the processing of a variety of sporting goods. First in the development of this system to design the contents of detailed preparation, analysis o f system functions to determine the basic framework. The corresponding database table structure, and finally start coding. Realization of system functions, greatly improving the rationality and efficiency of the management of sporting goods rental. Of the system userfriendly, practical, easy for users to grasp. Its main purpose is to provide customers with convenient rental services, and to improve the work efficiency of the management of sporting goods. Management only in the user interface, input supplies, and venue information can be achieved on the management of information storage, rental of supplies and venues. Supplies and site lease, the system will automatically time billing, realtime query to the data. The system also provides supplies and site management of loss and failure. The development of this system is THE MICROSOFT WINDOWS XP operating system using Microsoft Visual Studio 2020 as a development tool, SQL SERVER 2020 as backend database. Keywords: sporting goods rental management system, c , , Sql the server 3 目錄 摘 要 .............................................................................................................................. 1 ABSTRACT................................................................................................................... 2 介紹 ................................................................................................................................ 6 第一章課程背景 ............................................................................................................ 7 現(xiàn)狀 ...................................................................................................................... 7 研究的意義 .......................................................................................................... 8 概要 ...................................................................................................................... 8 第二章可行性分析 ........................................................................................................ 8 組織和管理可行性 .............................................................................................. 8 經濟可行性 ......................................................................................................... 8 技術可行性 ......................................................................................................... 9 第三章需求分析 .......................................................................................................... 11 用戶分析 ........................................................................................................... 12 功能分析 ........................................................................................................... 12 用戶管理功能 ............................................................................................ 12 體育器材的管理 ........................................................................................ 12 租借歸還管理 .......................................................................................... 12 丟失和故障管理 ........................................................................................ 13 數(shù)據(jù)庫的備份還原管理 ............................................................................ 13 開發(fā)工具 ........................................................................................................... 13 Microsoft Visual Studio 2020 ..................................................................... 13 c ................................................................................................................. 14 SQL Server 2020 ......................................................................................... 14 第四章系統(tǒng)設計 .......................................................................................................... 15 系統(tǒng)界面設計 ................................................................................................... 15 登陸界面 .................................................................................................... 15 系統(tǒng)主頁面 ................................................................................................ 15 數(shù)據(jù)庫設計 ....................................................................................................... 16 導論 ............................................................................................................ 16 4 數(shù)據(jù)庫的選擇 ............................................................................................ 16 數(shù)據(jù)庫的概念設計 .................................................................................... 17 表 DB_Admin（操作員表） ............................................................. 17 表 DB_Lease(租借表 ) ........................................................................ 17 表 DB_ReportedLoss（丟失報損表） .............................................. 18 表 DB_Stock（庫存表） ................................................................... 18 表 DB_Type(分類表