cardmaintain.java~19~

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

package parkingsystem;

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

public class CardMaintain extends JDialog {
  JPanel panel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JSplitPane jSplitPane1 = new JSplitPane();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;

  BorderLayout borderLayout2 = new BorderLayout();
  BorderLayout borderLayout3 = new BorderLayout();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  JdbTable jdbTable2 = new JdbTable();
  Database database1 = new Database();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  TitledBorder titledBorder8;
  TitledBorder titledBorder9;
  Column column3 = new Column();
  Column column4 = new Column();
  Column column7 = new Column();
  Column column8 = new Column();
  Column column9 = new Column();
  Column column10 = new Column();
  Column column11 = new Column();

  JFrame ff;
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JdbNavToolBar jdbNavToolBar2 = new JdbNavToolBar();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JButton jButton1 = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  XYLayout xYLayout2 = new XYLayout();
  JButton jButton6 = new JButton();
  JPanel jPanel5 = new JPanel();
  TitledBorder titledBorder3;
  TitledBorder titledBorder4;
  TitledBorder titledBorder5;
  TitledBorder titledBorder6;
  XYLayout xYLayout3 = new XYLayout();

  public CardMaintain(Frame frame, String title, boolean modal,JFrame f) {
    super(frame, title, modal);
    this.ff=f;
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }


  private void jbInit() throws Exception {

    titledBorder1 = new TitledBorder("车主信息");

    titledBorder2 = new TitledBorder("卡信息");

    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(165, 163, 151)),"卡信息维护");
    titledBorder5 = new TitledBorder("");
    titledBorder6 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(165, 163, 151)),"车主信息维护");
    panel1.setLayout(borderLayout1);
    panel1.setPreferredSize(new Dimension(500, 500));
    jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
    jSplitPane1.setPreferredSize(new Dimension(500, 500));
    jPanel1.setLayout(borderLayout2);
    jPanel2.setBorder(titledBorder1);
    jPanel2.setPreferredSize(new Dimension(500, 200));
    jPanel2.setLayout(borderLayout3);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=carparkingdb", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet2.setMetaDataUpdate(MetaDataUpdate.TABLENAME+MetaDataUpdate.PRECISION+MetaDataUpdate.SCALE+MetaDataUpdate.SEARCHABLE);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from CarOwer ", null, true, Load.ALL));
    jdbTable2.setDataSet(queryDataSet2);
    column3.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column3.setColumnName("UserID");
    column3.setDataType(com.borland.dx.dataset.Variant.INT);
    column3.setTableName("event");
    column3.setServerColumnName("UserID");
    column3.setSqlType(4);
    column3.setHidden(true);
    column4.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column4.setColumnName("CarNum");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(50);
    column4.setTableName("event");
    column4.setWidth(10);
    column4.setServerColumnName("CarNum");
    column4.setSqlType(12);
    column7.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column7.setColumnName("OwerNum");
    column7.setDataType(com.borland.dx.dataset.Variant.INT);
    column7.setRowId(true);
    column7.setTableName("CarOwer");
    column7.setServerColumnName("OwerNum");
    column7.setSqlType(4);
    column8.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column8.setColumnName("OwerName");
    column8.setDataType(com.borland.dx.dataset.Variant.STRING);
    column8.setPrecision(10);
    column8.setTableName("CarOwer");
    column8.setServerColumnName("OwerName");
    column8.setSqlType(12);
    column9.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column9.setColumnName("Telephone");
    column9.setDataType(com.borland.dx.dataset.Variant.STRING);
    column9.setPrecision(12);
    column9.setTableName("CarOwer");
    column9.setServerColumnName("Telephone");
    column9.setSqlType(12);
    column10.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column10.setColumnName("Address");
    column10.setDataType(com.borland.dx.dataset.Variant.STRING);
    column10.setPrecision(20);
    column10.setTableName("CarOwer");
    column10.setServerColumnName("Address");
    column10.setSqlType(12);
    column11.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
    column11.setColumnName("CardID");
    column11.setDataType(com.borland.dx.dataset.Variant.INT);
    column11.setTableName("CarOwer");
    column11.setServerColumnName("CardID");
    column11.setSqlType(4);
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME+MetaDataUpdate.PRECISION+MetaDataUpdate.SCALE+MetaDataUpdate.SEARCHABLE);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from card", null, true, Load.ALL));
    jdbTable1.setDataSet(queryDataSet1);
    column1.setColumnName("CardID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setRowId(true);
    column1.setTableName("card");
    column1.setServerColumnName("CardID");
    column1.setSqlType(4);
    jPanel1.setBorder(titledBorder2);
    jPanel1.setPreferredSize(new Dimension(500, 300));
    jPanel3.setBorder(titledBorder4);
    jPanel3.setOpaque(true);
    jPanel3.setPreferredSize(new Dimension(100, 270));
    jPanel3.setLayout(xYLayout1);
    jPanel4.setPreferredSize(new Dimension(100, 200));
    jPanel4.setLayout(xYLayout3);
    jdbNavToolBar2.setAlignment(FlowLayout.CENTER);
    jButton1.setText("新开卡");
    jButton2.setText("修改卡");
    jButton3.setText("删除卡");
    jButton4.setText("修  改");
    jButton5.setText("新  增");
    jButton6.setText("删 除");
    jPanel5.setLayout(xYLayout2);
    jPanel5.setPreferredSize(new Dimension(100, 170));
    jPanel5.setBorder(titledBorder6);
    jPanel5.setOpaque(true);
    jdbNavToolBar1.setPreferredSize(new Dimension(500, 30));
    getContentPane().add(panel1);
    panel1.add(jSplitPane1,  BorderLayout.CENTER);
    jSplitPane1.add(jPanel1, JSplitPane.TOP);
    jPanel1.add(jdbNavToolBar1,  BorderLayout.NORTH);
    jPanel1.add(tableScrollPane1, BorderLayout.CENTER);
    jPanel1.add(jPanel3,  BorderLayout.EAST);
    jPanel3.add(jButton1, new XYConstraints(4, 21, 76, -1));
    jPanel3.add(jButton2, new XYConstraints(4, 68, 76, -1));
    jPanel3.add(jButton3, new XYConstraints(4, 115, 76, -1));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jSplitPane1.add(jPanel2, JSplitPane.BOTTOM);
    jPanel2.add(tableScrollPane2,  BorderLayout.CENTER);
    jPanel2.add(jdbNavToolBar2,  BorderLayout.NORTH);
    jPanel2.add(jPanel4,  BorderLayout.EAST);
    jPanel4.add(jPanel5,  new XYConstraints(10, 5, -1, -1));
    jPanel5.add(jButton4, new XYConstraints(1, 67, 76, -1));
    jPanel5.add(jButton5, new XYConstraints(1, 20, 76, -1));
    jPanel5.add(jButton6, new XYConstraints(1, 114, 76, -1));
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jSplitPane1.setDividerLocation(250);
    queryDataSet2.setColumns(new Column[] {column7, column8, column9, column10, column11});

    queryDataSet1.setColumns(new Column[] {column4, column3});
    queryDataSet2.setMasterLink(new com.borland.dx.dataset.MasterLinkDescriptor(queryDataSet1, new String[] {"CardID"}, new String[] {"CardID"}, false, false, false));
    queryDataSet1.setColumns(new Column[] {column1});

  }

  void jButton1_actionPerformed(ActionEvent e) {
    CreateCardDialog create=new CreateCardDialog(ff," ",false,queryDataSet1,queryDataSet2,database1);
    create.show();
  }


}