【正文】 dwellers from China and India to the Mediterranean Sea during various periods of time. I met my dear hubby in 2009 the second year I was in my school and it was the first year when he came here. We became colleagues. And there was nothing special happening during that year. He was just a kind and humble brother graduated from the same college as me. But we did not know each other till he became my colleague and his office desk was just in front of me. There was only a glass between us. So actually we could see each other when we both look up. But it is not the main reason that really draws us close. How we bee close to each other was something seems quite natural. We went out to play badminton with other colleagues and we sometimes chatted for a while. He is a man of few words but somehow sometimes will say something really humorous. Then one day, to my great surprise, I found a pot of beautiful flower on my desk. It was just the flower I had talked about with my colleague the other day, and I thought it was her who put the flower there. But the truth is not. It was the humble guy sitting in front of me. He just simply said ,”well, I caught sight of this flower and thought that it’s beautiful and you may like it”. I wonder why I was moved because of these simple words and present. Maybe it is the sincerity and the true self that impress me. I thanked him and some colleagues walked past my desk would appreciate the beautiful flower and they noticed that something romance happened there. Then later on, there were some little surprises once in a while. Once, there was something wrong with my drawer and I had plained about it unconsciously. And he fixed it for me. Then the other day, he placed several pink diamond roses beside the flower with a piece of paper saying” I love you more than I can say! Diamond stands for marriage, rose stand for love. I hope you are mine, bee my wife. You are the only girl who I really want to spend the rest of my life to stand by.” Although there were some grammar errors but I got what he meant. He meant so clear and so direct. s Day on February 14, characterized by bouquets of roses, chocolates and romantic candlelight dinners, than they do about their homegrown day for lovers. Even Qixi is nowadays referred to as the Chinese Valentine39。You cannot miss out the Autumn of Arxan. It is definitely the best with brightlycolored scenery full of emotions. 我會在以后的工作和學(xué)習(xí)中不斷完善自己，為我最熱愛的母校爭光，為自己翻開輝煌的新篇章。但由于時間倉促，個人經(jīng)驗(yàn)的不足，還不能讓這個系統(tǒng)各個功能都做到完美，JSP代碼較為復(fù)雜，我相信我還要有一段漫長的研究過程，不過通過這次論文的寫作和系統(tǒng)設(shè)計(jì)，我覺得我真的學(xué)到了很多，給我以后的工作中提供了很大幫助和經(jīng)驗(yàn)。 單獨(dú)對系統(tǒng)的測試主要從以下幾方面入手：① 功能測試：測試是否滿足開發(fā)要求，是否提供設(shè)計(jì)所描述的功能，是否用戶的需求都得到滿足。 測試的主要內(nèi)容為了保證測試的質(zhì)量，將測試過程分成幾個階段，即:代碼審查、單元測試、集成測試、確認(rèn)測試和系統(tǒng)測試。通過分析錯誤產(chǎn)生的原因和錯誤的分布特征，可以幫助項(xiàng)目管理者發(fā)現(xiàn)當(dāng)前所采用的軟件過程的缺陷，以便改進(jìn)。 ③ 測試工作枯燥無味，不能引起人們的興趣。第5章程序測試與調(diào)試 程序調(diào)試在設(shè)計(jì)系統(tǒng)的過程中，避免不了一些錯誤。 String jieyueShijian=(jieyueShijian)。 if((userMana)) { userMana(req, res)。 String isbm=(isbm)。 Object[] params={}。 ()。如類別名稱、備注信息等，點(diǎn)擊保存按鈕，調(diào)用后臺的java類catelogServlett把圖書類別信息保存到數(shù)據(jù)庫。 if(userType==0)//系統(tǒng)管理員登陸 { String sql=select * from t_admin where userName=? and userPw=?。須視企業(yè)規(guī)模和地理分布確定。 系統(tǒng)設(shè)計(jì)模式B/S結(jié)構(gòu)，即Browser/Server(瀏覽器/服務(wù)器)結(jié)構(gòu)，是隨著Internet技術(shù)的興起，對C/S結(jié)構(gòu)的一種變化或者改進(jìn)的結(jié)構(gòu)。JSP遵循J2EE規(guī)范所采用的分層結(jié)構(gòu)也使得代碼容易組織維護(hù)，各個獨(dú)立的層次分別針對特定的編程領(lǐng)域，在某個領(lǐng)域發(fā)生變化的時候，只需要在對應(yīng)層次進(jìn)行針對性的修改，而不會影響到其他層次的代碼。盡管現(xiàn)在有Mono計(jì)劃將所有的開發(fā)轉(zhuǎn)移到Linux，但是由于各種原因，Mono有著眾多的制肘，并不被業(yè)界看好?！耙淮尉帉?，隨處運(yùn)行”的可移植性使用戶可以專注于JSP的開發(fā)，而無須考慮系統(tǒng)層面的問題；Java的開放特性使市面上涌現(xiàn)出了眾多的Web框架可供采納；面向?qū)ο蟮脑O(shè)計(jì)，為更加輕松地構(gòu)筑安全穩(wěn)定的Web在線系統(tǒng)提供了基礎(chǔ)保障。具體結(jié)構(gòu)設(shè)計(jì)如下：（1）圖書類別信息表（t_catelog）圖書類別信息表主要用于存放圖書類別的信息，主要字段包括：ID，類別名稱，備注信息等。包括增加新的，刪除不符合規(guī)定的借閱，編輯現(xiàn)有的借閱信息。第一層是用戶登錄界面。4. 圖書借閱管理：管理員登陸系統(tǒng)后。功能一致性：完成同樣的功能應(yīng)該盡量使用同樣的元素。圖書館采取手工方式對圖書借閱情況進(jìn)行人工管理，由于信息比較多，圖書借閱信息的管理工作混亂而又復(fù)雜；一般借閱情況是記錄在借書證上，圖書的數(shù)目和內(nèi)容記錄在文件中，圖書館的工作人員和管理員也只是當(dāng)時對它比較清楚，時間一長，如再要進(jìn)行查詢，就得在眾多的資料中翻閱、查找了，造成查詢費(fèi)時、費(fèi)力。s performance history, in the design meets the question and the solution as well as enhance the current application procedure or the system development progress and the improvement operating performance. Each kind of objectoriented development kit which provides using it, first establishes the system application prototype in a short time, then, carries on the demand iteration to the initial prototype system, revises unceasingly and improves, until forms the user satisfied feasible system.This curriculum project 2000 databases develops this literature management system management system using the JSP development kits and SQL the Server. This system must solve the literature administration center must solve the question, may satisfy the literature management essential requirements, including increase, inquiry, management and so on three aspect functions. This system can act according to the user the demand, what facilitates quickly is the reader provides the service.KEY WORDS Literature management system Information management JSP II目 錄摘要 IAbstract II第1章 前言 1 課題背景 1 課題意義 1 文獻(xiàn)綜述 2 技術(shù)綜述 2 總體設(shè)計(jì)原則 2第2章 系統(tǒng)分析 4 系統(tǒng)的需求分析 4 業(yè)務(wù)流程分析 5 系統(tǒng)管理員業(yè)務(wù)流程分析 5 數(shù)據(jù)流程分析 7 圖書類別管理模塊 7 圖書管理模塊 7 讀者管理模塊 8 圖書借閱模塊 8 修改密碼模塊 9 數(shù)據(jù)字典 9 數(shù)據(jù)項(xiàng)的描述 9 數(shù)據(jù)流的描述 10第3章 系統(tǒng)設(shè)計(jì) 12 系統(tǒng)體系結(jié)構(gòu)設(shè)計(jì) 12 系統(tǒng)子模塊功能介紹 12 數(shù)據(jù)庫設(shè)計(jì) 13 數(shù)據(jù)庫概念設(shè)計(jì)——ER模型 13 數(shù)據(jù)庫邏輯設(shè)計(jì)——關(guān)系模型 14 數(shù)據(jù)庫選型 14 數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計(jì) 14 數(shù)據(jù)庫表間關(guān)系設(shè)計(jì) 16 系統(tǒng)開發(fā)工具與開發(fā)模式的選擇 17 系統(tǒng)開發(fā)工具 17 系統(tǒng)設(shè)計(jì)模式 19第4章 系統(tǒng)實(shí)現(xiàn) 21 21 圖書類別管理模塊 22 圖書管理模塊 23 讀者管理模塊 24 圖書借閱管理模塊 25第5章程序測試與調(diào)試 26 程序調(diào)試 26 程序的測試 26 測試的重要性及目的 26 測試的步驟 27 測試的主要內(nèi)容 27 28第6章 總結(jié) 29參 考 文 獻(xiàn) 30致 謝 31廣州大學(xué)華軟軟件學(xué)院軟件工程系 趙銳年 基于JSP+SQL的圖書管理系統(tǒng)的設(shè)計(jì)與開發(fā)第1章 前言 課題背景隨著社會的發(fā)展，人們對知識的需求也不斷地增長。該系統(tǒng)要解決的圖書管理所要解決的問題，可以滿足圖書管理基本要求，包括添加、管理等功能。圖書管理系統(tǒng)是典型的信息管理系統(tǒng)。s expansion, system39?？偟膩碚f，缺乏系統(tǒng)，規(guī)范的信息管理手段。針對性：本系統(tǒng)設(shè)計(jì)是針對圖書館管理的需求定向開發(fā)設(shè)計(jì)，所以具有專業(yè)突出和很強(qiáng)的針對性。 系統(tǒng)需求分析圖1. 圖書類別信息管理：作為一個社區(qū)的圖書館，涉及到的圖書是很多的，這就有必要對圖書進(jìn)行分門別類，這樣有利于對圖書的查詢和管理，管理員登陸系統(tǒng)后可以對圖書類別進(jìn)行添加，更新和刪除操作。系統(tǒng)可以查看圖書信息，并對其進(jìn)行查找或刪除等操作；查看讀者信息，對不符合系統(tǒng)規(guī)定的進(jìn)行刪除操作；添加圖書借閱信息，并對其進(jìn)行編輯或刪除等操作。（3）讀者管理模塊：主要功能是管理員登入后，維護(hù)讀者的信息。圖書類別信息（ID，類別名稱，備注信息）圖書信息（ID，名稱，出版社，出版日期，IS