Events下ItemListener中的ItemStateChange的超强响应

最新推荐文章于 2021-03-01 15:23:14 发布

zings

最新推荐文章于 2021-03-01 15:23:14 发布

阅读量882

点赞数

分类专栏： swing 文章标签： events class exception sql string c

本文链接：https://blog.csdn.net/zings/article/details/2800434

版权

swing 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

//在Events下选择ItemListener中的ItemStateChanged直接响应事件
private void major_testComboBoxItemStateChanged(ItemEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  ResultSet resultSet1 = null;
  ResultSet resultSet2 = null;
  ResultSet resultSets = null;

  this.class_testComboBox.removeAllItems();
  this.class_testComboBox.updateUI();
  this.sub_testComboBox.removeAllItems();
  this.sub_testComboBox.updateUI();
  this.teacher_testComboBox.removeAllItems();
  this.teacher_testComboBox.updateUI();

  try{
   connection = fetchconnection();
   statement = connection.createStatement();

   String sql = "select c.class_name from class c,specialty s"+
                         " where c.spe_id=s.spe_id and s.spe_name='"+
                        this.major_testComboBox.getSelectedItem()+"'";//查询class表的class_name对应选中的spe_name
   String sql1 = "select sb.sub_name from subject sb,spesub ss,specialty sp"+
                         " where ss.sub_id=sb.sub_id and ss.spe_id=sp.spe_id and sp.spe_name='"+
                        this.major_testComboBox.getSelectedItem()+"'";//查询subject表的sub_name对应选中的spe_name
   String sql2 = "select t.teacher_name from teacher t,class c,classteacher ct,specialty s"+
                          " where ct.teacher_id=t.teacher_id and ct.class_id=c.class_id and c.spe_id=s.spe_id and s.spe_name='"+
                        this.major_testComboBox.getSelectedItem()+"'";//查询teacher表的teacher_name对应选中的spe_name
   resultSet = statement.executeQuery(sql);
   while(resultSet.next()) {
      this.class_testComboBox.addItem(resultSet.getString("class_name"));//显示数据在JComboBox中
   }
   resultSet1 = statement.executeQuery(sql1);
   while(resultSet1.next()) {
      this.sub_testComboBox.addItem(resultSet.getString("sub_name"));//显示数据在JComboBox中
      }
            resultSet2 = statement.executeQuery(sql2);
            while(resultSet2.next()) {
      this.teacher_testComboBox.addItem(resultSet.getString("teacher_name"));//显示数据在JComboBox中
     }
            this.textpointTextArea.show();
               //对应的class_name时候的class_id
            String sqltwo = "select class_id from class where class_name='"+
                            this.class_testComboBox.getSelectedItem()+"'";
            resultSets = statement.executeQuery(sqltwo);
   while(resultSets.next()) {
    this.class_idTextField.setText(resultSets.getString("class_id"));
   }

   //   对应的sub_name时候的sub_id
   sqltwo = "select sub_id from subject where sub_name='"+
               this.sub_testComboBox.getSelectedItem()+"'";
         resultSets = statement.executeQuery(sqltwo);
         while(resultSets.next()) {
       this.testsub_idTextField.setText(resultSets.getString("sub_id"));//显示数据在JComboBox中
   }

         //       对应的teacher_name时候的teacher_id
         sqltwo = "select teacher_id from teacher where teacher_name='"+
            this.teacher_testComboBox.getSelectedItem()+"'";
         resultSets = statement.executeQuery(sqltwo);
         while(resultSets.next()) {
         this.teacher_idTextField.setText(resultSets.getString("teacher_id"));
         }


  }
  catch(Exception e)
  {
     e.printStackTrace();
  }
  finally{
   resultSets.close();
   resultSet2.close();
   resultSet1.close();
   resultSet.close();
   statement.close();
   connection.close();
  }
}

private void class_testComboBoxItemStateChanged(ItemEvent evt) throws SQLException {
  this.classname_testTextField.setText((String) this.class_testComboBox.getSelectedItem());

  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
  //         对应的teacher_name时候的teacher_id
  String sql = "select class_id from class where class_name='"+
                     this.class_testComboBox.getSelectedItem()+"'";
        resultSet = statement.executeQuery(sql);
        while(resultSet.next()) {
            this.class_idTextField.setText(resultSet.getString("class_id"));//显示数据在JComboBox中
     }
  }
        catch(Exception e)
  {
     e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
}