userguanli.java

S1项目本需求规格说明描述了北大青鸟ACCP教学管理系统项目的要求

                                   getScreenSize();
            this.dispose();
        }

    }


    public void btnNew_actionPerformed(ActionEvent e) {
        try {
            if (this.txtUserName.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入用户名！");
                return;
            }
            if (String.valueOf(this.txtPassword.getPassword()).equals("")) {
                JOptionPane.showMessageDialog(this, "请输入密码！");
            }
            if (this.cmbUserType.getSelectedItem().toString().equals("")) {
                JOptionPane.showMessageDialog(this, "请选择用户类型！");
                return;
            }
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:xiangmu");
            PreparedStatement ps = con.prepareStatement("insert into SysUser(UserName,Password,UserType,registerDate,logoutDate,Status,remark) values(?,?,?,?,?,?,?)");
            ps.setString(1, this.txtUserName.getText());
            ps.setString(2, String.valueOf(this.txtPassword.getPassword()));
            ps.setString(3, this.cmbUserType.getSelectedItem().toString());
            ps.setString(4, this.txtzhuceDate.getText());
            //ps.setString(5,this.txtzhuxiaoDate.getText());
            Date obj = new Date();
            String str = obj.toString();
            SimpleDateFormat zxObj = new SimpleDateFormat(
                    "yyyy-MM-dd hh:mm:ss");
            ps.setString(5, zxObj.format(obj));
            ps.setString(6, this.cmbstatus.getSelectedItem().toString());
            ps.setString(7, this.txaRemark.getText());
            int rows = ps.executeUpdate();
            //判断是否执行成功
            if (rows > 0) {
                JOptionPane.showMessageDialog(this, "添加成功！");
            } else {
                JOptionPane.showMessageDialog(this, "添加失败！");
            }
            //关闭已打开的资源
            ps.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(this, "添加失败！");
        }

    }

    public void jTable1_mouseClicked(MouseEvent e) {
        try {
            int row = this.jTable1.getSelectedRow();
            if (row > -1) {
                this.txtUserName.setText(this.jTable1.getValueAt(row, 0).
                                         toString());
                this.txtPassword.setText(this.jTable1.getValueAt(row, 1).
                                         toString());
                this.cmbUserType.setSelectedItem(this.jTable1.getValueAt(row, 2).
                                                 toString());
                this.txtzhuceDate.setText(this.jTable1.getValueAt(row, 3).
                                          toString());
                this.txtzhuxiaoDate.setText(this.jTable1.getValueAt(row, 4).
                                            toString());
                this.cmbstatus.setSelectedItem(this.jTable1.getValueAt(row, 5).
                                               toString());
                this.txaRemark.setText(this.jTable1.getValueAt(row, 6).
                                       toString());
            }

        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }

    public void btnDel_actionPerformed(ActionEvent e) {
        try {
            int row = this.jTable1.getSelectedRow();
            if (JOptionPane.showConfirmDialog(this, "你确定删除吗?", "删除提示",
                                              JOptionPane.OK_CANCEL_OPTION) ==
                JOptionPane.OK_OPTION) {
                if (row < 0) {
                    JOptionPane.showMessageDialog(this, "请选择数据");
                    return;
                }
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection nod = DriverManager.getConnection(
                        "jdbc:odbc:xiangmu");
                PreparedStatement sql = nod.prepareStatement(
                        "delete from SysUser where UserName = ?");
                sql.setString(1, this.jTable1.getValueAt(row, 0).toString());
                int i = sql.executeUpdate();
                if (i > 0) {
                    bg.removeRow(row);
                    JOptionPane.showMessageDialog(this, "删除成功");
                } else {
                    JOptionPane.showMessageDialog(this, "删除失败");
                }
                this.txtUserName.setText("");
                this.txtPassword.setText("");
                this.txaRemark.setText("");
                this.cmbUserType.setSelectedItem("");
                this.cmbstatus.setSelectedItem("");
                this.txtzhuceDate.setText("");
                this.txtzhuxiaoDate.setText("");
                sql.close();
                nod.close();
            }
        } catch (Exception ex) {

        }

    }

    public void btnshuaxin_actionPerformed(ActionEvent e) {
        try {
            String sql = "select * from SysUser where 1=1 ";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            bg.setRowCount(0);
            while (rs.next()) {
                Object val[] = {rs.getString(1), rs.getString(2),
                               rs.getString(3), rs.getString(4), rs.getString(5),
                               rs.getString(6),
                               rs.getString(7)};
                bg.addRow(val);
            }
            jTable1.updateUI();
            this.txtUserName.setText("");
            this.txtPassword.setText("");
            this.cmbUserType.setSelectedItem("");
            this.txtzhuceDate.setText("");
            this.txtzhuxiaoDate.setText("");
            this.cmbstatus.setSelectedItem("");
            this.txaRemark.setText("");

            rs.close();
            ps.close();
            conn.close();
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "刷新失败！");
        }
    }

    public void this_windowOpened(WindowEvent e) {
        denglu obj = new denglu();
         userType = obj.cmbUserType.getSelectedItem().toString();
         if (denglu.userType.equals("普通用户")) {
             this.btnEdit.setEnabled(false);
             this.btnDel.setEnabled(false);

        }

    }


    class Userguanli_btnNew_actionAdapter implements ActionListener {
        private Userguanli adaptee;
        Userguanli_btnNew_actionAdapter(Userguanli adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnNew_actionPerformed(e);
        }
    }


    class Userguanli_btnExit_actionAdapter implements ActionListener {
        private Userguanli adaptee;
        Userguanli_btnExit_actionAdapter(Userguanli adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnExit_actionPerformed(e);
        }
    }


    class Userguanli_btnEdit_actionAdapter implements ActionListener {
        private Userguanli adaptee;
        Userguanli_btnEdit_actionAdapter(Userguanli adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnEdit_actionPerformed(e);
        }
    }


    class Userguanli_cmbstatus_actionAdapter implements ActionListener {
        private Userguanli adaptee;
        Userguanli_cmbstatus_actionAdapter(Userguanli adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.cmbstatus_actionPerformed(e);
        }
    }


    class Userguanli_jTextField1_actionAdapter implements ActionListener {
        private Userguanli adaptee;
        Userguanli_jTextField1_actionAdapter(Userguanli adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.jTextField1_actionPerformed(e);
        }
    }
}


class Userguanli_this_windowAdapter extends WindowAdapter {
    private Userguanli adaptee;
    Userguanli_this_windowAdapter(Userguanli adaptee) {
        this.adaptee = adaptee;
    }

    public void windowOpened(WindowEvent e) {
        adaptee.this_windowOpened(e);
    }
}


class Userguanli_btnshuaxin_actionAdapter implements ActionListener {
    private Userguanli adaptee;
    Userguanli_btnshuaxin_actionAdapter(Userguanli adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnshuaxin_actionPerformed(e);
    }
}


class Userguanli_btnDel_actionAdapter implements ActionListener {
    private Userguanli adaptee;
    Userguanli_btnDel_actionAdapter(Userguanli adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDel_actionPerformed(e);
    }
}


class Userguanli_jTable1_mouseAdapter extends MouseAdapter {
    private Userguanli adaptee;
    Userguanli_jTable1_mouseAdapter(Userguanli adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable1_mouseClicked(e);
    }
}