【正文】 以開(kāi)始設(shè)計(jì)時(shí)，真的遇到了很多困難，不過(guò)通過(guò)同學(xué)和老師的幫助以及上網(wǎng)學(xué)習(xí)，解決了設(shè)計(jì)上的不少問(wèn)題，也使我對(duì)Flex技術(shù)有了一定的掌握，同時(shí)鞏固了以前所學(xué)的知識(shí)。致 謝通過(guò)這次畢業(yè)設(shè)計(jì)，我獲益匪淺。Reilly, 200818．Katherine Ulrich. Flash CS4 Professional for Windows and Macintosh: Visual QuickStart Guide. Peachpit Press, 2008附錄1 外文參考文獻(xiàn)（譯文）淺析Java的數(shù)據(jù)庫(kù)訪問(wèn)技術(shù)1. 引言Java語(yǔ)言是一個(gè)支持網(wǎng)絡(luò)計(jì)算的面向?qū)ο蟪绦蛟O(shè)計(jì)語(yǔ)言。JDBC API通過(guò)一個(gè)JDBC驅(qū)動(dòng)程序管理器和為各種數(shù)據(jù)庫(kù)定制的JDBC驅(qū)動(dòng)程序，提供與不同數(shù)據(jù)庫(kù)的透明連接。目前比較常見(jiàn)的JDBC驅(qū)動(dòng)程序分為一下四個(gè)種類： JDBCODBC橋+ODBC驅(qū)動(dòng)程序JavaSoft橋產(chǎn)品利用ODBC驅(qū)動(dòng)程序提供JDBC訪問(wèn)。所用的具體協(xié)議取決于提供者。一般而言，我們建議不要適用橋驅(qū)動(dòng)程序，即第（1）（2）類驅(qū)動(dòng)程序，它們主要是作為純Java驅(qū)動(dòng)程序還沒(méi)有上市之前的過(guò)渡方案來(lái)適用，效率相對(duì)地下，程序的可移植性差。第（4）類驅(qū)動(dòng)程序的優(yōu)點(diǎn)在于與數(shù)據(jù)庫(kù)本身結(jié)合緊密，性能很高。我們可以通過(guò)設(shè)定連接池最大連接數(shù)來(lái)防止系統(tǒng)無(wú)盡的與數(shù)據(jù)庫(kù)連接。JavaBean技術(shù)是一種可以重復(fù)使用且跨平臺(tái)的軟件組件，可以使用JavaBean封裝事物邏輯和客戶端操作的分離，使系統(tǒng)具有更好的靈活性和適用性。 多線程及線程池技術(shù)多線程技術(shù)主要解決處理器單元內(nèi)多個(gè)縣城執(zhí)行的問(wèn)題，它可以顯著減少處理器單元的閑置時(shí)間，增加處理器單元的吞吐能力。另外，它使得與線程的啟動(dòng)及消亡后的清理相關(guān)的開(kāi)銷最小。s Database Access Technology1. IntroductionJava language is a support network puting objectoriented programming language. Java language has absorbed Smalltalk language and C + + language of the advantages, and an increase of other features such as support for concurrent programming, network munications and control of multimedia data.2. JDBCJDBC is a SQL statement can be used for the implementation of the Java API, it is written by a number of Java class and interface ponents. JDBC architecture consists of four ponents: the application, JDBC driver manager (JDBC Driver Manager), and data sources (Data Source). JDBC API via a JDBC driver manager and for a variety of customized database JDBC driver to provide transparent connectivity of different databases. JDBC API is the role of shielding between different database JDBC drivers the difference between, making programmers from a standard, pure Java database design interface, in Java of any type of database access to provide technical support. JDBC driver manager for databasedriven application program loaded. JDBC driver associated with a specific database, and data sources used to establish connections, submit SQL requests to the database. At present, the more mon JDBC drivers are divided into about four categories: JDBCODBC bridge + ODBC driverJavaSoft products that use ODBC bridge provides JDBC access to drivers Local APIThis type of driver on the client API of the JDBC call is converted to Oracle, Sybase, Informix, DB2 and other DBMS call. JDBC Network pure Java driverThis JDBC driver will convert the DBMS has nothing to do with the network protocol, such an agreement after a server has been converted to a DBMS protocol. This Web server middleware to its pure Java client to connect to a wide range of database. The agreement depends on the specific provider. Local agreements pure Java driverThis type of JDBC driver will call directly into a DBMS network protocol used. This will allow the client and from a direct call on DBMS server, Intranet access is a very practical solution. Driver for more than four choices, to build applications that need to take into account the actual needs. In general, we remend that drivers do not apply to the bridge, that is, subsection (1) (2) class driver, which is mainly as a pure Java driver has not yet listed on the program prior to the application of the transition, the relative efficiency of the ground, the procedure can be transplanted poor. (3) (4) from the JDBC driver is the preferred method to access the database, they not only improve the portability procedures to achieve the purpose of crossplatform, but also eliminates the need to install the client driver trouble. Subsection (3) class driver is on the merits of the largest multidatabase support, so that the most flexible JDBC model, widely used with the Internet / Intranet development, a very outstanding performance. This driver supports multidatabase and distributed transaction processing and centralized management for largescale enterprise applications. Subsection (4) driver the advantage of close integration with the database itself, a high performance. Applicable to smallscale enterprise applications. Application layer。在任務(wù)期限比較短時(shí)，線程池也是不錯(cuò)的方法。線程池技術(shù)正是關(guān)注如何縮短或調(diào)整時(shí)間的技術(shù)，從而提高服務(wù)器程序性能的。 數(shù)據(jù)庫(kù)批量更新機(jī)制數(shù)據(jù)庫(kù)批量更新的機(jī)制時(shí)通過(guò)一次調(diào)用將整批更新命令提交給數(shù)據(jù)庫(kù)，之后數(shù)據(jù)庫(kù)將一次處理所有的更新。 JavaBean技術(shù)在實(shí)際應(yīng)用程序中會(huì)遇到很多程序訪問(wèn)數(shù)據(jù)庫(kù)的情況，如果數(shù)據(jù)庫(kù)要修改，哪怕僅是密碼，也要改動(dòng)所有的程序，所以應(yīng)當(dāng)把鏈接數(shù)據(jù)庫(kù)的操作放進(jìn)一個(gè)程序中，再需要數(shù)據(jù)庫(kù)鏈接時(shí)去調(diào)用這個(gè)文件就可以解決這個(gè)問(wèn)題。3. 提高數(shù)據(jù)庫(kù)訪問(wèn)效率的幾種技術(shù) 數(shù)據(jù)庫(kù)連接池技術(shù)數(shù)據(jù)庫(kù)連接池的基本思想就是為數(shù)據(jù)庫(kù)連接建立一個(gè)“緩沖池”。應(yīng)用程序?qū)又泻?種重要的接口：。第（3）類驅(qū)動(dòng)程序最大的優(yōu)點(diǎn)在于對(duì)多數(shù)據(jù)庫(kù)的支持，使最靈活的JDBC模式，廣泛地應(yīng)用與Internet/Intranet開(kāi)發(fā)，性能十分突出。這將允許從客戶機(jī)及其上直接調(diào)用DBMS服務(wù)器，是Intranet訪問(wèn)的一個(gè)很實(shí)用的解決辦法。 JDBC網(wǎng)絡(luò)純Java驅(qū)動(dòng)程序這種驅(qū)動(dòng)程序?qū)DBC轉(zhuǎn)換為與DBMS無(wú)關(guān)的網(wǎng)絡(luò)協(xié)議，之后這種協(xié)議又被某個(gè)服務(wù)器轉(zhuǎn)換為一種DBMS協(xié)議。JDBC驅(qū)動(dòng)程序管理器為應(yīng)用程序裝載數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序。2. JDBCJDBC是一種可用于執(zhí)行SQL語(yǔ)句的Java API，它由一些Java語(yǔ)言編寫(xiě)的類和界面組成。在這次畢業(yè)設(shè)計(jì)過(guò)程中，得到了周鳳麗老師和其他老師的精心指導(dǎo)，在此表示衷心的感謝！要特別感謝指導(dǎo)我畢業(yè)設(shè)計(jì)的周鳳麗老師，在我有特殊情況時(shí)能及時(shí)幫助我，使我的畢業(yè)設(shè)計(jì)和論文得以順利完成?？偠灾@次畢業(yè)設(shè)計(jì)使我學(xué)到了很多在大學(xué)課堂上學(xué)不到東西，不光是專業(yè)知識(shí)有所提高，還鍛煉了我的意志，使我更加堅(jiān)強(qiáng)。通過(guò)這次畢業(yè)設(shè)計(jì)，我學(xué)到了很多，從最初的Java語(yǔ)言，后來(lái)到Web開(kāi)發(fā)，再后來(lái)在培訓(xùn)過(guò)程中學(xué)到的ssh，再后來(lái)學(xué)到Flex，最后到將軟件功能的思想融合與整個(gè)設(shè)計(jì)過(guò)程中，將平時(shí)所學(xué)的知識(shí)運(yùn)用于實(shí)際開(kāi)發(fā)實(shí)踐中。由于Flex需要遠(yuǎn)程調(diào)用數(shù)據(jù)庫(kù)，所以又選擇可一致性好的Java語(yǔ)言來(lái)配合開(kāi)發(fā)。數(shù)據(jù)庫(kù)設(shè)計(jì)有冗余，需要進(jìn)一步優(yōu)化。整個(gè)程序在編譯之后，顯示在瀏覽器上的部分全部是后綴名為swf的文件，安全性高；而且整個(gè)系統(tǒng)在運(yùn)行時(shí)，只會(huì)在地址欄看到一個(gè)頁(yè)面名：。本系統(tǒng)可以運(yùn)行在多種操作系統(tǒng)平臺(tái)上（Windows NT/Windows 2000/Windows XP/Windows Vista），數(shù)據(jù)庫(kù)管理系統(tǒng)采用MySQL，功能強(qiáng)大的Flex配合可移植性好的Java開(kāi)發(fā)環(huán)境。如果是教師，登錄后可以進(jìn)入教師主頁(yè)面進(jìn)行課程打分，個(gè)人信息查詢等操作。不同用戶在登錄本系統(tǒng)時(shí)需要選擇用戶類型、輸入用戶名和密碼，若通過(guò)了系統(tǒng)數(shù)據(jù)庫(kù)的驗(yàn)證，便可以進(jìn)入符合身份的用戶界面進(jìn)行用戶操作。學(xué)生功能： 本模塊具有五項(xiàng)功能：主要用戶學(xué)生查詢自己的學(xué)籍信息，也可以在線選課，可以修改個(gè)人的部分信息，修改登錄時(shí)的密碼等。 課程信息添加、修改、刪除頁(yè)面基本實(shí)現(xiàn)代碼如下所示：mx:method name=selectcourse result=processResult(event) fault=processFault(event)mx:argumentscheck{}/checkbo1{}/bo1/mx:arguments/mx:methodmx:method name=deleteteacher result=processdtResult(event) fault=processFault(event)mx:argumentsusernames{}/usernamesuser_name{user_name}/user_name/mx:arguments/mx:methodmx:method name=deletestudent result=processdtResult(event) fault=processFault(event)mx:argumentsusernames{}/usernamesuser_name{user_name}/user_name/mx:arguments/mx:method 學(xué)生學(xué)籍查詢、修改、刪除頁(yè)面學(xué)生學(xué)籍查詢、修改、系統(tǒng)管理員可以在此頁(yè)面中查看或者修改現(xiàn)有在校學(xué)生的基本信息。當(dāng)點(diǎn)擊“