基于J2EE網(wǎng)上書店管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)

1、supervision in large and medium goods vehicle. a is established large vehicles and small vehicles classification management of motor vehicle test mode, increased medium van car, and dangerous goods transport car, and school car test project; ii is established motor vehicle test regulatory platform,

2、achieved motor vehicle test full process video, and data remote regulatory; three is strictly motor vehicle identification management, equipped with unified of identification equipment and tool, using mobile identification terminal, and law enforcement records instrument, technology identification m

3、eans. as to 20xx years june 20 statewide motor vehicle keep volume for 567,408 car, and last year earlier than growth 75,814 car, growth 13.36%; this year january-june, vehicles management section and license archives management section total accepted the motor vehicle registration business 42,543 c

4、ar times, which registered registration 6,905 car times, and transfer registration 3,592 car times, and change registration 1033 car times, and mortgage registration 696 car times, and cancellation registration 187 car times, and into business 980 car times, and archives corrections 81 pieces times,

5、 and issued test qualified logo 25,429 car times, and other vehicles business 3,640 car times; supervision survey section relies on motor vehicle detection remote issued test qualified logo software platform supervision motor vehicle test, and identification situation 7418l liangci, investigation mo

6、tor vehicle exception business 30 car times, his pards business warning 244 article, vehicles and driving people sound video regulatory screenshots 1852 zhang, checks motor vehicle archives 716 pieces times, and medium bus, and medium above truck, and of hazardous chemicals, vehicles and school buse

7、s and other key vehicle inspection record of 420. (c) based on their own, and strict adherence to defense, more cheating, false false fugitive suspects, robbery suspect vehicles and the internet crackdown. dmv full play to the first line of defense position control, investigating cheating, fake iden

8、tification and robbery suspect vehicles through operational work, and carefully examine the documents and legal proof, check traffic violations, traffic accidents, the fugitive suspect suspected vehicles and theft than to work, further tight car, driving management business formalities review proced

9、ures. . truck driver information management platform. motor vehicles and traffic police departments, state transport authority to further clarify the division of labour, implementation responsibility, strengthen our collaboration and management together, reinforcing the management of drivers on whic

10、h strongly synthetic warfare and information warfare. 3 strictly implemented. from may 1 up, a is implemented complex road and bad weather driving exam, currently dmv is urged contractors party in treasures driving school increased simulation highway, and continuous urgent detours, and snow days, an

11、d wet sliding road, and burst situation disposal, subjects ii field to driving exam project, is expected基于j2ee網(wǎng)上書店管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)實(shí) 習(xí) 項(xiàng) 目 名 稱 ： 網(wǎng)上書店管理系統(tǒng) 學(xué) 生 姓 名（班學(xué)號(hào)） ： 指 導(dǎo) 教 師 ： 一、 需求說明1任務(wù)概述1.1目標(biāo)當(dāng)今社會(huì),隨著計(jì)算機(jī)的應(yīng)用和internet的普及, internet網(wǎng)絡(luò)給人類社會(huì)帶來了巨大變化,網(wǎng)絡(luò)在我們的生活中幾乎無處不在。因此,建立網(wǎng)上電子書店的銷售管理系統(tǒng)是時(shí)代的潮流。由于jsp可以在85%以上的服務(wù)器上運(yùn)行

12、,而且jsp技術(shù)的應(yīng)用程序比asp的應(yīng)用程序易于維護(hù)和管理。所以,通過采用jsp技術(shù)設(shè)計(jì)開發(fā)在線書店系統(tǒng)符合時(shí)代的潮流、具有積極的進(jìn)步意義。本人基于這樣的實(shí)際需求,結(jié)合教學(xué)需要設(shè)計(jì)開發(fā)了基于jsp的網(wǎng)上書店銷售管理系統(tǒng)。網(wǎng)上書店系統(tǒng)可以實(shí)現(xiàn)人們遠(yuǎn)程逛逛書店和購買圖書的愿望。本系統(tǒng)主的功能是實(shí)現(xiàn)網(wǎng)上購書?；竟δ馨ㄓ脩糇?cè)、會(huì)員登錄、圖書查詢、新書介紹、網(wǎng)上購書以及后臺(tái)管理等。1.2用戶特點(diǎn)用戶須具備一定的計(jì)算機(jī)知識(shí)、網(wǎng)絡(luò)知識(shí)。懂得如何操作電腦，了解java 2ee,會(huì)配置sql server數(shù)據(jù)庫，會(huì)添加數(shù)據(jù)源。1.3定義jsp技術(shù)：jsp（java server pages）技術(shù)是由sun

13、公司發(fā)布的用于開發(fā)動(dòng)態(tài)web應(yīng)用的一項(xiàng)技術(shù)。它以其簡(jiǎn)單易學(xué)、跨平臺(tái)的特性，在眾多動(dòng)態(tài)web應(yīng)用程序設(shè)計(jì)語言中異軍突起，在短短幾年中已經(jīng)形成了一套完整的規(guī)范，并廣泛地應(yīng)用于電子商務(wù)等各個(gè)領(lǐng)域中。在國內(nèi)，jsp現(xiàn)在也得到了比較廣泛的重視，得到了很好的發(fā)展，越來越多的動(dòng)態(tài)網(wǎng)站開始采用jsp技術(shù)。本章就對(duì)jsp及其相關(guān)技術(shù)進(jìn)行簡(jiǎn)單的介紹。javaserver pagestm (jsp(sun企業(yè)級(jí)應(yīng)用的首選)技術(shù)為創(chuàng)建顯示動(dòng)態(tài)生成內(nèi)容的web頁面提供了一個(gè)簡(jiǎn)捷而快速的方法。jsp(sun企業(yè)級(jí)應(yīng)用的首選)技術(shù)的設(shè)計(jì)目的是使得構(gòu)造基于web的應(yīng)用程序更加容易和快捷，而這些應(yīng)用程序能夠與各種web服務(wù)器，

14、應(yīng)用服務(wù)器，瀏覽器和開發(fā)工具共同工作。sql server ：sql server 2000 是microsoft 公司推出的sql server 數(shù)據(jù)庫管理系統(tǒng)的最新版本該版本繼承了sql server 7.0 版本的優(yōu)點(diǎn)同時(shí)又比它增加了許多更先進(jìn)的功能具有使用方便可伸縮性好與相關(guān)軟件集成程度高等優(yōu)點(diǎn)可跨越從運(yùn)行microsoft windows 98 的膝上型電腦到運(yùn)行microsoft windows 2000 的大型多處理器的服務(wù)器等多種平臺(tái)使用。sqlserver2000界面友好，易學(xué)易用且功能強(qiáng)大，與windows2000操作系統(tǒng)完美結(jié)合，可以構(gòu)造網(wǎng)絡(luò)環(huán)境數(shù)據(jù)庫甚至分布式數(shù)據(jù)庫，可

15、以滿足企業(yè)及intemet等大型數(shù)據(jù)庫應(yīng)用。java bean：javabean是描述java的軟件組件模型，有點(diǎn)類似于microsoft的com組件概念。在java模型中，通過javabean可以無限擴(kuò)充java程序的功能，通過javabean的組合可以快速的生成新的應(yīng)用程序。對(duì)于程序員來說，最好的一點(diǎn)就是javabean可以實(shí)現(xiàn)代碼的重復(fù)利用，另外對(duì)于程序的易維護(hù)性等等也有很重大的意義。比如說一個(gè)購物車程序，要實(shí)現(xiàn)購物車中添加一件商品這樣的功能，就可以寫一個(gè)購物車操作的javabean，建立一個(gè)public的additem成員方法，前臺(tái)jsp文件里面直接調(diào)用這個(gè)方法來實(shí)現(xiàn)。如果后來又考慮添

16、加商品的時(shí)候需要判斷庫存是否有貨物，沒有貨物不得購買，在這個(gè)時(shí)候我們就可以直接修改javabean的additem方法，加入處理語句來實(shí)現(xiàn)，這樣就完全不用修改前臺(tái)jsp程序了。javascript：javascript是用于瀏覽器的第一種具有通用目的、動(dòng)態(tài)的客戶端腳本語言。netscape于1995年首先提出了javascript，但當(dāng)時(shí)將其稱為livescript。后來netscape迅速地將livescript改名為javascript，java的開發(fā)商sun與他們?cè)谕荒臧l(fā)表了一項(xiàng)聲明。聲明中指出java和javascript將互相補(bǔ)充，但它們是截然不同的技術(shù)，這樣才打消了很多人對(duì)這兩項(xiàng)

17、技術(shù)的錯(cuò)誤理解。javascript為創(chuàng)建用戶界面控件提供了一種腳本語言。事實(shí)上，javascript在瀏覽器中插入了代碼邏輯。它可以支持這樣的效果：當(dāng)光標(biāo)在web頁的某個(gè)位置移動(dòng)時(shí)驗(yàn)證用戶輸入或者變換圖像。microsoft也編寫出了自己的javascript版本并將其稱為jscript。microsoft和netscape都支持一種圍繞javascript和jscript的核心特性并由（european computer manufacturers association，ecma）標(biāo)準(zhǔn)組織控制的腳本語言標(biāo)準(zhǔn)。ecma將其腳本語言命名為ecmascript。2數(shù)據(jù)描述參與系統(tǒng)的實(shí)體有：管理

18、員、顧客、圖書、銀行卡。(1):管理員和顧客有以下屬性： 用戶名、帳號(hào)、密碼 (2):圖書有以下屬性： 書名、作者、出版社、價(jià)格、類型、簡(jiǎn)介（3）銀行卡有以下屬性： 卡號(hào)、密碼、姓名（4）訂單表用戶名、購買書名、數(shù)量實(shí)體關(guān)系圖為：管理員用戶名賬號(hào)密碼管理銀行卡圖書卡號(hào)密碼姓名書簡(jiǎn)介出版社書名作者價(jià)格種類 管理員管理e-r圖顧客銀行卡使用圖書購買出版社書店作者價(jià)格種類卡號(hào)密碼姓名數(shù)量優(yōu)惠額度書簡(jiǎn)介 銀行卡-顧客-圖書e-r圖2.3數(shù)據(jù)庫介紹本項(xiàng)目使用的數(shù)據(jù)庫sql server 2000， 它是一個(gè)關(guān)系數(shù)據(jù)庫管理系統(tǒng)，是microsoft 公司推出的sql server 數(shù)據(jù)庫管理系統(tǒng)的最新版本

19、該版本繼承了sql server 7.0 版本的優(yōu)點(diǎn)同時(shí)又比它增加了許多更先進(jìn)的功能具有使用方便可伸縮性好與相關(guān)軟件集成程度高等優(yōu)點(diǎn)可跨越從運(yùn)行microsoft windows 98 的膝上型電腦到運(yùn)行microsoft windows 2000 的大型多處理器的服務(wù)器等多種平臺(tái)使用。數(shù)據(jù)庫設(shè)計(jì)：本數(shù)據(jù)庫一共包含四個(gè)表（書目表、用戶信息表、銀行卡、訂單表）。書目表：包含書名、作者、出版社、價(jià)格類型、本書簡(jiǎn)介。用戶信息表：包含用戶名、密碼。銀行卡表：包含卡號(hào)、密碼、姓名。訂單表：包含用戶名、購買書名、數(shù)量。3功能需求功能輸入變量處理過程輸出結(jié)果瀏覽首頁無直接運(yùn)行書店的首界面查找書籍書名或作者或

20、出版社查找數(shù)據(jù)庫書籍信息網(wǎng)上購書訂單網(wǎng)上交易購買成功注冊(cè)用戶名、密碼查找并寫入數(shù)據(jù)庫注冊(cè)結(jié)果會(huì)員登陸用戶名、密碼身份認(rèn)證登陸成功（失?。诸惞芾頃?、信息。書類型按類型歸類書籍按類別存放訂單管理用戶訂單對(duì)訂單進(jìn)行審核通過網(wǎng)上交易訂單、錢、用戶名審核賬目交易成功總體結(jié)構(gòu)開始網(wǎng)站首頁匿名用戶注冊(cè)用戶登陸后經(jīng)權(quán)限判斷普通用戶系統(tǒng)管理員查找書籍網(wǎng)上購書網(wǎng)上注冊(cè)書籍分類修改書籍分類修改書籍分類添加新書管理用戶管理交易查看訂單瀏覽分類查找書籍3.1功能劃分模塊分模塊模塊功能網(wǎng)上書店管理系統(tǒng)前臺(tái)閱讀匿名用戶書店首頁查找書籍網(wǎng)上注冊(cè)網(wǎng)上購書后臺(tái)管理管理員登錄身份確認(rèn)書籍管理書籍分類修改分類添加新書修改書籍

21、信息訂單管理審核訂單網(wǎng)上交易總體數(shù)據(jù)流圖：開始書店首界面選擇書店概況網(wǎng)上購書書籍信息查詢會(huì)員登陸注冊(cè)返回首頁買書流程圖：買書使用網(wǎng)上銀行付款現(xiàn)金支付網(wǎng)上支付修改數(shù)據(jù)庫成功下訂單4性能需求4.1數(shù)據(jù)精確度注冊(cè)時(shí)，輸入用戶名后，輸入密碼，再次確認(rèn)密碼，點(diǎn)擊“注冊(cè)”，如果用戶名已經(jīng)存在則不能注冊(cè)，反之注冊(cè)成為會(huì)員，輸出注冊(cè)失敗或者注冊(cè)成功。登錄時(shí)，輸入用戶名和密碼，經(jīng)過驗(yàn)證，如果正確則成功登錄。查找書籍時(shí)，輸入書名，查找數(shù)據(jù)庫后輸出書籍的信息。在購書時(shí)，所購買書的數(shù)量必須大于零，小于這本書的總量，點(diǎn)擊“確定”后，輸出購書訂單。付款時(shí)，錢數(shù)精確到分即小數(shù)點(diǎn)后兩位，經(jīng)過審核，輸出交易成功。4.2 適應(yīng)性

22、 javabeans 通過提供符合一致性設(shè)計(jì)模式的公共方法將內(nèi)部域暴露稱為屬性。眾所周知，屬性名稱符合這種模式，其他java 類可以通過自省機(jī)制發(fā)現(xiàn)和操作這些javabean 屬性。用戶可以使用javabean將功能、處理、值、數(shù)據(jù)庫訪問和其他任何可以用java代碼創(chuàng)造的對(duì)象進(jìn)行打包，并且其他的開發(fā)者可以通過內(nèi)部的jsp頁面、servlet、其他javabean、applet程序或者應(yīng)用來使用這些對(duì)象。用戶可以認(rèn)為javabean提供了一種隨時(shí)隨地的復(fù)制和粘貼的功能，而不用關(guān)心任何改變。當(dāng)操作方式發(fā)生變化時(shí)，一些功能同樣能夠?qū)崿F(xiàn)。因?yàn)樵趯?shí)現(xiàn)各項(xiàng)功能時(shí)，把功能劃分成了模塊，各模塊之間互不干擾，而

23、且java bean都采用類的形式，每個(gè)功能都封裝成一個(gè)類。運(yùn)行環(huán)境發(fā)生變化時(shí)，對(duì)程序會(huì)有一些影響，但打上補(bǔ)丁就可以繼續(xù)運(yùn)行了。總體上講，本系統(tǒng)具有一定的自適應(yīng)性。5運(yùn)行需求5.1用戶界面用戶主界面：搜索查詢書籍界面：會(huì)員登錄界面顧客注冊(cè)界面：管理員登錄界面： 購書界面： 購書之后顯示的訂單信息：5.2硬件接口本系統(tǒng)可在一般的windows x86操作系統(tǒng)上運(yùn)行，也可在linx上運(yùn)行。但需要安裝java bean，并且要安裝sql server數(shù)據(jù)庫，才能運(yùn)行程序。在進(jìn)行登錄、查詢時(shí)，如果數(shù)據(jù)庫不是sql server 2005 還需要添加驅(qū)動(dòng)器三個(gè)jar文件。數(shù)據(jù)庫附加好了，就可運(yùn)行。5.3

24、軟件接口系統(tǒng)包括網(wǎng)上購書、書籍查詢、會(huì)員登錄、用戶注冊(cè)、查看訂單、后臺(tái)管理這些模塊之間的接口。各個(gè)模塊之間有自成一個(gè)小的程序，功能封裝成了類，使用對(duì)象調(diào)用。類中成員函數(shù)的參數(shù)是傳遞值的接口。5.4故障處理 當(dāng)系統(tǒng)遇到問題時(shí)，首先查看運(yùn)行環(huán)境是否更該；如更改，只需修復(fù)運(yùn)行環(huán)境即可，若未更改，查看系統(tǒng)中各功能模塊之間的接口是否有問題，可通過調(diào)試改正錯(cuò)誤。數(shù)據(jù)庫最嚴(yán)重的問題莫過于數(shù)據(jù)庫損壞，那么當(dāng)數(shù)據(jù)庫損壞時(shí)，最好的辦法是從備份恢復(fù)數(shù)據(jù)庫。由于存儲(chǔ)問題導(dǎo)致部分?jǐn)?shù)據(jù)文件損壞，但是數(shù)據(jù)庫還可以連接，這種情況可以采用導(dǎo)出數(shù)據(jù)庫的表結(jié)果和數(shù)據(jù)的方法來恢復(fù)數(shù)據(jù)庫。當(dāng)然對(duì)損壞的表，導(dǎo)出是無法完成的，這是可以使用

25、db2dart的導(dǎo)出數(shù)據(jù)功能來導(dǎo)出這些損壞的表的數(shù)據(jù)。解決數(shù)據(jù)庫的性能問題，可以從以下方面入手，檢查數(shù)據(jù)庫的配置，如緩沖池，排序堆等是否合理；檢查數(shù)據(jù)庫是否收集過統(tǒng)計(jì)信息，準(zhǔn)確的統(tǒng)計(jì)信息對(duì)語句優(yōu)化起著重要的左右；對(duì)sql語句進(jìn)行優(yōu)化；查看是否有系統(tǒng)資源瓶頸。6其它需求java bean是java類，屬于某些特定的譯碼知道方針，并且擴(kuò)展了適應(yīng)性和范圍，允許用戶訪問內(nèi)部的屬性和方法。在ide中，javabean的功能允許應(yīng)用開發(fā)者瀏覽其中的方法，即使javabean是被編譯的，并且無法利用原始的源文件。 在安裝了java bean和sql server數(shù)據(jù)庫時(shí)可運(yùn)行該程序。本系統(tǒng)不僅能運(yùn)行在win

26、dows x86上，還能在linx上運(yùn)行，具有可移植性。程序較安全，高級(jí)管理員要保密，不對(duì)其他人泄露登錄密碼。程序在開發(fā)時(shí)，結(jié)構(gòu)是可擴(kuò)展的，后期可擴(kuò)展功能。to september end of qian by standard completed transformation; ii is implemented on medium van car actual road driving exam qualified hou, increased security civilization driving common sense exam, carried out new driving

27、people led card qian education and led card hou visit; three is implemented driving people exam full process real-time regulatory, is contact subjects three exam system production manufacturers, is expected to september end of qian in exam car shang added loaded for exam students of camera, complete

28、d subjects three video, and audio monitoring; four is implementation driving training quality full process regulatory, statewide 15 home driving training institutions car class driving people training has all application computer timing training management system, fingerprint recognition system is i

29、mplementation, is expected to october 1 qian completed installation. exists problem: recalled first half of of work, vehicles management although made has must of results, but and superior led of high standards, and strict requirements also has gap, away from social and people increasingly growth of

30、 service requirements also has insufficient, away from constantly new of car tube work also has many does not apply echo urgently solution of problem: main performance in: a is with i state urban and rural political, and economic, and culture of constantly prosperity development, driving people keep

31、 volume growth of momentum increased, third quarter, will and ushered in driving people training exam work of and a unprecedented of peak, driving people exam work will faced new of pressure and challenge; ii is vehicles high-speed growth situation still will keep more long period, motor vehicle kee

32、p volume growth 13.36%, driving people keep volume growth 9.35%, led to this year motor vehicle keep volume 567,408 car is greater than driving people keep volume 565xx6 people of not reasonable phenomenon, vehicles management work faced of situation will more severe; three is complex changeable of

33、social environment and public opinion power, to police vehicles management work brings new test, current society public opinion is complex, to network for focus of opinion supervision power constantly grow, effect increasingly wide, in management service and actual law enforcement in the slightly no

34、t note on will caused social and media concern, was internet focused or zoom, quickly formed social hot, even evolution into involved method involved police event; four is team itself quality capacity, in severe of situation before exposure show many of gap and problem, main reflected in: implement

35、implementation than shi, work responsibility not in place, work style is not pragmatic, aroused great attention. second half of the work plan: bridgehead wenshan high prospect of construction of inspiring, the dmv will be poised, firmly grasp the top two strategic opportunities, combined with the et

36、hnic minority regions, and firmly establish the concept of people-oriented, law enforcement for the people, adhere to the style of truth, excellence, always adhering to17二、主要程序清單（關(guān)鍵代碼） /書籍信息類public class book string bookname; string bookauthor; string publisher; string bookprice; string booktype; st

37、ring bookinfo; int quantity; public dblink link=new dblink(); public book(string name) connection conn=link.linkdb(); resultset res = null; string sql= select * from booksys where bookname = +name+; try statement sm = conn.createstatement(); res = sm.executequery(sql); res.next(); bookname=res.getst

38、ring(bookname); system.out.println(bookname); bookauthor=res.getstring(bookauthor); system.out.println(bookauthor); bookprice=res.getstring(bookprice); system.out.println(bookprice); quantity=1; res.close(); catch (sqlexception sqle) sqle.printstacktrace(); /連接數(shù)據(jù)庫的類import java.sql.*;public class dbl

39、ink public connection linkdb( ) connection connection = null; string url = jdbc:microsoft:sqlserver:/localhost:1433;databasename=news; try class.forname(com.microsoft.jdbc.sqlserver.sqlserverdriver); catch(exception e) e.printstacktrace(); try connection = drivermanager.getconnection(url, sa, ); catch