1、button1=new JButton(登录);button2=new JButton(退出);button1.addActionListener(this);button2.addActionListener(this);panel.add(J1);panel.add(c);panel.add(J2);panel.add(F1);panel.add(button1);panel.add(button2);add(panel);public void setBak()/设置背景方法 (JPanel)this.getContentPane().setOpaque(false);ImageIcon
2、 img=new ImageIcon(e:/数据库课程设计/六月物语.jpg);JLabel background=new JLabel(img);this.getLayeredPane().add(background,new Integer(Integer.MIN_VALUE);background.setBounds(0,0,img.getIconWidth(),img.getIconHeight();public void actionPerformed(ActionEvent e)if(e.getSource()=button1)if(c.getSelectedItem().equa
3、ls(Boss)&F1.getText().equals(boss)this.dispose();BS bs=new BS(管理员界面);bs.setSize(500,250);bs.setLocation(450,250);bs.setVisible(true);if(c.getSelectedItem().equals(Salesman)&F1.getText().equals(salesman)this.dispose();SL sl=new SL(销售员界面);sl.setSize(500,250);sl.setLocation(450,250);sl.setVisible(true)
4、;if(e.getSource()=button2)System.exit(0);public static void main(Stringargs)LoginBackPanel lgp=new LoginBackPanel(管理系统登录);lgp.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);lgp.setSize(300,200);lgp.setLocation(550,250);lgp.setVisible(true);class BS extends JFrame implements ActionListener JButton B1
5、,B2,B3,B4,B5,B6,B7;public BS(String str)super(str);JPanel JP=new JPanel();JP.setOpaque(false);ct.add(JP);JP.setLayout(new FlowLayout(FlowLayout.CENTER,30,50);B1=new JButton(销售情况);B2=new JButton(客户退货);B3=new JButton(销售收款);B4=new JButton(客户信息);B5=new JButton(员工管理);B6=new JButton(进货信息);B7=new JButton(更
6、换角色);B1.addActionListener(this);B2.addActionListener(this);B3.addActionListener(this);B4.addActionListener(this);B5.addActionListener(this);B6.addActionListener(this);B7.addActionListener(this);JP.add(B1);JP.add(B2);JP.add(B3);JP.add(B4);JP.add(B5);JP.add(B6);JP.add(B7);add(JP);public void setBak()(
7、JPanel)this.getContentPane().setOpaque(false);/数据库课程设计/六月物语 1.jpg);public void actionPerformed(ActionEvent e)if(e.getSource()=B1)this.dispose();CXFPXX cxfpxx=new CXFPXX(日常销售【发票情况】);cxfpxx.setSize(700,300);cxfpxx.setLocation(350,250);cxfpxx.setVisible(true);if(e.getSource()=B2)this.dispose();XSTHXX x
8、sthxx=new XSTHXX(日常销售【销售退货】);xsthxx.setSize(700,300);xsthxx.setLocation(350,250);xsthxx.setVisible(true);if(e.getSource()=B3)this.dispose();XSXXCX xsxxcx=new XSXXCX(日常销售【销售收款】);xsxxcx.setSize(700,300);xsxxcx.setLocation(350,250);xsxxcx.setVisible(true);if(e.getSource()=B4)this.dispose();HYXXCX hyxxc
9、x=new HYXXCX(基本信息管理【会员信息】);hyxxcx.setSize(700,300);hyxxcx.setLocation(350,250);hyxxcx.setVisible(true);if(e.getSource()=B5)this.dispose();YGGL yggl=new YGGL(员工管理【员工信息】);yggl.setSize(500,200);yggl.setLocation(450,250);yggl.setVisible(true);if(e.getSource()=B6)this.dispose();JHXX jhxx=new JHXX(商品更新【进货
10、信息】);jhxx.setSize(300,150);jhxx.setLocation(500,250);jhxx.setVisible(true);if(e.getSource()=B7)this.dispose();LoginBackPanel xt=new LoginBackPanel(管理系统登录);xt.setSize(300,200);xt.setLocation(550,250);xt.setVisible(true);class BG2 extends AbstractTableModel String rq,ph,mc,bh,dj,sl,je;final String col
11、umnNames=开票日期,销售票号,商品名称,商品编号,商品单价/元,销售数量/个,销售金额/元;Objectdata=new Object1007;public BG2()int m=0;String url=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=课程设计;Connection con;String sql;Statement stmt;try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);catch(java.lang.ClassNotFound
12、Exception e)try con=DriverManager.getConnection(url,sa,123456);stmt=con.createStatement();sql=SELECT*FROM 销售发票;ResultSet rs=stmt.executeQuery(sql);while(rs.next()rq=rs.getString(1);ph=rs.getString(2);mc=rs.getString(3);bh=rs.getString(4);dj=rs.getString(5);sl=rs.getString(6);je=rs.getString(7);datam
13、0=rq;datam1=ph;datam2=mc;datam3=bh;datam4=dj;datam5=sl;datam+6=je;stmt.close();con.close();catch(SQLException e)System.out.println(0);public int getColumnCount()return columnNames.length;public int getRowCount()return data.length;public String getColumnName(int col)return columnNamescol;public Objec
14、t getValueAt(int row,int col)return datarowcol;public void setValueAt(Object value,int row,int col)int numRows=getRowCount();int numCols=getColumnCount();for(int i=0;inumRows;i+)for(int j=0;jnumCols;j+)System.out.print(+dataij);class CXFPXX extends JFrame implements ActionListener BG2 bg2;JTable t;J
15、Button b;JPanel p;JScrollPane s;public CXFPXX(String str)super(str);setLayout(new BorderLayout();b=new JButton(确定);b.addActionListener(this);p=new JPanel();p.add(b);bg2=new BG2();t=new JTable(bg2);s=new JScrollPane(t);add(s,Center);add(p,South);public void actionPerformed(ActionEvent e)if(e.getSourc
16、e()=b)this.dispose();BS cxfpxx=new BS(管理员界面);cxfpxx.setSize(500,250);cxfpxx.setLocation(450,250);class BG3 extends AbstractTableModel String rq,mc,yy,sl,je;final String columnNames=退货日期,商品名称,退货原因,退货数量/件,退货金额/元;Objectdata=new Object1005;public BG3()int m=0;sql=SELECT*FROM 退货记录;mc=rs.getString(2);yy=r
17、s.getString(3);sl=rs.getString(4);je=rs.getString(5);datam1=mc;datam2=yy;datam3=sl;datam+4=je;class XSTHXX extends JFrame implements ActionListener BG3 bg3;public XSTHXX(String str)super(str);bg3=new BG3();t=new JTable(bg3);class BG4 extends AbstractTableModel String rq,mc,dj,sl,je;final String colu
18、mnNames=开票日期,商品名称,商品单价/元,销售数量/个,销售金额/元;public BG4()int m=0;sql=SELECT 开票日期,商品名称,商品单价/元,销售数量/个,销售金额/元 FROM 销售发票;dj=rs.getString(3);datam2=dj;class XSXXCX extends JFrame implements ActionListener BG4 bg4;public XSXXCX(String str)super(str);bg4=new BG4();t=new JTable(bg4);class BG5 extends AbstractTabl
19、eModel String ch,lx,dz,rq;final String columnNames=客户称呼,联系方式,客户地址,入会日期;Objectdata=new Object1004;public BG5()int m=0;sql=SELECT*FROM 客户信息;while(rs.next()ch=rs.getString(1);lx=rs.getString(2);dz=rs.getString(3);rq=rs.getString(4);datam0=ch;datam1=lx;datam2=dz;datam+3=rq;class HYXXCX extends JFrame implements ActionListener BG5 bg5;public HYXXCX(String st
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1