學(xué)生姓名:蔣斌指導(dǎo)老師：羅永紅摘要本課程設(shè)計主要是設(shè)計一個書店信息管理的系統(tǒng)，實現(xiàn)用戶的注冊、登加、刪除、修改、查詢及圖書的購買等功能。程序設(shè)計平臺初步實現(xiàn)了目標(biāo)。TheDesignandImplementationofnformationagementSystemNameJiangBinAdvisorLuoYonghongAbstractThiscoursedesignismainlytomakeainformationmanagementsystemofaonlinebookstore,Thefunctionofthesystemincludebook’adding,deletingandqueryingandpurchasebooks.ProgramdesignplatformisWindowsXP,programminglanguageisJAVA,aretheconnecteddatabaseisOracle10g.Intheprogramprocess,Iadoptedtwosolutionofthestructuredandobject-oriented.Programrunthroughthedebugger,achievingtheinitialgoal.KeywordsDatabase;oracle10g;JAVA;OnlineBookstoreInformationManagement目錄 1.1課題背景 11.2課程設(shè)計目的 1 結(jié)構(gòu)分析 22.1需求分析 22.2功能模塊圖 3 3.1概念結(jié)構(gòu)設(shè)計 4 實現(xiàn) 10 4.2登錄界面 11 4.5書籍修改 134.6圖書刪除 144.7圖書刪除 144.8訂單查詢修改 15 19特別重要。因此網(wǎng)上書店的出現(xiàn)成為必然。統(tǒng)，以達到上述的目的。管理，修改管理，查詢管理。登錄，客戶的購書等。與開發(fā)，采用Eclipse和oracle10g等軟件為開發(fā)工具。通過對計算機硬件和軟開發(fā)實踐。在指導(dǎo)老師的幫助下，已經(jīng)基本上成功地實現(xiàn)了設(shè)計任務(wù)書的要求，使得設(shè)計的數(shù)據(jù)庫系統(tǒng)能夠?qū)崿F(xiàn)一般數(shù)據(jù)庫的管理。構(gòu)分析需求分析發(fā)設(shè)計的。通過對書籍信息管理，使客戶能輕松購買書籍。經(jīng)過綜合分析，確定了網(wǎng)上書店信息管理系統(tǒng)的主要包括以下功能：(1)商家：此模塊的主要功能是用于商家注冊賬號；此模塊的主要功能是用于擁有商家賬號的用戶登陸系統(tǒng)對自己的書店進行管理；此模塊的主要功能是用于商家發(fā)布一些新書共客戶查看及購買；此模塊的主要功能是用于商家修改自己書店書籍的信息；此模塊的主要功能是用于商家刪除一些書籍信息；此模塊的主要功能是用于商家查詢自己書店的書籍；此模塊的主要功能是用于商家查詢自己書店賣書的記錄；(2)客戶：此模塊的主要功能是用于商家注冊賬號；此模塊的主要功能是對擁有客戶賬號的用戶登錄；此模塊的主要功能是用于客戶查看所有商家的書籍信息；商家注冊登錄書籍查詢書籍上傳書籍修改書籍刪除訂單查詢客戶注冊登錄書籍查詢購買書籍訂單查詢商家注冊登錄書籍查詢書籍上傳書籍修改書籍刪除訂單查詢客戶注冊登錄書籍查詢購買書籍訂單查詢能用于客戶購買書籍此模塊的主要功能是用于客戶查詢自己的購書記錄；能模塊圖上述的功能，可以設(shè)計出系統(tǒng)的總體功能模塊，如圖2.1所示,息管理系統(tǒng) buyer_id庫設(shè)計概念結(jié)構(gòu)設(shè)計得該系統(tǒng)的E-R圖,ER所示, pwdaddressbuyer_namebuyer_namebuyer pwdaddressamidamidumdd pricediscountnumyeridER得到總E-R圖，如圖3.5所示。邏輯結(jié)構(gòu)設(shè)計根據(jù)上述的概念結(jié)構(gòu)設(shè)計出邏輯結(jié)構(gòu)，將E-R圖轉(zhuǎn)換為關(guān)系模型。r(1)商家信息表seller所示，varchar20)varchar20)pwdvarchar20)書店地址varchar200)所示，buyer_idvarchar20)buyer_namevarchar20)pwdvarchar20)客戶住址varchar200)3-3所示，sidvarchar0)namevarchar0)price價格tum訂單信息表order用來保存訂單號、書籍編名等信息。表order的結(jié)構(gòu)如表3-4所示，idsidvarchar0)varchar0)buyer_idum量數(shù)據(jù)庫表的建立據(jù)tablesellerlleridvarcharprimarykeyernamevarcharpwdvarchar2(20),dressvarchartablebuyerbuyer_idvarchar(20)primarykey,buyer_namevarchar(20),pwdvarchar2(20),ressvarcharetablegoodsodsidintprimarykeyridvarcharoodsnamevarcharpriceint,ntintnumintconstraintfkselleridforeignkeyselleridreferencesseller(seller_id)tableorderseridintprimarykeydsidintridvarcharbuyer_idvarchar(20),numintconstraintfkgoodsidforeignkeygoodsidreferencesgoods(goods_id),constraintfksellersidforeignkeyselleridreferencesseller(seller_id),constraintfkbuyeridforeignkeybuyeridreferencesbuyer(buyer_id)該程序?qū)崿F(xiàn)了網(wǎng)上書店信息管理系統(tǒng)應(yīng)有的功能，即賬號注冊、登錄功能、書籍查詢、書籍添加、書籍刪除、書籍修改、書籍購買功能。界面成功，如圖4.1所示，圖4.1注冊界面實現(xiàn)注冊功能的核心代碼如下：/構(gòu)建客戶對象BuyerbuyernewBuyer();/設(shè)置客戶的信息buyer.setId(fieldCus0.getText());buyer.setName(fieldCus1.getText());buyer.setPwd(fieldCus2.getText());buyer.setAddress(fieldCus3.getText());/構(gòu)建BuyerDao對象BuyerDaodaonewBuyerDao();/把該客戶插入到數(shù)據(jù)庫中錄界面成功，如圖4.2所示，圖4.2登錄界面功時，進入主界面，實現(xiàn)登錄功能的核心代碼如下：/通過輸入姓名和密碼獲取一個用戶對象SellersellerSellerDaogetSelleruseNameTextgetTextpwsgetText));/判斷隊形是否為空/隱藏當(dāng)前窗口blefalse/構(gòu)建用戶主窗口，并顯示出來newSellerFramesetVisibletrue界面登錄成功后商家和客戶分別進入兩個不同的主界面，如圖4.3所示，圖4.3主界面圖4.3主界面界面主界面里面商家可以查看到自己的商品信息及商品出售后生成的訂單信息，客戶則可以瀏覽所有商家的商品信息和自己的購物記錄。添加圖4.4書籍添加界面心代碼如下：/構(gòu)建GoodsDao對象GoodsDaodaonewGoodsDao;/設(shè)置goods的屬性goodssetDiscountIntegervalueOffieldDiscountgetText)));goodssetNamefieldNamegetText;goodssetNumIntegervalueOffieldNumgetText)));goodssetPriceIntegervalueOffieldPricegetText)));//調(diào)用dao.insertGoods()方法，把商品插入到數(shù)據(jù)庫中insertGoodsgoods籍修改要用于商家修改自己的書籍的信息，如圖4.5所示，圖4.4書籍修改界面以對商品進行修改，實現(xiàn)修改功能的核心代碼如下：odsDaoGoodsDaodaonewGoodsDao;/讀取對應(yīng)文本框的信息并設(shè)置到goods里面goodssetDiscountIntegervalueOffieldDiscountgetText)));goodssetNamefieldNamegetText;goodssetNumIntegervalueOffieldNumgetText)));goodssetPriceIntegervalueOffieldPricegetText)));/修改goods信息updateGoodsgoods6圖書刪除要用于商家對書籍進行刪除操作，如圖4.6所示，圖4.6書籍刪除界面當(dāng)商家往文本框里輸入書籍編號后，點擊刪除，則可以對書籍進行刪除，下：/獲取文本框中輸入的書籍編號intidIntegerparseInt(field.getText());/構(gòu)建GoodsDaoGoodsDaodaonewGoodsDao;/調(diào)用//調(diào)用deleteById方法，刪除書籍eleteByIdid7圖書刪除要用于客戶購買書籍，如圖4.7所示，圖4.7圖書購買現(xiàn)客戶對書籍的購買。如果書籍編號錯誤或商品數(shù)量不夠時，系統(tǒng)會彈出提示，實現(xiàn)購書功能的核心代碼如下：/構(gòu)建GoodsDao對象GoodsDaodaonewGoodsDao;/構(gòu)建goods對象GoodsgoodsnewGoods;/減少庫存數(shù)量goodssetNumgoodsgetNumnum);/修改商品信息updateGoodsgoods/構(gòu)建訂單對象OrderDaoordernewOrderDao;/插入一條訂單數(shù)據(jù)rderinserOerderByGoodsgoodsnum訂單查詢修改要用于客戶查看生成的訂單，如圖4.8所示，序設(shè)計語言，它繼承了C++語言面向?qū)ο蠹夹g(shù)的核心，Java舍棄了C++語言中容易引起錯誤的指針(以引用取代)、運算符重載(operatoroverloading)、多重繼承(以接口取代)等特性，增加了垃圾回收器功能用于回收不再被引用的對象所占據(jù)的內(nèi)存空間，使得程序員不用再為內(nèi)存管理而擔(dān)憂。在JavaSE1.5版本中，Java又引入了泛型編程(GenericProgramming)、類型安全的枚舉、不定長參數(shù)和自動裝/拆箱等語言特性。代碼編譯成二進制字節(jié)碼(bytecode)，然后依賴各種不同平臺上的虛擬機來解釋執(zhí)行字節(jié)碼，從而實現(xiàn)了“一次編譯、到處執(zhí)行”的跨平臺特性[2]。leOracle數(shù)據(jù)庫包括Oracle數(shù)據(jù)庫服務(wù)器和客戶端。Oracle數(shù)據(jù)庫服務(wù)器：OracleServer是一個對象一關(guān)系數(shù)據(jù)庫管理系統(tǒng)。它提供開放的、全面的、和集成的信息管理方法。每個Server由一個OracleDB和一個OracleServer實例組成。它具有場地自治性(SiteAutonomy)和提供數(shù)據(jù)存儲透明機制，以此可實現(xiàn)數(shù)據(jù)存儲透明性。每個Oracle數(shù)據(jù)庫對應(yīng)唯一的一個實例名SID，Oracle數(shù)據(jù)庫服務(wù)器啟動后，一般至少有以下幾個用戶：Internal，它不是一個真實的用戶名，而是具有務(wù)，包括啟動和關(guān)閉數(shù)據(jù)庫；Sys，它是一個DBA用戶名，具有最大的數(shù)據(jù)庫System一個DBA用戶名，權(quán)限僅次于Sys用戶。客戶端：必須連接到一服務(wù)器，該數(shù)據(jù)庫稱為本地數(shù)據(jù)庫(LocalDB)。在網(wǎng)絡(luò)環(huán)境下其它服務(wù)器上的DB稱為遠程數(shù)據(jù)庫(RemoteDB)。用戶要存取遠程DB上的數(shù)據(jù)時，必須建立數(shù)據(jù)庫鏈。Oracle結(jié)構(gòu)。由于它們是相分離的，所以在管理數(shù)據(jù)的物理存儲結(jié)構(gòu)時并不會影響對邏輯存儲結(jié)構(gòu)的存取。存儲結(jié)構(gòu)模式對象是直接引用數(shù)據(jù)庫數(shù)據(jù)的邏輯結(jié)構(gòu)。模式對象包括這樣一些結(jié)構(gòu)：表、表關(guān)系形成了數(shù)據(jù)庫的關(guān)系設(shè)計。數(shù)據(jù)塊(Block)：是數(shù)據(jù)庫進行UO操作的最小單位，它與操作系統(tǒng)的塊不Oracle數(shù)據(jù)庫塊為單位。段(Segment)：是表空間中一個指定類型的邏輯存儲結(jié)構(gòu)，它由一個或多個范圍組成，段將占用并增長存儲空間。其中包括：數(shù)據(jù)段：用來存放表數(shù)據(jù)；索引段：用來存放表索引；用來存放中間結(jié)果；回滾段：用于出現(xiàn)異常時，恢復(fù)事務(wù)。范圍(Extent)：是數(shù)據(jù)庫存儲空間分配的邏輯單位，一個范圍由許多連續(xù)范圍[3]。一步學(xué)習(xí)了Java的基礎(chǔ)語法以及熟悉了用Java編次再去做類似的東西我覺得我一定會做的更好。[1]薩師煊，王珊.數(shù)據(jù)庫系統(tǒng)概論(第三版)[M].北京：高等教育出版社.YDanielLiangJavaM北京：機械工業(yè)出版社.2006.[3]夏幫貴，劉凡馨.JDBCAP數(shù)據(jù)庫編程實材作教.北京：北京希望電子出版2001.[4]王立福.軟件工程(第二版)[M].北京：北京大學(xué)出版社.2002.附錄全部源代碼packagecom.shoeShop.db;ortjavasqlConnectionortjavasqlDriverManagerortjavasqlSQLExceptionpublicclassConnect{privatestaticConnectioncon=null;privatestaticStringurl="jdbc:oracle:thin:@localhost:1521:ORCL";privatestaticStringdriver="oracle.jdbc.driver.OracleDriver";privatestaticStringuser="scott";privatestaticStringpwd="tiger";publicstaticConnectiongetConnection(){try{forNamedriverconDriverManagergetConnectionurluserpwd);}catch(ClassNotFoundExceptione){}catch(SQLExceptione){}returncon;}publicstaticvoidmain(String[]args){ctgetConnection}}packagecom.shoeShop.action;portjavaawteventActionEventportjavaawteventActionListenerortjavaxswingJPanelportcomshoeShopviewRegisterFramepublicclassdocMenuActionimplementsActionListener{RegisterFrameregisternullJPanelcusPanelnullJPaneldocPanelnullpublicdocMenuAction(RegisterFrameregister){thisregisterregister;thiscusPanel=register.cusPanel;thisdocPanelregister.docPanel;}publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstubregister.flag=1;//System.out.println(register.flag);registerremovecusPanel);registeradddocPanel);anelupdateUI}}packagecom.shoeShop.dao;ortjavasqlConnectionortjavasqlResultSetortjavasqlSQLExceptionortjavasqlStatementportcomshoeShopdbConnectportcomshoeShopentityBuyerportcomshoeShopentitySellerpublicclassBuyerDao{privatestaticConnectionconn;privatestaticStatementstatement;privatestaticResultSetresultSet;/插入數(shù)據(jù)，用于注冊publicintinsertBuyer(Buyerbuyer){intflag0;nnConnectgetConnectiontry{mentconncreateStatementStringsql="insertintobuyervalues+buyer.getId()+"','"+buyer.getName()+"','"+buyer.getPwd()+"','"+buyer.getAddress+"')";System.out.println("buyer"+sql);gstatementexecuteUpdatesqlntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}System.out.println(flag);returnflag}/通過用戶名和密碼查詢，用于登錄publicstaticBuyergetBuyer(Stringname,Stringpwd){nnConnectgetConnectionBuyerbuyernewBuyer();try{mentconncreateStatementStringsql="select*frombuyerwherebuyer_id='"+name+"'andpwd=dresultSetstatement.executeQuery(sql);whileresultSetnext()){buyer.setId(resultSet.getString("buyer_id"));buyer.setName(resultSet.getString("buyer_name"));buyer.setPwd(resultSet.getString("pwd"));buyer.setAddress(resultSet.getString("address"));}resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}returnbuyer}publicstaticvoidmain(String[]args){BuyerDaodaonewBuyerDao();SystemoutprintlndaogetBuyerzxk1"));////BuyerbuyernewBuyer();buyer.setId("lily");//buyer.setName("長理專賣");//buyer.setPwd("123456");//buyer.setAddress("湖南長沙");//dao.insertBuyer(buyer);}}packagecom.shoeShop.dao;ortjavasqlConnectionortjavasqlResultSetortjavasqlSQLExceptionortjavasqlStatementortjavautilArrayListportcomshoeShopdbConnectportcomshoeShopentityGoodsportcomshoeShopentitySellerportcomshoeShopimpUserpublicclassGoodsDao{privatestaticConnectionconn;privatestaticStatementstatement;privatestaticResultSetresultSet;/查詢登錄商家的所有商品，用于商家管理自己的商品publicArrayListgetAllGoods(){ArrayListlist=newArrayList();nnConnectgetConnectiontry{mentconncreateStatementStringsql="select*fromgoodsa,sellerbwherea.seller_id=b.seller_idandbselleridUsergetUserName)+"'";resultSetstatement.executeQuery(sql);whileresultSetnext()){sellernewSellerllersetNameresultSetgetStringsellernamelersetAddressresultSetgetStringaddressoodsgoodsnewGoodsssetSellersellergoodssetIdresultSetgetIntgoodsid));goodssetNameresultSetgetStringgoodsname);goodssetSelleridresultSetgetStringsellerid));goodssetDiscountresultSetgetIntdiscount;goodssetNumresultSetgetIntnum;goodssetPriceresultSetgetIntprice;//tprintlngoodstoStringtaddgoods}}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnlist}/查詢所有商家的所有商品.用于用戶搜索商品publicArrayListgetAllSellerGoods(){ArrayListlist=newArrayList();nnConnectgetConnectiontry{mentconncreateStatementStringsql="select*fromgoodsa,sellerbwhereelleridbselleridresultSetstatement.executeQuery(sql);whileresultSetnext()){sellernewSellerllersetNameresultSetgetStringsellernamelersetAddressresultSetgetStringaddressoodsgoodsnewGoodsssetSellersellergoodssetIdresultSetgetIntgoodsid));goodssetNameresultSetgetStringgoodsname);goodssetSelleridresultSetgetStringsellerid));goodssetDiscountresultSetgetIntdiscount;goodssetNumresultSetgetIntnum;goodssetPriceresultSetgetIntprice;//}tprintlngoodstoStringtaddgoods}}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnlist/根據(jù)商品號查詢商品信息publicGoodsgetOneGoods(intid){oodsgoodsnewGoodsnnConnectgetConnectiontry{mentconncreateStatementStringsqlselectfromgoodswheregoodsid+id;resultSetstatement.executeQuery(sql);whileresultSetnext()){dssetIdidgoodssetNameresultSetgetStringgoodsname);goodssetPriceresultSetgetIntprice;goodssetNumresultSetgetIntnum;goodssetDiscountresultSetgetIntdiscount;goodssetSelleridresultSetgetStringsellerid"));goodssetNumresultSetgetIntnum;}}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returngoods;}/修改商品信息publicintupdateGoods(Goodsgoods){intflag0;nnConnectgetConnectiontry{mentconncreateStatementStringsqlupdategoodssetgoodsname'"+goods.getName()+"',pricegoodsgetPrice)iscount="+goods.getDiscount()+",num="+goods.getNum()+"wheregoodsidgoodsgetIdgstatementexecuteUpdatesql}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnflag}dpublicintdeleteById(intid){intflag0;nnConnectgetConnectiontry{mentconncreateStatementStringsqldeletegoodswheregoodsid+id;gstatementexecuteUpdatesql}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnflag}//添加publicintinsertGoods(Goodsgoods){intflag0;nnConnectgetConnectiontry{mentconncreateStatementStringsql="insertintogoodsvalues((selectmax(goods_id+1)fromgoodsUsergetUserName+"','"+goods.getName()+"',"+goods.getPrice()+","+goodsgetDiscountgoods.getNum()+")";gstatementexecuteUpdatesql}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnflag}publicstaticvoidmain(String[]args){oodsDaodaonewGoodsDao////////////////oodsgoodsnewGoodsgoodssetNamec;oodssetPriceUsersetUserName"niclascage");odssetDiscountoodssetNumprintlnmainmoutprintlniidaoinsertGoodsgoodsSystem.out.println(dao.deleteById(4));//Goodsgoods=newGoods();//goods.setId(1);//goods.setName("oracle");//goods.setPrice(50);//goods.setDiscount(8);//goods.setNum(5);System.out.println(dao.updateGoods(goods));etAllSellerGoodsSystem.out.println(dao.getOneGoods(1));}}packagecom.shoeShop.dao;ortjavasqlConnectionortjavasqlResultSetortjavasqlSQLExceptionortjavasqlStatementortjavautilArrayListportcomshoeShopdbConnectportcomshoeShopentityGoodsmportcomshoeShopentityOrderportcomshoeShopentitySellerportcomshoeShopimpUserpublicclassOrderDao{privatestaticConnectionconn;privatestaticStatementstatement;privatestaticResultSetresultSet;//插入publicintinserOerderByGoods(Goodsgoods,intnum){intflag0;nnConnectgetConnectiontry{mentconncreateStatementStringsql="insertintoordersvalues((selectmax(order_id+1)fromorders"+goods.getId()+",'"+goods.getSeller_id()+"','"+User.getUserName()+"',"+num)";gstatementexecuteUpdatesql}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnflag}/查詢登錄用戶的所有訂單publicArrayListgetOrder(){ArrayListlist=newArrayList();nnConnectgetConnectiontry{mentconncreateStatementStringsql="select*fromordersa,sellerb,goodscwhereaselleridbselleridanda.goods_id=c.goods_idanda.buyer_id=UsergetUserName";resultSetstatement.executeQuery(sql);whileresultSetnext()){OrderordernewOrderoodsgoodsnewGoodssellernewSellerordersetIdresultSetgetIntorderid);ordersetNumresultSetgetIntnumordersetGoodsidresultSetgetIntgoodsid));goodssetIdresultSetgetIntgoodsid));goodssetPriceresultSetgetShortprice;goodssetPriceresultSetgetIntprice;goodssetDiscountresultSetgetIntdiscount;goodssetNameresultSetgetStringgoodsname);llersetNameresultSetgetStringsellernamelersetAddressresultSetgetStringaddresssetSellersellerrsetGoodsgoods//tprintlnordertoString//addorder}}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnlist}/查詢登錄商家的所有訂單publicArrayListgetSellerOrder(){ArrayListlist=newArrayList();nnConnectgetConnectiontry{mentconncreateStatementStringsql="select*fromordersa,sellerb,goodscwhereaselleridbsellerid"+"anda.goods_id=c.goods_idanda.seller_id=UsergetUserName;resultSetstatement.executeQuery(sql);whileresultSetnext()){OrderordernewOrderoodsgoodsnewGoodssellernewSellerordersetIdresultSetgetIntorderid);ordersetNumresultSetgetIntnumordersetGoodsidresultSetgetIntgoodsid));ordersetBuyeridresultSetgetStringbuyerid);goodssetIdresultSetgetIntgoodsid));goodssetPriceresultSetgetShortprice;goodssetPriceresultSetgetIntprice;goodssetDiscountresultSetgetIntdiscount;goodssetNameresultSetgetStringgoodsname);llersetNameresultSetgetStringsellernamelersetAddressresultSetgetStringaddresssetSellersellerrsetGoodsgoodsaddorder}}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTracetry{resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}}returnlist}publicstaticvoidmain(String[]args){OrderDaodaonewOrderDaoetOrder}}packagecom.shoeShop.dao;ortjavasqlConnectionortjavasqlResultSetortjavasqlSQLExceptionortjavasqlStatementportcomshoeShopdbConnectportcomshoeShopentitySellerpublicclassSellerDao{privatestaticConnectionconn;privatestaticStatementstatement;privatestaticResultSetresultSet;/插入數(shù)據(jù)，用于注冊publicintinsertSeller(Sellerseller){intflag0;nnConnectgetConnectiontry{mentconncreateStatementStringsql="insertintosellervalues"+seller.getId()+"','"+seller.getName()+"','"+seller.getPwd()+"','"+seller.getAddress+"')";gstatementexecuteUpdatesqlntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}returnflag}/通過用戶名和密碼查詢，用于登錄publicstaticSellergetSeller(Stringname,Stringpwd){nnConnectgetConnectionsellernewSellertry{mentconncreateStatementStringsql="select*fromsellerwhereseller_id='"+name+"'andpwd='"+pwd+"'";resultSetstatement.executeQuery(sql);whileresultSetnext()){llersetIdresultSetgetStringselleridllersetNameresultSetgetStringsellernamelersetPwdresultSetgetStringpwdlersetAddressresultSetgetStringaddress}resultSetclose);ntcloseclose}catch(SQLExceptione){//TODOAuto-generatedcatchblocktStackTrace}returnseller}publicstaticvoidmain(String[]args){aodaonewSellerDaoSystem.out.println(dao.getSeller("蔣斌","654321"));Sellerseller=newSeller();//seller.setId("lily");//seller.setName("長理專賣");//seller.setPwd("123456");//seller.setAddress("湖南長沙");//dao.insertSeller(seller);}}packagecom.shoeShop.entity;**publicclassBuyer{privateStringid;privateStringname;privateStringaddress;privateStringpwd;publicStringgetPwd(){returnpwd}publicvoidsetPwd(Stringpwd){thispwdpwd;}publicStringgetId(){returnid}publicvoidsetId(Stringid){this.id=id;}publicStringgetName(){returnname}publicvoidsetName(Stringname){thisnamename;}publicStringgetAddress(){returnaddress}publicvoidsetAddress(Stringaddress){thisaddress=address;}publicStringtoString(){returnBuyer[id="+id+",name="+name+",address="+address"]";}}packagecom.shoeShop.entity;***publicclassGoods{privateintid;privateStringseller_id;privateSellerseller;privateStringname;privateintprice;privateintdiscount;privateintnum;publicSellergetSeller(){returnseller}publicvoidsetSeller(Sellerseller){thisseller=seller;}publicintgetDiscount(){returndiscount}publicvoidsetDiscount(intdiscount){this.discount=discount;}publicintgetNum(){returnnum}publicvoidsetNum(intnum){thisnumnum;}publicintgetId(){returnid}publicvoidsetId(intid){this.id=id;}publicStringgetSeller_id(){returnseller_id;}publicvoidsetSeller_id(Stringseller_id){thissellerid=seller_id;}publicStringgetName(){returnname}publicvoidsetName(Stringname){thisnamename;}publicintgetPrice(){returnprice}publicvoidsetPrice(intprice){thispriceprice;}publicStringtoString(){returnGoods[id="+id+",seller_id="+seller_id+",seller="seller",name="+name+",price="+price",discount="+discount+",num="+num+"]";}}packagecom.shoeShop.entity;***publicclassOrder{privateintid;privateintgoods_id;privateStringseller_id;privateStringbuyer_id;privateGoodsgoods;privateSellerseller;privateBuyerbuyer;privateintnum;publicintgetNum(){returnnum}publicvoidsetNum(intnum){thisnumnum;}publicGoodsgetGoods(){returngoods;}publicvoidsetGoods(Goodsgoods){thisgoods=goods;}publicSellergetSeller(){returnseller}publicvoidsetSeller(Sellerseller){thisseller=seller;}publicBuyergetBuyer(){returnbuyer}publicvoidsetBuyer(Buyerbuyer){thisbuyerbuyer;}publicintgetId(){returnid}publicvoidsetId(intid){this.id=id;}publicintgetGoods_id(){returngoods_id;}publicvoidsetGoods_id(intgoods_id){thisgoodsid=goods_id;}publicStringgetSeller_id(){returnseller_id;}packagecom.shoeShop.entity;publicvoidsetSeller_id(Stringseller_id){thissellerid=seller_id;}publicStringgetBuyer_id(){returnbuyerid;}publicvoidsetBuyer_id(Stringbuyer_id){thisbuyerid=buyer_id;}publicStringtoString(){returnOrder[id="+id+",goods_id="+goods_id+",seller_id="sellerid",buyer_id="+buyer_id+",goods="+goodsseller="+seller+",buyer="+buyer+",num="+num"]";}}**publicclassSeller{privateStringid;privateStringname;privateStringpwd;privateStringaddress;publicStringgetPwd(){returnpwd}publicvoidsetPwd(Stringpwd){thispwdpwd;}publicStringgetId(){returnid}publicvoidsetId(Stringid){this.id=id;}publicStringgetName(){returnname}publicvoidsetName(Stringname){thisnamename;}publicStringgetAddress(){returnaddress}publicvoidsetAddress(Stringaddress){thisaddress=address;}publicStringtoString(){returnSeller[id="+id+",name="+name+",pwd="+pwdaddress="+address+"]";}}packagecom.shoeShop.imp;publicclassUser{privatestaticintflag=0;privatestaticStringuserName;privatestaticStringpwd;publicstaticStringgetPwd(){returnpwd}publicstaticvoidsetPwd(Stringpwd){Userpwd=pwd;}publicstaticStringgetUserName(){returnuserName}publicstaticvoidsetUserName(StringuserName){UseruserName=userName;}publicstaticintgetFlag(){returnflag}publicstaticvoidsetFlag(intflag){User.flag=flag;}}packagecom.shoeShop.view;portjavaawteventActionEventportjavaawteventActionListenerortjavaxswingImageIconortjavaxswingJButtonortjavaxswingJFrameortjavaxswingJLabelortjavaxswingJOptionPaneortjavaxswingJTextFieldportcomshoeShopdaoGoodsDaoportcomshoeShopentityGoodspublicclassAddGoodsFrameextendsJFrame{privatestaticfinalGoodsGoods=null;privateJTextFieldfieldName=newJTextField(20);privateJTextFieldfieldPrice=newJTextField(20);privateJTextFieldfieldDiscount=newJTextField(20);privateJTextFieldfieldNum=newJTextField(20);privateJButtonbtSure=newJButton("確定");privateJButtonbtCancel=newJButton("取消");privateGoodsgoods=newGoods();publicAddGoodsFrame(){}privatevoidinit(){thissetSize320,330);thissetTitle商品添加");thissetIconImagenewImageIcon("images/1.png").getImage());thissetLayoutnull;thissetLocationRelativeTonull;thissetResizablefalse;//this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);thissetLayoutnull;tPanel}privatevoidsetContentPanel(){lbNamesetBounds,80,30);fieldNamesetBounds0,150,30);lbPricesetBounds90,80,30);fieldPricesetBounds0,150,30);lbDiscountsetBounds150,80,30);fieldDiscountsetBounds50,150,30);lbNumsetBounds200,80,30);fieldNumsetBounds00,150,30);btCancel.setBounds(30,250,70,30);btSure.setBounds(210,250,70,30);thisaddlbName;thisaddfieldName;thisaddlbPrice;thisaddfieldPrice;thisaddlbDiscount;thisaddfieldDiscount;thisaddlbNum);thisaddfieldNum;thisaddbtCancel;thisaddbtSure);btCancel.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstubefalse}btSure.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstuboodsDaodaonewGoodsDaogoodssetDiscountIntegervalueOffieldDiscountgetText);oodssetNamefieldNamegetTextgoodssetNumIntegervalueOffieldNumgetText);goodssetPriceIntegervalueOffieldPricegetText);nsertGoodsgoodsefalse//}}}publicGoodsgetGoods(){returngoods;}publicvoidsetGoods(Goodsgoods){thisgoods=goods;}publicstaticvoidmain(String[]args){UpdateFrameframe=newUpdateFrame();etVisibletrue}}packagecom.shoeShop.view;ortjavaawtBorderLayoutportjavaawtColorportjavaawteventActionEventportjavaawteventActionListenerortjavautilArrayListortjavaxswingImageIconortjavaxswingJButtonortjavaxswingJComboBoxortjavaxswingJFrameortjavaxswingJLabelortjavaxswingJMenuortjavaxswingJMenuBarortjavaxswingJMenuItemortjavaxswingJOptionPaneortjavaxswingJPanelortjavaxswingJScrollPaneortjavaxswingJTableortjavaxswingJTextFieldportcomshoeShopdaoGoodsDaoportcomshoeShopdaoOrderDaoportcomshoeShopentityGoodsmportcomshoeShopentityOrderpublicclassBuyerFrameextendsJFrame{privateJPanelgoodsPanel=newJPanel();//中間面板privateJPanelorderPanel=newJPanel();//訂單面板privateJPanelsouthPanel=newJPanel();//南邊用于方按鈕的面板privateJMenuBarmenuBar=newJMenuBar();privateJMenugoodsMenu=newJMenu("商品管理");privateJMenuorderMenu=newJMenu("訂單管理");privateJMenuItemgoodsMenuItem=newJMenuItem("商品購買");privateJMenuItemorderMenuItem=newJMenuItem("訂單管理");//privateJButtonbtDelet=newJButton("刪除");privateJButtonbtAdd=newJButton("購買");privateJComboBoxnumBox=newJComboBox(newString4","5","6","7","8","9"});//privateJButtonbtUpdate=newJButton("修改");privateJTextFieldfieldId=newJTextField(15);ObjectarnewObject80][8];ObjectornewObject80][9];publicBuyerFrame(){}privatevoidinit(){rthissetTitle網(wǎng)上鞋購系統(tǒng)");thissetIconImagenewImageIcon("images/1.png").getImage());thissetSize600,400);thissetDefaultCloseOperationJFrameEXIT_ON_CLOSE);thissetLocationRelativeTonull;thisaddmenuBarBorderLayout.NORTH);aneldsPanelsetBackgroundColorGRAYthisaddgoodsPanel,BorderLayout.CENTER);erPanelsetBackgroundColorLIGHTGRAYanelanelthisaddsouthPanel,BorderLayout.SOUTH);}//borderlayout北邊面板設(shè)置privatevoidsetMenuBar(){menuBaraddgoodsMenu);dsMenuaddgoodsMenuItemgoodsMenuItem.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstubremoveorderPanel;dsPanelsPanelupdateUI}menuBaraddorderMenu);MenuaddorderMenuItemorderMenuItem.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstubremovegoodsPanel;erPanelPanelupdateUI}}//borderlayout南邊面板設(shè)置privatevoidsetSouthPanel(){eladdfieldIdeladdnumBox//修改eladdbtAddbtAdd.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstuboodsDaodaonewGoodsDaooodsgoodsnewGoodsifequalsfieldIdgetText))){JOptionPane.showMessageDialog(null,"請輸入商品編號或商intidIntegerparseIntfieldIdgetText());intnumIntegerparseIntString)numBox.getSelectedItem());oodsdaogetOneGoodsidif(JOptionPane.showConfirmDialog(null,"您確定要購買嗎？ifgoodsgetId){llifgoodsgetNumnumJOptionPane.showMessageDialog(null,"商品數(shù)量goodssetNumgoodsgetNumnumpdateGoodsgoodsOrderDaoordernewOrderDaoerinserOerderByGoodsgoodsnumJOptionPane.showMessageDialog(null,"購買成sPanelupdateUI}}}}}}//borderlayout中間商品面板設(shè)置privatevoidsetGoodsPanel(