frame1.java~84~

学生宿舍管理信息系统,大家快来看看,看有什么错误,对你学JAVA有好处的

        {
          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 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() + "')";
        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 statement = connection.createStatement();
        rSet = statement.executeQuery("select * from stu_info ");
        查询记录 = 0;
        String sno;
        sno = rSet.getString("学号");
       while (rSet.next()==true) {
          if (sno.equals(jTextField5.getText())){
            jTextField5.setText("");
            jTextPane1.setText("查询信息如下:"); //显示数据
            jTextField1.setText(rSet.getString("学号"));
            jTextField2.setText(rSet.getString("姓名"));
            jTextField3.setText(rSet.getString("所属学院"));
            jTextField4.setText(rSet.getString("所属班级"));
            break;
          }
          else{
            jTextField5.setText("");
            jTextPane1.setText("数据库中没有您查询的学号!");
          }
          rSet.close();
        }
      }

      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);
  }
}