fenbiaoshow2.java

JAVA数据库编程实例随书源码 JAVA数据库编程实例随书源码

package train_table;

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

public class fenbiaoshow2 extends JFrame {
  private JPanel jPanel1 = new JPanel();
  private XYLayout xYLayout1 = new XYLayout();
  private JScrollPane jScrollPane1 = new JScrollPane();
  private CardLayout cardLayout1 = new CardLayout();
  private JdbTable jdbTable1 = new JdbTable();
  private TitledBorder titledBorder1;
  private Database database1 = new Database();
  private QueryDataSet queryDataSet1 = new QueryDataSet();
  private Column column1 = new Column();
  private Column column2 = new Column();
  private Column column3 = new Column();
  private Column column4 = new Column();
  private Column column5 = new Column();

      //通过传入车次显示分表信息，是对主表信息的更详细的现实
  public fenbiaoshow2(String times) {
    try {
      //根据传入的车次查询分表
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT daozhanfenbiao.\"车次\",daozhanfenbiao.\"发车车站\",daozhanfenbiao.\"到站时间\",daozhanfenbiao.\"硬座票价\",daozhanfenbiao.\"卧铺票价\" " +
      "FROM\"E:\\train_table\\trainmaindb\".daozhanfenbiao where daozhanfenbiao.\"车次\"='"+times+"'", null, true, Load.ALL));
      jdbTable1.setDataSet(queryDataSet1);  //发送结果集
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    this.getContentPane().setLayout(xYLayout1);
    jPanel1.setLayout(cardLayout1);
    xYLayout1.setWidth(450);
    xYLayout1.setHeight(240);
    jPanel1.setBorder(titledBorder1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:traindb", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));

    column1.setCaption("车次");
    column1.setColumnName("车次");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    column2.setCaption("发车车站");
    column2.setColumnName("发车车站");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setServerColumnName("NewColumn2");
    column2.setSqlType(0);
    column3.setColumnName("到站时间");
    column3.setDataType(com.borland.dx.dataset.Variant.TIME);
    column3.setServerColumnName("NewColumn1");
    column3.setSqlType(0);
    column4.setColumnName("硬座票价");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setServerColumnName("NewColumn1");
    column4.setSqlType(0);
    column5.setCaption("卧铺票价");
    column5.setColumnName("卧铺票价");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setServerColumnName("NewColumn2");
    column5.setSqlType(0);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5});
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
    this.getContentPane().add(jPanel1,    new XYConstraints(6, 5, 439, 205));
    jPanel1.add(jScrollPane1,  "jScrollPane1");
    jScrollPane1.getViewport().add(jdbTable1, null);
  }
}