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

1、数据库课程设计商品销售管理系统import java.awt.event.*;import java.awt.*;import javax.swing.*;import java.sql.*;import javax.swing.table.AbstractTableModel;public class LoginBackPanel extends JFrame implements ActionListenerprivate static final long serialVersionUID = 1L;JButton button1,button2;JTextField F1;Choice

2、 c;Container ct = getContentPane(); public LoginBackPanel(String str)super(str);setBak(); JPanel panel = new JPanel(); panel.setOpaque(false); ct.add(panel); panel.setLayout(new FlowLayout(FlowLayout.CENTER,60,20);c = new Choice();c.add( Boss );c.add( Salesman );JLabel J1 = new JLabel(验证身份:);JLabel

3、J2 = new JLabel(登录密码:);F1 = new JTextField(9);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() /设置背景方法 (JPa

4、nel)this.getContentPane().setOpaque(false);ImageIcon 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(Acti

5、onEvent e)if(e.getSource()=button1)if(c.getSelectedItem().equals( 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(销售员界

6、面);sl.setSize(500,250);sl.setLocation(450,250);sl.setVisible(true);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(

7、true); class BS extends JFrame implements ActionListenerJButton B1,B2,B3,B4,B5,B6,B7;Container ct = getContentPane(); public BS(String str)super(str);setBak(); JPanel JP = new JPanel(); JP.setOpaque(false); ct.add(JP);JP.setLayout(new FlowLayout(FlowLayout.CENTER,30,50);B1 = new JButton(销售情况);B2 = n

8、ew JButton(客户退货);B3 = new JButton(销售收款);B4 = new JButton(客户信息);B5 = new JButton(员工管理);B6 = new JButton(进货信息);B7 = new JButton(更换角色);B1.addActionListener(this);B2.addActionListener(this);B3.addActionListener(this);B4.addActionListener(this);B5.addActionListener(this);B6.addActionListener(this);B7.add

9、ActionListener(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() (JPanel)this.getContentPane().setOpaque(false);ImageIcon img = new ImageIcon(e:/数据库课程设计/六月物语1.jpg); JLabel background = new JLabel(img);this.getLayeredPane().add(background

10、, new Integer(Integer.MIN_VALUE); background.setBounds(0, 0, img.getIconWidth(), img.getIconHeight();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.ge

11、tSource()=B2)this.dispose();XSTHXX xsthxx = 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.ge

12、tSource()=B4)this.dispose();HYXXCX hyxxcx = 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()=

13、B6)this.dispose();JHXX jhxx = new JHXX(商品更新【进货信息】);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 AbstractTableMo

14、delString rq,ph,mc,bh,dj,sl,je;final String columnNames=开票日期,销售票号,商品名称,商品编号,商品单价/元,销售数量/个,销售金额/元;Objectdata=new Object1007;public BG2()int m=0;String url=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=课程设计;Connection con;String sql;Statement stmt;tryClass.forName(com.microsoft.jdbc.sqlserver.

15、SQLServerDriver);catch(java.lang.ClassNotFoundException e)trycon=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.getStrin

16、g(5);sl=rs.getString(6);je=rs.getString(7);datam0=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 getColum

17、nName(int col)return columnNamescol;public Object 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 JF

18、rame implements ActionListenerBG2 bg2;JTable t;JButton 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,Sout

19、h);public void actionPerformed(ActionEvent e)if(e.getSource()=b)this.dispose();BS cxfpxx = new BS(管理员界面);cxfpxx.setSize(500,250);cxfpxx.setLocation(450,250);cxfpxx.setVisible(true);class BG3 extends AbstractTableModelString rq,mc,yy,sl,je;final String columnNames=退货日期,商品名称,退货原因,退货数量/件,退货金额/元;Objectd

20、ata=new Object1005;public BG3()int m=0;String url=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=课程设计;Connection con;String sql;Statement stmt;tryClass.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);catch(java.lang.ClassNotFoundException e)trycon=DriverManager.getConnection(url,sa,1234

21、56);stmt=con.createStatement();sql=SELECT * FROM 退货记录 ;ResultSet rs=stmt.executeQuery(sql);while(rs.next()rq=rs.getString(1);mc=rs.getString(2);yy=rs.getString(3);sl=rs.getString(4);je=rs.getString(5);datam0=rq;datam1=mc;datam2=yy;datam3=sl;datam+4=je;stmt.close();con.close();catch(SQLException e)Sy

22、stem.out.println(0);public int getColumnCount()return columnNames.length;public int getRowCount()return data.length;public String getColumnName(int col)return columnNamescol;public Object getValueAt(int row,int col)return datarowcol;public void setValueAt(Object value,int row,int col)int numRows=get

23、RowCount();int numCols=getColumnCount();for(int i=0;inumRows;i+)for(int j=0;jnumCols;j+)System.out.print( +dataij);class XSTHXX extends JFrame implements ActionListenerBG3 bg3;JTable t;JButton b;JPanel p;JScrollPane s;public XSTHXX(String str)super(str);setLayout(new BorderLayout();b = new JButton(确

24、定);b.addActionListener(this);p = new JPanel();p.add(b);bg3 = new BG3();t = new JTable(bg3);s = new JScrollPane(t);add(s,Center);add(p,South);public void actionPerformed(ActionEvent e)if(e.getSource()=b)this.dispose();BS cxfpxx = new BS(管理员界面);cxfpxx.setSize(500,250);cxfpxx.setLocation(450,250);cxfpx

25、x.setVisible(true);class BG4 extends AbstractTableModelString rq,mc,dj,sl,je;final String columnNames=开票日期,商品名称,商品单价/元,销售数量/个,销售金额/元;Objectdata=new Object1005;public BG4()int m=0;String url=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=课程设计;Connection con;String sql;Statement stmt;tryClass.f

26、orName(com.microsoft.jdbc.sqlserver.SQLServerDriver);catch(java.lang.ClassNotFoundException e)trycon=DriverManager.getConnection(url,sa,123456);stmt=con.createStatement();sql=SELECT 开票日期,商品名称,商品单价/元,销售数量/个,销售金额/元 FROM 销售发票 ;ResultSet rs=stmt.executeQuery(sql);while(rs.next()rq=rs.getString(1);mc=rs.

27、getString(2);dj=rs.getString(3);sl=rs.getString(4);je=rs.getString(5);datam0=rq;datam1=mc;datam2=dj;datam3=sl;datam+4=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 g

28、etColumnName(int col)return columnNamescol;public Object 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 XSXXCX extends JFrame implements ActionListenerBG4 bg4;JTable t;JButton b;JPanel p;J