shorttermindialog.java~5~

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

package parkingsystem;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;

import java.text.*;
import java.awt.event.*;

import java.sql.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;

public class ShortTermInDialog extends JDialog {
  JPanel panel1 = new JPanel();
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JButton jButton1 = new JButton();

  private int cardID;
  String nowFormat;

  Connection con;
  Statement st;
  ResultSet rs;
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();


  public ShortTermInDialog(Frame frame, String title, boolean modal,int cardID) {
    super(frame, title, modal);
    this.cardID=cardID;
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public ShortTermInDialog() {
    this(null, "", false,0);
  }
  private void jbInit() throws Exception {
    panel1.setLayout(xYLayout1);
    jLabel2.setText("选择卡类型：");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel2.setText("车   牌   号：");
    jLabel1.setText("选择操作类型：");
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel1.setText("卡          号：");
    jLabel3.setText("车   牌   号：");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel3.setText("入 场 时 间：");
    jLabel4.setText("卡          号：");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel4.setText("");
    jLabel4.setText("");
    jTextField1.setText(" ");
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 14));

    jButton1.setFont(new java.awt.Font("Dialog", 0, 14));
    jButton1.setText("确   定");
    jButton1.addActionListener(new ShortTermInDialog_jButton1_actionAdapter(this));
    panel1.setPreferredSize(new Dimension(400, 300));
    this.setModal(true);
    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.setTableName("event");
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from event", null, true, Load.ALL));
    column1.setColumnName("EventID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setRowId(true);
    column1.setTableName("event");
    column1.setServerColumnName("EventID");
    column1.setSqlType(4);
    column2.setColumnName("CardID");
    column2.setDataType(com.borland.dx.dataset.Variant.INT);
    column2.setTableName("event");
    column2.setServerColumnName("CardID");
    column2.setSqlType(4);
    column3.setColumnName("UserID");
    column3.setDataType(com.borland.dx.dataset.Variant.INT);
    column3.setTableName("event");
    column3.setServerColumnName("UserID");
    column3.setSqlType(4);
    column4.setColumnName("CarNum");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(50);
    column4.setTableName("event");
    column4.setServerColumnName("CarNum");
    column4.setSqlType(12);
    column5.setColumnName("InTime");
    column5.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column5.setTableName("event");
    column5.setServerColumnName("InTime");
    column5.setSqlType(93);
    column6.setColumnName("OutTime");
    column6.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column6.setTableName("event");
    column6.setServerColumnName("OutTime");
    column6.setSqlType(93);
    getContentPane().add(panel1);
    panel1.add(jButton1, new XYConstraints(159, 216, 115, 33));
    panel1.add(jLabel1, new XYConstraints(81, 45, 94, 31));
    panel1.add(jLabel4, new XYConstraints(204, 43, 94, 31));
    panel1.add(jLabel2, new XYConstraints(81, 91, 94, 31));
    panel1.add(jTextField1, new XYConstraints(204, 92, 148, 28));
    panel1.add(jLabel3, new XYConstraints(81, 144, 94, 31));
    panel1.add(jLabel5, new XYConstraints(204, 146, 150, 31));

    jLabel4.setText(cardID+"");
    java.util.Date nowTime=new java.util.Date();
    SimpleDateFormat dateFormat=new SimpleDateFormat("yy-MM-dd HH:mm");
    nowFormat=dateFormat.format(nowTime);
    jLabel5.setText(nowFormat);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});
  }

  void jButton1_actionPerformed(ActionEvent e) {
    String carNum=jTextField1.getText().trim();
    queryDataSet1.open();
    queryDataSet1.insertRow(false);
    queryDataSet1.setInt("CardID", cardID);
    queryDataSet1.setInt("UserID", LoginFrame.userID);
    queryDataSet1.setString("CarNum", carNum);
    java.util.Date l = new java.util.Date();
    long lTime = l.getTime();
    Timestamp t = new Timestamp(lTime);
    queryDataSet1.setTimestamp("InTime", t);
    database1.saveChanges(queryDataSet1);
    this.hide();

    /*con=DbConnection.getCon();
    try{
      st = con.createStatement();
      String insertStr="Insert into event (CardID,UserID,CarNum,InOutName,InTime) values("+
              cardID+","+ParkingFrame.userID+",'"+carNum+"','"+ParkingFrame.inOutPlace+"','"+
              nowFormat+"')";
      int result=st.executeUpdate(insertStr);
      if(result>0){
        JOptionPane.showMessageDialog(this,"操作成功！");

      }

    }catch(Exception ex){
      ex.printStackTrace();
    }
    this.hide();*/

  }
}

class ShortTermInDialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  ShortTermInDialog adaptee;

  ShortTermInDialog_jButton1_actionAdapter(ShortTermInDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}