Oracle課程設計報告-倉庫管理系統(tǒng)

1、 Oracle課課程設計 實驗題目目：倉庫管理理系統(tǒng) 專 業(yè)： 計計算機應用與與技術 班 級： 學 號： 姓 名： 胡強 指導教師： 王 芳芳一、系統(tǒng)描述述倉庫管理理系統(tǒng)的功能能：、產(chǎn)品入倉管理理：在貨物送送到倉庫時，對對貨物信息進進行了解并將將相關信息輸輸入到數(shù)據(jù)庫庫中，同時時更新數(shù)據(jù)庫庫。2）、產(chǎn)品出倉倉管理：在貨貨物運出倉庫庫時，進行貨貨物信息統(tǒng)計計并將數(shù)據(jù)保保存到數(shù)據(jù)庫庫中，同時更新數(shù)據(jù)據(jù)庫。倉庫貨物信息提提醒：當貨物物少于某一規(guī)規(guī)定的值時，或或者貨物保質質期將至時將將發(fā)出提醒。、借出管理：憑憑借條借出，然然后能夠還庫庫。5）、查詢修改改：管理員可可以進行一系系列查詢：查查詢貨物類別別

2、及貨物的信信息、數(shù)量和和貨物流動的規(guī)規(guī)則（對貨物物出倉進倉的的要求）；并并可以對以上上查詢進行修修改；可以查查詢某一天貨貨物流動的信信息，以及出出倉及入倉的的詳細信息。6）、初始化庫庫存設置：設設置庫存的初初始化值，庫庫存的上下警警戒限制。7）、盤庫情況況：反映沒有有、年的庫存存情況；二、系統(tǒng)需求求分析利用用例圖、類類圖、E-RR圖對系統(tǒng)進進行需求分析析。倉庫管理系統(tǒng)可可以實現(xiàn)對倉倉庫貨物信息息、出倉貨物物管理、進倉倉貨物管理、貨物數(shù)量管管理以及貨物物出入倉限制制規(guī)則，以下下為其用例圖圖、類圖及EE-R圖。倉庫管理系統(tǒng)用用例圖類圖表1：產(chǎn)品信息息表PRO字段名數(shù)據(jù)類型長度約束說明PROIDNU

3、MBER11主碼產(chǎn)品編號PRONAMEEVARCHARR220NOT NULLL產(chǎn)品名稱PRODRESSSVARCHARR250產(chǎn)品地址DREPHONNENUMBER20產(chǎn)品地址號碼BDATENUMBER5NOT NULLL保質天數(shù)DEMOVARCHARR2100說明表2：產(chǎn)品信息息管理PROO_MAN字段名數(shù)據(jù)類型長度約束說明PROIDNUMBER11主碼，外碼產(chǎn)品編號BIRDATEEDATE主碼產(chǎn)品生產(chǎn)日期ZNUMNUMBER20NOT NULLL產(chǎn)品數(shù)量DEMOVARCHARR2100說明表3：產(chǎn)品出庫庫管理C_PPRO字段名數(shù)據(jù)類型長度約束說明PROIDNUMBER11主碼，外碼產(chǎn)品編

4、號CDATEDATE主碼出庫日期BIRDATEEDATENOT NULLL生產(chǎn)日期ZNUMNUMBER10NOT NULLL出庫數(shù)量DEMOVARCHARR2100說明表4：產(chǎn)品入庫庫日期R_PPRO字段名數(shù)據(jù)類型長度約束說明PROIDNUMBER11主碼，外碼產(chǎn)品編號RDATEDATE主碼入庫日期BIRDATEEDATENOT NULLL生產(chǎn)日期RNUMNUMBER10NOT NULLL入庫數(shù)量DEMOVARCHARR2100說明表5：產(chǎn)品倉庫庫限制規(guī)則字段名數(shù)據(jù)類型長度約束說明PROIDNUMBER11主碼，外碼產(chǎn)品編號BIRDATEEDATE主碼產(chǎn)品生產(chǎn)日期ZNUMNUMBER20NOT

5、 NULLL產(chǎn)品數(shù)量DEMOVARCHARR2100說明表6：管理員表表ADMINN字段名數(shù)據(jù)類型長度約束說明IDNUMBER11主碼管理員編號USARNAMMEVARCHARR210NOT NULLL管理員賬號PASSORDDVARCHARR211NOT NULLL賬號密碼E-R圖三、數(shù)據(jù)庫對對象設計1、表設計通過過對倉庫管理理系統(tǒng)的業(yè)務務分析及查詢詢資料了解，設設計該系統(tǒng)的的6個關系表表，詳情見上上邊類圖部分分。2、序列設計為了了方便倉庫產(chǎn)產(chǎn)品管理，在在數(shù)據(jù)庫中用用以下序列產(chǎn)產(chǎn)生相應編號號C_R_VVIEW：產(chǎn)產(chǎn)生產(chǎn)品編號號，起始值1100。3、視圖設計為了了方便倉庫管管理員查詢出出入庫情

6、況、每個生產(chǎn)日日期的庫存信信息及產(chǎn)品的的總數(shù)量，創(chuàng)創(chuàng)建下列視圖圖。（1）創(chuàng)建名名為“C_R_PPRO_VIIEW”的視圖，用用于查看產(chǎn)品品的出入庫匯匯總情況，包包括出庫的產(chǎn)產(chǎn)品編號，入入庫的產(chǎn)品編編號，產(chǎn)品名名稱，入庫日日期，出庫日日期，出庫產(chǎn)產(chǎn)品的生生產(chǎn)日期，入入庫產(chǎn)品的生生產(chǎn)日期，出出庫數(shù)量，入入庫數(shù)量。（2）創(chuàng)建名為為“SNUM”的視圖，用用于查詢一種種產(chǎn)品的總庫庫存量，包括括產(chǎn)品編號，產(chǎn)產(chǎn)品總數(shù)量。（3）創(chuàng)建名為為“ZNUM_PRO_VVIEW”的視圖，用用于查詢產(chǎn)品品的庫存信息息，包括不同同生產(chǎn)日期的的庫存量4、PL/SQQL功能模塊塊設計利用PL/SQL程序序創(chuàng)建下列各各種數(shù)據(jù)庫對

7、對象。（1）創(chuàng)建一個個當倉庫產(chǎn)品品少于最少數(shù)數(shù)量或者大于于最大數(shù)量時時顯示出產(chǎn)品品數(shù)量、生產(chǎn)產(chǎn)日期及保質質期的函數(shù)。（2）創(chuàng)建一個個計算距保質質期時間的存存儲過程。（3）創(chuàng)建一個個計算出庫后后數(shù)量的函數(shù)數(shù)。（4）創(chuàng)建一個個計算入庫后后數(shù)量的函數(shù)數(shù)。四、數(shù)據(jù)庫對對象創(chuàng)建描述數(shù)據(jù)庫對象象中表的創(chuàng)建建、序列的創(chuàng)創(chuàng)建、視圖的的創(chuàng)建、存儲儲過程的創(chuàng)建建，觸發(fā)器的的創(chuàng)建等內容容，實現(xiàn)系統(tǒng)統(tǒng)的基本功能能。1、表的創(chuàng)建(11)產(chǎn)品信息PPRO:CREATTETABLEEUSERRS.PPRO(PROIDNUMBEER(11)NOTNULL,PRONAAMEVARCHHAR2(220)NOTNULL,PRODR

8、EESSVARCHHAR2(550),DREPHOONENUMBEER(20),BDATENUMBEER(5)NOTNULL,DEMOVARCHHAR2(1100), PRIMMARYKEY(PROOID)VALIDDATE)TABLESPPACEUSERRS(2)倉庫產(chǎn)品管管理PRO_MANCREATTETABLEEUSERRS.PPRO_MAAN(PROIDNUMBEER(11)NOTNULL,BIRDATTEDATENOTNULL, ZNUMNUMBEER(20)NOTNULL, DEMOVARCHHAR2(1100),PRIMMARYKEY(PROOID,BIRDDATE) VALLI

9、DATEE,FOREEIGNKEY(PROOID)REFERRENCESSSYS.PROO(PROOID) VALLIDATEE)TABLESPPACEUSERRS（3）創(chuàng)建入庫庫管理表R_PROCREATTETABLEEUSERRS.RR_PRO(PROIDNUMBEER(11)NOTNULL,RDATEDATENOTNULL,BIRDATTEDATENOTNULL,RNUMNUMBEER(10)NOTNULL,DEMOVARCHHAR2(1100),PRIMAARYKEY(PROOID,RDATTE)VALIDDATE,FOREIIGNKEY(PROOID)REFERRENCESSSYS.

10、PROO(PROOID) VALIIDATE)TABLESPPACEUSERRS（4）出庫產(chǎn)品品管理C_PPROCREATTETABLEEUSERRS.CC_PRO(PROIDNUMBEER(11)NOTNULL,CDATEDATENOTNULL,BIRDATTEDATENOTNULL,CNUMNUMBEER(10)NOTNULL,DEMOVARCHHAR2(1100), PRIIMARYKEY(PROOID,CDATTE) VALIIDATE,FOREIIGNKEY(PROOID)REFERRENCESSSYS.PROO(PROOID) VALIIDATE)TABLESPPACEUSERRS

11、（5）管理規(guī)則則PRO_LLIMCREATTETABLEEUSERRS.PPRO_LIIM(PROIDNUMBEER(11)NOTNULL,MINUMNUMBEER(10)NOTNULL,MAXUMNUMBEER(10)NOTNULL,LBIRDDATENUMBEER(5)NOTNULL,DEMOVARCHHAR2(1100),PRIMARRYKEY(PROOID)VALIDDATE,FOREIGNNKEY(PROOID)REFERRENCESSSYS.PROO(PROOID) VALIDAATE)TABLESPPACEUUSERS（6）管理員表表ADMINNCREATEETABLEEUSER

12、RS.AADMIN(IDNNUMBERR(11) NOT NULLL,USERNAAMEVARCHHAR2(110)NOTNULL,PASSWWORDVARCHHAR2(111)NOTNULL,PRIMARYYKEY(ID)VALIDDATE)TABLESPPACEUSERRS2、序列的創(chuàng)建建CREATESEQUEENCEC_R_VVIEWNOCYCCLENOORDDERNOCACCHNOMAXVAALUEMINVAALUE100INCREEMENTBY1STARTTWITH1003、視圖的創(chuàng)創(chuàng)建1）產(chǎn)品品的出入庫情情況C_R_PRO_VVIEWCREATEORREPLAACEVIEWC_R_

13、PPRO_VIIEWASSELECTCPROID,RPROIID,PROONAME,RDATEE,CDATTE,CBIIRDATEE,RBIRRDATE,CNUM,RNUMFROMPRO,(SELECTTC_PRO.PPROIDAS CCPROIDD,R_PRRO.PROOID AS RPROIID,RDAATE,CDDATE,CC_PRO.BIRDAATE ASS CBBIRDATTE,R_PPRO.BIIRDATEE ASS RBIIRDATEE,CNUMM,RNUMM FROOMC_PROO FULL JOINNR_PROOONC_PROO.PROIID=R_PPRO.PRROIDand

14、CDATEE=RDATTEORDERRBYRPROIID)R_CWHEREEPRO.PPROID=CPROIIDANDPRO.PPROID=RPROIID2）產(chǎn)品總數(shù)量量:SNUMMCREATEORREPLAACEVIEWSNUMASSELECTPRO.PPROID,SUM(ZZNUM)SNUMFROMPRO,PPRO_MAANWHERREPRO.PPROID=PRO_MMAN.PRROIDGROUPPBYPRO.PPROID3）產(chǎn)品的庫存存信息:ZNNUM_PRRO_VIEEWCREATEORREPLAACEVIEWZNUM_PRO_VVIEWASSELECTPRO_MMAN.PRROID,

15、PPRONAMME,BIRRDATE,BDATEE,ZNUMMFROMPRO,PPRO_MAANWHERPRO.PPROID=PRO_MMAN.PRROID4、PL/SQQL程序設計計（1）倉庫產(chǎn)品品少于最少數(shù)數(shù)量或者大于于最大數(shù)量時時顯示出產(chǎn)品品數(shù)量、生產(chǎn)日期保質期期來：CREATEORREPLAACEFUNCTTIONMIN_MMAX_NUUM_SHOOW(V_PROIDDNUMBEER,V_BBIRDATTEOUTDATE,V_BDAATEOUTNUMBEER)RETUURNNUMBEERASV_SNUMNUMBEER;V_MMINUMNUMBEER;V_MMAXUMNUMBEER;BE

16、GIN SELLECTSUM(ZZNUM)INTOV_SNUUMFROMPRO_MMANWHEREEPROIDD=V_PRROID;SELECTMINUMM,MAXUUMINTOV_MINNUM,V_MAXUMMFROMPRO_LLIMWHEREEPROIDD=V_PRROID; SELEECTBIRDAATEINTOV_BIRRDATEFROMPRO_MMANWHEREEPROIDD=V_PRROID;SELECTBDATEEINTOV_BDAATEFROMPROWHEREEPROIDD=V_PRROID;IFV_SNNUM-V_MINUMM=0THENRETTURNV_SNUUM;ENDI

17、FF;END;（2）計算距保保質期時間:CREAATEORREPLAACEPROCEEDUREPRO_BB(V_PROIDDNUMBEER)ASVV_DAYSSNUMBEER;VV_LBIRRDATENUMBEER;CCURSORRC_BIRRDATEISSELECCTBIRDAATE FROOMPRRO_MANNWHEREEPROIDD=V_PRROID;BEGINSELEECTLBIRDDATEINTOV_LBIIRDATEEFROMPRO_LLIMWHEREPPROID=V_PROOID;FORV_BIRDAATEINC_BIRRDATELOOPIIFV_DAYYS:=(SSYSDATT

18、E-V_BBIRDATTE)=VV_LBIRRDATETHENDDBMS_OOUTPUTT.PUTLLINE(VV_DAYSS);ENDIF;ENDLOOOP;END；(4)計算入庫庫后數(shù)量：CREATEORREPLAACEFUNCTTIONA_R_NNUM(V_PROIDDNUMBEER,V_BBIRDATTEOUTDATE)RETURRNNUMBRRASV_RZNNUMNUMBEER;BEGINSELECCTBIRDAATEINTOV_BIRRDATEFROMR_PROOWHEREEPROIDD=V_PRROID;SELECTZNUM+RNUMINTOV_RZNNUMFROM(SELECT

19、PRO_MMAN.PRROID,PRO_MMAN.BIIRDATEERBIRDDATE,RRNUM,ZZNUMFROMR_PPRO,PRRO_MANN WHEEREPRO_MAN.PPROID=R_PROO.PROIIDANDPRO_MMAN.BIIRDATEE=R_PRRO.BIRRDATE)A_RWHEREEPROIDD=V_PRROIDANDA_R.RRBIRDAATE=V_BIRDAATE; RETURNNV_RZNNUM;END;附Java源代代碼：packagee 倉庫管理理;import java.awt.BBorderrLayouut;import java.awt.EEven

20、tQQueue;import javaxx.swinng.JFrrame;import javaxx.swinng.JPaanel;import javaxx.swinng.borrder.EEmptyBBorderr;import javaxx.swinng.JBuutton;public classs jiemmian2 extennds JFFrame privatee JPannel coontenttPane;public JPaneel gettConteentPanne() return conteentPanne;/* * Launnch thhe appplicattion.

21、 */public statiic voiid maiin(Strring argss) EventQuueue.iinvokeeLaterr(new Runnaable() public void run() try jiemiann2 fraame = new jjiemiaan2();frame.ssetVissible(true); catchh (Excceptioon e) e.printtStackkTracee(););/* * Creaate thhe fraame. */public jiemiian2() setDefaaultClloseOpperatiion(JFFr

22、ame.EXIT_ON_CLLOSE);setBounnds(1000, 1000, 4550, 3000);contenttPane = neww JPannel();contenttPane.setBoorder(new EEmptyBBorderr(5, 55, 5, 5);setConttentPaane(coontenttPane);contenttPane.setLaayout(null);packagee 倉庫管理理;import java.awt.BBorderrLayouut;import java.awt.CCardLaayout;import java.awt.EEven

23、tQQueue;import javaxx.swinng.JFrrame;import javaxx.swinng.JMeenuIteem;import javaxx.swinng.JOpptionPPane;import javaxx.swinng.JPaanel;import javaxx.swinng.borrder.EEmptyBBorderr;import javaxx.swinng.JTeextFieeld;import javaxx.swinng.JLaabel;import java.awt.FFont;import java.awt.eevent.ActioonEvennt;

24、import java.awt.eevent.ActioonListtener;import javaxx.swinng.JBuutton;public classs jiemmian1 extennds JFFrame impleementss ActiionLisstenerrprivatee JPannel coontenttPane;jiemiann jm;CardLayyout ccl;JPanel jp;jiemiann2 jm22;JPanel jp2;privatee stattic doouble chushhi,up,down;public JPaneel gettCont

25、eentPanne() return conteentPanne;public void setCoontenttPane(JPaneel conntentPPane) this.coontenttPane = conntentPPane;privatee JTexxtFielld texxt1;privatee JLabbel laabel_11;privatee JLabbel laabel_22;privatee JTexxtFielld texxt2;privatee JTexxtFielld texxt3;privatee JButtton jjb1;privatee JButtto

26、n jjb2;/* * Launnch thhe appplicattion. */* * Creaate thhe fraame. */public jiemiian1() jp=jiemmian.ggetJp();cl=jiemmian.ggetCl();setDefaaultClloseOpperatiion(JFFrame.EXIT_ON_CLLOSE);setBounnds(1000, 1000, 4550, 3000);contenttPane = neww JPannel();contenttPane.setBoorder(new EEmptyBBorderr(5, 55, 5,

27、 5);setConttentPaane(coontenttPane);contenttPane.setLaayout(null);text1 = new JTexttFieldd();text1.ssetBouunds(1193, 222, 1992, 299);contenttPane.add(ttext1);text1.ssetCollumns(10);JLabel labell = neew JLaabel(u5E993u5BB58u5521Duu59CBu53166u5033CuFFF1A);label.ssetFonnt(neww Fontt(微軟雅雅黑, FFont.PPLAIN

28、, 16);label.ssetBouunds(446, 211, 1133, 29);contenttPane.add(llabel);label_11 = neew JLaabel(u4E00Au8BB66u66212uu7EBFuFF1AA);label_11.setFFont(nnew Foont(微微軟雅黑, Fontt.PLAIIN, 166);label_11.setBBoundss(79, 70, 880, 299);contenttPane.add(llabel_1);label_22 = neew JLaabel(u4E00Bu8BB66u66212uu7EBFuFF1AA

29、);label_22.setFFont(nnew Foont(微微軟雅黑, Fontt.PLAIIN, 166);label_22.setBBoundss(79, 125, 80, 229);contenttPane.add(llabel_2);text2 = new JTexttFieldd();text2.ssetCollumns(10);text2.ssetBouunds(1193, 775, 1992, 299);contenttPane.add(ttext2);text3 = new JTexttFieldd();text3.ssetCollumns(10);text3.ssetBo

30、uunds(1193, 1130, 1192, 229);contenttPane.add(ttext3);jb1 = nnew JBButtonn(u7786Euu5B9A);jb1.settFont(new FFont(華文琥珀, Fonnt.PLAAIN, 116);jb1.settBoundds(76, 194, 122, 39);contenttPane.add(jjb1);jb2 = nnew JBButtonn(u88FD4uu56DE);jb2.settFont(new FFont(華文琥珀, Fonnt.PLAAIN, 116);jb2.settBoundds(2622, 1

31、944, 1222, 39);contenttPane.add(jjb2);jb1.adddActioonListtener(this);jb2.adddActioonListtener(this);jm2=neww jiemmian2();jp2=jm22.getCContenntPanee();jp.add(jp2,two);Overriidepublic void actioonPerfformedd(ActiionEveent e) / TODOO Autoo-geneeratedd methhod sttubif(e.geetSourrce()=jb1)int i=00;trychu

32、shi=new DDoublee(textt1.gettText().toSStringg();up=new Doublle(texxt2.geetTextt().tooStrinng();down=neew Douuble(ttext3.getTeext().toStrring();jm.m1_mmi1.seetEnabbled(ttrue);jm.m1_mmi2.seetEnabbled(ttrue);jm.m2_mmi1.seetEnabbled(ttrue);jm.m2_mmi2.seetEnabbled(ttrue);jm.m2_mmi3.seetEnabbled(ttrue);jm

33、.m3_mmi1.seetEnabbled(ttrue);jm.m3_mmi2.seetEnabbled(ttrue);JOptionnPane.showMMessaggeDiallog(nuull, 初始化成功功！);catch(EExcepttion ee1)JOptionnPane.showMMessaggeDiallog(nuull, 數(shù)據(jù)不能為為空！);i=1;if(i!=11)cl.showw(jp, two);if(e.geetSourrce()=jb2)cl.showw(jp, mainn);packagee 倉庫管理理;import java.awt.BBorderrLayo

34、uut;import java.awt.CCardLaayout;import java.awt.EEventQQueue;import javaxx.swinng.JFrrame;import javaxx.swinng.JMeenuIteem;import javaxx.swinng.JOpptionPPane;import javaxx.swinng.JPaanel;import javaxx.swinng.borrder.EEmptyBBorderr;import javaxx.swinng.JTeextFieeld;import javaxx.swinng.JLaabel;impor

35、t java.awt.FFont;import java.awt.eevent.ActioonEvennt;import java.awt.eevent.ActioonListtener;import javaxx.swinng.JBuutton;public classs jiemmian1 extennds JFFrame impleementss ActiionLisstenerrprivatee JPannel coontenttPane;jiemiann jm;CardLayyout ccl;JPanel jp;jiemiann2 jm22;JPanel jp2;privatee s

36、tattic doouble chushhi,up,down;public JPaneel gettConteentPanne() return conteentPanne;public void setCoontenttPane(JPaneel conntentPPane) this.coontenttPane = conntentPPane;privatee JTexxtFielld texxt1;privatee JLabbel laabel_11;privatee JLabbel laabel_22;privatee JTexxtFielld texxt2;privatee JTexx

37、tFielld texxt3;privatee JButtton jjb1;privatee JButtton jjb2;/* * Launnch thhe appplicattion. */* * Creaate thhe fraame. */public jiemiian1() jp=jiemmian.ggetJp();cl=jiemmian.ggetCl();setDefaaultClloseOpperatiion(JFFrame.EXIT_ON_CLLOSE);setBounnds(1000, 1000, 4550, 3000);contenttPane = neww JPannel(

38、);contenttPane.setBoorder(new EEmptyBBorderr(5, 55, 5, 5);setConttentPaane(coontenttPane);contenttPane.setLaayout(null);text1 = new JTexttFieldd();text1.ssetBouunds(1193, 222, 1992, 299);contenttPane.add(ttext1);text1.ssetCollumns(10);JLabel labell = neew JLaabel(u5E993u5BB58u5521Duu59CBu53166u5033C

39、uFFF1A);label.ssetFonnt(neww Fontt(微軟雅雅黑, FFont.PPLAIN, 16);label.ssetBouunds(446, 211, 1133, 29);contenttPane.add(llabel);label_11 = neew JLaabel(u4E00Au8BB66u66212uu7EBFuFF1AA);label_11.setFFont(nnew Foont(微微軟雅黑, Fontt.PLAIIN, 166);label_11.setBBoundss(79, 70, 880, 299);contenttPane.add(llabel_1);

40、label_22 = neew JLaabel(u4E00Bu8BB66u66212uu7EBFuFF1AA);label_22.setFFont(nnew Foont(微微軟雅黑, Fontt.PLAIIN, 166);label_22.setBBoundss(79, 125, 80, 229);contenttPane.add(llabel_2);text2 = new JTexttFieldd();text2.ssetCollumns(10);text2.ssetBouunds(1193, 775, 1992, 299);contenttPane.add(ttext2);text3 =

41、new JTexttFieldd();text3.ssetCollumns(10);text3.ssetBouunds(1193, 1130, 1192, 229);contenttPane.add(ttext3);jb1 = nnew JBButtonn(u7786Euu5B9A);jb1.settFont(new FFont(華文琥珀, Fonnt.PLAAIN, 116);jb1.settBoundds(76, 194, 122, 39);contenttPane.add(jjb1);jb2 = nnew JBButtonn(u88FD4uu56DE);jb2.settFont(new

42、FFont(華文琥珀, Fonnt.PLAAIN, 116);jb2.settBoundds(2622, 1944, 1222, 39);contenttPane.add(jjb2);jb1.adddActioonListtener(this);jb2.adddActioonListtener(this);jm2=neww jiemmian2();jp2=jm22.getCContenntPanee();jp.add(jp2,two);Overriidepublic void actioonPerfformedd(ActiionEveent e) / TODOO Autoo-geneerate

43、dd methhod sttubif(e.geetSourrce()=jb1)int i=00;trychushi=new DDoublee(textt1.gettText().toSStringg();up=new Doublle(texxt2.geetTextt().tooStrinng();down=neew Douuble(ttext3.getTeext().toStrring();jm.m1_mmi1.seetEnabbled(ttrue);jm.m1_mmi2.seetEnabbled(ttrue);jm.m2_mmi1.seetEnabbled(ttrue);jm.m2_mmi2

44、.seetEnabbled(ttrue);jm.m2_mmi3.seetEnabbled(ttrue);jm.m3_mmi1.seetEnabbled(ttrue);jm.m3_mmi2.seetEnabbled(ttrue);JOptionnPane.showMMessaggeDiallog(nuull, 初始化成功功！);catch(EExcepttion ee1)JOptionnPane.showMMessaggeDiallog(nuull, 數(shù)據(jù)不能為為空！);i=1;if(i!=11)cl.showw(jp, two);if(e.geetSourrce()=jb2)cl.showw(

45、jp, mainn);packagee 倉庫管理理;import java.awt.BBorderrLayouut;import java.awt.CCardLaayout;import java.awt.EEventQQueue;import javaxx.swinng.JFrrame;import javaxx.swinng.JOpptionPPane;import javaxx.swinng.JPaanel;import javaxx.swinng.borrder.EEmptyBBorderr;import javaxx.swinng.JLaabel;import java.awt.FF

46、ont;import javaxx.swinng.JTeextFieeld;import javaxx.swinng.JBuutton;import java.awt.eevent.ActioonListtener;import java.awt.eevent.ActioonEvennt;public classs jiemmian3 extennds JFFrame impleementss ActiionLisstenerr privatee JPannel coontenttPane;privatee JTexxtFielld texxtFielld;privatee JTexxtFie

47、lld texxtFielld_1;privatee JTexxtFielld texxtFielld_2;privatee JTexxtFielld texxtFielld_3;jiemiann jm;CardLayyout ccl;JPanel jp;privatee JButtton jjb1,jbb2;/* * Launnch thhe appplicattion. */* * Creaate thhe fraame. */public jiemiian3() setDefaaultClloseOpperatiion(JFFrame.EXIT_ON_CLLOSE);setBounnds

48、(1000, 1000, 4550, 3000);contenttPane = neww JPannel();contenttPane.setBoorder(new EEmptyBBorderr(5, 55, 5, 5);setConttentPaane(coontenttPane);contenttPane.setLaayout(null);JLabel labell = neew JLaabel(u51665u5EE93u44EA7uu54C1u540DDu79FF0uFFF1A);label.ssetFonnt(neww Fontt(黑體, Fonnt.BOLLD, 155);label

49、.ssetBouunds(338, 199, 1277, 28);contenttPane.add(llabel);JLabel labell_1 = new JJLabell(u55165uu5E93u4EA77u54CC1u65570u991CFuuFF1A);label_11.setFFont(nnew Foont(黑黑體, FFont.BBOLD, 15);label_11.setBBoundss(38, 57, 1127, 228);contenttPane.add(llabel_1);JLabel labell_2 = new JJLabell(u55165uu5E93u4EA77

50、u54CC1u7FF16u553F7uuFF1A);label_22.setFFont(nnew Foont(黑黑體, FFont.BBOLD, 15);label_22.setBBoundss(38, 95, 1114, 228);contenttPane.add(llabel_2);JLabel labell_3 = new JJLabell(u55165uu5E93u4EA77u54CC1u4EEF7u6683CuuFF1A);label_33.setFFont(nnew Foont(黑黑體, FFont.BBOLD, 15);label_33.setBBoundss(38, 133,

51、114, 28);contenttPane.add(llabel_3);textFieeld = new JJTextFField();textFieeld.seetFontt(new Font(黑體, Fontt.BOLDD, 15);textFieeld.seetBounnds(1996, 222, 1622, 21);contenttPane.add(ttextFiield);textFieeld.seetColuumns(110);textFieeld_1 = neww JTexxtFielld();textFieeld_1.setFoont(neew Fonnt(黑體體, Foont

52、.BOOLD, 115);textFieeld_1.setCoolumnss(10);textFieeld_1.setBoounds(196, 60, 1162, 221);contenttPane.add(ttextFiield_11);textFieeld_2 = neww JTexxtFielld();textFieeld_2.setFoont(neew Fonnt(黑體體, Foont.BOOLD, 115);textFieeld_2.setCoolumnss(10);textFieeld_2.setBoounds(196, 98, 1162, 221);contenttPane.ad

53、d(ttextFiield_22);textFieeld_3 = neww JTexxtFielld();textFieeld_3.setFoont(neew Fonnt(黑體體, Foont.BOOLD, 115);textFieeld_3.setCoolumnss(10);textFieeld_3.setBoounds(196, 136, 162, 21);contenttPane.add(ttextFiield_33); jb1 = new JJButtoon(uu5165u5E933);jb1.adddActioonListtener(new AActionnListeener() p

54、ublic void actioonPerfformedd(ActiionEveent e) );jb1.settFont(new FFont(黑體, Font.BOLD, 15);jb1.settBoundds(72, 179, 111, 34);contenttPane.add(jjb1); jb2 = new JJButtoon(uu8FD4u56DEE);jb2.settFont(new FFont(黑體, Font.BOLD, 15);jb2.settBoundds(2477, 1799, 1111, 34);contenttPane.add(jjb2); cl=jm.getCll(

55、); jp=jm.getJpp();jp.add(conteentPanne,thhree);jb1.adddActioonListtener(this);jb2.adddActioonListtener(this);Overriidepublic void actioonPerfformedd(ActiionEveent e) / TODOO Autoo-geneeratedd methhod sttubif(e.geetSourrce()=jb1)JOptionnPane.showMMessaggeDiallog(nuull, 入庫成功！);if(e.geetSourrce()=jb2)c

56、l.showw(jp, two);packagee 倉庫管理理;import java.awt.BBorderrLayouut;import java.awt.CCardLaayout;import java.awt.EEventQQueue;import javaxx.swinng.JFrrame;import javaxx.swinng.JOpptionPPane;import javaxx.swinng.JPaanel;import javaxx.swinng.borrder.EEmptyBBorderr;import javaxx.swinng.JLaabel;import java.

57、awt.FFont;import java.awt.eevent.ActioonEvennt;import java.awt.eevent.ActioonListtener;import javaxx.swinng.JTeextFieeld;import javaxx.swinng.JBuutton;public classs jiemmian4 extennds JFFrame impleementss ActiionLisstenerrprivatee JPannel coontenttPane;privatee JTexxtFielld texxtFielld;privatee JTex

58、xtFielld texxtFielld_1;privatee JTexxtFielld texxtFielld_2;jiemiann jm;CardLayyout ccl;JPanel jp;JButtonn jb1,jb2;/*/* * Launnch thhe appplicattion. */* * Creaate thhe fraame. */public jiemiian4() setDefaaultClloseOpperatiion(JFFrame.EXIT_ON_CLLOSE);setBounnds(1000, 1000, 4550, 3000);contenttPane =

59、neww JPannel();contenttPane.setBoorder(new EEmptyBBorderr(5, 55, 5, 5);setConttentPaane(coontenttPane);contenttPane.setLaayout(null);JLabel labell = neew JLaabel(u51FFAu5EE93u44EA7uu54C1u540DDu79FF0uFFF1A);label.ssetFonnt(neww Fontt(黑體, Fonnt.BOLLD, 155);label.ssetBouunds(336, 355, 1122, 28);contenttPane.add(llabel);textFieeld = new JJTextFField();textFieeld.seetFontt(new Font(黑體, Fontt.BOLDD, 15);textFieeld.seetColuumns(110);textFieeld.seetBounnds(1668, 399, 1622, 21);conten