frame1.java~33~

db数据库 的编程程序

package dbswing;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.JdbNavToolBar;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.JdbStatusLabel;
import com.borland.dx.dataset.Column;
import com.borland.dbswing.DBDisposeMonitor;

public class Frame1
    extends JFrame {
  JPanel contentPane;
  XYLayout xYLayout1 = new XYLayout();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JScrollPane jScrollPane1 = new JScrollPane();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JdbTable jdbTable1 = new JdbTable();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  Column column2=new Column();
  public Frame1() {
    try {
      setDefaultCloseOperation(EXIT_ON_CLOSE);
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  /**
   * Component initialization.
   *
   * @throws java.lang.Exception
   */
  private void jbInit() throws Exception {
    contentPane = (JPanel) getContentPane();
    contentPane.setLayout(xYLayout1);
    setSize(new Dimension(400, 300));
    setTitle("dbSwing Demo");
    database1.setConnection(new ConnectionDescriptor("jdbc:borland:dslocal:E:/JBuilder2005/samples/JDataStore/datastores/employee.jds",
        "sysdba", "masterkey", false,
        "com.borland.datastore.jdbc.DataStoreDriver"));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
        database1, "select * from employee", null, true, Load.ALL));
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jdbTable1.setDataSet(queryDataSet1);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
        database1, "select Country from Country", null, true, Load.ALL));

    column1.setColumnName("JOB_COUNTRY");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPickList(new com.borland.dx.dataset.PickListDescriptor(
         queryDataSet2, new String[] {"COUNTRY"}, new String[] {"COUNTRY"},
         new String[] {"JOB_COUNTRY"}, false));
    column1.setPrecision(15);
    column1.setTableName("employee");
    column1.setServerColumnName("JOB_COUNTRY");
    column1.setSqlType(12);
    queryDataSet1.setColumns(new Column[] {column1});

    contentPane.add(jdbNavToolBar1, new XYConstraints(2, 1, 398, -1));
    jScrollPane1.getViewport().add(jdbTable1);
    contentPane.add(jScrollPane1, new XYConstraints(6, 45, -1, 388));
  }
}