timeframe1.java~108~

java语言做的教务管理系统

                obj.setLocation(0, 0);
                obj.setVisible(true);
            }
            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);
            }
            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);
            }
            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);
            }
            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);
            }
            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);
            }
            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);
            }
            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);
            }
            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);

            }
            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);
                }
                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);
                }
                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);
                }
                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);
                }
                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);
                }

            }
        } 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(
                    "update go set Logoff=?,Appearance='离线' where useid= '" +
                    this.txtid.getText() + "'");
            sql.setString(1, this.txttime.getText());
            int i = sql.executeUpdate();
            if (i > 0) {
                Lordmain obj = new Lordmain();
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                this.dispose();
            }
        } catch (Exception ex) {

        }
    }

    public void jMenuItem2_actionPerformed(ActionEvent e) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:studer");
            PreparedStatement sql = conn.prepareStatement(
                    "update go set Logoff=?,Appearance='离线' where useid= '" +
                    this.txtid.getText() + "'");
            sql.setString(1, this.txttime.getText());
            int i = sql.executeUpdate();
            if (i > 0) {
                Lordmain obj = new Lordmain();
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                       getScreenSize();
                obj.setSize(screenSize);
                obj.setLocation(0, 0);
                obj.setVisible(true);
                this.dispose();
            }
        } catch (Exception ex) {

        }
    }

    public void jMenuItem15_actionPerformed(ActionEvent e) {
        System.exit(0);
    }

    public void btnclassadd_actionPerformed(ActionEvent e) {
        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);
    }

    public void btnclassselect_actionPerformed(ActionEvent e) {
        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);
    }

    public void btnstuadd_actionPerformed(ActionEvent e) {
        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);
    }

    public void btnstuselect_actionPerformed(ActionEvent e) {
        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);
    }

    public void btnremarkadd_actionPerformed(ActionEvent e) {
        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);
    }

    public void btnremarkselect_actionPerformed(ActionEvent e) {
        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);
    }

    public void jMenuItem3_actionPerformed(ActionEvent e) {
        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);
    }

    public void mnustudel_actionPerformed(ActionEvent e) {
        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);
    }

    public void jMenuItem7_actionPerformed(ActionEvent e) {
        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);
    }

    public void jMenuItem8_actionPerformed(ActionEvent e) {
        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);
    }

    public void jMenuItem9_actionPerformed(ActionEvent e) {
        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);
    }

    public void jMenuItem10_actionPerformed(ActionEvent e) {
        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);
    }

    public void mnustuupdate_actionPerformed(ActionEvent e) {
        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);
    }