数据库课程设计商品销售管理系统.docx

数据库课程设计商品销售管理系统importjava.awt.*;importjavax.swing.*;importjava.sql.*;importjavax.swing.table.AbstractTabIeModel;publicclassLoginBackPanelextendsJFrameimplementsActionListenerprivatestaticfinallongSeriaIVersionUID=IL;JButtonbutton1,button2;JTextFieldFl;Choicec;Containerct=getContentPane();publicLoginBackPaneKStringstr)super(str);setBak();JPanelpanel=newJPanel();panel.setpaque(false);ct.add(panel);panel.setLayout(newFIOWLayoUt(FIoWLayOUt.CENTER,60,20);c=newChoice();c.add("Boss");c.add(Salesman");JLabelJl=newJLabeI("验证身份:")；JLabelJ2=newJLabe1("登录密码巧；Fl=newJTextField(9);button1=newJBUItOn("登录")；button2=newJBUtlon("退出")；button1.addActionListener(this);button2.addActionListener(this);panel.add(JI);panel.add(c);panel.add(J2);panel.add(Fl);panel.add(buttonl);panel.add(button2);add(panel);)publicvoidsetBak()设置背景方法(JPanel)this.getContentPane().setOpaque(false);Imageiconimg=newImagelCOn("e:数据库课程设计六月物语Jpg");JLabelbackground=newJLabel(img);this.getLayeredPane().add(background,newInteger(Integer.MIN-VALUE);background.setBounds(0,0,img.getIconWidth(),img.getIconHeight();publicvoidactionPerformed(ActionEvente)if(e.getSource()=button1)Bossif(c.getSelectedItem().equals(H°)&&F1.getText().equals(',boss")this.dispose();BSbs=newBS("管理员界面");bs.setSize(500,250);bs.setLocation(450,250);bs.setVisible(true);)Salesmanif(c.getSelectedItem().equals(H°)&&F1.getText().equals("salesman")(this.dispose();SLSI=newSLf销售员界面”)；sl.setSize(500,250);sl.setLocation(450,250);sl.setVisible(true);)1if(e.getSource()=button2)System.exit(O);publicstaticvoidmain(Stringargs)1.oginBackPanellgp=newLOginBaCkPane1("管理系统登录");lgp.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);lgp.setSize(300,200);lgp.setLocation(550,250);lgp.setVisible(true);classBSextendsJFrameimplementsActionListenerJButtonB1,B2,B3,B4,B5,B6,B7;Containerct=getContentPane();publicBS(Stringstr)super(str);setBak();JPanelJP=newJPanel();JP.setOpaque(false);ct.add(JP);JP.setLayout(newFlOWLayoUt(FlOWLayoUt.CENTER,30,50);Bl=newJBUtton("销售情况")；B2=newJBUtlon(“客户退货”)；B3=newJBUttonC'销售收款”);B4=newJBUtKm(“客户信息”)；B5=newJButlon("员工管理”)；B6=newJBUuon("进货信息")；B7=newJBUuOn(“更换角色”)；B1.addActionListener(this);B2.addActionListener(this);B3.addActionListener(this);B4.addActionListener(this);B5.addActionListener(this);B6.addActionListener(this);B7.addActionListener(this);JRadd(Bl);JRadd(B2);JP.add(B3);JP.add(B4);JP.add(B5);JP.add(B6);JP.add(B7);add(JP);publicvoidsetBak()(JPanel)this.getContentPane().setOpaque(false);Imageiconimg=newImageICon("e:数据库课程设计六月物语1.jpg");JLabelbackground=newJLabel(img);this.getLayeredPane().add(background,newInteger(Integer.MIN-VALUE);background.setBounds(0,O,img.getlconWidth(),img.getIconHeight();(publicvoidactionPerformed(ActionEvente)if(e.getSource()=B1)this.dispose();CXFPXXcxfpxx=newCXFPXX("日常销售一发票情况】")；cxfpxx.setSize(700,300);cxfpxx.setLocation(350,250);cxfpxx.setVisible(true);)if(e.getSource()=B2)this.dispose();XSTHXXXSthXX=newXSTHXX("日常销售一【销售退货】")；xsthxx.setSize(700,300);xsthxx.setLocation(350,250);xsthxx.setVisible(te);)if(e.getSource()=B3)this.dispose();XSXXCXXSXXCX=newXSXXCX("日常销售一【销售收款】")；xsxxcx.setSize(700,300);xsxxcx.setLocation(350,250);xsxxcx.setVisible(true);)if(e.getSource()=B4)this.dispose();HYXXCXhyXXCX=newHYXXCX("基本信息管理一【会员信息】");hyxxcx.setSize(700,300);hyxxcx.setLocation(350,250);hyxxcx.setVisible(true);)if(e.getSource()=B5)this.dispose();YGGLyggl=newYGGLf员工管理一【员工信息】")；yggl.setSize(500,200);yggl.setLocation(450,250);yggl.setVisible(true);if(e.getSource()=B6)this.dispose();JHXXjhXX=newJHXX("商品更新一【进货信息】")；jhxx.setSize(300,l50);jhxx.setLocation(500,250);jhxx.setVisible(true);)if(e.getSource()=B7)this.dispose();1.oginBackPanelxt=newLOginBaCkPane1("管理系统登录");xt.setSize(3OO,2OO);xt.setLocation(550,250);xt.setVisible(true);classBG2extendsAbstractTableModeIStringrq,ph,mc,bh,dj,sl,je;finalStringCOlumnNamesR”开票日期”,“销售票号”,嘀品名称",”商品编号”J商品单价/元/销售数量/个”,”销售金额/元”；Objectdata=new0bject1007;publicBG2()intm=0;StringIIrI="jdbc:microsoft:SqISerVer:IOCalhoSt:1433;DaIabaSeName=课程设计”；Connectioncon;Stringsql;Statementstmt;try(Class.forName(',com.microsoft.jdbc.sqlserver.SQLServerDriver");catch(java.lang.ClassNotFoundExceptione)trycon=DriverManager.getConnection(url,"sa","l23456,');stmt=con.createStatement();sql=,SELECT*FROM销售发票"ResultSetrs=stmt.executeQuery(sql);while(rs.next()rq=rs.getString(l);ph=rs.getString(2);mc=rs.getString(3);bh=rs.getString(4);dj=rs.getString(5);sl=rs.getString(6);je=rs.getString(7);datam0=rq;dataml=ph;datam2=mc;datam3=bh;datam4=dj;datam5=sl;datam+6=je;)stmt.close();con.close();)catch(SQLException