score_input_dialog.java

包含了7个java经典案例

package student;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import javax.swing.border.*;
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_Input_Dialog extends JDialog {
  JPanel panel1 = new JPanel();
  JdbComboBox jdbComboBox1 = new JdbComboBox();
  TitledBorder titledBorder1;
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JdbComboBox jdbComboBox2 = new JdbComboBox();
  JdbComboBox jdbComboBox3 = new JdbComboBox();
  JdbComboBox jdbComboBox4 = new JdbComboBox();
  JButton jButton1 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JdbTable jdbTable1 = new JdbTable();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  QueryDataSet queryDataSet3 = new QueryDataSet();
  QueryDataSet queryDataSet4 = new QueryDataSet();
  QueryDataSet queryDataSet5 = new QueryDataSet();
  QueryDataSet queryDataSet6 = new QueryDataSet();
  QueryDataSet queryDataSet7 = new QueryDataSet();
  Column column7 = new Column();
  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 column8 = new Column();
  Column column9 = new Column();
  Column column10 = new Column();
  Column column11 = new Column();
  Column column12 = new Column();
  GridBagLayout gridBagLayout1 = new GridBagLayout();

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

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

  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    panel1.setLayout(gridBagLayout1);
    jdbComboBox1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbComboBox1.setAutoscrolls(true);
    jdbComboBox1.setBorder(BorderFactory.createEtchedBorder());
    jdbComboBox1.setEditable(false);
    jdbComboBox1.setColumnName("");
    jdbComboBox1.setDataSet(null);

    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel1.setText("所在班级：");
    jLabel2.setText("时间段：");
    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel3.setText("考试类型：");
    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel4.setText("科目：");
    jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbComboBox2.setEditable(false);
    jdbComboBox2.setBorder(BorderFactory.createEtchedBorder());
    jdbComboBox2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbComboBox3.setEditable(false);
    jdbComboBox3.setBorder(BorderFactory.createEtchedBorder());
    jdbComboBox3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbComboBox4.setEditable(false);
    jdbComboBox4.setBorder(BorderFactory.createEtchedBorder());
    jdbComboBox4.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton1.setText("开始录入");
    jButton1.addActionListener(new Score_Input_Dialog_jButton1_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton2.setText("保存");
    jButton2.addActionListener(new Score_Input_Dialog_jButton2_actionAdapter(this));
    jButton3.setText("取消");
    jButton3.addActionListener(new Score_Input_Dialog_jButton3_actionAdapter(this));
    jButton3.setFont(new java.awt.Font("DialogInput", 0, 12));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from class;", null, true, Load.ALL));
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable1.setDataSet(queryDataSet1);
    queryDataSet3.setReadOnly(false);
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from examtime;", null, true, Load.ALL));
    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from examtype;", null, true, Load.ALL));
    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from examsubject;", null, true, Load.ALL));
    queryDataSet7.setMetaDataUpdate(MetaDataUpdate.TABLENAME+MetaDataUpdate.PRECISION+MetaDataUpdate.SCALE+MetaDataUpdate.SEARCHABLE);
    queryDataSet7.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from score;", null, true, Load.ALL));
    column7.setColumnName("ID");
    column7.setDataType(com.borland.dx.dataset.Variant.INT);
    column7.setRowId(true);
    column7.setTableName("score");
    column7.setServerColumnName("ID");
    column7.setSqlType(4);
    column1.setColumnName("ID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setEditable(false);
    column1.setTableName("score");
    column1.setServerColumnName("ID");
    column1.setSqlType(4);
    column2.setColumnName("code");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(16);
    column2.setEditable(false);
    column2.setTableName("score");
    column2.setServerColumnName("code");
    column2.setSqlType(12);
    column3.setColumnName("name");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(10);
    column3.setEditable(false);
    column3.setTableName("score");
    column3.setServerColumnName("name");
    column3.setSqlType(12);
    column4.setColumnName("subject");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(20);
    column4.setEditable(false);
    column4.setTableName("score");
    column4.setServerColumnName("subject");
    column4.setSqlType(12);
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME+MetaDataUpdate.PRECISION+MetaDataUpdate.SCALE+MetaDataUpdate.SEARCHABLE);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select ID ,code ,name , subject ,score,makeup_score,absent  from " +
      "score where code = \'000\'", null, true, Load.ALL));
    column5.setCaption("编号");
    column5.setColumnName("ID");
    column5.setDataType(com.borland.dx.dataset.Variant.INT);
    column5.setEditable(false);
    column5.setRowId(true);
    column5.setTableName("score");
    column5.setServerColumnName("ID");
    column5.setSqlType(4);

    column6.setCaption("学号");
    column6.setColumnName("code");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(16);
    column6.setEditable(false);
    column6.setTableName("score");
    column6.setServerColumnName("code");
    column6.setSqlType(12);
    column8.setCaption("姓名");
    column8.setColumnName("name");
    column8.setDataType(com.borland.dx.dataset.Variant.STRING);
    column8.setPrecision(10);
    column8.setEditable(false);
    column8.setTableName("score");
    column8.setServerColumnName("name");
    column8.setSqlType(12);
    column9.setCaption("科目");
    column9.setColumnName("subject");
    column9.setDataType(com.borland.dx.dataset.Variant.STRING);
    column9.setPrecision(20);
    column9.setEditable(false);
    column9.setTableName("score");
    column9.setServerColumnName("subject");
    column9.setSqlType(12);
    column10.setCaption("分数");
    column10.setColumnName("score");
    column10.setDataType(com.borland.dx.dataset.Variant.INT);
    column10.setTableName("score");
    column10.setServerColumnName("score");
    column10.setSqlType(4);
    column11.setCaption("补考成绩");
    column11.setColumnName("makeup_score");
    column11.setDataType(com.borland.dx.dataset.Variant.INT);
    column11.setTableName("score");
    column11.setServerColumnName("makeup_score");
    column11.setSqlType(4);
    column12.setCaption("缺考");
    column12.setColumnName("absent");
    column12.setDataType(com.borland.dx.dataset.Variant.BOOLEAN);
    column12.setTableName("score");
    column12.setServerColumnName("absent");