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

import java awt event import java awt import javax swing import java sql import javax swing table AbstractTableModel public class LoginBackPanel extends JFrame implements ActionListener private static final long serialVersionUID 1L JButton button1 button2 JTextField F1 Choice 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 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 设置背景方法 JPanel 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 ActionEvent e if e getSource button1 if c getSelectedItem equals Boss BS bs new BS 管理员界面 bs setSize 500 250 bs setLocation 450 250 bs setVisible true if c getSelectedItem equals Salesman SL sl new SL 销售员界面 sl setSize 500 250 sl setLocation 450 250 sl setVisible true if e getSource button2 System exit 0 public static void main String args 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 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 new 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 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 JPanel this getContentPane setOpaque false ImageIcon img new ImageIcon e 数据库课程设计 六月物语 1 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 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 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 getSource 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 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 AbstractTableModel String rq ph mc bh dj sl je final String columnNames 开票日期 销售票号 商品名称 商品编号 商品单价 元 销售数量 个 销售金额 元 Object data new Object 100 7 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 ClassNotFoundException e try con DriverManager getConnection url sa 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 data m 0 rq data m 1 ph data m 2 mc data m 3 bh data m 4 dj data m 5 sl dat a m 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 columnNames col public Object getValueAt int row int col return data row col public void setValueAt Object value int row int col int numRows getRowCount int numCols getColumnCount for int i 0 i numRows i for int j 0 j numCols j System out print data i j class CXFPXX extends JFrame implements ActionListener BG2 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 South 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 AbstractTableModel String rq mc yy sl je final String columnNames 退货日期 商品名称 退货原因 退货数量 件 退货金 额 元 Object data new Object 100 5 public BG3 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 ClassNotFoundException e try con DriverManager getConnection url sa 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 data m 0 rq data m 1 mc data m 2 yy data m 3 sl data m 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 getColumnName int col return columnNames col public Object getValueAt int row int col return data row col public void setValueAt Object value int row int col int numRows getRowCount int numCols getColumnCount for int i 0 i numRows i for int j 0 j numCols j System out print data i j class XSTHXX extends JFrame implements ActionListener BG3 bg3 JTable t JButton b JPanel p JScrollPane s public XSTHXX String str super str setLayout new BorderLayout b new JButton 确定 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 cxfpxx setVisible true class BG4 extends AbstractTableModel String rq mc dj sl je final String columnNames 开票日期 商品名称 商品单价 元 销售数量 个 销售 金额 元 Object data new Object 100 5 public BG4 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 ClassNotFoundException e try con DriverManager getConnection url sa stmt con createStatement sql SELECT 开票日期 商品名称 商品单价 元 销售数量 个 销售金额 元 FROM 销售发票 ResultSet rs stmt executeQuery sql while rs next rq rs getString 1 mc rs getString 2 dj rs getString 3 sl rs getString 4 je rs getString 5 data m 0 rq data m 1 mc data m 2 dj data m 3 sl data m 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 getColumnName int col return columnNames col public Object getValueAt int row int col return data row col public void setValueAt Object value int row int col int numRows getRowCount int numCols getColumnCount for int i 0 i numRows i for int j 0 j numCols j System out print data i j class XSXXCX extends JFrame implements ActionListener BG4 bg4 JTable t JButton b JPanel p JScrollPane s public XSXXCX String str super str setLayout new BorderLayout b new JButton 确定 b addActionListener this p new JPanel p add b bg4 new BG4 t new JTable bg4 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 cxfpxx setVisible true class BG5 extends AbstractTableModel String ch lx dz rq final String columnNames 客户称呼 联系方式 客户地址 入会日期 Object data new Object 100 4 public BG5 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 ClassNotFoundException e try con DriverManager getConnection url sa stmt con createStatement sql SELECT FROM 客户信息 ResultSet rs stmt executeQuery sql while rs next ch rs getString 1 lx rs getString 2 dz rs getString 3 rq rs getString 4 data m 0 ch data m 1 lx data m 2 dz data m 3 rq 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 columnNames col public Object getValueAt int row int col return data row col public void setValueAt Object value int row int col int numRows getRowCount int numCols getColumnCount for int i 0 i numRows i for int j 0 j numCols j System out print data i j class HYXXCX extends JFrame implements ActionListener BG5 bg5 JTable t JButton b JPanel p JScrollPane s public HYXXCX String str super str setLayout new BorderLayout b new JButton 确定 b addActionListener this p new JPanel p add b bg5 new BG5 t new JTable bg5 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 cxfpxx setVisible true class YGGL extends JFrame implements ActionListener JButton B1 B2 B3 B4 B5 Container ct getContentPane public YGGL String str super str setBak JPanel panel new JPanel panel setOpaque false panel setLayout new FlowLayout FlowLayout CENTER 60 40 B1 new JButton 添加员工 B2 new JButton 删除员工 B3 new JButton 员工名单 B4 new JButton 更新信息 B5 new JButton 返回 B1 addActionListener this B2 addActionListener this B3 addActionListener this B4 addActionListener this B5 addActionListener this panel add B1 panel add B2 panel add B3 panel add B4 panel add B5 add panel public void setBak JPanel this getContentPane setOpaque false ImageIcon img new ImageIcon e 数据库课程设计 六月物语 1 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 B1 this dispose TJYG tjyg new TJYG 员工管理 添加员工 tjyg setSize 400 350 tjyg setLocation 450 200 tjyg setVisible true if e getSource B2 this dispose SCYG scyg new SCYG 员工管理 删除员工 scyg setSize 300 150 scyg setLocation 550 300 scyg setVisible true if e getSource B3 this dispose YGMDXX ygmdxx new YGMDXX 员工管理 员工名单 ygmdxx setSize 700 300 ygmdxx setLocation 350 250 ygmdxx setVisible true if e getSource B4 this dispose GXXX gxxx new GXXX 员工管理 更新信息 gxxx setSize 300 200 gxxx setLocation 500 250 gxxx setVisible true if e getSource B5 this dispose BS bs new BS 管理员界面 bs setSize 500 250 bs setLocation 450 250 bs setVisible true class TJYG extends JFrame implements ActionListener JLabel L1 L2 L3 L4 L5 JTextField T1 T2 T3 T4 T5 JButton B1 B2 Container ct getContentPane public TJYG String str super str setBak JPanel panel new JPanel panel setOpaque false panel setLayout new FlowLayout FlowLayout CENTER 60 25 L1 new JLabel 员工名称 L2 new JLabel 员工编号 L3 new JLabel 员工职位 L4 new JLabel 聘请日期 L5 new JLabel 联系方式 T1 new JTextField 10 T2 new JTextField 10 T3 new JTextField 10 T4 new JTextField 10 T5 new JTextField 10 B1 new JButton 确定 B2 new JButton 返回 B1 addActionListener this B2 addActionListener this panel add L1 panel add T1 panel add L2 panel add T2 panel add L3 panel add T3 panel add L4 panel add T4 panel add L5 panel add T5 panel add B1 panel add B2 add panel public void setBak JPanel this getContentPane setOpaque false ImageIcon img new ImageIcon e 数据库课程设计 六月物语 2 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 B1 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 ClassNotFoundException e1 e1 printStackTrace try con DriverManager getConnection url sa stmt con createStatement sql INSERT INTO 人员管理 员工名称 员工编号 员工职位 聘请日期 联系方式 VALUES T1 getText T2 getText T3 getText T4 getText T5 getT ext stmt executeUpdate sql stmt close con close catch SQLException e2 e2 printStackTrace JOptionPane showMessageDialog this 添加员工成功 提示 JOptionPane INFORMATION MESSAGE T1 setText T2 setText T3 setText T4 setText T5 setText if e getSource B2 this dispose YGGL yggl new YGGL 员工管理 员工信息 yggl setSize 500 200 yggl setLocation 450 250 yggl setVisible true class SCYG extends JFrame implements ActionListener JLabel L1 JTextField T1 JButton B1 B2 Container ct getContentPane public SCYG String str super str setBak JPanel panel new JPanel panel setOpaque false panel setLayout new FlowLayout FlowLayout CENTER 60 20 L1 new JLabel 员工名称 T1 new JTextField 10 B1 new JButton 确定 B2 new JButton 返回 B1 addActionListener this B2 addActionListener this panel add L1 panel add T1 panel add B1 panel add B2 add panel public void setBak JPanel this getContentPane setOpaque false ImageIcon img new ImageIcon e 数据库课程设计 六月物语 3 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 B1 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 ClassNotFoundException e1 e1 printStackTrace try con DriverManager getConnection url sa stmt con createStatement sql DELETE FROM 人员管理 WHERE 员工名称 T1 getText stmt executeUpdate sql stmt close con close catch SQLException e2 e2 printStackTrace JOptionPane showMessageDialog this 成功删除 提示 JOptionPane INFORMATION MESSAGE T1 setText if e getSource B2 this dispose YGGL yggl new YGGL 员工管理 员工信息 yggl setSize 500 200 yggl setLocation 450 250 yggl setVisible true class BG6 extends AbstractTableModel String mc bh zw rq lx final String columnNames 员工名称 员工编号 员工职位 聘请日期 联系方式 Object data new Object 100 5 public BG6 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 ClassNotFoundException e try con DriverManager getConnection url sa stmt con createStatement sql SELECT FROM 人员管理 ResultSet rs stmt executeQuery sql while rs next mc rs getString 1 bh rs getString 2 zw rs getString 3 rq rs getString 4 lx rs getString 5 data m 0 mc data m 1 bh data m 2 zw data m 3 rq data m 4 lx 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 columnNames col public Object getValueAt int row int col return data row col public void setValueAt Object value int row int col int numRows getRowCount int numCols getColumnCount for int i 0 i numRows i for int j 0 j numCols j System out print data i j class YGMDXX extends JFrame implements ActionListener BG6 bg6 JTable t JButton b JPanel p JScrollPane s public YGMDXX String str super str setLayout new BorderLayout b new JButton 确定 b addActionListener this p new JPanel p add b bg6 new BG6 t new JTable bg6 s new JScrollPane t add s Center add p South public void actionPerformed ActionEvent e if e getSource b this dispose YGGL yggl new YGGL 员工管理 员工信息 yggl setSize 500 200 yggl setLocation 450 250 yggl setVisible true class GXXX extends JFrame implements ActionListener JLabel L1 L2 JTextField T1 T2 JButton B1 B2 Container ct getContentPane public GXXX String str super str setBak JPanel panel new JPanel panel setOpaque false panel setLayout new FlowLayout FlowLayout CENTER 60 20 L1 new JLabel 员工名称 L2 new JLabel 员工职位 T1 new JTextField 10 T2 new JTextField 10 B1 new JButton 确定 B2 new JButton 返回 B1 addActionListener this B2 addActionListener this panel add L1 panel add T1 panel add L2 panel add T2 panel add B1 panel add B2 add panel public void setBak JPanel this getContentPane setOpaque false ImageIcon img new ImageIcon e 数据库课程设计 六月物语 3 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 B1 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 ClassNotFoundException e1 e1 printStackTrace try con DriverManager getConnection url sa stmt con createStatement sql UPDATE 人员管理 SET 员工职位 T2 getText WHERE 员工名称 T1 getText stmt executeUpdate sql stmt close con close catch SQLException e2 e2 printStackTrace JOptionPane showMessageDialog this 更新成功 提示 JOptionPane INFORMATION MESSAGE T1 setText T2 setText if e getSource B2 this dispose YGGL yggl new YGGL 员工管理 员工信息 yggl setSize 500 200 yggl setLocation 450 250 yggl setVisible true class JHXX extends JFrame implements ActionListener JButton B1 B2 B3 Container ct getContentPane public JHXX String str super str setBak JPanel panel new JPanel panel setOpaque false panel setLayout new FlowLayout FlowLayout CENTER 60 20 B1 new JBut