void deleteButton_actionPerformed(ActionEvent e) {  // 處理deleteButton(刪除按鈕)的ActionEvent    try {      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 實例化JDBC-ODBC橋的驅動      String url = "jdbc:odbc:TestDbStu";             // 設置連接字符串      connection = DriverManager.getConnection(url);  // 連接數據庫      // 創建Statement接口對象      statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);      String sql = "select * from studentbase where 學號="+Integer.parseInt(stunumField.getText()) ;      rSet = statement.executeQuery(sql);             // 執行學號為輸入學號的查詢語句      if (rSet.next()==false) {                       // 判斷數據庫中是否有要刪除的記錄，如沒有則顯示提示框        JOptionPane msg = new JOptionPane();        JOptionPane.showMessageDialog(StuAddQuerySysFrame.this, "數據庫中沒有您刪除的學號", "數據庫中沒有您刪除的學號！", 1);      }      else {        String sql1="delete from studentbase where 學號="+Integer.parseInt(stunumField.getText());        statement.executeUpdate(sql1);             // 刪除studentbase表中對應學號的數據記錄        String sql2="delete from studentaddress where 學號="+Integer.parseInt(stunumField.getText());        statement.executeUpdate(sql2);             // 刪除studentaddress表中對應學號的數據記錄        // 清空信息框        stunumField.setText("");        nameField.setText("");        ageField.setText("");        sexField.setText("");        departmentField.setText("");      }    }    catch(SQLException ex){                        // 捕捉異常      System.out.println("\nERROR:----- SQLException -----\n");      while (ex != null) {        System.out.println("Message:   " + ex.getMessage());        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());        ex = ex.getNextException();      }    }    catch(Exception ex ) {      ex.printStackTrace();    }    finally {      try {        if(statement != null) {          statement.close();                                // 關閉Statement接口實例        }        if(connection != null) {          connection.close();                               // 關閉Connection接口實例        }      }      catch (SQLException ex)  {        System.out.println("\nERROR:----- SQLException -----\n");        System.out.println("Message:   " + ex.getMessage( ));        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());      }    }  }  void refreshButton_actionPerformed(ActionEvent e) { // 處理refreshButton(修改按鈕)的ActionEvent    try {      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 實例化JDBC-ODBC橋的驅動      String url = "jdbc:odbc:TestDbStu";             // 設置連接字符串      connection = DriverManager.getConnection(url);  // 連接數據庫      // 創建Statement接口對象      statement = connection.createStatement();      String sql1="update studentbase set 姓名='"+nameField.getText()+"', 年齡="+Integer.parseInt(ageField.getText())+" ,性別='"+sexField.getText()+"',系名='"+departmentField.getText()+"' where 學號="+Integer.parseInt(stunumField.getText());      statement.executeUpdate(sql1);             // 更新studentbase表中輸入學號的記錄      String sql2="update studentaddress set 電話='"+teleField.getText()+"', Email地址='"+emailField.getText()+"' where 學號="+Integer.parseInt(stunumField.getText());      statement.executeUpdate(sql2);             // 更新studentaddress表中輸入學號的記錄      // 清空信息框      stunumField.setText("");      nameField.setText("");      ageField.setText("");      sexField.setText("");      departmentField.setText("");      teleField.setText("");      emailField.setText("");    }    catch(SQLException ex){                        // 捕捉異常      System.out.println("\nERROR:----- SQLException -----\n");      while (ex != null) {        System.out.println("Message:   " + ex.getMessage());        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());        ex = ex.getNextException();      }    }    catch(Exception ex ) {      ex.printStackTrace();    }    finally {      try {        if(statement != null) {          statement.close();                                // 關閉Statement接口實例        }        if(connection != null) {          connection.close();                               // 關閉Connection接口實例        }      }      catch (SQLException ex)  {        System.out.println("\nERROR:----- SQLException -----\n");        System.out.println("Message:   " + ex.getMessage( ));        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());      }    }  }  void stunumqueryButton_actionPerformed(ActionEvent e) {  // 處理stunumqueryButton(學號查詢按鈕)的ActionEvent    try {      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 實例化JDBC-ODBC橋的驅動      String url = "jdbc:odbc:TestDbStu";             // 設置連接字符串      connection = DriverManager.getConnection(url);  // 連接數據庫      // 創建Statement接口對象      statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);      String sql = "select * from studentbase where 學號="+Integer.parseInt(stunumField.getText()) ;      rSet = statement.executeQuery(sql);             // 執行學號為輸入學號的查詢語句      if (rSet.next()==false) {                       // 判斷數據庫中是否有要查詢的記錄，如沒有則顯示提示框        JOptionPane msg = new JOptionPane();        JOptionPane.showMessageDialog(StuAddQuerySysFrame.this, "數據庫中沒有您查詢的學號", "數據庫中沒有您查詢的學號！", 1);      }      else {        sql = "select studentbase.學號,姓名,年齡,性別,系名,電話,EMAIL地址 from studentbase inner join studentaddress on (studentbase.學號=studentaddress.學號) where studentbase.學號="+Integer.parseInt(stunumField.getText()) ;        ResultSet rs = statement.executeQuery(sql);   // 執行表studentbase、studentaddress的聯合查詢語句，將結果集放入rs中        stunumField.setText("") ;             // 清空輸入學號        vector.removeAllElements();          // 初始化向量對象        tm.fireTableStructureChanged();      // 更新表格內容        while(rs.next())        {          Vector rec_vector = new Vector();          // 從結果集中取數據放入向量rec_vector中          rec_vector.addElement(String.valueOf(rs.getInt(1)));          rec_vector.addElement(rs.getString(2));          rec_vector.addElement(String.valueOf(rs.getInt(3)));          rec_vector.addElement(rs.getString(4));          rec_vector.addElement(rs.getString(5));          rec_vector.addElement(rs.getString(6));          rec_vector.addElement(rs.getString(7));          vector.addElement(rec_vector);      // 向量rec_vector加入向量vector中        }        tm.fireTableStructureChanged();       // 更新表格，顯示向量vector的內容      }    }    catch(SQLException ex){                   // 捕捉異常      System.out.println("\nERROR:----- SQLException -----\n");      while (ex != null) {        System.out.println("Message:   " + ex.getMessage());        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());        ex = ex.getNextException();      }    }    catch(Exception ex ) {      ex.printStackTrace();    }    finally {      try {        if(statement != null) {          statement.close();                                // 關閉Statement接口實例        }        if(connection != null) {          connection.close();                               // 關閉Connection接口實例        }      }      catch (SQLException ex)  {        System.out.println("\nERROR:----- SQLException -----\n");        System.out.println("Message:   " + ex.getMessage( ));        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());      }    }  }  void allrecordButton_actionPerformed(ActionEvent e) {// 處理allrecordButton(全部記錄按鈕)的ActionEvent    try {      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 實例化JDBC-ODBC橋的驅動      String url = "jdbc:odbc:TestDbStu";             // 設置連接字符串      connection = DriverManager.getConnection(url);  // 連接數據庫      // 創建Statement接口對象      statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);      String sql = "select studentbase.學號,姓名,年齡,性別,系名,電話,EMAIL地址 from studentbase inner join studentaddress on (studentbase.學號=studentaddress.學號)";      rSet = statement.executeQuery(sql);     // 執行表studentbase、studentaddress的聯合查詢語句，將結果集放入rSet中      vector.removeAllElements();                     // 初始化向量對象      tm.fireTableStructureChanged();                 // 更新表格內容      while(rSet.next()) {        Vector rec_vector = new Vector();        // 從結果集中取數據放入向量rec_vector中        rec_vector.addElement(String.valueOf(rSet.getInt(1)));        rec_vector.addElement(rSet.getString(2));        rec_vector.addElement(String.valueOf(rSet.getInt(3)));        rec_vector.addElement(rSet.getString(4));        rec_vector.addElement(rSet.getString(5));        rec_vector.addElement(rSet.getString(6));        rec_vector.addElement(rSet.getString(7));        vector.addElement(rec_vector);                // 向量rec_vector加入向量vector中      }      tm.fireTableStructureChanged();                 // 更新表格，顯示向量vector的內容    }    catch(SQLException ex){                   // 捕捉異常      System.out.println("\nERROR:----- SQLException -----\n");      while (ex != null) {        System.out.println("Message:   " + ex.getMessage());        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());        ex = ex.getNextException();      }    }    catch(Exception ex ) {      ex.printStackTrace();    }    finally {      try {        if(statement != null) {          statement.close();                                // 關閉Statement接口實例        }        if(connection != null) {          connection.close();                               // 關閉Connection接口實例        }      }      catch (SQLException ex)  {        System.out.println("\nERROR:----- SQLException -----\n");        System.out.println("Message:   " + ex.getMessage( ));        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());      }    }  }}