shopmis.java~361~

百货商场信息管理系统

package liu;

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2008</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class ShopMIS extends JFrame {
  int dingdanNO=0;//订单号
  Connection con,con1;
  Statement st;
  ImageIcon a=new ImageIcon("1.gif");
  //Icon b=new Icon(a);
  private String[] string={"超级用户","销售系统","采购系统","会计系统"};
  //Item a=new Item();
  CardLayout cardLayout1 = new CardLayout();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JLabel jLabel1 = new JLabel();

  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JPasswordField jPasswordField1 = new JPasswordField();
  JComboBox jComboBox1 = new JComboBox();
  JButton jButton2 = new JButton();
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenuItem jMenuItem1 = new JMenuItem();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JPanel jPanel5 = new JPanel();
  JLabel jLabel5 = new JLabel();
  CardLayout cardLayout2 = new CardLayout();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel12 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField6 = new JTextField();
  JLabel jLabel14 = new JLabel();
  JTextField jTextField8 = new JTextField();
  JMenu jMenu2 = new JMenu();
  JMenu jMenu3 = new JMenu();
  JMenu jMenu4 = new JMenu();
  JMenuItem jMenuItem4 = new JMenuItem();
  JButton jButton4 = new JButton();
  JPanel jPanel6 = new JPanel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JLabel jLabel13 = new JLabel();
  JLabel jLabel15 = new JLabel();
  JLabel jLabel16 = new JLabel();
  JLabel jLabel17 = new JLabel();
  JLabel jLabel18 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField4 = new JTextField();
  JTextField jTextField5 = new JTextField();
  JTextField jTextField7 = new JTextField();
  JTextField jTextField9 = new JTextField();
  JTextField jTextField10 = new JTextField();
  JTextField jTextField11 = new JTextField();
  JLabel jLabel19 = new JLabel();
  JTextField jTextField12 = new JTextField();
  JLabel jLabel20 = new JLabel();
  JLabel jLabel21 = new JLabel();
  JTextField jTextField14 = new JTextField();
  JLabel jLabel22 = new JLabel();
  JTextField jTextField15 = new JTextField();
  JLabel jLabel23 = new JLabel();
  JTextField jTextField16 = new JTextField();
  JMenuItem jMenuItem6 = new JMenuItem();
  JPanel jPanel7 = new JPanel();
  JLabel jLabel24 = new JLabel();
  JLabel jLabel25 = new JLabel();
  JLabel jLabel26 = new JLabel();
  JTextField jTextField18 = new JTextField();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTextArea jTextArea1 = new JTextArea();
  JTextField jTextField13 = new JTextField();
  CardLayout cardLayout3 = new CardLayout();
  JPanel jPanel8 = new JPanel();
  JLabel jLabel6 = new JLabel();
  JScrollPane jScrollPane2 = new JScrollPane();
  JTextArea jTextArea2 = new JTextArea();
  JButton jButton8 = new JButton();
  JButton jButton9 = new JButton();
  JButton jButton3 = new JButton();
  JMenuItem jMenuItem7 = new JMenuItem();
  JMenuItem jMenuItem8 = new JMenuItem();
  JPanel jPanel9 = new JPanel();
  JScrollPane jScrollPane3 = new JScrollPane();
  JTextArea jTextArea3 = new JTextArea();
  JButton jButton10 = new JButton();
  JMenuItem jMenuItem9 = new JMenuItem();
  JPanel jPanel10 = new JPanel();
  JLabel jLabel27 = new JLabel();
  JButton jButton5 = new JButton();
  JScrollPane jScrollPane4 = new JScrollPane();
  JTextArea jTextArea4 = new JTextArea();
  JLabel jLabel28 = new JLabel();
  JTextField jTextField17 = new JTextField();
  JButton jButton11 = new JButton();
  JButton jButton12 = new JButton();
  JButton jButton13 = new JButton();
  CardLayout cardLayout4 = new CardLayout();
  JPanel jPanel11 = new JPanel();
  JLabel jLabel7 = new JLabel();
  JButton jButton14 = new JButton();
  JScrollPane jScrollPane5 = new JScrollPane();
  JTextArea jTextArea5 = new JTextArea();
  JButton jButton15 = new JButton();
  JLabel jLabel29 = new JLabel();
  JLabel jLabel30 = new JLabel();
  JTextField jTextField19 = new JTextField();
  JLabel jLabel31 = new JLabel();
  JButton jButton16 = new JButton();
  JMenuItem jMenuItem10 = new JMenuItem();
  JMenuItem jMenuItem5 = new JMenuItem();
  JPanel jPanel12 = new JPanel();
  JMenuItem jMenuItem11 = new JMenuItem();
  JMenuItem jMenuItem12 = new JMenuItem();
  JLabel jLabel32 = new JLabel();
  JLabel jLabel33 = new JLabel();
  JTextField jTextField21 = new JTextField();
  JButton jButton17 = new JButton();
  JScrollPane jScrollPane6 = new JScrollPane();
  JLabel jLabel34 = new JLabel();
  JButton jButton18 = new JButton();
  JTextField jTextField20 = new JTextField();
  JPanel jPanel13 = new JPanel();
  JLabel jLabel35 = new JLabel();
  JTextField jTextField22 = new JTextField();
  JButton jButton19 = new JButton();
  JPanel jPanel14 = new JPanel();
  JTextArea jTextArea6 = new JTextArea();
  JLabel jLabel36 = new JLabel();
  JLabel jLabel37 = new JLabel();
  JLabel jLabel38 = new JLabel();
  JLabel jLabel39 = new JLabel();
  JLabel jLabel40 = new JLabel();
  JTextField jTextField23 = new JTextField();
  JTextField jTextField24 = new JTextField();
  JTextField jTextField25 = new JTextField();
  JTextField jTextField26 = new JTextField();
  JTextField jTextField27 = new JTextField();
  JButton jButton20 = new JButton();
  JMenuItem jMenuItem13 = new JMenuItem();
  JMenuItem jMenuItem14 = new JMenuItem();
  JPanel jPanel15 = new JPanel();
  JLabel jLabel41 = new JLabel();
  JTextField jTextField28 = new JTextField();
  JButton jButton21 = new JButton();
  JLabel jLabel42 = new JLabel();
  JTextField jTextField29 = new JTextField();
  JLabel jLabel43 = new JLabel();
  JTextField jTextField30 = new JTextField();
  JButton jButton22 = new JButton();
  JMenuItem jMenuItem15 = new JMenuItem();
  JMenuItem jMenuItem16 = new JMenuItem();
  JPanel jPanel16 = new JPanel();
  JPanel jPanel17 = new JPanel();
  JLabel jLabel44 = new JLabel();
  JLabel jLabel45 = new JLabel();
  JLabel jLabel46 = new JLabel();
  JTextField jTextField31 = new JTextField();
  JTextField jTextField32 = new JTextField();
  JTextField jTextField33 = new JTextField();
  JButton jButton23 = new JButton();
  JLabel jLabel47 = new JLabel();
  JLabel jLabel48 = new JLabel();
  JLabel jLabel49 = new JLabel();
  JTextField jTextField34 = new JTextField();
  JButton jButton24 = new JButton();
  JLabel jLabel50 = new JLabel();
  JButton jButton25 = new JButton();
  JScrollPane jScrollPane7 = new JScrollPane();
  JTextArea jTextArea7 = new JTextArea();
  JMenuItem jMenuItem18 = new JMenuItem();
  JMenuItem jMenuItem19 = new JMenuItem();
  JPanel jPanel18 = new JPanel();
  JLabel jLabel51 = new JLabel();
  JTextField jTextField35 = new JTextField();
  JButton jButton26 = new JButton();
  JScrollPane jScrollPane8 = new JScrollPane();
  JTextArea jTextArea8 = new JTextArea();
  JMenu jMenu5 = new JMenu();
  JMenuItem jMenuItem17 = new JMenuItem();
  JMenuItem jMenuItem20 = new JMenuItem();
  JMenuItem jMenuItem21 = new JMenuItem();
  JMenuItem jMenuItem22 = new JMenuItem();
  CardLayout cardLayout5 = new CardLayout();
  JPanel jPanel19 = new JPanel();
  JPanel jPanel20 = new JPanel();
  JPanel jPanel21 = new JPanel();
  JPanel jPanel22 = new JPanel();
  JLabel jLabel52 = new JLabel();
  JTextField jTextField36 = new JTextField();
  JButton jButton27 = new JButton();
  JLabel jLabel53 = new JLabel();
  JTextField jTextField37 = new JTextField();
  JButton jButton28 = new JButton();
  JLabel jLabel54 = new JLabel();
  JTextField jTextField38 = new JTextField();
  JButton jButton29 = new JButton();
  JLabel jLabel55 = new JLabel();
  JLabel jLabel56 = new JLabel();
  JLabel jLabel57 = new JLabel();
  JTextField jTextField39 = new JTextField();
  JTextField jTextField40 = new JTextField();
  JTextField jTextField41 = new JTextField();
  JButton jButton30 = new JButton();
  JLabel jLabel58 = new JLabel();
  JTextField jTextField42 = new JTextField();
  JLabel jLabel59 = new JLabel();
  JTextField jTextField43 = new JTextField();
  JLabel jLabel60 = new JLabel();
  JTextField jTextField44 = new JTextField();
  JLabel jLabel61 = new JLabel();
  JTextField jTextField45 = new JTextField();
  JButton jButton31 = new JButton();


  public ShopMIS() throws HeadlessException {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) throws HeadlessException {
    ShopMIS shopMIS1 = new ShopMIS();
    //int[]  a={1,2,3,4};
    String[][]  b={{"5","6","7","8"},{"9","10","11","12"}};
    //JTable jTable2=new JTable(new DataModel());
    DataModel d=new DataModel();
    d.changeData(b);
    shopMIS1.getContentPane().repaint();
  }
  private void jbInit() throws Exception {
    //jLabel1.setIcon(a);

    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      String url="jdbc:odbc:MIS";
      String username="sa";
      String password="";
      con=DriverManager.getConnection(url,username,password);
      con1=DriverManager.getConnection(url,username,password);

    }catch(SQLException e)
    {
      e.printStackTrace();
    }
    catch(ClassNotFoundException e1)
    {
      e1.printStackTrace();
    }

    jMenuBar1.setVisible(false);
    this.setJMenuBar(jMenuBar1);
    this.setVisible(true);
    this.setBounds(200,100,500,500);
    for(int i=0;i<4;i++)
    {
      jComboBox1.addItem(string[i]);
    }
    this.getContentPane().setLayout(cardLayout1);
    jPanel1.setLayout(null);
    jPanel2.setLayout(cardLayout2);
    jPanel3.setLayout(cardLayout3);
    jPanel4.setLayout(cardLayout4);
    jLabel1.setFont(new java.awt.Font("Serif", 0, 20));
    jLabel1.setForeground(Color.red);
    jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel1.setIcon(a);
    jLabel1.setIconTextGap(4);
    jLabel1.setBounds(new Rectangle(-1, 3, 477, 119));
    jLabel2.setFont(new java.awt.Font("Serif", 0, 11));
    jLabel2.setText("用户类型");
    jLabel2.setBounds(new Rectangle(123, 149, 59, 16));
    jLabel3.setText("用户名");
    jLabel3.setBounds(new Rectangle(123, 195, 49, 16));
    jLabel4.setText("密码");
    jLabel4.setBounds(new Rectangle(123, 244, 49, 16));
    jTextField1.setText("1");
    jTextField1.setBounds(new Rectangle(206, 195, 103, 22));
    jPasswordField1.setText("1");
    jPasswordField1.setBounds(new Rectangle(206, 244, 103, 22));
    jComboBox1.setBounds(new Rectangle(206, 149, 108, 22));
    jButton2.setBounds(new Rectangle(289, 297, 73, 25));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton2.setText("重置");
    jButton2.addActionListener(new ShopMIS_jButton2_actionAdapter(this));
    jMenu1.setText("系统管理");
    jMenuItem1.setText("销售系统");
    jMenuItem1.addActionListener(new ShopMIS_jMenuItem1_actionAdapter(this));
    jMenuItem2.setText("采购系统");
    jMenuItem2.addActionListener(new ShopMIS_jMenuItem2_actionAdapter(this));
    jMenuItem3.setText("会计系统");
    jMenuItem3.addActionListener(new ShopMIS_jMenuItem3_actionAdapter(this));
    jLabel5.setFont(new java.awt.Font("SansSerif", 0, 15));
    jLabel5.setMinimumSize(new Dimension(44, 16));
    jLabel5.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel5.setIcon(null);
    jLabel5.setText("编辑订单");
    jLabel5.setBounds(new Rectangle(133, 5, 192, 21));
    jPanel5.setLayout(null);
    jLabel9.setText("客户号");
    jLabel9.setBounds(new Rectangle(10, 63, 40, 16));
    jLabel12.setText("货物编号");
    jLabel12.setBounds(new Rectangle(5, 103, 51, 16));
    jTextField3.setText("c001");
    jTextField3.setBounds(new Rectangle(102, 60, 82, 22));
    jTextField6.setText("g001");
    jTextField6.setBounds(new Rectangle(102, 100, 81, 22));
    jLabel14.setText("货物数量");
    jLabel14.setBounds(new Rectangle(3, 139, 55, 16));
    jTextField8.setText("10");
    jTextField8.setBounds(new Rectangle(102, 136, 82, 22));
    jMenu2.setText("销售系统");
    jMenu2.addActionListener(new ShopMIS_jMenu2_actionAdapter(this));
    jMenu3.setText("采购系统");
    jMenu3.addActionListener(new ShopMIS_jMenu3_actionAdapter(this));
    jMenu4.setText("会计系统");
    jMenu4.addActionListener(new ShopMIS_jMenu4_actionAdapter(this));
    jMenuItem4.setText("编辑订单");
    jMenuItem4.addActionListener(new ShopMIS_jMenuItem4_actionAdapter(this));
    jButton4.setBounds(new Rectangle(104, 206, 73, 25));
    jButton4.setText("重置");
    jButton4.addActionListener(new ShopMIS_jButton4_actionAdapter(this));
    jPanel6.setLayout(null);
    jLabel8.setFont(new java.awt.Font("SansSerif", 0, 14));
    jLabel8.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel8.setHorizontalTextPosition(SwingConstants.LEADING);
    jLabel8.setText("订单详况");
    jLabel8.setBounds(new Rectangle(168, 3, 141, 23));
    jLabel10.setText("订单号");
    jLabel10.setBounds(new Rectangle(17, 64, 40, 16));
    jLabel11.setText("顾客号");
    jLabel11.setBounds(new Rectangle(17, 110, 40, 16));
    jLabel13.setText("货物编号");
    jLabel13.setBounds(new Rectangle(13, 195, 58, 16));
    jLabel15.setText("货物名称");
    jLabel15.setBounds(new Rectangle(13, 244, 65, 16));
    jLabel16.setText("货物数量");
    jLabel16.setBounds(new Rectangle(13, 291, 66, 16));
    jLabel17.setText("顾客名");
    jLabel17.setBounds(new Rectangle(17, 152, 40, 16));
    jLabel18.setText("厂商名");
    jLabel18.setBounds(new Rectangle(17, 336, 45, 16));
    jTextField2.setEditable(false);
    jTextField2.setText("jTextField2");
    jTextField2.setBounds(new Rectangle(93, 61, 61, 22));
    jTextField4.setEditable(false);
    jTextField4.setText("jTextField4");
    jTextField4.setBounds(new Rectangle(93, 107, 63, 22));
    jTextField5.setEditable(false);
    jTextField5.setText("jTextField5");
    jTextField5.setBounds(new Rectangle(93, 149, 60, 22));
    jTextField7.setEditable(false);
    jTextField7.setText("jTextField7");
    jTextField7.setBounds(new Rectangle(93, 192, 61, 22));