Oracle课程设计报告-仓库管理系统

1、 Oracle课课程设计 实验题目目：仓库管理理系统 专 业： 计计算机应用与与技术 班 级： 学 号： 姓 名： 胡强 指导教师： 王 芳芳一、系统描述述仓库管理理系统的功能能：、产品入仓管理理：在货物送送到仓库时，对对货物信息进进行了解并将将相关信息输输入到数据库库中，同时时更新数据库库。2）、产品出仓仓管理：在货货物运出仓库库时，进行货货物信息统计计并将数据保保存到数据库库中，同时更新数据据库。仓库货物信息提提醒：当货物物少于某一规规定的值时，或或者货物保质质期将至时将将发出提醒。、借出管理：凭凭借条借出，然然后能够还库库。5）、查询修改改：管理员可可以进行一系系列查询：查查询货物类别别

2、及货物的信信息、数量和和货物流动的规规则（对货物物出仓进仓的的要求）；并并可以对以上上查询进行修修改；可以查查询某一天货货物流动的信信息，以及出出仓及入仓的的详细信息。6）、初始化库库存设置：设设置库存的初初始化值，库库存的上下警警戒限制。7）、盘库情况况：反映没有有、年的库存存情况；二、系统需求求分析利用用例图、类类图、E-RR图对系统进进行需求分析析。仓库管理系统可可以实现对仓仓库货物信息息、出仓货物物管理、进仓仓货物管理、货物数量管管理以及货物物出入仓限制制规则，以下下为其用例图图、类图及EE-R图。仓库管理系统用用例图类图表1：产品信息息表PRO字段名数据类型长度约束说明PROIDNU

3、MBER11主码产品编号PRONAMEEVARCHARR220NOT NULLL产品名称PRODRESSSVARCHARR250产品地址DREPHONNENUMBER20产品地址号码BDATENUMBER5NOT NULLL保质天数DEMOVARCHARR2100说明表2：产品信息息管理PROO_MAN字段名数据类型长度约束说明PROIDNUMBER11主码，外码产品编号BIRDATEEDATE主码产品生产日期ZNUMNUMBER20NOT NULLL产品数量DEMOVARCHARR2100说明表3：产品出库库管理C_PPRO字段名数据类型长度约束说明PROIDNUMBER11主码，外码产品编

4、号CDATEDATE主码出库日期BIRDATEEDATENOT NULLL生产日期ZNUMNUMBER10NOT NULLL出库数量DEMOVARCHARR2100说明表4：产品入库库日期R_PPRO字段名数据类型长度约束说明PROIDNUMBER11主码，外码产品编号RDATEDATE主码入库日期BIRDATEEDATENOT NULLL生产日期RNUMNUMBER10NOT NULLL入库数量DEMOVARCHARR2100说明表5：产品仓库库限制规则字段名数据类型长度约束说明PROIDNUMBER11主码，外码产品编号BIRDATEEDATE主码产品生产日期ZNUMNUMBER20NOT

5、 NULLL产品数量DEMOVARCHARR2100说明表6：管理员表表ADMINN字段名数据类型长度约束说明IDNUMBER11主码管理员编号USARNAMMEVARCHARR210NOT NULLL管理员账号PASSORDDVARCHARR211NOT NULLL账号密码E-R图三、数据库对对象设计1、表设计通过过对仓库管理理系统的业务务分析及查询询资料了解，设设计该系统的的6个关系表表，详情见上上边类图部分分。2、序列设计为了了方便仓库产产品管理，在在数据库中用用以下序列产产生相应编号号C_R_VVIEW：产产生产品编号号，起始值1100。3、视图设计为了了方便仓库管管理员查询出出入库情

6、况、每个生产日日期的库存信信息及产品的的总数量，创创建下列视图图。（1）创建名名为“C_R_PPRO_VIIEW”的视图，用用于查看产品品的出入库汇汇总情况，包包括出库的产产品编号，入入库的产品编编号，产品名名称，入库日日期，出库日日期，出库产产品的生生产日期，入入库产品的生生产日期，出出库数量，入入库数量。（2）创建名为为“SNUM”的视图，用用于查询一种种产品的总库库存量，包括括产品编号，产产品总数量。（3）创建名为为“ZNUM_PRO_VVIEW”的视图，用用于查询产品品的库存信息息，包括不同同生产日期的的库存量4、PL/SQQL功能模块块设计利用PL/SQL程序序创建下列各各种数据库对

7、对象。（1）创建一个个当仓库产品品少于最少数数量或者大于于最大数量时时显示出产品品数量、生产产日期及保质质期的函数。（2）创建一个个计算距保质质期时间的存存储过程。（3）创建一个个计算出库后后数量的函数数。（4）创建一个个计算入库后后数量的函数数。四、数据库对对象创建描述数据库对象象中表的创建建、序列的创创建、视图的的创建、存储储过程的创建建，触发器的的创建等内容容，实现系统统的基本功能能。1、表的创建(11)产品信息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)仓库产品管管理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）创建入库库管理表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）出库产品品管理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）管理规则则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、序列的创建建CREATESEQUEENCEC_R_VVIEWNOCYCCLENOORDDERNOCACCHNOMAXVAALUEMINVAALUE100INCREEMENTBY1STARTTWITH1003、视图的创创建1）产品品的出入库情情况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）产品总数量量:SNUMMCREATEORREPLAACEVIEWSNUMASSELECTPRO.PPROID,SUM(ZZNUM)SNUMFROMPRO,PPRO_MAANWHERREPRO.PPROID=PRO_MMAN.PRROIDGROUPPBYPRO.PPROID3）产品的库存存信息:ZNNUM_PRRO_VIEEWCREATEORREPLAACEVIEWZNUM_PRO_VVIEWASSELECTPRO_MMAN.PRROID,

15、PPRONAMME,BIRRDATE,BDATEE,ZNUMMFROMPRO,PPRO_MAANWHERPRO.PPROID=PRO_MMAN.PRROID4、PL/SQQL程序设计计（1）仓库产品品少于最少数数量或者大于于最大数量时时显示出产品品数量、生产日期保质期期来：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)计算入库库后数量：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, 数据不能为为空！);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, 数据不能为为空！);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