超市商品管理系统源代码importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;publicclasssale2extendsJFrameimplementsActionListener//销售界面{privateJPanelsM=newJPanel();//supermarket面板JLabellabel1,label2;JTextFieldfield1,field2;JButtonbutton1,button2;Stringnum=null,name=null,time=null,add=null,t1=null,t2=null,t3=null;intprice=0,countBG,n1;//价格/商品的卖出数量privateJTextAreagoodsShow=newJTextArea();//文本区privateJScrollPanejsp=newJScrollPane(goodsShow);//滚动区域设定内容为商品显示的文本区privateJButton[]pS={newJButton(销售界面),newJButton(销售管理),newJButton(商品管理),newJButton(用户管理)};//personty按钮privateJLabel[]CD={newJLabel(清单号,JLabel.CENTER),---本文来源于网络，仅供参考，勿照抄，如有侵权请联系删除---newJLabel(编号,JLabel.CENTER),newJLabel(名称,JLabel.CENTER),newJLabel(价格,JLabel.CENTER),newJLabel(生产日期,JLabel.CENTER),newJLabel(产地,JLabel.CENTER),newJLabel(数量,JLabel.CENTER)};//帐单查询时的商品显示标签publicsale2(){label1=newJLabel(按编号查询,JLabel.CENTER);label2=newJLabel(按帐单查询,JLabel.CENTER);field1=newJTextField(30);field2=newJTextField(30);button1=newJButton(查询1);button2=newJButton(查询2);sM.setLayout(null);field1.setBounds(100,120,150,22);field2.setBounds(600,120,150,22);label1.setBounds(100,90,150,30);label2.setBounds(600,90,150,30);button1.setBounds(260,120,80,22);button2.setBounds(760,120,80,22);button1.addActionListener(this);---本文来源于网络，仅供参考，勿照抄，如有侵权请联系删除---button2.addActionListener(this);sM.add(label1);sM.add(label2);sM.add(field1);sM.add(field2);sM.add(button1);sM.add(button2);for(inti=0;i《4;i++){pS[i].setBounds(550+i*110,50,100,22);sM.add(pS[i]);pS[i].addActionListener(this);}for(inti=0;i《7;i++)//6个标签的绘制{CD[i].setBounds(100+i*115,160,115,20);sM.add(CD[i]);}jsp.setBounds(100,180,800,500);goodsShosetLineWrap(true);addWindowListener(newWindowAdapter(){publicvoidwindowClosing(WindowEvente){---本文来源于网络，仅供参考，勿照抄，如有侵权请联系删除---System.exit(0);}});sM.add(jsp);this.add(sM);this.setTitle(销售窗口);this.setResizable(false);this.setBounds(0,0,1024,768);this.setVisible(true);}publicvoidactionPerformed(ActionEventp){Connectioncon,con1;Statementsql,sql1;Stringurl=jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=D:\upermarket.mdb;ResultSetrs,rs1;if(p.getSource()==button1){Stringnum=field1.getText();try{Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);}catch(ClassNotFoundExceptionf){System.out.println(+f);---本文来源于网络，仅供参考，勿照抄，如有侵权请联系删除---}try{con=DriverManager.getConnection(url);sql=con.createStatement();rs=sql.executeQuery(SELECTcount(goodsnum)FROMinformationwheregoodsnum=+num+);while(rs.next()){countBG=rs.getInt(1);System.out.println(countBG);}rs=sql.executeQuery(SELECT*FROMgoodswherenum=+num+);while(rs.next()){name=rs.getString(2);price=rs.getInt(3);time=rs.getString(4);add=rs.getString(5);n1=1;---本文来源于网络，仅供参考，勿照抄，如有侵权请联系删除---}con.close();}catch(SQLExceptiong){System.out.println(g);}if(n1==1){goodsShoappend(（物品销售量查询）+num++name++price++time++add++countBG+\n);n1=0;}else{//goodsShosetText();num=null;name=null;price=0;time=null;add=null;JOptionPane.showMessageDialog(this,输入错误\n请重新输入,提示,JOptionPane.WARNING_MESSAGE);}}if(p.getSource()=...