【正文】 , has carried on the system design, the detailed design to the system, and used the JSP dynamic work programming environment and the oracleXE database has realized the system user debarkation, The user registration, the inquiry, the revision, the deletion, functions and so on increase ski equipment information, indicated after the test that, this system has achieved the function demand, can the normal operation. This ski apparatus rent when the system design had considered fully and the system extendibility and the trade activity unique service flow, the good design enables the system to have the outstanding expansion ability to be advantageous for the maintenance. This system is typical based on the Web management information system, its realization work mainly is the client side design development which the backstage database establishment and the enpassment database carry on. Key words： Electron management system The ski thing rents JSP OracleXE 目 錄 1 前 言 ............................................................................................................................. 1 課題的來源及意義 ...................................................................................................... 1 國內(nèi)外發(fā)展?fàn)顩r .......................................................................................................... 1 本課題研究的目標(biāo) ...................................................................................................... 3 本課題研究的內(nèi)容 ...................................................................................................... 3 2 主要用到的技術(shù)和工具 ................................................................................................ 5 JSP 技術(shù) ...................................................................................................................... 5 MVC 思想 ................................................................................................................... 5 Tomcat ......................................................................................................................... 7 Oracle 數(shù)據(jù)庫 ............................................................................................................. 8 數(shù)據(jù)庫訪問接口 JDBC 技術(shù) ................................................................................ 9 MyEclipse 開發(fā)環(huán)境 ................................................................................................... 9 3 系統(tǒng)需求分析與總體設(shè)計(jì) .......................................................................................... 10 系統(tǒng)功能需求分析 .................................................................................................... 10 系統(tǒng)的功能描述 ........................................................................................................ 10 系統(tǒng)流程圖 ................................................................................................................ 11 系統(tǒng)的三層架構(gòu)設(shè)計(jì)思想 ........................................................................................ 12 4 數(shù)據(jù)庫設(shè)計(jì) ...................................................................................................................... 13 關(guān)系數(shù)據(jù)庫的基本概念 ............................................................................................ 13 系統(tǒng) ER 圖 ................................................................................................................ 13 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì) ................................................................................................ 13 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) ................................................................................................ 15 5 詳 細(xì)設(shè)計(jì) ........................................................................................................................... 17 管理員登陸的實(shí)現(xiàn) .................................................................................................... 17 滑雪器材信息的管理 ................................................................................................ 18 滑雪器材租用的管理 ................................................................................................ 21 滑雪器材歸還的管理 ................................................................................................ 23 租用信 息的管理 ........................................................................................................ 24 6 系統(tǒng)測試 ........................................................................................................................... 27 測試概論 .................................................................................................................... 27 測試方法 .................................................................................................................... 27 測試內(nèi)容和結(jié)果 ........................................................................................................ 28 管理員登陸測試 .............................................................................................. 28 滑雪器材的管理測試 ...................................................................................... 29 租用信息查詢和歸還雪具的功能測試 .......................................................... 30 租用滑雪用具功能的測試 .............................................................................. 32 結(jié) 論 ............................................................................................................................... 34 謝 辭 ............................................................................................................................... 35 參考文獻(xiàn) ............................................................................................................................... 36 附 錄 ............................................................................................................................... 37 大連 交通大學(xué)信息工程學(xué)院 2021 屆本科生畢業(yè)設(shè)計(jì)（論文） 1 1 前 言 課題的來源及意義 20世紀(jì) 60年代