score_query_dialog.java

包含了7个java经典案例

package student;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;
import java.awt.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Score_Query_Dialog extends JDialog {
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JPanel jPanel1 = new JPanel();
  XYLayout xYLayout2 = new XYLayout();
  JButton jButton1 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JPanel jPanel2 = new JPanel();
  XYLayout xYLayout3 = new XYLayout();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton2 = new JButton();
  JdbTable jdbTable2 = new JdbTable();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  QueryDataSet queryDataSet3 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  GridBagLayout gridBagLayout1 = new GridBagLayout();

  public Score_Query_Dialog(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public Score_Query_Dialog() {
    this(null, "", false);
  }

  private void jbInit() throws Exception {
    panel1.setLayout(gridBagLayout1);
    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel1.setText("班级：");
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setLayout(xYLayout2);
    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton1.setText("显示学生列表");
    jButton1.addActionListener(new Score_Query_Dialog_jButton1_actionAdapter(this));
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setLayout(xYLayout3);
    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel2.setText("学生学号：");
    jTextField1.setText("");
    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton2.setText("直接查询");
    jButton2.addActionListener(new Score_Query_Dialog_jButton2_actionAdapter(this));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from class;", null, true, Load.ALL));
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select code,name from student where class = \'000\'", null, true, Load.ALL));
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select  time , type , subject , score ,makeup_score  from score where " +
      "code = \'000\'", null, true, Load.ALL));
    column1.setCaption("学期");
    column1.setColumnName("time");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(24);
    column1.setServerColumnName("time");
    column1.setSqlType(12);
    column2.setCaption("考试类型");
    column2.setColumnName("type");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(16);
    column2.setServerColumnName("type");
    column2.setSqlType(12);
    column3.setCaption("考试科目");
    column3.setColumnName("subject");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(20);
    column3.setServerColumnName("subject");
    column3.setSqlType(12);
    column4.setCaption("成绩");
    column4.setColumnName("score");
    column4.setDataType(com.borland.dx.dataset.Variant.INT);
    column4.setServerColumnName("score");
    column4.setSqlType(4);
    column5.setCaption("补考成绩");
    column5.setColumnName("makeup_score");
    column5.setDataType(com.borland.dx.dataset.Variant.INT);
    column5.setServerColumnName("makeup_score");
    column5.setSqlType(4);
    queryDataSet3.setColumns(new Column[] {column1, column2, column3, column4, column5});
    jdbTable2.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable2.setDataSet(queryDataSet3);
    jdbTable2.setEditable(false);
    column6.setCaption("学号");
    column6.setColumnName("code");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(14);
    column6.setRowId(true);
    column6.setTableName("student");
    column6.setServerColumnName("code");
    column6.setSqlType(12);
    column7.setCaption("姓名");
    column7.setColumnName("name");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(10);
    column7.setTableName("student");
    column7.setServerColumnName("name");
    column7.setSqlType(12);
    queryDataSet2.setColumns(new Column[] {column6, column7});
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable1.setDataSet(queryDataSet2);
    jdbTable1.setEditable(false);
    jdbTable1.addMouseListener(new Score_Query_Dialog_jdbTable1_mouseAdapter(this));
    this.setResizable(false);
    this.setTitle("成绩查询");
    getContentPane().add(panel1);
    panel1.add(jPanel1,  new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(21, 17, 15, 0), 14, 12));
    jPanel1.add(jComboBox1, new XYConstraints(81, 7, 103, -1));
    jPanel1.add(jLabel1, new XYConstraints(28, 8, -1, -1));
    jPanel1.add(jButton1,    new XYConstraints(30, 44, 145, 28));
    jPanel1.add(tableScrollPane1,    new XYConstraints(12, 81, 201, 334));
    panel1.add(jPanel2,  new GridBagConstraints(1, 0, 1, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(21, 13, 15, 12), 8, 13));
    jPanel2.add(tableScrollPane2,           new XYConstraints(7, 49, 410, 365));
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jPanel2.add(jLabel2, new XYConstraints(11, 10, -1, -1));
    jPanel2.add(jTextField1,  new XYConstraints(77, 8, 101, 24));
    jPanel2.add(jButton2, new XYConstraints(208, 7, -1, -1));
    tableScrollPane1.getViewport().add(jdbTable1, null);

    int count = 0;
    try{
      if(!queryDataSet1.isOpen()) queryDataSet1.open();
      count = queryDataSet1.getRowCount();
      queryDataSet1.first();
      for (int i = 0; i < count; i++) {
        jComboBox1.addItem(queryDataSet1.getString("code"));
        queryDataSet1.next();
      }
      jComboBox1.setSelectedIndex(-1);
    }catch(Exception ex){}
    finally{
      queryDataSet1.close();
    }

  }

  void jButton1_actionPerformed(ActionEvent e) {
    if(jComboBox1.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择班级！","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(queryDataSet2.isOpen()) queryDataSet2.close();
    String sql = "select code ,name from student where class = \'"
        + jComboBox1.getSelectedItem() + "\'";

    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
        database1,sql, null, true,Load.ALL));
    try{
      queryDataSet2.open();
    }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.INFORMATION_MESSAGE);}


  }

  void jdbTable1_mousePressed(MouseEvent e) {
    try{
      String sql = "select  time , type , subject , score ,makeup_score  from score  where code = \'"
          + queryDataSet2.getString("code") + "\'";
      if (queryDataSet3.isOpen()) queryDataSet3.close();
      queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
          database1, sql, null, true, Load.ALL));

      queryDataSet3.open();
    }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.INFORMATION_MESSAGE);}

  }

  void jButton2_actionPerformed(ActionEvent e) {
    if(jTextField1.getText().length()==0){
      JOptionPane.showMessageDialog(this,"请输入学号","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    try{
      String sql = "select  time , type , subject , score ,makeup_score  from score  where code = \'"
          + jTextField1.getText() + "\'";
      if (queryDataSet3.isOpen()) queryDataSet3.close();
      queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
          database1, sql, null, true, Load.ALL));
      queryDataSet3.open();
    }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.INFORMATION_MESSAGE);}

  }
}

class Score_Query_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Score_Query_Dialog adaptee;

  Score_Query_Dialog_jButton1_actionAdapter(Score_Query_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Score_Query_Dialog_jdbTable1_mouseAdapter extends java.awt.event.MouseAdapter {
  Score_Query_Dialog adaptee;

  Score_Query_Dialog_jdbTable1_mouseAdapter(Score_Query_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void mousePressed(MouseEvent e) {
    adaptee.jdbTable1_mousePressed(e);
  }
}

class Score_Query_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Score_Query_Dialog adaptee;

  Score_Query_Dialog_jButton2_actionAdapter(Score_Query_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}