asmainmenu.java

管理系统

                InputEvent.CTRL_MASK));
        jMenuItem2.setText("库存信息");
        jMenuItem2.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_A,
                InputEvent.CTRL_MASK));
        jMenuItem3.setText("人员信息");
        jMenuItem3.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Z,
                InputEvent.CTRL_MASK));
        jMenuItem7.setText("采购入库详情");
        jMenuItem7.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_K,
                InputEvent.CTRL_MASK));
        jMenuItem8.setText("人员情况");
        jMenuItem8.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_R,
                InputEvent.CTRL_MASK));
        jMenuItem11.setText("销售情况");
        jMenuItem11.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_X,
                InputEvent.CTRL_MASK));
        jMenuItem13.setText("客户详情");
        jMenuItem13.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_I,
                InputEvent.CTRL_MASK));
        jMenu7.setText("帮助");
        jMenuItem15.setText("关于我们");
        jMenuItem16.setText("退出");
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenuBar1.add(jMenu4);
        jMenuBar1.add(jMenu5);
        jMenuBar1.add(jMenu6);
        jMenuBar1.add(jMenu7);
        jMenu1.add(jMenuItem1);
        jMenu1.add(jMenuItem2);
        jMenu1.add(jMenuItem3);
        jMenu1.add(jMenuItem17);
        jMenu2.add(jMenu8);
        jMenu2.add(jMenu9);
        jMenu3.add(jMenuItem7);
        jMenu4.add(jMenuItem8);
        jMenu4.add(jMenuItem6);
        jMenu5.add(jMenuItem11);
        jMenu5.add(jMenuItem22);
        jMenu6.add(jMenuItem13);
        jMenu7.add(jMenuItem15);
        jMenu7.add(jMenuItem16);
        jSplitPane1.add(jPanel3, JSplitPane.RIGHT);
        jPanel5.add(jScrollPane2);
        jPanel5.add(jButton12);
        jPanel5.add(jButton9);
        jPanel5.add(jButton7);
        jPanel5.add(jButton8);
        jPanel3.add(jPanel7);
        jScrollPane2.getViewport().add(jTable1);
        jPanel5.setBorder(BorderFactory.createTitledBorder(BorderFactory.
                createLineBorder(Color.black, 1),
                "采购入库信息表", TitledBorder.LEFT, TitledBorder.TOP));
        jSplitPane1.add(jSplitPane2, JSplitPane.LEFT);
        jSplitPane2.add(jScrollPane1, JSplitPane.TOP);
        jSplitPane2.add(jScrollPane3, JSplitPane.BOTTOM);
        jScrollPane3.getViewport().add(jTree2);
        jScrollPane1.getViewport().add(jTree1);
        jPanel6.add(jRadioButton2);
        jPanel6.add(jRadioButton1);
        jPanel6.add(jRadioButton3);
        jPanel7.add(jLabel5);
        jPanel7.add(txtPrice);
        jPanel7.add(jLabel2);
        jPanel7.add(txtmath);
        jPanel7.add(jLabel6);
        jPanel7.add(jComboBox1);
        jPanel7.add(jLabel15);
        jPanel7.add(jComboBox2);
        jPanel7.add(jLabel16);
        jPanel7.add(jComboBox3);
        jPanel7.add(jLabel9);
        jPanel7.add(txtPrice2);
        jPanel7.add(txtashow);
        jPanel7.add(jLabel3);
        jPanel7.add(jComboBox4);
        jPanel7.add(jLabel12);
        jPanel7.add(txt1);
        jPanel7.add(jLabel10);
        jPanel7.add(jLabel8);
        jPanel7.add(txtAdd);
        jPanel7.add(jLabel7);
        jPanel3.add(jPanel5);
        jPanel7.add(txtID);
        jPanel7.add(jLabel4);
        jPanel7.add(txtName);
        jPanel7.add(jLabel13);
        jPanel7.add(txtTime);
        jPanel7.add(jPanel6);
        jPanel7.add(jLabel14);
        jPanel7.add(jLabel11);
        jPanel7.add(txtnum);
        jPanel7.add(jButton11);
        jPanel7.add(jButton10);
        jMenu8.add(jMenuItem4);
        jMenu8.add(jMenuItem9);
        jMenu8.add(jMenuItem10);
        jMenu8.add(jMenuItem12);
        jMenu8.add(jMenuItem18);
        jMenu8.add(jMenuItem19);
        jMenu9.add(jMenuItem5);
        jMenu9.add(jMenuItem20);
        jMenu9.add(jMenuItem14);
        jMenu9.add(jMenuItem21);
        jPanel4.add(jButton1, null);
        jPanel4.add(jButton2, null);
        jPanel4.add(jButton3, null);
        jPanel4.add(jButton4, null);
        jPanel4.add(jButton5, null);
        jPanel4.add(jButton6, null);
        this.getContentPane().add(jPanel1, null);
        jButton1.setLocation(4, 5);
        buttonGroup1.add(jRadioButton2);
        buttonGroup1.add(jRadioButton1);
        buttonGroup1.add(jRadioButton3);
        this.notanumber();
        String[] str = {"编号","姓名","存货数量","售出数量","小类","大类","款式","单位","重量","成本","售价","地址","日期"};
       for (int i = 0; i < str.length; i++) {
            v_asset.add(str[i]);
     }
        root.add(parent);
        jScrollPane1.getViewport().add(jTree1);
        jPanel1.add(jSplitPane1, null);
        jPanel1.add(jPanel2, null);
        jPanel2.add(jTextField1);
        jPanel2.add(jTextField2);
        jPanel2.add(jTextField3, null);
        this.showTree2();
    }
    public void showTree2(){ //系统树型设置
            DefaultMutableTreeNode root = new DefaultMutableTreeNode("系统设置");
            DefaultMutableTreeNode roo1 = new DefaultMutableTreeNode("字体颜色");
            DefaultMutableTreeNode roo2 = new DefaultMutableTreeNode("背景颜色");
            DefaultMutableTreeNode roo3 = new DefaultMutableTreeNode("文本框颜色");
            DefaultMutableTreeNode roo4 = new DefaultMutableTreeNode("默认颜色");
            DefaultMutableTreeNode leaf1 = new DefaultMutableTreeNode("黑");
            DefaultMutableTreeNode leaf2 = new DefaultMutableTreeNode("黄");
            DefaultMutableTreeNode leaf3 = new DefaultMutableTreeNode("蓝");
            DefaultMutableTreeNode leaf4 = new DefaultMutableTreeNode("浅灰");
            DefaultMutableTreeNode leaf5 = new DefaultMutableTreeNode("深灰");
            DefaultMutableTreeNode leaf6 = new DefaultMutableTreeNode("白");
            DefaultMutableTreeNode leaf7 = new DefaultMutableTreeNode("黑色");
            DefaultMutableTreeNode leaf8 = new DefaultMutableTreeNode("黄色");
            DefaultMutableTreeNode leaf9 = new DefaultMutableTreeNode("蓝色");

            roo1.add(leaf1);roo1.add(leaf2);roo1.add(leaf3);
            roo2.add(leaf4);roo2.add(leaf5);roo2.add(leaf6);
            roo3.add(leaf7);roo3.add(leaf8);roo3.add(leaf9);
            root.add(roo1);root.add(roo2);root.add(roo3);root.add(roo4);
            jTree2.setModel(new DefaultTreeModel(root));
    }

    public void notanumber(){
        String rownum = SDBManager.getAll("select count(*) from asset").elementAt(0).toString();
        String sumprice = SDBManager.getAll("select sum(convert(float,acost)) from asset").elementAt(0).toString();
        String sumcount = SDBManager.getAll("select sum(convert(int,anumber)) from asset").elementAt(0).toString();
        txtashow.setText("            采购入库记录 "+rownum+" 条        进货成本总额 "+sumprice+" ￥        库存总数 "+sumcount+" 件");
    }
    DefaultMutableTreeNode root = new DefaultMutableTreeNode("库存管理系统");
    DefaultMutableTreeNode parent = new DefaultMutableTreeNode("库存管理表");
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    JSplitPane jSplitPane1 = new JSplitPane();
    JSplitPane jSplitPane2 = new JSplitPane();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTree jTree1 = new JTree(root);
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu2 = new JMenu();
    JMenu jMenu3 = new JMenu();
    JMenu jMenu4 = new JMenu();
    JMenu jMenu5 = new JMenu();
    JMenu jMenu6 = new JMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem7 = new JMenuItem();
    JMenuItem jMenuItem8 = new JMenuItem();
    JMenuItem jMenuItem11 = new JMenuItem();
    JMenuItem jMenuItem13 = new JMenuItem();
    JMenu jMenu7 = new JMenu();
    JMenuItem jMenuItem15 = new JMenuItem();
    JMenuItem jMenuItem16 = new JMenuItem();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    int num = (int) Math.round(Math.random() * 9);
    Vector v_asset = new Vector();
    JPanel jPanel4 = new JPanel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    JMenuItem jMenuItem17 = new JMenuItem();
    JMenuItem jMenuItem6 = new JMenuItem();
    JMenu jMenu8 = new JMenu();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem9 = new JMenuItem();
    JMenuItem jMenuItem10 = new JMenuItem();
    JMenuItem jMenuItem12 = new JMenuItem();
    JMenuItem jMenuItem18 = new JMenuItem();
    JMenuItem jMenuItem19 = new JMenuItem();
    JMenu jMenu9 = new JMenu();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenuItem jMenuItem20 = new JMenuItem();
    GridLayout gridLayout1 = new GridLayout();
    JMenuItem jMenuItem14 = new JMenuItem();
    JMenuItem jMenuItem21 = new JMenuItem();
    JPanel jPanel5 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JButton jButton7 = new JButton();
    JButton jButton8 = new JButton();
    JButton jButton9 = new JButton();
    JPanel jPanel7 = new JPanel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JTextField txtPrice2 = new JTextField();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox2 = new JComboBox();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JButton jButton10 = new JButton();
    JButton jButton11 = new JButton();
    JScrollPane jScrollPane2 = new JScrollPane();
    JPanel jPanel6 = new JPanel();
    JTable jTable1 = new JTable();
    JRadioButton jRadioButton1 = new JRadioButton();
    JRadioButton jRadioButton2 = new JRadioButton();
    JRadioButton jRadioButton3 = new JRadioButton();
    JComboBox jComboBox3 = new JComboBox();
    JLabel jLabel15 = new JLabel();
    JLabel jLabel16 = new JLabel();
    JTextField txtTime = new JTextField();
    JTextField txtPrice = new JTextField();
    JTextField txtID = new JTextField();
    JTextField txtName = new JTextField();
    JTextField txtAdd = new JTextField();
    JTextField txt1 = new JTextField();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JButton jButton12 = new JButton();
    private String asmall;
    private String abig;
    GridLayout gridLayout2 = new GridLayout();
    JLabel jLabel2 = new JLabel();
    JTextField txtmath = new JTextField();
    JComboBox jComboBox4 = new JComboBox();
    JLabel jLabel10 = new JLabel();
    JTextField txtnum = new JTextField();
    Border border1 = BorderFactory.createMatteBorder(0, 0, 1, 0, Color.yellow);
    JTextField txtashow = new JTextField();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JMenuItem jMenuItem22 = new JMenuItem();
    JScrollPane jScrollPane3 = new JScrollPane();
    JTree jTree2 = new JTree();
    public void run(){ //线程设置
       while(true){
           SimpleDateFormat sdf = new SimpleDateFormat("hh:mm:ss aaa");
           jTextField3.setText(SGetDate.getDate().concat(sdf.format(new Date())));
           try {
               Thread.sleep(1000);
           } catch (InterruptedException ex) {
               ex.printStackTrace();
           }
       }
   }
    public void getTime() {
        Date date = new Date();
        DateFormat dft = new SimpleDateFormat("yyyy-MM-dd");
        txtTime.setText(dft.format(date));
    }

    public void jbInit1() throws SQLException {
        AssetInfo as = new AssetInfo();
        Vector ve = as.vector();
        ATilte at = new ATilte();
        Vector vec = at.titleName();
        this.jTable1 = new JTable(ve,vec);
        jTable1.addMouseListener(new ASMainMenu_jTable1_mouseAdapter(this));
        this.jScrollPane2.getViewport().add(jTable1);

    }
    //函数判断是否为字符 如果不是数字返回 false, 如果是字符返回 true
        private boolean objBool(String ab) {
            char[] stringArr = ab.toCharArray();
            for (int i = 0; i < stringArr.length; i++) {
                if (!Character.isDigit(stringArr[i])) {
                    return false;
                }
            }
            return true;
    }

    /**
     * jButton12_componentRemoved
     *
     * @return Vector
     */


    public Vector jButton12_componentRemoved(ContainerEvent e){
        return null;
    }

    public void setButton(){
        if(jRadioButton2.isSelected()){
            txtName.setText("");
            txtmath.setText("");
            txtAdd.setText("");
            txt1.setText("");
            txtnum.setText("");
            txtPrice.setText("");
            txtPrice2.setText("");
            txtID.setEditable(true);
            txtName.setEnabled(true);
            txtnum.setEnabled(false);
            txtmath.setEnabled(true);
            txtAdd.setEnabled(true);
            txt1.setEnabled(true);
            txtPrice.setEnabled(true);
            txtPrice2.setEnabled(true);
            txtTime.setEnabled(false);
            jComboBox1.setEnabled(true);
            jComboBox2.setEnabled(true);
            jComboBox3.setEnabled(true);