inoutframe.java~24~

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

package parkingsystem;

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

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

public class InOutFrame extends JFrame {
  BorderLayout borderLayout1 = new BorderLayout();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  JPanel jPanel1 = new JPanel();
  XYLayout xYLayout3 = new XYLayout();
  JButton jButton2 = new JButton();
  JLabel jLabel3 = new JLabel();
  JButton jButton1 = new JButton();
  JRadioButton jRadioButton1 = new JRadioButton();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JRadioButton jRadioButton2 = new JRadioButton();
  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();
  ParameterRow cardparameter = new ParameterRow();
  Column column6 = new Column();
  Column column7 = new Column();
  QueryDataSet queryDataSet2 = new QueryDataSet();

  public InOutFrame() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.setTitle("欢迎使用停车场进出管理系统");
    this.getContentPane().setLayout(borderLayout1);
    jPanel1.setLayout(xYLayout3);
    jButton2.setFont(new java.awt.Font("Dialog", 0, 14));
    jButton2.setText("重  置");
    jButton2.addActionListener(new InOutFrame_jButton2_actionAdapter(this));
    jLabel3.setText("请输入卡号：");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel3.setText("选择卡类型：");
    jButton1.setText("确  定");
    jButton1.addActionListener(new InOutFrame_jButton1_actionAdapter(this));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 14));
    jRadioButton1.setText(" 入   场");
    jRadioButton1.setSelected(true);
    jRadioButton1.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel1.setText("选择操作类型：");
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel1.setText("选择操作类型：");
    jLabel2.setText("选择卡类型：");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel2.setText("请输入卡号：");
    //jTextField1.addActionListener(new In_OutFrame_jTextField1_actionAdapter(this));
    jTextField1.setText(" ");
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 14));
    jRadioButton2.setFont(new java.awt.Font("Dialog", 0, 14));
    jRadioButton2.setText("出    场");
    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 14));
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 14));
    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("card");
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from cardtype", null, true, Load.ALL));
    column1.setColumnName("CardID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setServerColumnName("CardID");
    column1.setSqlType(4);
    column2.setColumnName("Password");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(10);
    column2.setServerColumnName("Password");
    column2.setSqlType(12);
    column3.setColumnName("CardType");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(10);
    column3.setServerColumnName("CardType");
    column3.setSqlType(12);
    column4.setColumnName("CarNum");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(20);
    column4.setServerColumnName("CarNum");
    column4.setSqlType(12);
    column5.setColumnName("TimeLimit");
    column5.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column5.setServerColumnName("TimeLimit");
    column5.setSqlType(93);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5});
    column6.setColumnName("CardID");
    column6.setDataType(com.borland.dx.dataset.Variant.INT);
    column6.setDefault("0");
    column6.setServerColumnName("NewColumn1");
    column6.setSqlType(0);
    column7.setColumnName("CardType");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setDefault("\"\"");
    column7.setServerColumnName("NewColumn2");
    column7.setSqlType(0);
    cardparameter.setColumns(new Column[] {column6, column7});
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from card where CardID=:CardID and CardType=:Cardtype", cardparameter, true, Load.ALL));
    this.getContentPane().add(jPanel1,  BorderLayout.CENTER);
    jPanel1.add(jLabel3,    new XYConstraints(62, 154, 99, 31));
    jPanel1.add(jComboBox1,  new XYConstraints(171, 152, 149, 29));
    jPanel1.add(jRadioButton1, new XYConstraints(169, 27, 78, 28));
    jPanel1.add(jLabel1, new XYConstraints(62, 26, 102, 31));
    jPanel1.add(jRadioButton2, new XYConstraints(267, 27, 78, 28));
    jPanel1.add(jLabel2,   new XYConstraints(62, 90, 92, 31));
    jPanel1.add(jTextField1,  new XYConstraints(171, 90, 148, 29));

    queryDataSet1.open();
    jComboBox1.addItem("");
    jComboBox1.addItem(queryDataSet1.getString("CardType"));
    while(queryDataSet1.next()){
      jComboBox1.addItem(queryDataSet1.getString("CardType"));
    }
    jPanel1.add(jButton2, new XYConstraints(237, 215, 71, 26));
    jPanel1.add(jButton1, new XYConstraints(111, 214, 71, 26));
    buttonGroup1.add(jRadioButton2);
    buttonGroup1.add(jRadioButton1);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    String oper="";
    if(jRadioButton1.isSelected()){
      oper="入场";
    }
    else if(jRadioButton2.isSelected()){
      oper="出场";
    }
    int cardID=Integer.parseInt(jTextField1.getText().trim());
    String cardType=jComboBox1.getSelectedItem().toString();

    cardparameter.setInt("CardID",cardID);
    cardparameter.setString("CardType",cardType);
    queryDataSet2.refresh();

    if(queryDataSet2.rowCount()!=0){
      if(cardType.equals("长期卡")){
        // 显示长期卡管理页面，并传进cardID和oper参数
        LongTermInOutDialog inOutDialog=new LongTermInOutDialog(this,"长期卡用户进出管理",false,cardID,oper);
        inOutDialog.show();
      }
      else if(cardType.equals("次卡") && oper.equals("入场")){
        //显示次卡管理页面，并
        ShortTermInDialog shortTermIn=new ShortTermInDialog(this,"次卡用户进出进入管理",false,cardID);
        shortTermIn.show();
      }
      else if(cardType.equals("次卡") && oper.equals("出场")){
        ShortTermOutDialog shortTermOut=new ShortTermOutDialog(this,"次卡用户出车场管理",false,cardID);
        shortTermOut.show();
     //  Dialog1 d=new Dialog1(this,"hello",false,cardID);
     //  d.show();
      }
    }
    else {
      jTextField1.setText("该卡不存在！");
    }
  }

  void jButton2_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
    jComboBox1.setSelectedIndex(0);
  }
}

class InOutFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  InOutFrame adaptee;

  InOutFrame_jButton1_actionAdapter(InOutFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class InOutFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
  InOutFrame adaptee;

  InOutFrame_jButton2_actionAdapter(InOutFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}