2022年超市商品管理系统源代码 .pdf

《2022年超市商品管理系统源代码 .pdf》由会员分享，可在线阅读，更多相关《2022年超市商品管理系统源代码 .pdf（14页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、 import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class sale2 extends JFrame implements ActionListener /销售界面 private JPanel sM=new JPanel(); /supermarket面板JLabel label1,label2; JTextField field1,field2; JButton button1,button2; String num=null,name=null,tim

2、e=null,add=null,t1=null,t2=null,t3=null; int price=0,countBG,n1;/ 价格 / 商品的卖出数量private JTextArea goodsShow=new JTextArea(); / 文本区private JScrollPane jsp=new JScrollPane(goodsShow); /滚动区域设定内容为商品显示的文本区private JButton pS=new JButton("销售界面 "), new JButton("销售管理 "), new JButton("商

3、品管理 "), new JButton("用户管理 "); /personty 按钮private JLabel CD=new JLabel("清单号 ",JLabel.CENTER), new JLabel("编号 ",JLabel.CENTER), new JLabel("名称 ",JLabel.CENTER), new JLabel("价格 ",JLabel.CENTER), new JLabel("生产日期 ",JLabel.CENTER), new JLa

4、bel("产地 ",JLabel.CENTER), new JLabel("数量 ",JLabel.CENTER); / 帐单查询时的商品显示标签public sale2() label1=new JLabel("按编号查询 ",JLabel.CENTER); label2=new JLabel("按帐单查询 ",JLabel.CENTER); field1=new JTextField(30); field2=new JTextField(30); button1=new JButton("查询 1&q

5、uot;); button2=new JButton("查询 2"); sM.setLayout(null); field1.setBounds(100,120,150,22); field2.setBounds(600,120,150,22); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 1 页，共 14 页 - - - - - - - - - label1.setBounds(100,90,150,30); label2.setBounds(600,90,

6、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(int i=0;i<4;i+) pSi.setBounds(550+i*110,50,100,22);

7、sM.add(pSi); pSi.addActionListener(this); for(int i=0;i<7;i+) /6个标签的绘制 CDi.setBounds(100+i*115,160,115,20); sM.add(CDi); jsp.setBounds(100,180,800,500); goodsShow.setLineWrap(true); addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) System.exit(0); ); sM.add(jsp); this

8、.add(sM); this.setTitle("销售窗口 "); this.setResizable(false); this.setBounds(0,0,1024,768); this.setVisible(true); public void actionPerformed(ActionEvent p) Connection con,con1; 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 2 页，共 14 页 - - - - - - - - - Stat

9、ement sql,sql1; String url = "jdbc:odbc:driver=Microsoft Access Driver (*.mdb);DBQ=D:supermarket.mdb" ResultSet rs,rs1; if (p.getSource()=button1) String num=field1.getText(); try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); catch (ClassNotFoundException f) System.out.println(&

10、quot;"+f); try con=DriverManager.getConnection(url); sql=con.createStatement(); rs=sql.executeQuery("SELECT count(goodsnum) FROM information where goodsnum='"+num+"'"); while(rs.next() countBG=rs.getInt(1); System.out.println(countBG); rs=sql.executeQuery("SELEC

11、T * FROM goods where num='"+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 (SQLException g) 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 3 页，共 14 页 - - -

12、 - - - - - - System.out.println(g); if (n1=1) goodsShow.append(" （物品销售量查询） "+num+" "+name+" "+price+" "+time+" "+add+" "+countBG+"n"); n1=0; else /goodsShow.setText(" "); num=null;name=null;price=0;time=null;add=null; JO

13、ptionPane.showMessageDialog(this," 输 入 错 误 n 请重新输入 ","提示 ",JOptionPane.WARNING_MESSAGE); if(p.getSource()=pS0) View2 frame=new View2(); dispose(); if(p.getSource()=pS2) Frm_Main frame=new Frm_Main(); dispose(); if(p.getSource()=pS3) View3 frame=new View3(); dispose(); if (p.getSo

14、urce()=button2) String numb=field2.getText(); int num=Integer.parseInt(numb); try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); catch (ClassNotFoundException f) 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 4 页，共 14 页 - - - - - - - - - System.out.println(

15、""+f); try con=DriverManager.getConnection(url); sql=con.createStatement(); rs=sql.executeQuery("SELECT goodsnum,count(goodsnum) FROM information where listnum="+num+" group by goodsnum"); while(rs.next() con1=DriverManager.getConnection(url); sql1=con1.createStatement(

16、); String number=rs.getString(1); countBG=rs.getInt(2); System.out.println(countBG+number+name+time+price+add); rs1=sql1.executeQuery("SELECT * FROM goods where num='"+number+"'"); while (rs1.next() name=rs1.getString(2); price=rs1.getint(3); time=rs1.getString(4); add=rs

17、1.getString(5); goodsShow.append(" "+num+" "+number+" "+name+" "+price+" "+time+" "+add+" "+countBG+"n"); con1.close(); con.close(); catch (SQLException g) System.out.println(g); / / goodsShow.setText(" "); / n

18、um=null;name=null;price=0;time=null;add=null; / JOptionPane.showMessageDialog(this," 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 5 页，共 14 页 - - - - - - - - - 输入错误n 请重新输入","提示",JOptionPane.WARNING_MESSAGE); / public class View2 extends JFrame im

19、plements ActionListener /销售界面 String num=null,name=null,time=null,add=null,t1=null,t2=null,t3=null; int price=0; int n1,n2,ap,n3; private JPanel sM=new JPanel(); /supermarket面板private JButton pS=new JButton("销售界面 "),new JButton("销售管理"), new JButton("商品管理 "),new JButton(

20、"权限管理 ");/personty 按钮private JTextArea goodsShow=new JTextArea(), searchShow=new JTextArea(); /文本区private JScrollPane jsp=new JScrollPane(goodsShow); /滚动区域设定内容为商品显示的文本区private JTextField numSearch=new JTextField(),showGoods=new JTextField(); /商品查询 / 显示商品private JButton searchGoods=new JBut

21、ton("搜索"),buyGoods=new JButton("购买 "), clean=new JButton("清空 "), ok=new JButton("提交 "),print=new JButton("打印并提交 "); /查询按钮private JLabel goodsInformation=new JLabel("商品编码",JLabel.CENTER),new JLabel("商品名称 ",JLabel.CENTER), new JLabe

22、l("商 品 价 格 ",JLabel.CENTER),new JLabel("生 产 日 期",JLabel.CENTER),new JLabel("生产地 ",JLabel.CENTER) ; private JLabel goodsI=new JLabel("商 品 编 码 ",JLabel.CENTER),new JLabel("商品名称 ",JLabel.CENTER), new JLabel("商 品 价 格 ",JLabel.CENTER),new JLabel

23、("生 产 日 期",JLabel.CENTER),new JLabel("生产地 ",JLabel.CENTER) ; private JLabel allPrice=new JLabel("商品总价：n ",JLabel.LEFT),label1=new JLabel("商品信息名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 6 页，共 14 页 - - - - - - - - - ",JLabel.

24、RIGHT),label2=new JLabel("购物信息 ",JLabel.RIGHT); public View2() sM.setLayout(null); for(int i=0;i<4;i+) pSi.setBounds(550+i*110,50,100,22); sM.add(pSi); pSi.addActionListener(this); jsp.setBounds(100,180,800,500); goodsShow.setLineWrap(true); numSearch.setBounds(100,50,150,22); searchGoo

25、ds.setBounds(260,50,60,22); searchGoods.addActionListener(this); buyGoods.setBounds(330,50,60,22); buyGoods.addActionListener(this); showGoods.setBounds(100,120,800,22); for (int b=0;b<5 ;b+ ) goodsInformationb.setBounds(100+160*b,87,160,30); sM.add(goodsInformationb); for (int b=0;b<5 ;b+ ) g

26、oodsIb.setBounds(100+160*b,150,160,30); sM.add(goodsIb); clean.setBounds(100,690,100,22); clean.addActionListener(this); ok.setBounds(690,690,100,22); ok.addActionListener(this); print.setBounds(800,690,100,22); print.addActionListener(this); allPrice.setBounds(900,480,100,50); label1.setBounds(20,1

27、20,80,22); label2.setBounds(20,180,80,22); sM.add(label1); sM.add(label2); sM.add(allPrice); sM.add(print); sM.add(ok); sM.add(showGoods); sM.add(clean); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 7 页，共 14 页 - - - - - - - - - sM.add(numSearch ); sM.add(searchGood

28、s); sM.add(buyGoods); sM.add(jsp); addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) Connection con; Statement sql; ResultSet rs; try if (n3!=0) int a1=0; con=DriverManager.getConnection("jdbc:odbc:q","",""); sql=con.createStatement(); rs=sq

29、l.executeQuery("SELECT MAX(编号 ) from information"); while(rs.next() a1=rs.getInt(1); for (int i=0;i<n3 ;i+ ) sql.executeUpdate("delete from information where 编号 ="+(a1-i); con.close(); ap=0; num=null;name=null;price=0;time=null;add=null;n3=0; goodsShow.setText(null); catch (SQ

30、LException g) System.out.println(g); System.exit(0); ); this.add(sM); this.setTitle("销售窗口 "); this.setResizable(false); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 8 页，共 14 页 - - - - - - - - - this.setBounds(0,0,1024,768); this.setVisible(true); validate

31、(); if(p.getSource()=buyGoods) /购买按键 try if (num!=null) con=DriverManager.getConnection("jdbc:odbc:q","",""); sql=con.createStatement(); sql.executeUpdate("insert into information(listnum,goodsnum) values('"+n2+"','"+num+"')"

32、;); rs=sql.executeQuery("SELECT * FROM information where listnum="+n2); n3+;/记录购买商品个数con.close(); goodsShow.append(" "+num+" "+name+" "+price+" "+time+" "+add+"n"); else JOptionPane.showMessageDialog(this,"请选择商品","提

33、示",JOptionPane.WARNING_MESSAGE); ap=ap+price;/总价allPrice.setText("商品总价： n"+ap); catch (SQLException g) System.out.println(g); if(p.getSource()=ok) try if (n3!=0) con=DriverManager.getConnection("jdbc:odbc:q","",""); sql=con.createStatement(); sql.executeU

34、pdate("insert into information(listnum,allprice) values('"+n2+"','"+ap+"')"); rs=sql.executeQuery("SELECT * FROM information where listnum="+n2); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 9 页，共 14 页 - - - -

35、 - - - - - con.close(); ap=0; num=null;name=null;price=0;time=null;add=null;n3=0; goodsShow.setText(null); n2+;/帐单号 else JOptionPane.showMessageDialog(this,"请购买商品","提示",JOptionPane.WARNING_MESSAGE); catch (SQLException g) System.out.println(g); if(p.getSource()=print) try if (n3!

36、=0) con=DriverManager.getConnection("jdbc:odbc:q","",""); sql=con.createStatement(); sql.executeUpdate("insert into information(listnum,allprice) values('"+n2+"','"+ap+"')"); rs=sql.executeQuery("SELECT * FROM informati

37、on where listnum="+n2); con.close(); ap=0; num=null;name=null;price=0;time=null;add=null;n3=0; goodsShow.setText(null); n2+;/帐单号 else JOptionPane.showMessageDialog(this,"请购买商品","提示",JOptionPane.WARNING_MESSAGE); catch (SQLException g) System.out.println(g); 名师资料总结 - - -精品资料欢

38、迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 10 页，共 14 页 - - - - - - - - - if(p.getSource()=clean) try if (n3!=0) int a1=0; con=DriverManager.getConnection("jdbc:odbc:q","",""); sql=con.createStatement(); rs=sql.executeQuery("SELECT MAX(编号 ) from

39、information"); while(rs.next() a1=rs.getInt(1); for (int i=0;i<n3 ;i+ ) sql.executeUpdate("delete from information where 编号 ="+(a1-i); con.close(); ap=0; num=null;name=null;price=0;time=null;add=null;n3=0; goodsShow.setText(null); catch (SQLException g) System.out.println(g); publi

40、c class Login extends Frame implements ActionListener,WindowListener /登陆界面 public int screanWidth,screanHeight; String idin=null; String keyin=null; String passwordD=null; public static String persontyD=null; MenuBar menubar; Menu menu; MenuItem quet,help; Label id,key; TextField idtf,keytf; Box box

41、V1,boxV2,boxV3,baseBox,boxx; Button enterB; Login() setTitle("超市管理系统登陆界面"); Toolkit tool=getToolkit(); Dimension dim=tool.getScreenSize(); screanWidth=dim.width; screanHeight=dim.height; setBounds(dim.width/3,dim.height/3,320,215); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名

42、师精心整理 - - - - - - - 第 11 页，共 14 页 - - - - - - - - - menubar=new MenuBar(); menu=new Menu(" 功能 "); help=new MenuItem("帮助 "); quet=new MenuItem("退出 "); quet.setShortcut(new MenuShortcut(KeyEvent.VK_E); quet.addActionListener(new ActionListener() /匿名类实例控制 public void actio

43、nPerformed(ActionEvent p) System.exit(0); ); menu.add(help); menu.add(quet); menubar.add(menu); setMenuBar(menubar); id=new Label("请输入帐号： ",Label.RIGHT); key=new Label("请输入密码： ",Label.RIGHT); idtf=new TextField(10); keytf=new TextField(10); keytf.setEchoChar('*'); enterB=

44、new Button("登陆 "); boxV1=Box.createVerticalBox(); boxV1.add(Box.createVerticalStrut(35); boxV1.add(id); boxV1.add(Box.createVerticalStrut(15); boxV1.add(key); boxV1.add(Box.createVerticalStrut(15); boxV2=Box.createVerticalBox(); boxV2.add(Box.createVerticalStrut(35); boxV2.add(idtf); boxV2

45、.add(Box.createVerticalStrut(15); boxV2.add(keytf); boxV2.add(Box.createVerticalStrut(15); baseBox=Box.createHorizontalBox(); baseBox.add(Box.createHorizontalStrut(25); baseBox.add(boxV1); baseBox.add(Box.createHorizontalStrut(5); baseBox.add(boxV2); baseBox.add(Box.createHorizontalStrut(70); boxV3=

46、Box.createHorizontalBox(); boxV3.add(Box.createHorizontalStrut(125); boxV3.add(enterB); boxV3.add(Box.createHorizontalStrut(125); boxx=Box.createVerticalBox(); boxx.add(baseBox); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 12 页，共 14 页 - - - - - - - - - boxx.add(Bo

47、x .createVerticalStrut(15); boxx.add(boxV3); boxx.add(Box.createVerticalStrut(70); add(boxx); enterB.addActionListener(this); addWindowListener(this); setResizable(false); setVisible(true); public void actionPerformed(ActionEvent e) Connection con; Statement sql; ResultSet rs; if (e.getSource()=ente

48、rB) idin=idtf.getText(); keyin=keytf.getText(); try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); catch (ClassNotFoundException f) System.out.println(""+f); try con=DriverManager.getConnection("jdbc:odbc:q","",""); sql=con.createStatement(); rs=sql.

49、executeQuery("SELECT * FROM password where ID='"+idin+"'"); while(rs.next() passwordD=rs.getString(2); persontyD=rs.getString(3); con.close(); catch (SQLException g) System.out.println(g); if (keyin.equals(passwordD) View2 frame=new View2(); this.setVisible(false); else J

50、OptionPane.showMessageDialog(this," 帐 户或密码错 误 n 请重新输入 ","提示 ",JOptionPane.WARNING_MESSAGE); public void windowActivated(WindowEvent o) validate(); public void windowDeactivated(WindowEvent o) setBounds(screanWidth/3,screanHeight/3,320,215); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - -