JAVA程序设计 超市库存销售会员管理系统

1、JAVA程序设计实验报告姓名：班级：学号：成绩：教师签字：完成日期：2013.12.22.大连海事大学交通运输管理学院实验题目一，实验要求与分析(1) 实验的目熟练使用JAVASW组件的使用，数据库连接操作，异常类的处理等。对 使用JAVA处理实际问题有所理解和提高。(2) 实验主要内容使用JAVA组件式开发超市库存数据库维护系统，对超市库存数据维护系 统进行设计，并实现增加，删除，修改和查询四大基本操作。(3) 实验的意义对使用JAVA处理实际问题有所理解和提高。二，实验分析与设计(1) 实验环境JDK6 java eclipse,SQL Sever 2005(2) 实验步骤1. 用swin

2、g插件设计登陆，菜单，查看库存，进货，消除商品，修改商品，管理会员，统计界面；2. 用 SQL SEVER 200设计 AdminUser,Goods,GoodsNumber,VIP,表 和 View_Goods 视图；3. 编写 Query.java,Mo ndifyTable.java,DrawPa nel.java类分别用于查询，更改数据，和画统计圆饼图。(3) 总体设计主要窗体：见图1；Iogin.java（用户登陆界面）Xiu.java（修改窗体）主要数据库表和视图:系统管理员表：列名数据类型允许空 AdminUservardiar(20)EAdminUserPassvarchart

3、20)11_1商品信息表：数据熔允诈空网 GdckIsIDviarchiar(5O)nGcodsNamevarchiar(5G)Goodsdassvarchar(5O)paivardnar(5O)xnghaoviardnar(5O)guigevirdnar(50)jibangdanweiv;ardnar(5O)FcrePricedeanal(10P 2)costdedmal(10r 3)圍pricedeanal(10P 2)商品库存销里表：列若数齬类型岬Gw血IDvarchar(50iGoodsMumberdecimal 鬧0)GoodsXjaodecimal便0)会员信息表:*厂！#7厅.L

4、 id 毗傑:iarI讹品 询倉I雄品虎MAS4 fla】 D01 nunuNiIB1B丸at妙3D0mlIDDml 4DDml IKWflnulBC dig hul nul nul N 16D dsv 印包a&di笔时 2用1.M4 QD5 509.00S9.DU4Q QD2Q0QQ 160.D0 顶.M40 00蓟肿30JO尹0Q23.DD 呦赴韻侨 1.000 BDD3-5QD2004.700 34.000 21I0QD H4QQ0 10Q.ODD .DDD 12.000 719 000 34.000 21血 &uoa33 000 U.000 科M存兑J515代码：private voi

5、d in itComp onen ts() setTitle(” 管理库存); setLayout (n ull);add(getJLabelO();add(getJPa nelO();add(getJButto n5();setSize(1208, 722);jTextAreaO.setText(”商品IDt商品名称t商品种类t品牌t规格t型号t计量单位t零售价t进货价t实际售价t库存n);String datasource=Market;Stri ng tableName=View_Goods;Query query=new Query();Stri ng SQL=SELECT * FRO

6、M View_Goods;query.setSQL(SQL);query.setDatasourceName(datasource);query.setTableName(tableName);高级检索，通过商品编码检索；详初信息query.i nputQueryResult(jTextAreaO);ft齟号：如泄帅i1 T代码：private void jButto nIActio nActio nPeformed(Actio nEvent event) Stri ng GoodsID =jTextField0.getText();GoodsID=GoodsID.trim();if(Good

7、sID.equals()JOptionPane.showMessageDialog(null,商品 ID 不能为空！ ”,JOptio nPa ne.WARNING_MESSAGE);System.out.pri ntln (GoodsID);Stri ng dataSource=Market;Stri ng tabelName=GoodsNumber;String SQL=SELECT * FROM GoodsNumber WHERE GoodsID=+GoodsID+”;Query query=new Query();query.setDatasourceName(dataSource);

8、query.setTableName(tabelName);query.setSQL(SQL);if(query.getQueryReasult()jTextAreaO.setText();jTextAreaO.append(”商品IDt商品库存t商品销量n);query.i nputQueryResult(jTextAreaO);elseJOptionPane.showMessageDialog(this,库存没有此商品！ ”n ull,JOptio nPan e.WARNING_MESSAGE);模糊检索，可以通过类别或商品名称检索查询；输入牛奶和食品类，单击“查看库存（模糊查询）”按钮，

9、结果如下:详細信見两咼銅：育品曲:母仔tn级椎薦J盲巾LdlUMI恥OHEHSIfl格3wowE+JDQmi12 SO1回a时Wttfi*4QA4童吐存|鼻级也丞|查询“食品类”；MOWSKWiiOHM 13诽细怙息应r;R *11卯KG】曲書恰苗：ae-B牛3Mnit2.50uoa吐序和4Mrriti.W3.mnulln(|liflWMOWAMt!iBDUJU DOO+23 (MKWr-曲=n=代码:private void jButto nO Actio nActio nPeformed(Actio nEvent event) Stri ng GoodsID =jTextFieldO.ge

10、tText();GoodslD=GoodslD.trim();Stri ng GoodsName=jTextField1.getText();GoodsName=GoodsName.trim();int l=jComboBox5.getSelectedl ndex();Stri ng GoodsClass=;if(I=0)GoodsClass=食品类;else if(I=1)GoodsClass=生活用品类;else if(I=2)GoodsClass=数码电子类;else if(I=3)GoodsClass=体育用品类;else if(I=4)GoodsClass=保健品类;else if(

11、I=5)GoodsClass=服饰类;else if(I=6)GoodsClass=其他;Stri ng dataSource=Market;Stri ng tabelName=View_Goods;String SQL=SELECT * FROM View_Goods WHERE GoodsID=+GoodsID+ AND GoodsName=+GoodsName+ AND GoodsClass=+GoodsClass+;ANDif(GoodslD.equals()&!(GoodsName.equals() &! (GoodsClass.equals() SQL=SELECT * FROM

12、View_Goods WHERE GoodsName=+GoodsName+ GoodsClass=+GoodsClass+;if(!GoodsID.equals()SQL=SELECT * FROM View_Goods WHERE GoodsID=+GoodsID+;if(GoodsID.equals()&GoodsName.equals()SQL=SELECT * FROM View_Goods WHERE GoodsClass=+GoodsClass+”; if(GoodsID.equals()&GoodsClass.equals()SQL=SELECT * FROM View_Goo

13、ds WHERE GoodsName=”+GoodsName+”;Query query=new Query();query.setDatasourceName(dataSource);query.setTableName(tabelName);query.setSQL(SQL);jTextAreaO.setText();jTextAreaO.append(”商品IDt商品名称t类别t品牌t型号t规格t计量单位t 售价t进价t实际售价t库存n);query.i nputQueryResult(jTextAreaO);看总库存:代码：private void jTextFieldOActio n

14、Actio nPeformed(Actio nEvent event) Stri ng GoodsID =jTextField0.getText();GoodsID=GoodsID.trim();if(GoodslD.equals()不能为空！JOptionPane.showMessageDialog(null,商品 ID”,JOptio nPa ne.WARNING_MESSAGE);System.out.pri ntln (GoodsID);Stri ng dataSource=Market;Stri ng tabelName=GoodsNumber;Stri ngSQL=SELECT *

15、 FROM GoodsNumber WHEREGoodsID=+GoodsID+”;Query query=new Query();query.setDatasourceName(dataSource);query.setTableName(tabelName);query.setSQL(SQL);if(query.getQueryReasult()jTextArea0.setText();jTextAreaO.append(”商品IDt商品库存t商品销量n);query.i nputQueryResult(jTextAreaO);jTextFieldl.requestFocusI nWin

16、dow();elseJOptionPane.showMessageDialog(this,库存没有此商品！ ”n ull,JOptio nPan e.WARNING_MESSAGE);进货:個ID航悄计昭Hl港*1肓品爭巧：0MM1ita*KOpm生铀1帥00000*)2闻判国1150800盲品左祚：0(W31t*3iqrw屯刃刖畫350Q畜吕真制l*sF1liffl品畫ff*1期爭刊4 2Q0(HCi5q丰BlWb70D0D0QQ6HjSnulnJI35.-W30.DDD0WXM7吕匚USEnulSG初.W2O.0DDOKXNBSLfib直用吊贯丰hdldg*2Q0.Q4zcn.two吕品两

17、植r呷血冋L翔弹用品克niAnulnull丰160.04OW&lO狗m会1咙ndnul&l:B0.MM00pwon删nmnuhMl斤40連曲k 卜1ffrjttHT慄VU叫gnTO财/JTStH?層舲SIB他41-DOSUDD卅一ITHX15sdKWIH先div丰丸4ziaoo追認怵；11 /HK41i51BD囲邑EO.QQDad尢div34.WZ3.0DD1 iIHKMK1salanf3541d河垃W34.QN0昭hg647S.0M洞捋量：进新产品:价格和库存应该输入数据型，若输入字符串型，会有如下结果:详拙倍息0MBMHKPMDX7oixKnflDKK9DffiniQ咖12000010咖诗

18、!&：C13DD-M21DKOSfl*&0xwn竄品Ir1HXni空爲用品克蚀毛巾主适用品潯白邑nullmilitt*c*m-1里邑sdiVft&S的鼻冊dsvsalH&Aa&dfjdlhgK血m?iZM1 win1.M獅4.0035505.50砂&?00ano44 DOzoaoo200 .W200.0DD1W.W1DD.0DD3M.W3K.QD040. Ml3(2000W.D0TWOSOM)sum掣叫amaaoo冈QODDO23QQD1.DOMJHH154. DOTCQDO若编码没有输入6位数:正确输入结果，插入商品:详削信息合品址的：曲0D3盲届删I l*M帥；吕品網枯:贰、叽:翔帕MAi

19、d拥用mvi90000*1嵐品0zw甲MiKftl1.50.期*O&rt40035005WWfl毛巾TifflAAS白負8QD耳PlQ僦孑：nullndl3fi.DC)3D HODDWX7acufinull44.002D QUO阴曲込XL DO2W.QDVDDCXXHtM用品曼nulnullmil140.00mono咖询口日式IY瞬nulnullmJI3M.03250帥月WiXiilMlM.Ofi32000咖诅*理聊虫闻70 MOMOM女饰抄七n*sis斡MQDD0015sdiKdtv24 DO33 00D卩网谄艮土科够七四第iaa厦邑SO. DOED HODsdSdsv34. DO23 00

20、0sal45 4123. MJ34 00DDDCWQha処DOQUU I准軀芦品用6品f：宦不耗为空J代码:private void jTextFieldOActio nActio nPeformed(Actio nEvent event) Stri ng GoodsID =jTextFieldO.getText();GoodslD=GoodslD.trim();if(GoodslD.equals()JOptionPane.showMessageDialog(null,商品 ID 不能为空！,”,JOptio nPa ne.WARNING_MESSAGE);Stri ng dataSource

21、=Market;Stri ng tabelName=Goods;Stri ng SQL=SELECT * FROM Goods WHERE GoodsID=+GoodsID+;Query query=new Query();query.setDatasourceName(dataSource);query.setTableName(tabelName);query.setSQL(SQL);if(query.getQueryReasult()jTextArea0.setText();jTextAreaO.append(”商品IDt商品名称t类别t品牌t型号t规格t计量单位t售价t进价n);que

22、ry.i nputQueryResult(jTextAreaO); jTextFieldl.requestFocusI nWin dow();else库存没有此商品！JOptio nPan e.showMessageDialog(this, n ull,JOptio nPan e.WARNING_MESSAGE);单击“已有商品进货”嗣D pw1详削信息吕品细瞎:MOD蚀SI自品电也育品羽剤：-|nOHKM iIViXMmlZ51 SODIQOnM1.W8404.0flIWfi1Hh35.504JM十SH&7WIfull弭g3OQIHIfiGM DOjsoanoIfydm2i0X2OKDD0Z

23、16D.CX1OO.DDOmilIBQ.OO2W.EHBJf44.W3ZQNhahM爬1W件Sfl.MSUMO牛MD0230M件M-K皿护伯23-00如&5.WT&DQD34.4SfliJOD砂画品毎卸输入 000001 ；000001商品开始的库存量:商恳IDS4fi帥输入进货量45;之后商品的库存量;数据库中的数据也发生改变:表-dbdGoodsNuMMr 播要GoadsIDGoodsNumber GoodsXiao000001290ao代码：private void jButto n2Actio nActio nPeformed(Actio nEvent event) String Go

24、odslD=JOptionPane.showlnputDialog(this,输入商品 ID);Stri ng dataSource=Market;Stri ng tabelName=GoodsNumber;Query query=new Query();/ 显示库存；query.setDatasourceName(dataSource);query.setTableName(tabelName);Stri ng SQL=SELECT * FROM GoodsNumber WHERE GoodsID=+GoodsID+”; query.setSQL(SQL);if(query.getQuery

25、Reasult()trydouble GoodsNumber=Double.parseDouble(JOptionPane.showInputDialog(this, 输入进货量);SQL=UPDA TEGoodsNumberSETGoodsNumber=GoodsNumber+GoodsNumber+WHERE GoodsID=+GoodsID+;query.setSQL(SQL);query.modifyRecord();JOptionPane.showMessageDialog(this,操作成功！ ”)； jTextArea0.setText( null);jTextAreaO.app

26、end(”商品IDt商品库存t商品销量 n);SQL=SELECT * FROM GoodsNumber WHERE GoodsID=+GoodsID+; query.setSQL(SQL);query.i nputQueryResult(jTextAreaO);jTextFieldO.requestFocus InWin dow();catch(NumberFormatExceptio n e)JOptionPane.showMessageDialog(nuII,请输入数据类型！”)；elseJOptionPane.showMessageDialog(nuII,没有此商品！ ”)；修改，删除

27、商品：单击“显示仓库全部信息”2D mm mmNMoaH4WNMHMHO? mm DttcttWXnQSCW11EDMH3MomtEHCW014DdCHfll选中多条商品;t|GH|IJwure i v it*ssr-TOmnMSMZ-R1 m ZM屯倾：UidW1 5H血秤爲缺i anw=w4On&j -iW?Ml13询Tf.7WQtssat30M0asi3100040 DQ2WQQ ia wWMmmNW2WW 1EOOO 蚁俑W M4CM&00& 200 0X11 閒 ISO raotno3HD0-16iW曲3 3Q0k?沁JB書打1汨昭巴吓rEtftJHMKOtrw肖呻匸罠0W5护sex

28、FWiiKO；H1巨凸It曲moi?M&ZME!fuNDHK心sww跻=tCRIK斶OlMrtna扪祐丈畛iKOL-lb*-m?tER1&OftKHisdtt中W曲QWM1itxHJjldHOW間？77单击删除;杷悩 SK 16S-H1E6K475TTOHBM&5snwrs#*HBfcH 品AecDEF5M_J_TKI曲口風E弃型SH空匚1卅韵酗EtFBHTQ&M14加科託4和zoom*2 Dd1泗2.502W仙.用初岸品WF气牛如“如*1 tflhraj1沖诙冷000003tss品5年列E54oomK4 003MC4-DQ5B7BTGDXHU5fiRQIf ULlia&?*S BQuhqh閑

29、曲TO M0酣湖仍详土tJTS牛SdM鶴止0CKM13nJ=tj+*vM (TO23 OBJG7BQ&MI-S*HK?HSOtKC儆酩iXralfraE品主：=l* 1X1床皿并1 a星師总曲主峠為品常鼎1H| r?rtL.oHFi取拈瞬数据库信息也删除了;dtoo_View_i&fl&d4 表 dbQjn-nUser i3 dbosV 严口託亦 丢 dboMPGraxkZDbocdsfHam-G fwyl:厂 w: jIM*xngnoo&M001000002000003OOOfflM0000050CHWC60CW007XMca0MHJO90000100W1100W12amis0MM1500W

30、U6OMUSO必白主細i类 主舌用品粪 生舌用品裳 計驰孑賞 就円旦孑锲 棣言用品盅 协冃阳品娶 恨储品 锢类 爲品宴 肺市裳腳币粪1=ffi* 曰色 AUX i hdfAW1 i AUIfu 红色大130代码:private void jButto nIActio nActio nPeformed(Actio nEvent event) DefaultTableModel tableModel = (DefaultTableModel) jTable0.getModel();int i=jTable0.getSelectedRowCount();in t nu mber=jTable0.ge

31、tSelectedRows();System.out.pri nt(i);System.out.print(number0);String datasource=Market;String tablename=GoodsNumber;Stri ng SQL=;Stri ng GoodsID=;Query query=new Query();query.setDatasourceName(datasource); query.setTableName(table name);for(i nt j=1;j=i;j+)GoodslD=jTable0.getV alueAt(numberj-1, 0)

32、.toString();System.out.pri nt(GoodslD);SQL=DELETE FROM GoodsNumber WHERE GoodsID=+GoodsID+”;query.setSQL(SQL);query.modifyRecord();SQL=DELETE FROM Goods WHERE GoodsID=+GoodsID+”;query.setSQL(SQL);query.modifyRecord();for(i nt j=1;jwui?吕出aw0WW1牛 Kfii?千FHHMM冋姬锁1M1千翅书fiUKrai9TOQtAK 押UrlmmmajnmiKO河3祕BBK

33、KO=Hfl113(KnHF 4GiQ归EGwsmmritiss 吓棚喷mm kithn.HKonnwo=nmnrffic嘶|丁ASWTtailMmr,ijma-tnmiMKn5更！ramms伽wwisftrwam七區伍*e斤VfB9JHUlmBK.40.n4040nonWWN1宜M Ji 4 ? ft -K-1WW血JJM WwnW*5F32%O鬥知码除画品es-*单击“商品信息后”直接在文本框中修改信息;信息修改后;w IE丰 蚀 IfUQUSB品古B1fflWW tH&A 询?ial4E 特4裁 q=fflmMficua 年砒 mm BS .卿 碎lfl+ 如曲: sdWM他DO60 0

34、0 $0闻 31M的闻3MH 4 20CIC rw30 DOG 边碗 3M M 104WX1TOMB 融啊 ZiMWflUMH BQj 5SB6*Y a样商呂miDOOO0O1 0002 QWMD 000004 1X)0005QOHXK D0HH7 OHKHi oxx DOOOW MW11 ooin DOHblS KW15 tHKie昭电股 阴电浄r4.CKW7B7Bum他理MT?3CJ90Efl7B8MjMa5719fi7209 00tB&DaBGEGaaoM5W740 00SW5BOMUliB容5期闆En数据库的信息也发生改变;H!圈 dba.Vim_SMd5 垂 dbc_Adm鬲 wr|

35、 1$* - dbo诉叶jSoodMt - dbaVl日帚 XpsiMeQWW1牛妍菽牛埔牛妍30M000002牛胡貝品蒙牛纯牛坷IXXknl牛甥IP*J珂牛餌400mlCHKHK香皇魄香loos000005毛巾生送羽品益白国OddODB歎冯电子裳JfiwWWW?3GL-熬码电孑类主三JiW药TMfdfo000009网讳粕ALUALUWOO ID膽白金ALUjflWMAIwwn月诵AWMCXM4XWMi2我也fiJN00(X113女報衬挣七匹犧画OOlMlS犬dsvWXW3&勇士封捞七匹踽CHXKW诗品类更廉hi韩代码如下：private void jButto nO Actio nActio

36、 nPeformed(Actio nEvent event) xiu frame = new xiu();frame.setDefaultCloseOperatio n(xiu.HIDE_ON_CLOSE); frame.getCo nte ntPa ne().setBackgrou nd( new Color(255,255,255); frame.getC on te ntPa ne().setPreferredSize(frame.getSize(); frame.pack();frame.setLocati on RelativeTo (nu II);frame.setVisible(

37、true);int n =jTable0.getSelectedRow(); frame.GoodslD=jTable0.getValueAt(n, 0).toString(); frame.GoodsName=jTable0.getValueAt( n, 1).toStri ng();String s=jTable0.getValueAt(n, 2).toString();if(s.equals(食品类)frame.GoodsClass=0;if(s.equals(生活用品类)frame.GoodsClass=1;if(s.equals(数码电子类)frame.GoodsClass=2;if(s.equals(体育用品类)frame.GoodsClass=3; if(s.equals(保健品类)frame.GoodsClass=4; if(s.equals(服饰类)frame.GoodsClass=5;if(s.equals(” 其他)frame.GoodsClass=6; frame.pai=jTableO.getValueAt( n, 3).toStri ng(); frame.x