basicdbframe.java~7~

Contains a complete archiver by Haruhiko Okumura. The archiver uses an LZ engine whose output is c

package basicdbappexample;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import com.borland.dx.dataset.*;

public class BasicDBFrame extends JFrame {
  JPanel contentPane;
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JdbNavField jdbNavField1 = new JdbNavField();
  JLabel jLabel1 = new JLabel();
  Column GRADE = new Column();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
  JdbTextField jdbTextField1 = new JdbTextField();
  Column column1 = new Column();

  //Construct the frame
  public BasicDBFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    dBDisposeMonitor1.setDataAwareComponentContainer(this);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT STUDENT.ID,STUDENT.NAME,STUDENT.AGE,STUDENT.GRADE FROM STUDENT", null, true, Load.ALL));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:borland:dslocal:F:\\work\\java\\JDBC\\JDBCExampleCode\\Employee.jds", "ljp", "lijianping", false, "com.borland.datastore.jdbc.DataStoreDriver"));
    contentPane.setLayout(null);
    this.setSize(new Dimension(400, 300));
    this.setTitle("简单数据库应用程序示例");
    tableScrollPane1.setBounds(new Rectangle(9, 86, 400, 174));
    jdbTable1.setDataSet(queryDataSet1);
    jdbNavToolBar1.setBounds(new Rectangle(2, 2, 398, 37));
    jdbNavField1.setText("jdbNavField1");
    jdbNavField1.setBounds(new Rectangle(274, 39, 80, 22));
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 14));
    jLabel1.setText("Find");
    jLabel1.setBounds(new Rectangle(226, 42, 45, 16));
    GRADE.setColumnName("GRADE");
    GRADE.setDataType(com.borland.dx.dataset.Variant.SHORT);
    GRADE.setPreferredOrdinal(4);
    GRADE.setTableName("STUDENT");
    GRADE.setServerColumnName("GRADE");
    GRADE.setSqlType(5);
    jdbStatusLabel1.setText("jdbStatusLabel1");
    jdbStatusLabel1.setBounds(new Rectangle(140, 264, 121, 27));
    jdbTextField1.setText("jdbTextField1");
    jdbTextField1.setColumns(0);
    jdbTextField1.setColumnName("ID");
    jdbTextField1.setDataSet(queryDataSet1);
    jdbTextField1.setBounds(new Rectangle(43, 52, 118, 22));
    column1.setAgg(new com.borland.dx.dataset.AggDescriptor((String[]) null, "ID", new com.borland.dx.dataset.SumAggOperator()));
    column1.setColumnName("ID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setRowId(true);
    column1.setTableName("STUDENT");
    column1.setServerColumnName("ID");
    column1.setSqlType(4);
    queryDataSet1.setColumns(new Column[] {column1, GRADE});
    contentPane.add(jdbNavToolBar1, null);
    contentPane.add(jdbStatusLabel1, null);
    contentPane.add(jLabel1, null);
    contentPane.add(jdbNavField1, null);
    contentPane.add(tableScrollPane1, null);
    contentPane.add(jdbTextField1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }
  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }
}