createcarownerdialog.java~1~

来自「eidtplus注册码.txt eidtplus注册码.txt」· JAVA~1~ 代码 · 共 117 行

package parkingsystem;

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import com.borland.dbswing.JdbTextField;
import com.borland.dbswing.JdbLabel;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.dataset.MetaDataUpdate;
import com.borland.dx.dataset.Column;

public class CreateCarOwnerDialog
    extends JDialog {
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JdbTextField jdbTextField1 = new JdbTextField();
  JdbTextField jdbTextField2 = new JdbTextField();
  JdbTextField jdbTextField3 = new JdbTextField();
  JdbLabel jdbLabel1 = new JdbLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  QueryDataSet queryDataSet;
  Database database;
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  public CreateCarOwnerDialog(Frame owner, String title, boolean modal,QueryDataSet queryDataSet,
  Database database) {
    super(owner, title, modal);
    this.queryDataSet=queryDataSet;
    this.database=database;
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

//  public CreateCarOwnerDialog() {
//    this(new Frame(), "CreateCarOwnerDialog", false);
//  }

  private void jbInit() throws Exception {
    panel1.setLayout(null);
    jLabel1.setText("卡   号：");
    jLabel1.setBounds(new Rectangle(62, 42, 98, 31));
    jLabel2.setText("车主姓名：");
    jLabel2.setBounds(new Rectangle(62, 93, 98, 31));
    jLabel3.setText("联系电话：");
    jLabel3.setBounds(new Rectangle(62, 143, 98, 31));
    jLabel4.setText("住   址：");
    jLabel4.setBounds(new Rectangle(62, 194, 98, 31));
    jdbTextField1.setText("jdbTextField1");
    jdbTextField1.setBounds(new Rectangle(181, 93, 131, 31));
    jdbTextField2.setText("jdbTextField1");
    jdbTextField2.setBounds(new Rectangle(181, 143, 131, 31));
    jdbTextField3.setText("jdbTextField1");
    jdbTextField3.setBounds(new Rectangle(181, 194, 131, 31));
    jdbLabel1.setBounds(new Rectangle(181, 42, 131, 31));
    jButton1.setBounds(new Rectangle(44, 271, 115, 34));
    jButton1.setText("插入车主信息");
    jButton2.setBounds(new Rectangle(212, 271, 115, 34));
    jButton2.setText("取   消");
    database1.setConnection(new ConnectionDescriptor(
        "jdbc:microsoft:sqlserver://Localhost:1433;DatabaseName=parkingdb",
        "sa", "123456", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME +
                                    MetaDataUpdate.PRECISION +
                                    MetaDataUpdate.SCALE +
                                    MetaDataUpdate.SEARCHABLE);
    queryDataSet1.setQuery(new QueryDescriptor(database1,
                                               "select * from carowner", null, true,
                                               Load.ALL));
    column1.setColumnName("CardID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setRowId(true);
    column1.setTableName("carowner");
    column1.setServerColumnName("CardID");
    column1.setSqlType(4);
    getContentPane().add(panel1);
    panel1.add(jdbLabel1);
    panel1.add(jLabel1);
    panel1.add(jLabel2);
    panel1.add(jLabel3);
    panel1.add(jLabel4);
    panel1.add(jdbTextField3);
    panel1.add(jdbTextField2);
    panel1.add(jdbTextField1);
    panel1.add(jButton1);
    panel1.add(jButton2);
    jdbLabel1.setDataSet(queryDataSet);
    jdbLabel1.setColumnName("CardID");
    queryDataSet1.setColumns(new Column[] {column1});
    jdbTextField3.setDataSet(queryDataSet1);
    jdbTextField1.setDataSet(queryDataSet1);
    jdbTextField2.setDataSet(queryDataSet1);
    jdbTextField1.setColumnName("OwnerName");
    jdbTextField2.setColumnName("Telephone");
    jdbTextField3.setColumnName("Address");
    queryDataSet1.open();
    queryDataSet1.last();
    queryDataSet1.insertRow(false);

  }
}