【正文】
SQL; 登錄管理; 團(tuán)員信息管理 ABSTRACT the College of Information Engineering League members’ information in the management system is mainly designed for the management of information. Purpose of the college league members in four years, these information required for effective management, and management awareness into practice to improve student ability, as well as deepen the understanding of the object oriented thoughts and make full use of the system design tools. League members’ information in the management system is based on Eclipse development and SQL database, being a data collection, analysis and summary. Eclipseis to provide users with visual window, userfriendly. By Eclipse in JDBCODBC Bridge to connect SQL database, and generate an executable file. This can be familiar with and master JFC, SQL editor and debugger to use, and understanding of these programming tools. Determine the system functions through system analysis, design database, establish the corresponding ER diagram, the preparation of the fields and properties, this editing frame interface and modify the corresponding Java code, eventually generate executable programs. The system has two modules – login management, the management of leagues information. calls the corresponding interface can be built in the database on to make the designated operations. Keywords: Eclipse。 login management。 緒 論 ................................................................. 1 1 開發(fā)工具的選擇 ....................................................... 2 Eclipse 的開發(fā)環(huán)境 .............................................. 2 SQL 查詢語言及使用 .............................................. 2 2 問題定義與可行性研究 ................................................. 3 系統(tǒng)初步調(diào)查 ................................................... 3 系統(tǒng)的可行性分析 ............................................... 3 系統(tǒng)的開發(fā)步驟 ................................................. 4 3 需求分析 ............................................................. 5 需求分析報(bào)告 ................................................... 5 功能設(shè)計(jì)圖 ..................................................... 5 4 數(shù)據(jù)流圖和程序流程圖設(shè)計(jì) ............................................. 7 數(shù)據(jù)流圖的定義與分析 ........................................... 7 系統(tǒng)流程圖的分析與設(shè)計(jì) ......................................... 7 5 系統(tǒng)設(shè)計(jì) ............................................................. 9 數(shù)據(jù)庫(kù)設(shè)計(jì) ..................................................... 9 數(shù)據(jù)庫(kù)需求分析 ........................................... 9 系統(tǒng)數(shù)據(jù)庫(kù)之 ER 圖 ....................................... 9 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) ...................................... 10 界面設(shè)計(jì) ...................................................... 10 登錄窗口 ................................................ 10 主窗口 .................................................. 11 用戶操作窗口(舉例) .................................... 11 系統(tǒng)相關(guān)環(huán)境配置與實(shí)現(xiàn) ........................................ 12 數(shù)據(jù)庫(kù)實(shí)現(xiàn) .............................................. 12 配置 OBDC 數(shù)據(jù)源 ......................................... 12 實(shí)現(xiàn)在 Eclipse 中訪問 SQL 數(shù)據(jù)庫(kù)的方法 .................... 13 6 系統(tǒng)編碼與測(cè)試 ...................................................... 14 應(yīng)用程序項(xiàng)目設(shè)計(jì) .............................................. 14 軟件測(cè)試 ...................................................... 14 測(cè)試步驟 ................................................ 14 測(cè)試方法 ................................................ 14 部分測(cè)試舉例 ............................................ 14 結(jié) 語 ................................................................ 19 參考文獻(xiàn) .............................................................. 20 附 錄 ................................................................ 21 致 謝 ................................................................ 24