deleteaction.java~4~

简单的硬盘配置界面

package informationsystem.gui;

import java.awt.event.*;
import informationsystem.gui.MainWindow;
import informationsystem.database.DBHandler;
public class DeleteAction
    implements ActionListener {
  private MainWindow window;
  private DBHandler db = new DBHandler();

  public DeleteAction(MainWindow window) {
    this.window = window;
  }

  /**
   * Invoked when an action occurs.
   *
   * @param e ActionEvent
   * @todo Implement this java.awt.event.ActionListener method
   */
  public void actionPerformed(ActionEvent e) {
    try
      {
        String number = this.window.jTextField1.getText();
        if(number.equals(""))
        {
          this.window.jTextPane1.setText("请输入学号!");
          return;
        }
        if (db.validate(number))                        // 判断数据库中是否有要删除的记录，如没有则显示提示框
        {
          this.window.jTextField1.setText("");
          this.window.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());
        }
      }

  }
}