fenbiaoshow1.java

java 数据库编程源代码

package train_table;

import javax.swing.table.*;
import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.sql.*;
import java.awt.event.*;
import com.borland.dbswing.*;
import javax.swing.border.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;
public class fenbiaoshow1 extends JFrame{
  private XYLayout xYLayout1 = new XYLayout();

  private JPanel jPanel1 = new JPanel();
  private TitledBorder titledBorder1;
  private TableScrollPane tableScrollPane1 = new TableScrollPane();
  private GridLayout gridLayout1 = new GridLayout();
  private JdbTable jdbTable1 = new JdbTable();
  private Database database1 = new Database();

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

    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
    column1.setColumnName("到站时间");
    column1.setDataType(com.borland.dx.dataset.Variant.TIME);
    column1.setReadOnly(true);
    column1.setWidth(12);
    column1.setServerColumnName("到站时间");
    column1.setSqlType(93);
    column2.setColumnName("硬座票价");
    column2.setDataType(com.borland.dx.dataset.Variant.ASSIGNED_NULL);
    column2.setPrecision(19);
    column2.setReadOnly(true);
    column2.setScale(4);
    column2.setWidth(10);
    column2.setServerColumnName("硬座票价");
    column2.setSqlType(2);
    column3.setColumnName("到达车站");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(12);
    column3.setReadOnly(true);
    column3.setWidth(10);
    column3.setServerColumnName("到达车站");
    column3.setSqlType(12);
    column4.setColumnName("卧铺票价");
    column4.setDataType(com.borland.dx.dataset.Variant.ASSIGNED_NULL);
    column4.setPrecision(19);
    column4.setReadOnly(true);
    column4.setScale(4);
    column4.setWidth(10);
    column4.setServerColumnName("卧铺票价");
    column4.setSqlType(2);
    column5.setColumnName("车次");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(6);
    column5.setReadOnly(true);
    column5.setServerColumnName("车次");
    column5.setSqlType(12);
    queryDataSet1.setColumns(new Column[] {column5, column3, column1, column2, column4});
    column6.setColumnName("硬座票价");
    column6.setDataType(com.borland.dx.dataset.Variant.ASSIGNED_NULL);
    column6.setPrecision(19);
    column6.setScale(4);
    column6.setServerColumnName("硬座票价");
    column6.setSqlType(2);
   this.getContentPane().add(jPanel1,                      new XYConstraints(6, 5, 439, 205));
    jPanel1.add(tableScrollPane1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
   }
}