【正文】 知識(shí)，并且將其應(yīng)用到實(shí)踐中。因此，我學(xué)到了許多書本上學(xué)不到的知識(shí)，增強(qiáng)了自己的動(dòng)手能力。即將畢業(yè)我十分珍惜這次鍛煉的機(jī)會(huì)，我按部就班的完成了自己的設(shè)計(jì)任務(wù)，但由于自己的知識(shí)水平有限，仍然存在很多的不足之處，懇請(qǐng)老師多多指教！當(dāng)今的社會(huì)是競(jìng)爭(zhēng)的社會(huì)，而人才的競(jìng)爭(zhēng)則是競(jìng)爭(zhēng)的焦點(diǎn)，畢業(yè)設(shè)計(jì)對(duì)于我們即將離校的同學(xué)來說，是離校前很好的一次鍛煉，使我們各方面的能力都有了很大的提高，為我們踏出校門，走上社會(huì)增強(qiáng)了能力與自信！計(jì)算機(jī)技術(shù)的高速發(fā)展，使我深深地認(rèn)識(shí)到只有不斷的加強(qiáng)學(xué)習(xí)，才能在計(jì)算機(jī)技術(shù)方面不至于被淘汰，今后，我還要加強(qiáng)學(xué)習(xí)，努力使自己成為一位專業(yè)的計(jì)算機(jī)人員，為我自己所從事的工作服務(wù)。畢業(yè)設(shè)計(jì)33謝 辭首先非常感謝學(xué)校能開設(shè)這個(gè)課題，為本人日后從事計(jì)算機(jī)方面的工作提供了經(jīng)驗(yàn)，奠定了基礎(chǔ)。本次畢業(yè)設(shè)計(jì)大概持續(xù)了半年的時(shí)間，現(xiàn)在終于到結(jié)尾了。剛拿到這個(gè)課題時(shí)，覺得這個(gè)課題比較難。今天回過去看看，卻十分的欣慰，因?yàn)橥ㄟ^我們的努力終于完成了。雖然這不是我讀大學(xué)以來第一次寫論文，但卻是花費(fèi)心血最多的一次，這是對(duì)我大學(xué)四年學(xué)習(xí)下來最好的檢驗(yàn)。經(jīng)過這次畢業(yè)設(shè)計(jì)，我的能力有了很大的提高，比如操作能力、分析問題的能力、自學(xué)能力、嚴(yán)謹(jǐn)?shù)墓ぷ髯黠L(fēng)等方方面面都進(jìn)步了。這期間凝結(jié)了很多人的心血，在此我表示由衷的感謝。沒有他們的幫助，我將無法順利完成這次設(shè)計(jì)。首先，我要特別感謝老師對(duì)我的悉心指導(dǎo)，在設(shè)計(jì)期間石老師幫助我收集文獻(xiàn)資料，理清設(shè)計(jì)思路，指導(dǎo)操作方法，并對(duì)我所做的課題提出有效的改進(jìn)方案。老師淵博的知識(shí)、嚴(yán)謹(jǐn)?shù)淖黠L(fēng)、誨人不倦的態(tài)度和學(xué)術(shù)上精益求精的精神讓我受益終生。其次，學(xué)校在這方面也給我們提供了很大的支持和幫助，學(xué)校領(lǐng)導(dǎo)比較重視，給我們安排了較多的上機(jī)次數(shù)和足夠的計(jì)算機(jī)，讓我們有盡可能多的時(shí)間上機(jī)；并為我們開通了網(wǎng)線，方便我們上網(wǎng)查找信息；另外提供了專門的教室方便我們上機(jī)調(diào)試；每個(gè)設(shè)計(jì)小組配有專門的指導(dǎo)老師，幫助我們能順利完成整個(gè)設(shè)計(jì)。對(duì)于學(xué)校和老師為我的畢業(yè)設(shè)計(jì)所提供的極大幫助和關(guān)心，在此我致以衷心的感謝！另外，還要感謝同學(xué)三年來對(duì)我的關(guān)心與支持，感謝各位老師在學(xué)習(xí)期間對(duì)我的嚴(yán)格要求。同時(shí)也要感謝身邊朋友的熱心幫助，沒有你們的支持與關(guān)心，就沒有我今天的畢業(yè)設(shè)計(jì)！最后，我要向我的父母致以最崇高的敬意，沒有你們無私的支持，就沒有我今天的成績(jī)?。簩W(xué)生網(wǎng)上選課系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)34參 考 文 獻(xiàn)[1] 鄭阿齊，王燕平，湯玫．ASP 程序設(shè)計(jì)教程［Ｍ］ ．北京：機(jī)械工業(yè)出版社，2022．[2] 薩師煊，王珊．?dāng)?shù)據(jù)庫系統(tǒng)概論[ 第三版] ［Ｍ］ ．北京：北京高等教育出版社，2022．[3] 夏邦貴，劉凡馨．SQL Server 數(shù)據(jù)庫開發(fā)經(jīng)典實(shí)例精解［Ｍ］ ．北京：機(jī)械工業(yè)出版社，2022．[4] 鄭人杰，殷人昆，陶永雷．實(shí)用軟件工程[ 第二版]［Ｍ］ ．北京：清華大學(xué)出版社，1997．[5] 陳文華．多媒體技術(shù)［Ｍ］ ．北京：機(jī)械工業(yè)出版社， 2022．[6] 劉青炎，劉春．網(wǎng)頁制作三劍客經(jīng)典效果 100 例［Ｍ］ ．上海：上?？茖W(xué)普及出版社，2022．[7] 微軟( 中國(guó))有限公司[8] 網(wǎng)易學(xué)院[9] 在線教程[10] ASP 編程菜鳥入門教程[11] 學(xué)網(wǎng)[12] ASP 教程吧畢業(yè)設(shè)計(jì)35附錄 A 外文翻譯 原文部分An Exercise about XML and SQLWhat This Exercise is AboutXML is found in more and more applications today. With its nonproprietary format, XML can be used to represent and exchange information in an application. The information for most applications is stored in some fashion. A relational database is the most mon location for persisting information. With databases storing information and XML used for representing information, a relationship exists between the two technologies. WebSphere Studio Application Developer has tooling that supports this relationship as well as individual relational database design tools and XML authoring tools. There are tools for working with existing databases schemas or creating new database schemas. There are also editors for specific types of XML documents. In this exercise you will use some of the XML tools and some of the features in the Data Perspective in WebSphere Studio Application Developer.User RequirementUser must have DB2(version ) and WebSphere Studio Application Developer installed. The Invest database must be setup (c:\yourbank\lab5\) and the source files used in the lab must be available at c:\yourbank\lab5.What You Should Be Able to DoAfter pleting this lab you should understand how to connect to an active database and import the schema into WebSphere Studio Application Developer. You should be able to add foreign keys to a table schema. By the end of this lab you will also be able to create SQL statements from multiple tables using the SQL statement wizard. Finally, you should be able to use the XML to SQL wizard to query the active database and return the information in an XML document. With the XML results, you will use the XML to XML mapping wizard to translate the results to another XML format.IntroductionThe Invest database contains three tables for storing information on stocks owned by a customer and customer contact information. To extract this information from the database and possibly integrate it into your application, you will need to connect to the database and import the schema into WebSphere Studio Application Developer. With the schema in the workbench, you will link the ADDRESS table to the PERSONALINFORMATION table. Next you will create a SQL SELECT statement that will select all of the customer address information. Then in the Data Perspective, you will execute the SQL statement against the database and obtain customer information in XML format for two customers. Finally you will use the XML to XML mapping wizard to map customer information to a statement DTD.Exercise InstructionsPart One: Setup Data Perspective__1. Set up the Invest database, if it has not been done already.：學(xué)生網(wǎng)上選課系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)36__ Run C:\YourBank\Lab5\ from a DB2 Command windowStartProgramsIBM DB2Command WindowType C:\YourBank\Lab5\.Enter the password PASSWORD when prompted.__2. In Application Developer, Open the Data Perspective.__ Click Perspective Open Other... and click Data.__ Click OK.__3. Connect to the Invest database.__ In the DB Explorer view, right click and click New Connection....__ In the Connection field, change the value to Invest DB Connection.__ In the Database field, change the value to Invest.__ In the User ID and Password fields, enter USERID and PASSWORD.__ Leave the other default values unchanged and click Finish.__4. Import data into a Project__ Click File New Project....__ Click Simple and Project before clicking Next.__ For the Project name enter InvestDatabase.__ Click Finish. The new project will be created in a Resource perspective.__ Close the Resource perspective by right clicking on the Resource perspective icon an clicking Close.__ If the Data perspective is not displayed, switch to it and insure the DB Explorer view is displayed.__ Expand the Invest DB Connection and right click on Invest (jdbc:db2:Invest) and click Import to Folder…__ Click Browse. Select the InvestDatabase project and click OK. Then click Finish.The schema information for the invest database will be imported into the InvestDatabase project.Part Two: Create Foreign Key__1. In the Data perspective, switch to the Navigator view.__2. Expand InvestDatabase and double click Invest DB .__3. Change to the Foreign Keys view by clicking on the tab.__4. Click Add another.__5. For the Target Table field, click Browse... to select the table holding the key.__ E