stuaddquerysysframe.java

java开发的学生管理系统

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