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 jButton2_actionPerformed(ActionEvent e)                  // 處理添加按鈕)的ActionEvent
    {
      try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動
        connection = DriverManager.getConnection("jdbc:odbc:local", "sa",
                                                 "hunterd"); // 連接數據庫
        // 創建Statement接口對象
        statement = connection.createStatement();
        String sql1 = "insert  into stu_info  values ('" + jTextField1.getText() +
            "','" + jTextField2.getText() + "','" + jTextField3.getText() + "','" +
            jTextField4.getText() + "')";
        if (jTextField1.getText().length() == 0) {
          jTextPane1.setText("不能修改，請先輸入學號！");
          // 清空信息框
          jTextField1.setText("");
          jTextField2.setText("");
          jTextField3.setText("");
          jTextField4.setText("");
        }
        else {
          statement.executeUpdate(sql1); // stu_info表中添加記錄
          jTextPane1.setText("記錄添加成功!");
          // 清空信息框
          jTextField1.setText("");
          jTextField2.setText("");
          jTextField3.setText("");
          jTextField4.setText("");
        }
      }
      catch (SQLException ex) { // 捕捉異常
        jTextPane1.setText(ex.getMessage());
        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  jButton3_actionPerformed(ActionEvent e)                  // 處理刪除按鈕的ActionEvent
   {
      try
      {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");           // 實例化JDBC-ODBC橋的驅動
        connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd");  // 連接數據庫
        // 創建Statement接口對象
        statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        rSet = statement.executeQuery("select 學號 from stu_info ");
        if (rSet.next()==false)                        // 判斷數據庫中是否有要刪除的記錄，如沒有則顯示提示框
        {
          jTextField5.setText("");
          jTextPane1.setText("數據庫中沒有您要刪除的學號!");
        }
        else
        {
          String sql2="delete from stu_info where 學號='"+jTextField5.getText()+"'";
          statement.executeUpdate(sql2);             // 刪除stu_info表中對應學號的數據記錄
          // 清空信息框
          jTextField1.setText("");
          jTextField2.setText("");
          jTextField3.setText("");
          jTextField4.setText("");
          jTextField5.setText("");
          jTextPane1.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 jButton4_actionPerformed(ActionEvent e)
    {
      jTextField1.setText("");
      jTextField2.setText("");
      jTextField3.setText("");
      jTextField4.setText("");
      jTextField5.setText("");
      jTextPane1.setText("");
    }

    void jButton5_actionPerformed(ActionEvent e)             // 處理查詢按鈕的ActionEvent
    {
      try
      {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 實例化JDBC-ODBC橋的驅動
        connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd");  // 連接數據庫
        // 創建Statement接口對象
        statement = connection.createStatement();
        rSet = statement.executeQuery("select * from stu_info ");
        String sno;
        sno = rSet.getString(1);
        if (rSet.next()==false)                  // 判斷數據庫中是否有要查詢的記錄，如沒有則顯示提示框
        {
          jTextField5.setText("");
          jTextPane1.setText("數據庫中沒有您查詢的學號!");
        }
        else{
          if (sno.equals(jTextField5.getText())) {
              jTextField5.setText("");
              jTextPane1.setText("查詢信息如下:"); //顯示數據
              jTextField1.setText(rSet.getString(1));
              jTextField2.setText(rSet.getString(2));
              jTextField3.setText(rSet.getString(3));
              jTextField4.setText(rSet.getString(4));
            }
            else
            {
              jTextField5.setText("");
              jTextPane1.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());
      }
    }
  }
}
class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton4_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton2_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}
class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton3_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton5_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}