timeframe1.java~114~

java语言做的教务管理系统

        jPanel1.add(jLabel2);
        jPanel1.add(txtid);
        jPanel1.add(jLabel3);
        jPanel1.add(txttype);
        jPanel1.add(jLabel4);
        jPanel1.add(txtRegister);
        jPanel1.add(jLabel5);
        jPanel1.add(txtLogoff);
        jPanel1.add(jLabel6);
        jPanel1.add(txtAppearance);
        jPanel1.add(jLabel7);
        jPanel1.add(txtRemarks);
        jPanel1.add(btnjihuo);
        jPanel1.add(jButton1);
        this.getContentPane().add(trmod, null);
        this.getContentPane().add(pnlLord);
        this.getContentPane().add(jToolBar1);
        jToolBar1.add(btngo);
        jToolBar1.add(btnstuadd);
        jToolBar1.add(btnstuselect);
        jToolBar1.add(btnclassadd);
        jToolBar1.add(btnclassselect);
        jToolBar1.add(btnremarkadd);
        jToolBar1.add(btnremarkselect);
        jToolBar1.add(btnallselect);
        jToolBar1.add(btnexit);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(txttime);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel9);
        btnjihuo.setText("激活窗体");
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(mnustu);
        jMenuBar1.add(mnuclass);
        jMenuBar1.add(mnuremerk);
        jMenuBar1.add(jMenu5);
        jMenu1.add(mnugo);
        jMenu1.add(mnusuperadd);
        jMenu1.add(jMenuItem2);
        jMenu1.add(jMenuItem15);
        mnustu.add(mnustuadd);
        mnustu.add(mnustudel);
        mnustu.add(mnustuupdate);
        mnustu.add(mnustuselect);
        mnuclass.add(jMenuItem7);
        mnuclass.add(jMenuItem8);
        mnuclass.add(jMenuItem9);
        mnuclass.add(jMenuItem10);
        mnuremerk.add(jMenuItem11);
        mnuremerk.add(jMenuItem12);
        mnuremerk.add(jMenuItem13);
        mnuremerk.add(jMenuItem14);
    }

    public void jMenuItem1_actionPerformed(ActionEvent e) {
        go obj = new go();
        obj.setSize(350, 200);
        obj.setModal(true);
        obj.setLocation(200, 200);
        obj.setVisible(true);
        this.txtid.setText(obj.txtid.getText());
    }

    public void trmod_valueChanged(TreeSelectionEvent e) {
        try {
            DefaultMutableTreeNode nod = (DefaultMutableTreeNode) trmod.
                                         getLastSelectedPathComponent();
            String age = nod.getUserObject().toString();
            if (age.equals("添加班级")) {
                classadd obj = new classadd();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("添加班级信息");
            }
            if (age.equals("删除班级")) {
                classdel obj = new classdel();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("删除班级信息");
            }
            if (age.equals("修改班级")) {
                classupdate obj = new classupdate();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("修改班级信息");
            }
            if (age.equals("查看班级")) {
                classselect obj = new classselect();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("查询班级信息");
            }
            if (age.equals("添加学生")) {
                stuadd obj = new stuadd();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("添加学生信息");
            }
            if (age.equals("删除学生")) {
                studel obj = new studel();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("删除学生信息");
            }
            if (age.equals("修改学生")) {
                stuupdate obj = new stuupdate();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("修改学生信息");
            }
            if (age.equals("查看学生")) {
                stuselect obj = new stuselect();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("查询学生信息");
            }
            if (age.equals("添加成绩")) {
                remarkadd obj = new remarkadd();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("添加成绩信息");
            }
            if (age.equals("删除成绩")) {
                remarkdel obj = new remarkdel();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("删除成绩信息");
            }
            if (age.equals("修改成绩")) {
                remarkupdate obj = new remarkupdate();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("修改成绩信息");

            }
            if (age.equals("查询成绩")) {
                remarkselect obj = new remarkselect();
                this.pnlLord.removeAll();
                this.pnlLord.add(obj);
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                jLabel9.setText("查询成绩信息");
            }
        } catch (Exception ex) {

        }
    }

    public void btnjihuo_actionPerformed(ActionEvent e) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection nod = DriverManager.getConnection("jdbc:odbc:studer");
            PreparedStatement sqlupdate = nod.prepareStatement(
                    "update go set Appearance='上线' where useid='" +
                    this.txtid.getText() + "'");
            sqlupdate.executeUpdate();

            PreparedStatement sql = nod.prepareStatement(
                    "select Type,Register,Logoff,Appearance,Remarks from go where useid = ?");
            sql.setString(1, this.txtid.getText());
            ResultSet i = sql.executeQuery();
            if (i.next()) {
                String type = i.getString(1);
                String register = i.getString(2);
                String logoff = i.getString(3);
                String appearance = i.getString(4);
                String remarks = i.getString(5);
                this.txttype.setText(type);
                this.txtRegister.setText(register);
                this.txtLogoff.setText(logoff);
                this.txtAppearance.setText(appearance);
                this.txtRemarks.setText(remarks);
                this.mnugo.setEnabled(false);
                this.btngo.setEnabled(false);
                if (type.equals("系统管理员")) {
                    this.mnusuperadd.setEnabled(true);
                    this.mnustu.setEnabled(true);
                    this.mnuclass.setEnabled(true);
                    this.mnuremerk.setEnabled(true);
                    this.btnclassadd.setEnabled(true);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkadd.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuadd.setEnabled(true);
                    this.btnstuselect.setEnabled(true);
                    this.trmod.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                }
                if (type.equals("成绩管理员")) {
                    this.mnusuperadd.setEnabled(false);
                    this.mnustu.setEnabled(false);
                    this.mnuclass.setEnabled(false);
                    this.mnuremerk.setEnabled(true);
                    this.btnclassadd.setEnabled(false);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkadd.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuadd.setEnabled(false);
                    this.btnstuselect.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                }
                if (type.equals("学生管理员")) {
                    this.mnusuperadd.setEnabled(false);
                    this.mnustu.setEnabled(true);
                    this.mnuclass.setEnabled(false);
                    this.mnuremerk.setEnabled(false);
                    this.btnstuadd.setEnabled(true);
                    this.btnclassadd.setEnabled(false);
                    this.btnremarkadd.setEnabled(false);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuselect.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                }
                if (type.equals("班级管理员")) {
                    this.mnusuperadd.setEnabled(false);
                    this.mnustu.setEnabled(false);
                    this.mnuclass.setEnabled(true);
                    this.mnuremerk.setEnabled(false);
                    this.btnstuadd.setEnabled(false);
                    this.btnclassadd.setEnabled(true);
                    this.btnremarkadd.setEnabled(false);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuselect.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                }
                if (type.equals("普通用户")) {
                    this.mnusuperadd.setEnabled(false);
                    this.mnustu.setEnabled(false);
                    this.mnuclass.setEnabled(false);
                    this.mnuremerk.setEnabled(false);
                    this.btnstuadd.setEnabled(false);
                    this.btnclassadd.setEnabled(false);
                    this.btnremarkadd.setEnabled(false);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuselect.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                }
                this.btnjihuo.setEnabled(false);
            }
        } catch (Exception ex) {
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:studer");
            PreparedStatement sql = conn.prepareStatement(