pmainmenu.java

管理系统

        jMenu1.setText("珠宝数据(D)");
        jMenu1.setMnemonic('D');
        jMenu3.setText("珠宝入库(K)");
        jMenu3.setMnemonic('k');
        jMenu4.setText("人员管理(P)");
        jMenu4.setMnemonic('P');
        jMenu5.setText("珠宝销售(S)");
        jMenu5.setMnemonic('S');
        jMenu6.setText("客户管理(C)");
        jMenu6.setMnemonic('C');
        jMenuItem1.setText("基础信息");
        jMenu1.setMnemonic('D');
        jMenuItem1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Q,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);
        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(jButton5, null);
        jPanel4.add(jButton1, null);
        jPanel4.add(jButton2, null);
        jPanel4.add(jButton3, null);
        jPanel4.add(jButton4, null);
        jPanel4.add(jButton6, null);
        jSplitPane1.add(jSplitPane2, JSplitPane.LEFT);
        jSplitPane2.add(jScrollPane1, JSplitPane.TOP);
        jSplitPane2.add(jScrollPane3, JSplitPane.BOTTOM);
        jScrollPane3.getViewport().add(jTree2);
        jSplitPane1.add(jPanel3, JSplitPane.RIGHT);
        jPanel3.add(jPanel7);
        jPanel5.add(txtName);
        jPanel5.add(jLabel2);
        jPanel5.add(jLabel3);
        jPanel5.add(jLabel4);
        jPanel5.add(jLabel14);
        jPanel5.add(jComboBox2);
        jPanel5.add(jComboBox3);
        jPanel5.add(txtId);
        jPanel5.add(txtSex);
        jPanel5.add(jLabel5);
        jPanel5.add(txtDate);
        jPanel5.add(jLabel8);
        jPanel5.add(txtAge);
        jPanel5.add(jLabel6);
        jPanel5.add(jComboBox4);
        jPanel5.add(jLabel9);
        jPanel5.add(jButton8);
        jPanel5.add(jButton10);
        jPanel5.add(txtAdd);
        jPanel5.add(jLabel7);
        jPanel5.add(txtPhone);
        jPanel5.add(jLabel10);
        jPanel7.add(jScrollPane2);
        jTabbedPane1.add(jPanel5, "人员管理 1");
        jPanel7.add(jTabbedPane1);
        jScrollPane2.getViewport().add(jTable2);
        jPanel6.add(jLabel13);
        jPanel6.add(jLabel11);
        jPanel6.add(txtTiao);
        jPanel6.add(jLabel12);
        jPanel6.add(jComboBox1);
        jPanel6.add(jButton11);
        jPanel6.add(jButton13);
        jPanel6.add(jButton12);
        jPanel7.add(txtnote);
        jPanel1.add(jPanel2);
        jPanel2.add(jTextField1);
        jPanel2.add(jTextField2);
        jPanel2.add(jTextField3);
        jTabbedPane1.add(jPanel6, "人员管理 2");
        jScrollPane1.getViewport().add(jTree1);
        jPanel1.add(jSplitPane1, null);
        this.getContentPane().add(jPanel1, null);
        jPanel7.add(jTabbedPane1);
        jPanel7.add(jScrollPane2);
        jButton1.setLocation(4,5);
        this.showTree2();
        getNumber();
        this.notenumber();
        this.setVisible(true);
    }
    JPanel jPanel7 = new JPanel();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JSplitPane jSplitPane1 = new JSplitPane();
    JSplitPane jSplitPane2 = new JSplitPane();
    JScrollPane jScrollPane1 = new JScrollPane();
    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();
    int num = (int)Math.round(Math.random()*9);
    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();
    JPanel jPanel3 = new JPanel();
    JScrollPane jScrollPane2 = new JScrollPane();
    Point p = new Point(340,250);
    JTable jTable2 = new JTable();
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel5 = new JPanel();
    JPanel jPanel6 = new JPanel();
    JLabel jLabel2 = new JLabel();
    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();
    JLabel jLabel10 = new JLabel();
    JTextField txtAge = new JTextField();
    JTextField txtAdd = new JTextField();
    JTextField txtPhone = new JTextField();
    JTextField txtSex = new JTextField();
    JTextField txtDate = new JTextField();
    JTextField txtId = new JTextField();
    JTextField txtName = new JTextField();
    JButton jButton8 = new JButton();
    JButton jButton10 = new JButton();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JTextField txtTiao = new JTextField();
    JButton jButton11 = new JButton();
    JButton jButton12 = new JButton();
    JButton jButton13 = new JButton();
    JLabel jLabel14 = new JLabel();
    JComboBox jComboBox2 = new JComboBox();
    JComboBox jComboBox3 = new JComboBox();
    JComboBox jComboBox4 = new JComboBox();

    public void notenumber(){  //显示人员的统计信息
        String rownum = SDBManager.getAll("select count(*) from person").elementAt(0).toString();
        String summan = SDBManager.getAll("select count(*) from person where psex = '男'").elementAt(0).toString();
        String sumgril = SDBManager.getAll("select count(*) from person where psex = '女'").elementAt(0).toString();
        String summanager = SDBManager.getAll("select count(*) from person where pstep = '经理'").elementAt(0).toString();
        String sumpepole = SDBManager.getAll("select count(*) from person where pstep = '职员'").elementAt(0).toString();
        String sumbi = SDBManager.getAll("select count(*) from person where pstate = '病假'").elementAt(0).toString();
        String sumxiu = SDBManager.getAll("select count(*) from person where pstate = '休假'").elementAt(0).toString();
        System.out.println(sumbi);
        txtnote.setText("   人员总数记录 "+rownum+" 条            男"+summan+" 人            女 "+sumgril+" 人            经理 "+summanager+" 人            职员 "+sumpepole+" 人            病假 "+sumbi+" 人            休假 "+sumxiu+" 人");
    }

    public void getNumber(){
        boolean sidd = true;
        do{
            String str = "JPID00" + Math.round(Math.random()*1000 + 1);
            if(SDBManager.getOne("select pid from person where pid = '"+str+"'").isEmpty()){
                txtId.setText(str);
                sidd = false;
            }
        }while(sidd);
    }

    SPerControl sp = new SPerControl();
    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 jTree2_mouseClicked(MouseEvent e) {//系统树型设置事件
       JTree tree = (JTree) e.getSource();
        DefaultMutableTreeNode node = (DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
        Vector vlter = new Vector();
        vlter.addElement(jLabel2);vlter.addElement(jLabel3);
        vlter.addElement(jLabel4);vlter.addElement(jLabel5);vlter.addElement(jLabel6);
        vlter.addElement(jLabel7);vlter.addElement(jLabel8);vlter.addElement(jLabel9);
        vlter.addElement(jLabel10);vlter.addElement(jLabel11);vlter.addElement(jLabel12);
        vlter.addElement(jLabel13);vlter.addElement(jLabel14);
        Vector vbut = new Vector();
        vbut.addElement(jButton8);vbut.addElement(jButton10);vbut.addElement(jButton11);
        vbut.addElement(jButton12);vbut.addElement(jButton13);
        Vector vpnl = new Vector();
        vpnl.addElement(jPanel3);vpnl.addElement(jPanel5);vpnl.addElement(jPanel6);vpnl.addElement(jPanel7);
        Vector vtxt = new Vector();
        vtxt.addElement(txtSex);vtxt.addElement(txtName);vtxt.addElement(txtAge);
        vtxt.addElement(txtAdd);vtxt.addElement(txtPhone);vtxt.addElement(txtTiao);

        if(!node.isRoot()){
           if(node.isLeaf()){
               if(node.toString().equals("黑")){
                   for (int i = 0; i < vlter.size(); i++) {
                       JLabel jab = (JLabel)vlter.elementAt(i);
                       jab.setForeground(Color.black);
                   }
                   for (int i = 0; i < vbut.size(); i++) {
                       JButton jbt = (JButton)vbut.elementAt(i);
                       jbt.setBackground(Color.white);
                       jbt.setForeground(Color.black);
                   }
               }
               if(node.toString().equals("黄")){
                   for (int i = 0; i < vlter.size(); i++) {
                       JLabel jab = (JLabel)vlter.elementAt(i);
                       jab.setForeground(Color.yellow);
                   }
                   for (int i = 0; i < vbut.size(); i++) {
                       JButton jbt = (JButton)vbut.elementAt(i);
                       jbt.setBackground(Color.yellow);
                       jbt.setForeground(Color.black);
                   }
               }
               if(node.toString().equals("蓝")){
                   for (int i = 0; i < vlter.size(); i++) {
                       JLabel jab = (JLabel)vlter.elementAt(i);
                       jab.setForeground(Color.blue);
                   }
                   for (int i = 0; i < vbut.size(); i++) {
                       JButton jbt = (JButton)vbut.elementAt(i);
                       jbt.setBackground(Color.blue);
                       jbt.setForeground(Color.orange);
                   }
               }
               if(node.toString().equals("黑色")){
                   for (int i = 0; i < vtxt.size(); i++) {
                       JTextField jtf = (JTextField)vtxt.elementAt(i);
                       jtf.setForeground(Color.black);
                   }
               }
               if(node.toString().equals("黄色")){
                   for (int i = 0; i < vtxt.size(); i++) {