frame1.java~14~

基于数据库组件的系统开发的实例

package parkingsystem;

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

public class Frame1 extends JFrame {
  JMenuBar jMenuBar1 = new JMenuBar();
  XYLayout xYLayout1 = new XYLayout();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JButton jButton1 = new JButton();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();

  public Frame1() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(xYLayout1);
    jButton1.setText("jButton1");
    jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=testdb", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
    queryDataSet1.setResolveOrder(new String[] {"test1", "test2"});
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from test1,test2 where test1.ID=test2.ID", null, true, Load.ALL));
    jdbTable1.setDataSet(queryDataSet1);
    column1.setColumnName("ID1");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setTableName("test2");
    column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column1.setServerColumnName("ID");
    column1.setSqlType(4);
    column2.setAlignment(com.borland.dx.text.Alignment.RIGHT | com.borland.dx.text.Alignment.MIDDLE);
    column2.setColumnName("ID");
    column2.setDataType(com.borland.dx.dataset.Variant.INT);
    column2.setRowId(true);
    column2.setSchemaName("");
    column2.setTableName("test1");
    column2.setServerColumnName("ID");
    column2.setSqlType(4);
    column3.setColumnName("DepID");
    column3.setDataType(com.borland.dx.dataset.Variant.INT);
    column3.setRowId(true);
    column3.setTableName("test2");
    column3.setServerColumnName("DepID");
    column3.setSqlType(4);
    queryDataSet1.setColumns(new Column[] {column2, column1, column3});
    this.getContentPane().add(tableScrollPane1, new XYConstraints(70, 28, 272, 118));
    this.getContentPane().add(jButton1,   new XYConstraints(142, 172, 114, 36));
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }

  public static void main(String args[]){
    Frame1 f=new Frame1();
    f.setSize(400,300);
    f.setVisible(true);
    f.show();
  }

  void jButton1_actionPerformed(ActionEvent e) {
    Dialog1 d=new Dialog1(this," ",false,queryDataSet1,database1);
    d.show();
  }
}

class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}