quanxian.java

学生管理系统

                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();//執行SQL語句
                    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 , String.valueOf(jComboBox1.getSelectedItem()) });
                } 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=jTextField1.getText();//保存原用戶名
        String password=null;
        int qx=0;
        if (jButton1.getText().equals("修改")) {//是否為修改
            //——————初始化界面
            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";
                      //修改SQL語句
                       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();
//                           System.out.println("1>>>>"+username1);
//                           System.out.println("2>>>>"+password);
//                          System.out.println("3>>>>"+qx);
//                          System.out.println("4>>>>"+username);

                           JOptionPane.showMessageDialog(null, "修改成功");
                           //在表中改記錄
                           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) {
        if(jTable1.getSelectedRow()!=-1){//查看表中是否有記錄被選中
        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(row);
        }else{
            JOptionPane.showMessageDialog(null,"請先選擇用戶才能執行。");
        }


        }

}

//以下系統自動生成
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);
    }
}