Java期末课程设计-超市进销存管理系统.docx

《Java期末课程设计-超市进销存管理系统.docx》由会员分享，可在线阅读，更多相关《Java期末课程设计-超市进销存管理系统.docx（19页珍藏版）》请在课桌文档上搜索。

1、(1)功能模块划分:本进销存管理系统划分为六个模块，分别为系统登陆模块，系统主窗体设计模块，进货单模块，销售单模块，库存盘点模块和数据库备份与红原模块，数据库结构描述：企业进销存管理系统须要运用数据库存储和管理进销存过程中的全部信息，本企业进销存管理系统运用Access数据库系统作为后台数据库，数据库名称为db_database28。其中包含了14张数据表、两个视图。以下是系统主要涉及的六个数据库表：1.供应商信息表：主要用于存储供应商具体信息，其结构如下表所示：User表：三user3)userIdusernae!金莉舁password520u_text庭苏以我7默认管理员雨2root123

2、root*0Handle表:StUff表:3*XtViff1*uff.rutitf,cchfcj*4ff-lXuHjX”皿.Bl，Mjlatdt.detetuf“*”1/2im&rdfrroI代4ftf4ffcjc.euff.11taaiuff.pochcku*,ciuff.0x2iuf.v)iuf.rp*,8f.s1ftuf.platetPaintWradientPeicS;q2d.fIllRectlrOrwidth,b-ghtl;g2d，6lUgrlngH，mRfind。YingiHC3XEYAV?ZAXfASJRd*ringHlnt.VA1.UEAWJA1.JASOFF);Iprvat)

3、avox.swing.JButtonnow)avx.swing.JButtoncIpcprivateAwing.JBuctoncaac1.a-newjavAx.vln9.JButton(J04eprivatJFra11logo_?rSyste.err.printecortadItr)Toolkittoolfl-logoFr116.g6t7oolklt);Irrcgelogo-tool9.9etlm09*(rwlo90j9w);logo-Fra11e-nwJFrane;lgo-Fr11e.setIconnago;3ova.BWing.J1.abelusersnwjavax.swing.J1.af

4、cel(U5erI;SQtufiCocrponent(uacrsrO,1.1,1.flsol;yav.awlyg.J1.dbe1a公-nwvA.aclfy.J1.dbal(pjjh3);三otufCcponnt(cnposrO,3.1,1,folsol:Ufidxlaxc-n*wjavAX.AMln9.JxtFi61d(12;U8drl-reqvwtFocu11;u三er7et.ZicWKey1.istenernwKey1.istener1(publicvoidXcyTypcd(KcyEntQlIpxblicvoidZoyRolaqS(KoyEsnt)publicvoidc*yPre58ed(

5、ife.jetKeChar(l-KeyEvent.vrKtiTRIS6Iuseriext.getTet.trn；itChr(I-Ke*yEent.VATR)XStringu&ers-userTcxt.get7extI).tri11;StringPMdBU5rp%cl.gotPassvordO.toStringil.trl.();StringdH)ncrAflord.gtPflfiNrd(.CoStringO.trin);ifer.iEFty(l)IjV4x.wing.JOptonPene.1ogo-Pr*!wt必需归入用户名！输入用户名-,JCptionPene.ERRoS_MESSAGE”f

6、irxt.requoacFoeuflO；|ifjvax,awing.JOptionPene.h;UgtrPKd.xoqgFocg)：)ifH-r三Wftf-rJOptlonPano.EO-MFSSJkS;nterpword.reqvetFocue11;Ibooleanb三DBUtll.X5xi5t(3clc2tuscrnanc*rcuserwhereurnna-tw*Dar3*,;e;usrxt.aat7xcwm;u”。Pwddctlt*)；entcrpassuord.&etextw);uscrcxt.rcqucstFocus/)intvlr-DBUtil.7eClJeI*selecter-n

7、11cfrcuserwhereser-nan*-,*user8*w*1;lfO)Stxirvgs】-ln6rtInto-rVi1.uaa*vila*w,tu4irttwdt)；booleanbo-USeOB.VpdtCe(cqlI;f(bo)JoPtionP.nedhrodd.addAction1.i9t9nern*Action1.19tnr(IIpublicvoidaCtionPerforne!IActionEventelIStringuserssrcxt.qctTcxt().tri11I);:F4-uAxpwd.gcPAflvord.toStxltgr(.；d6tVCc*TPonent但t

8、uf1,Utru;stuff_nane-nwjavx.swing.J7extField10);stuf-nanc.OddKcy1.istcncrIimvXcy1.istcnarOpublicvoidkyypd(KeyEvontO)IlpublicvoidkeyPre58ed(IpblcvoideyReleased(KeyEventelI12H.9a。t守CCtfPOnOC匕(XtlUrfny,3r0,lvIrtrue;yav.lnq.J1.ubA1SiEUrfCeaPanyINgl-MyjAV.%;8cttCoponent(stff_ccrpany_labelf4r0,lt1,trul;3tu

9、ff-ccpanynewJavax.swlnq.JloxtFlcld10);flturfjcpny.AddKAy1.iflCanAr|nwXoy1.fitoMt)publicvoidkeyyped(KvyBvntelIIpublicvoideyPressed(IpublicvoidXcyRcleased(KcyEvcnta1I11-KayEvent.VK-EVER)(cuff_coarany.tT4xt(.Crlm()!-m)tff-*opl*.r*t0c5;cetcCcpo11nt-ff_CEF”ny，5,0,11,tru;javx.swin9.J1.ebeltuff-peple-lbel-

10、wjov4x.9win9.J1.ebel(*(kV.,.;3QtuCcponnt(sturf_pccplc_laboir6,0,G1,tru.fltuffppl-newJaVaX.2*罔.JTGXtF。Id(IO)：etuff_pvopl.eddKy1.ietenrowKey1.itener(IIpublicvoidkeyTyped(KeyEntelIJpublicvoidXcyPrcsscd(iibllGvoidxayRlAd(KayvntOJlifICh(I-KeyEvent.VK-E*TXl“(tff-p*cple.9et7extO-txn!wlIIcheck-people,reques

11、tFocus;三etvCcponentEufJpccpleJ.O*lr1*trl;Iovax.SKingaJ1.obalcckjoplvlabcl=nwivx.svin9.J1.abclet5sCcF11ent(chck_p*cple_labl,0.1*1/1.tru；check-people-nw3ovax.cwiryg.JTextFieldIlOl;chck_pooplQ.addKy1.lstonernwKay1.lstcncrOpublicvoidZayTypod(KyEnta()UfltvpCotTponont(sntrr)3.U1.trv;Clddn-nwjova.9win9.But

12、ton,fl登;clan.ddActlon1.15tQnQr2。t.卑CCaPonQC匕(clanr33.1,1,tc;encl6-nwvax.aMlr9.JButtan;cancle.addAction1.istenerInAction1.istenerdIpublicvoidctlonPcrror11clIActlonEvcntcl1I；stufCcponntgncl0.3,1r1zCruoIjFpublicvoi4PdintconPOnentGrephiEg(pr.pantCconent(gI;if(!IsOpsaquaOroturnCtpTlcfl2D92d-(CPhIS2D)g；/n

13、trule-Alph4Cc*po:te.SPCJVBR;AlpbaCcxrpoBiteopaque-A1.phaCcnposite.SrcOver;/A1.phaConpos1CqblendAlphaCanposltc.QcclnstanccrulfO.6f;/XlphAConpofl116st-AlCcpi.Sx;intwidth-9tWidth(l;Intheight-getHcghtO;GradlcntPalnt9radlcntPaintnwCYadIontPalmQr0,J.awt.Co1or.giAitvidth2zl9ht24Java.awc.Color.ytUk4fal；q2d-

14、eetjnpoiteentJCcntipadrbool411till)IfinalGxidBagCanfitrAlntfl9rIdEugConattAlnfi-miwGt14B。勺COnqtraSCC);grdK59Contrin.gridx-grd;gr1dBa7C0natrain5.gridy-rdy;9ridB09C0n3trains,insets=new1vo.algrIdBegConetreine.gridvidth-gridwidth;IflipadxOlgridBof7Constrains.Ipodx三lpadx;clean11;rturn;FSaql-dalatafronstu

15、ffinwhatAstuffID-*dandfituffA11a-*nAar,(rxltff-ccpe11y-ctxp9nyendtff-nt-nit;USeDB.0rdatePS(sqH;&ql*ldt.tat*conpAy*r(ol*rw*cXt*unitt,h*va1o*rcpd.JcoIor“JmE-l-dtmJ-，&ql-insertintoBtuff_quitvalues,*aql*hIw;USQDBW“QDBCqlclaan();)privatebooloanChQckValucJStrlngalIchar(-A.toChrArrAy();Int3-0;forlint1-0;i,

16、u002f,“ciu0040I(j”Fif13-ch.lngthlIrturntru;Frtumfalse;)privatebooleanChockDota(Stringst收效。”Uboolanbfal*;Stringtoken-st.splith;IflIchcckDateRoxgcxIatl)(ChackVa1u6tokn(1)“CoekVAlu0(b-IS1.edPYear(tok511);IFrtuxnb;)privatebooleanIS1.eapYear!Stringstr)IIIntyearInteger.pjrrolnt(str0IIntaronc-Intuit.paxSln

17、t(tr(l);intUy-Integer.prwZnCO“3Xnt13)(nonth-711(nonth8)11(nonth-1011Ignth-121IifO46day32lIb-tr:I)olsif(ifQ“dy;productvlu.t7fttIm);projct-vle.requetFocu(I;publicvoidyylyped(KfyyEme11IpublicvoidoyPrs30d(l；8tCcpD11ent(podct-v;stufCcponnt(prod三t-aXc-latoclr4,1.1,1,truproductrAka-newjAvx.Kin9.JTaxtFialdI

18、lO);pr。加ct_cdkeeddK刁y1.iutCCe:(11wKey1.iUteneX(Ilpublicvoid.KayEvcnt.7K_EVTERproduct-nake.gotTQt11!,IGtxXds.SqgqtFOCglJ;IIpublicvoidKoyTyped(KcyEon.Q)IlPUblfevoidxyPxfiflkd；BetujJCarponent(DroduCj-S.Itlr1.trl;java.SWingtJ1.abeletock_date_lat*lnewjavax.swing.J1.abelIw,;aot*Cctfponocc(ACackIabaI.6,1,1

19、.Utru;8tock-dte-nwjevax.swing.J*TetFildIO);etock_date.addKey1.iBtenerlnwKey1.ictenerDIpublicvoidXcyRclQasQdCKQyCvcntq)(ifI“At.trln!-w)(ifChckDat,il,JfiiA!程入HMl格.SHfiY,jnvax.awing.JCptlOCPNM,ARaR，/5八。);三tock-date.&etext-;stoek_dat.requestFocusI”)IIpublicvoidkeyyped(KeyEentelIIpublicvoidoyPrs30d(0tvCo

20、oFOnnt(q,.，tru；publicvoidpalntConponcnt(Graphicsg(super.palntCctfonnt(g);UipaqueOrturn;IGraphiC82Dq2d-(Graphics2DIq;/lntrule-AlpoCc;/lphaCo11Foiteset-AlphaCcaposite.Src;Intwidth9ctWldth(1Intlht-gotHQfght，)：CradientPeintgrad11tPeint-nwGradientFaintIOrO/java.awt.Color.7rce11rvidth/2#height2fjava.awt.l

21、or.yelJo,f18l;g2d.SQtConpos1tcopaquc);92d.AatPAlntIgtrMSCsIHnt);2d.fillRectIOrOrwidth,heightI;pxlv*t*voidtUpCoflponantJCctflgrldBoConstrans.gridwidth9rldMldth/if(lpdOgridB4Contrn.ipad-ipa:FprivatevoidInput11IStringId=productid.gtT0t(I.trimO；Stringellnt-productclint.gt7tO.trin；String11an?：r：xJuct_rnn

22、r.grt7?xtIl.tri11);Stringspec-prcduct_sFcc.getTextIl.tri11l);Stringunitproduct-unt.qctTt1).trl11I);Stringvlu-pradostvlu.gtTaxt(.crlnO;Stringmke-prduct_nako.getText11.trinI);Stringdate-三tock-date.getextO.trno,apcrunit,vlu.3krdAta4caxc；Stringtnke-prduct-nay.getText11.tri11I);Stringdate-三tock-date.gete

23、t.trnl;Stringtextproduct-tcxt.gctTcxtI).trl11O;String2ba-id4cllnt/11XtfiC,unlt4valu.auk6rdACAjcat)；forlinti-O;ibabe.1.ngth-l;ilIifIbabai.IsEnptyOjaax.swing.JCptionPane.3fto*He55ageoaJ9null,除卷注吸外.N他“敢也心上克的,小山以注入，.输入龄极不充解rV，X.5Wlng.JOpt1onPane.fiROR-RESSS);return;IIif(!ChackVi1g(b4(5)1iva.flwltg.JOpti

24、onPAna.(xrnull.”数入ItiK只以收。生9之呵的数字.HUM,javax.wing.JOptionPane8M0fSSMSy;product-vluc.setTextf,productVAlu.r6ifufltFoeua(|;return;Iif(!ChcckDatcbbo11J11)ova.3;.JOptlanPonc.nll.”,八1基哎格式输入布鳄,它为/7YKYY/尔DD.MW入1Ia侑入H啷大谁识,vaxAMingaJOptIonPanatHES5S；atock_ddte.set7ext-1;3tock_dotc.requestFocus(Ixtucn；IitI!cet

25、il.i5xcselectfromproduct_inwhereproduct-ID-w*w,*baba04-113avax.swing.JQptionPane.shoKessavDialoginl1,IW后加改MJ敷冷:号不存在.不便更，A笊所伶NttWOiN,avox.swing.JOptIonPane.ERSfJfESSAgiCIednI);return;ISiqI-TdM,-*clie11t-.w*na11epe*rt,11k4,w4date-text4,w;sql-wupd3teprcduct-inctPmdUUJID,“*,pt。ClUujC14。-3*cliQit,producJ

26、nanc=Jmg”3PrOCiUCJSpQU1.rpc*,pmductuAit-tunlt*zproduct-value-value*/product-11k-w-n3Ke*,5tcK_date-*-*date*r*product_text,*tet*wherePrOdUCJlD,JWj门ag.gci”。，软物出人般利！cleanI);if(11onth-2)IifIMlvor100I-Ol)IIIzar“0。O)(Zf*ifO“doy30)b三-tr0j)ifdO“Uy29lIb-txu；|IJrtucnb；卜privatebooleanChecktMteRexgexIStrinqstr)I

27、Pottornrc-Pottornpd2cO-9)(4)XX(D-9111/2)X(0-9;Utehrn-r.natebratr);booleanb-11；rturnb;F/publicAtAt1.cvoid11in(Stringarga11)nowCrfiateuaoirPrcductIntarFace(Ah;/)packagefire；ISlertjava.awt.AlphaCoriFocite;aortjava.avt.GradiontPolntiK)OXt.Gxphicfl;reportj4v.avt.Graphic2D;ort3ava.awt.GridR3gC0nBtraint8;i

28、0ort30va.Awc.Renderr;HlntslscxtAV.Avt.avnc.ActlonEvent；reportJCVd.avt.event.Action1.ietener;三ortjava.avt.event.KeyEvent;ixort)av.owe.event:.Kcy1.lstcnar;lfcxtjAVA.util.xg.Utchr;importjava.uti1.rgtx.Pattern;sortjava.swing.JPanel;iflore30v.swing.JConpancntlflortjimport：publicclassCreateuserProductOutI

29、nterFacextndsJPanelprivatetinlstaticIongscrllVcrslMUD2300001.231.322121.:pxlvAtStxingWql-null；privatjav0(eql-wpiteproduct-inPrOdUCjVdl*-v&lWheXgprodct-10-idIUScDB.UpdtcDBIsql)clan):privatevoidIsUplatc()Stringid-xoduetasid.9tTttc(.trlA();Stringclient-prodct-clint.get7extD-trin;String11ane-product-na1

30、1e.getText11.tri11D;Stringspecproductasspoc.qot,Tat11.trl11I);Stringunlc-productt.g6t76t().tri11);Stringvalue-prdvct-valu.9tText(I.tri(l;Stringtrxake-product_naKe.QetText11.tri11I);Stringzqstock-dot.gctct.trinjStringcGt-productvtt.96tTAt().trin);Stringbabe11-Iidclieat/nmeopCrunit4valu9vn9kerdatetxtI

31、;forlinti-0;ibat*gth-l;i*lIiflbabail.IsCnptyOX)Avax.swlng.JCptlonPona./)0kWc25iaDij2c9null(除Jfr建以外.M佳，牧”氐&倏的.清币册片人，,8融入CUK不克flpa,Jvax.q1ng.JOpt8Pn。M0R_MESSAZ)；rtrn;ifI!CheckVaIue(bb(5)ijdx/，ngJOptionPdne“齐OiGly(null.皎曜儡AUtlM”接收。支9之间的数？，谓喂新S入？javax.swing.JOptionPaneFBCR_KSS5AG);productVAluft.ftt74t*：PrMUCjVd】uer=UedtFoCU8(I;return;IifUChackDatAWDD.常内看人！.侑入H阴格式Itti*,rjavax,j5vin9.JOptionPdn*RWtO(HE5SA);3tock_datc.sot7extw-