quanxian.java~88~

学生管理系统

                JOptionPane.showMessageDialog(null, "名稱不能為空");
                return;
            } else if (jTextField2.getText().equals("")) {
                JOptionPane.showMessageDialog(null, "密碼不能為空");
                return;
            } else {
                String username = jTextField1.getText();
                String password = jTextField2.getText();
                int qx = jComboBox1.getSelectedIndex() + 1;

                new sun.jdbc.odbc.JdbcOdbcDriver();
                String url = "jdbc:odbc:glxt";
                String sql =
                        "insert into usertable(username,[password],quanxian_id)values(?,?,?)";
                Connection con = null;
                PreparedStatement pre = null;
                try {
                    con = DriverManager.getConnection(url);
                    pre = con.prepareStatement(sql);
                    pre.setString(1, username);
                    pre.setString(2, password);
                    pre.setInt(3, qx);
                    pre.executeUpdate();
                    JOptionPane.showMessageDialog(null, "增加成功");
                    jTextField1.setEnabled(false);
                    jTextField2.setEnabled(false);
                    jComboBox1.setEnabled(false);
                    jTable1.setEnabled(true);
                    jButton1.setEnabled(true);
                    jButton2.setEnabled(true);
                    DefaultTableModel   dtm=(DefaultTableModel)jTable1.getModel();
                dtm.addRow(new String[] {username , password , Integer.toString(qx) });
                } catch (SQLException ex) {
                    JOptionPane.showMessageDialog(null,"新加入的用戶已存在");
                } finally {
                    try {
                        pre.close();
                        con.close();
                    } catch (SQLException ex1) {
                    }

                }
                }

                        jButton3.setText("增加");
                }

    }
//修改用戶
    public void jButton1_actionPerformed(ActionEvent e) {
        String username=null;
        String password=null;
        int qx=0;
        if (jButton1.getText().equals("修改")) {

            username = jTextField1.getText();
            jTextField1.setEnabled(true);
                   jTextField2.setEnabled(true);
                   jComboBox1.setEnabled(true);
                   jTable1.setEnabled(false);
                   jButton3.setEnabled(false);
                   jButton2.setEnabled(false);
                   jButton1.setText("確定");
                      } else if (jButton1.getText().equals("確定")) {

                   if (jTextField1.getText().equals("")) {
                       JOptionPane.showMessageDialog(null, "名稱不能為空");
                       return;
                   } else if (jTextField2.getText().equals("")) {
                       JOptionPane.showMessageDialog(null, "密碼不能為空");
                       return;
                   } else {
                       String username1 = jTextField1.getText();
                       password = jTextField2.getText();
                      qx = jComboBox1.getSelectedIndex() + 1;
                       new sun.jdbc.odbc.JdbcOdbcDriver();
                       String url = "jdbc:odbc:glxt";
                       String sql =
                        "update usertable set username=?,[password]=?,quanxian_ID=? where username=?";
                       Connection con = null;
                       PreparedStatement pre = null;
                       try {
                           con = DriverManager.getConnection(url);
                           pre = con.prepareStatement(sql);
                           pre.setString(1, username1);
                           pre.setString(2, password);
                           pre.setInt(3, qx);
                           pre.setString(4,username);
                           pre.executeUpdate();
                           JOptionPane.showMessageDialog(null, "修改成功");
                            System.out.println(row);
                           jTable1.setValueAt(jTextField1.getText(),row,0);
                           jTable1.setValueAt(jTextField2.getText(),row,1);
                           jTable1.setValueAt(jComboBox1.getSelectedItem(),row,2);
                            jTextField1.setEnabled(false);
                           jTextField2.setEnabled(false);
                           jComboBox1.setEnabled(false);
                           jTable1.setEnabled(true);
                           jButton3.setEnabled(true);
                           jButton2.setEnabled(true);
                       } catch (SQLException ex) {
                           JOptionPane.showMessageDialog(null,"修改的用戶名已存在");
                       } finally {
                           try {
                               pre.close();
                               con.close();
                           } catch (SQLException ex1) {
                           }

                       }

                        jButton1.setText("修改");
                   }
               }



    }

    public void jButton2_actionPerformed(ActionEvent e) {
        new sun.jdbc.odbc.JdbcOdbcDriver();
        String url = "jdbc:odbc:glxt";
        String sql = "delete from usertable where username=?";
        Connection con = null;
        PreparedStatement pre = null;

        try {
            con = DriverManager.getConnection(url);
            pre = con.prepareStatement(sql);
            pre.setString(1, jTextField1.getText());
            pre.executeUpdate();
            JOptionPane.showMessageDialog(null, "記錄已經被成功刪除");
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "記錄刪除失敗");
            ex.printStackTrace();
        } finally {
            try {
                pre.close();
                con.close();
            } catch (SQLException ex1) {
            }

        }

        DefaultTableModel   dtm=(DefaultTableModel)jTable1.getModel();
        dtm.removeRow(0);



        }

}


class QuanXian_jButton2_actionAdapter implements ActionListener {
    private QuanXian adaptee;
    QuanXian_jButton2_actionAdapter(QuanXian adaptee) {
        this.adaptee = adaptee;
    }

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


class QuanXian_jButton1_actionAdapter implements ActionListener {
    private QuanXian adaptee;
    QuanXian_jButton1_actionAdapter(QuanXian adaptee) {
        this.adaptee = adaptee;
    }

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


class QuanXian_jButton3_actionAdapter implements ActionListener {
    private QuanXian adaptee;
    QuanXian_jButton3_actionAdapter(QuanXian adaptee) {
        this.adaptee = adaptee;
    }

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


class QuanXian_jComboBox1_actionAdapter implements ActionListener {
    private QuanXian adaptee;
    QuanXian_jComboBox1_actionAdapter(QuanXian adaptee) {
        this.adaptee = adaptee;
    }

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


class QuanXian_jTable1_keyAdapter extends KeyAdapter {
    private QuanXian adaptee;
    QuanXian_jTable1_keyAdapter(QuanXian adaptee) {
        this.adaptee = adaptee;
    }

    public void keyPressed(KeyEvent e) {
        adaptee.jTable1_keyPressed(e);
    }
}


class QuanXian_jTable1_mouseAdapter extends MouseAdapter {
    private QuanXian adaptee;
    QuanXian_jTable1_mouseAdapter(QuanXian adaptee) {
        this.adaptee = adaptee;
    }

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