carmaintain.java~15~

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

package parkingsystem;

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

public class CarMaintain extends JFrame {
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JPanel jPanel1 = new JPanel();
  BorderLayout borderLayout2 = new BorderLayout();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
  JPanel jPanel2 = new JPanel();
  JButton jButton1 = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  JButton jButton2 = new JButton();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JButton jButton3 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();

  public CarMaintain() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(borderLayout1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=carparkingdb", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
    queryDataSet1.setResolveOrder(new String[] {"card", "carower"});
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from card,carower where card.CardType=\'长期卡\' and card.CardID=carower.CardID ", null, true, Load.ALL));
    jPanel1.setLayout(borderLayout2);
    jdbStatusLabel1.setText("jdbStatusLabel1");
    jPanel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jPanel2.setPreferredSize(new Dimension(500, 80));
    jPanel2.setLayout(xYLayout1);
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setPreferredSize(new Dimension(500, 300));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("新开卡");
    jButton1.addActionListener(new CarMaintain_jButton1_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setText("修  改");
    jButton3.setText("删  除");
    jButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jdbTable1.setDataSet(queryDataSet1);
    column1.setColumnName("Password");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(10);
    column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column1.setServerColumnName("Password");
    column1.setSqlType(12);
    column2.setColumnName("OwerNum");
    column2.setDataType(com.borland.dx.dataset.Variant.INT);
    column2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column2.setServerColumnName("OwerNum");
    column2.setSqlType(4);
    column3.setColumnName("CardID1");
    column3.setDataType(com.borland.dx.dataset.Variant.INT);
    column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column3.setServerColumnName("CardID1");
    column3.setSqlType(4);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3});
    this.getContentPane().add(jPanel1,  BorderLayout.CENTER);
    jPanel1.add(jdbStatusLabel1,  BorderLayout.SOUTH);
    jPanel1.add(jdbNavToolBar1, BorderLayout.NORTH);
    jPanel1.add(tableScrollPane1,  BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    this.getContentPane().add(jPanel2,  BorderLayout.SOUTH);
    jPanel2.add(jButton2, new XYConstraints(216, 21, 73, 27));
    jPanel2.add(jButton1, new XYConstraints(75, 21, -1, -1));
    jPanel2.add(jButton3, new XYConstraints(357, 21, 73, -1));
  }

  void jButton1_actionPerformed(ActionEvent e) {
    CreateCardDialog create=new CreateCardDialog(this,"新增长期卡",false,queryDataSet1,database1);
    create.show();
  }
}

class CarMaintain_jButton1_actionAdapter implements java.awt.event.ActionListener {
  CarMaintain adaptee;

  CarMaintain_jButton1_actionAdapter(CarMaintain adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}