frame1.java~21~

javastore 的编程程序

package jdatastoregui;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.jbcl.control.NavigatorControl;
import com.borland.jbcl.control.LabelControl;
import com.borland.jbcl.control.GridControl;
import com.borland.jbcl.control.ImageControl;
import com.borland.dx.dataset.*;
import com.borland.dx.sql.dataset.*;

public class Frame1
    extends JFrame {
  JPanel contentPane;
  XYLayout xYLayout1 = new XYLayout();
  NavigatorControl navigatorControl1 = new NavigatorControl();
  LabelControl labelControl1 = new LabelControl();
  LabelControl labelControl2 = new LabelControl();
  LabelControl labelControl3 = new LabelControl();
  GridControl gridControl1 = new GridControl();
  ImageControl imageControl1 = new ImageControl();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  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("JDataStore GUI Demo");
    navigatorControl1.setAlignment(FlowLayout.CENTER);
    navigatorControl1.setDataSet(queryDataSet1);
    labelControl1.setColumnName("PRODUCTID");
    labelControl1.setDataSet(queryDataSet1);
    labelControl1.setText("");
    labelControl2.setColumnName("CATEGORY");
    labelControl2.setDataSet(queryDataSet1);
    labelControl2.setText("");
    labelControl3.setColumnName("NAME");
    labelControl3.setDataSet(queryDataSet1);
    labelControl3.setText("");
    imageControl1.setColumnName("THE_IMAGE");
    imageControl1.setDataSet(queryDataSet1);
    gridControl1.setDataSet(queryDataSet1);
    contentPane.add(labelControl2, new XYConstraints(23, 86, -1, -1));
    contentPane.add(labelControl3, new XYConstraints(24, 114, -1, -1));
    contentPane.add(gridControl1, new XYConstraints(9, 154, 383, 139));
    contentPane.add(navigatorControl1, new XYConstraints(10, 6, 391, -1));
    contentPane.add(imageControl1, new XYConstraints(265, 40, 128, 108));
    contentPane.add(labelControl1, new XYConstraints(24, 57, 102, -1));

    openTable();
  }

  private void openTable() throws Exception
  {
    String url = "jdbc:borland:dslocal:D:/JTJB2005/chapter9/db/petstore.jds";
    String username = "sysdba";
    String password = "masterkey";
    try {
      database1.setConnection(new ConnectionDescriptor(url, username, password, false, "com.borland.datastore.jdbc.DataStoreDriver"));
      database1.openConnection();
      queryDataSet1.setQuery( new QueryDescriptor(database1,"select * from PRODUCT",null,true,Load.ALL) );
      queryDataSet1.open();
    }
    finally {
      database1.closeConnection();
    }
  }
}