score_input_dialog.java

包含了7个java经典案例

    column12.setSqlType(-7);
    this.setResizable(false);
    this.setTitle("成绩录入");
    getContentPane().add(panel1);
    panel1.add(jLabel1,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(28, 28, 0, 0), 0, 0));
    panel1.add(jdbComboBox1,  new GridBagConstraints(1, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(28, 0, 0, 0), 100, 1));
    panel1.add(jLabel3,  new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(25, 21, 0, 0), 0, 0));
    panel1.add(jdbComboBox3,  new GridBagConstraints(1, 1, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(22, 0, 0, 0), 101, 1));
    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 2, 5, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(21, 21, 0, 15), 78, -138));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    panel1.add(jButton1,  new GridBagConstraints(4, 0, 1, 2, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(35, 29, 0, 24), 0, 27));
    panel1.add(jdbComboBox2,  new GridBagConstraints(3, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(28, 28, 0, 0), 95, 1));
    panel1.add(jLabel2,  new GridBagConstraints(2, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(28, 15, 0, 0), 0, 0));
    panel1.add(jLabel4,  new GridBagConstraints(2, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(24, 16, 0, 11), 0, 0));
    panel1.add(jdbComboBox4,  new GridBagConstraints(3, 1, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(22, 28, 0, 0), 98, 1));
    panel1.add(jButton3, new GridBagConstraints(3, 3, 1, 1, 0.0, 0.0
            ,GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(19, 64, 21, 16), 19, 0));
    panel1.add(jButton2,   new GridBagConstraints(1, 3, 1, 1, 0.0, 0.0
            ,GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(21, 49, 20, 12), 19, 0));

    int count = 0;
    try{
      if(!queryDataSet2.isOpen()) queryDataSet2.open();
      count = queryDataSet2.getRowCount();
      queryDataSet2.first();
      for (int i = 0; i < count; i++) {
        jdbComboBox1.addItem(queryDataSet2.getString("code"));
        queryDataSet2.next();
      }
      queryDataSet2.close();
    }catch(Exception ex){}

    try{
      if(!queryDataSet3.isOpen()) queryDataSet3.open();
      count = queryDataSet3.getRowCount();
      queryDataSet3.first();
      for (int i = 0; i < count; i++) {
        jdbComboBox2.addItem(queryDataSet3.getString("time"));
        queryDataSet3.next();
      }
      queryDataSet3.close();
    }catch(Exception ex){}

    try{
      if(!queryDataSet4.isOpen()) queryDataSet4.open();
      count = queryDataSet4.getRowCount();
      queryDataSet4.first();
      for (int i = 0; i < count; i++) {
        jdbComboBox3.addItem(queryDataSet4.getString("name"));
        queryDataSet4.next();
      }
      queryDataSet4.close();
    }catch(Exception ex){}

    try{
      if(!queryDataSet5.isOpen()) queryDataSet5.open();
      count = queryDataSet5.getRowCount();
      queryDataSet5.first();
      for (int i = 0; i < count; i++) {
        jdbComboBox4.addItem(queryDataSet5.getString("name"));
        queryDataSet5.next();
      }
      queryDataSet5.close();
    }catch(Exception ex){}
    jdbComboBox1.setSelectedIndex(-1);
    jdbComboBox2.setSelectedIndex(-1);
    jdbComboBox3.setSelectedIndex(-1);
    jdbComboBox4.setSelectedIndex(-1);
    queryDataSet7.setColumns(new Column[] {column7});
    queryDataSet1.setColumns(new Column[] {column5, column6, column8, column9, column10, column11, column12});

  }

  void jButton1_actionPerformed(ActionEvent e) {
    if(jdbComboBox1.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择班级！","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(jdbComboBox2.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择考试时间段","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(jdbComboBox3.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择考试类型","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(jdbComboBox4.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择考试科目","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(queryDataSet1.isOpen()) queryDataSet1.close();
    String sql = "select ID ,code ,name , subject ,score,makeup_score,absent " +
        "from score where class = \'" + jdbComboBox1.getSelectedItem() +
        "\' and time = \'" + jdbComboBox2.getSelectedItem() +
        "\' and type = \'" + jdbComboBox3.getSelectedItem() +
        "\' and subject = \'" + jdbComboBox4.getSelectedItem() + "\'";

    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
        database1,sql, null, true,Load.ALL));

    queryDataSet1.open();
    if(queryDataSet1.getRowCount()==0){
      if(queryDataSet6.isOpen()) queryDataSet6.close();
      sql = "select * from student where class = \'"
          + jdbComboBox1.getSelectedItem() + "\'";
      //JOptionPane.showMessageDialog(this,sql);

      queryDataSet6.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
          database1,sql, null, true,Load.ALL));
      queryDataSet6.open();
      try{

        int count = queryDataSet6.getRowCount();
        queryDataSet6.first();
        if(!queryDataSet7.isOpen()) queryDataSet7.open();
        for (int i = 0; i < count; i++) {

          queryDataSet7.insertRow(false);
          queryDataSet7.setString("class",jdbComboBox1.getSelectedItem().toString());
          queryDataSet7.setString("time",jdbComboBox2.getSelectedItem().toString());
          queryDataSet7.setString("type",jdbComboBox3.getSelectedItem().toString());
          queryDataSet7.setString("subject",jdbComboBox4.getSelectedItem().toString());
          queryDataSet7.setString("code",queryDataSet6.getString("code"));
          queryDataSet7.setString("name",queryDataSet6.getString("name"));
          queryDataSet7.setInt("score",0);
          queryDataSet7.setInt("makeup_score",0);
          queryDataSet7.setBoolean("absent",false);
          queryDataSet7.post();
          queryDataSet7.saveChanges();
          queryDataSet6.next();
        }
        queryDataSet6.close();
        queryDataSet1.refresh();
      }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString());}


    }

  }

  void jButton2_actionPerformed(ActionEvent e) {
    try{

       queryDataSet1.post();
       queryDataSet1.saveChanges();

     }catch(Exception ex){

       JOptionPane.showMessageDialog(this,"注册失败！","提示",JOptionPane.ERROR_MESSAGE);
     }finally{
       queryDataSet1.refresh();
     }


  }

  void jButton3_actionPerformed(ActionEvent e) {
    this.dispose();
  }
}

class Score_Input_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Score_Input_Dialog adaptee;

  Score_Input_Dialog_jButton1_actionAdapter(Score_Input_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Score_Input_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Score_Input_Dialog adaptee;

  Score_Input_Dialog_jButton2_actionAdapter(Score_Input_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class Score_Input_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Score_Input_Dialog adaptee;

  Score_Input_Dialog_jButton3_actionAdapter(Score_Input_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}