inoutsearchdialog.java

来自「eidtplus注册码.txt eidtplus注册码.txt」· Java 代码 · 共 217 行

package parkingsystem;

import java.awt.*;
import javax.swing.*;
import java.awt.Dimension;
import javax.swing.Box;
import java.awt.Rectangle;
import java.awt.BorderLayout;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.JdbNavToolBar;
import com.borland.dbswing.JdbNavField;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbStatusLabel;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.dataset.Column;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class InOutSearchDialog
    extends JDialog {
  JPanel panel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JSplitPane jSplitPane1 = new JSplitPane();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  XYLayout xYLayout2 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JRadioButton jRadioButton1 = new JRadioButton();
  JRadioButton jRadioButton2 = new JRadioButton();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanel3 = new JPanel();
  XYLayout xYLayout1 = new XYLayout();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JLabel jLabel6 = new JLabel();
  JdbNavField jdbNavField1 = new JdbNavField();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
  JdbTable jdbTable1 = new JdbTable();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column EventID = new Column();
  Column CardID = new Column();
  Column UserID = new Column();
  Column CarNum = new Column();
  Column InTime = new Column();
  Column OutTime = new Column();
  public InOutSearchDialog(Frame owner, String title, boolean modal) {
    super(owner, title, modal);
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

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

  private void jbInit() throws Exception {
    panel1.setLayout(borderLayout1);
    panel1.setPreferredSize(new Dimension(500, 400));
    jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
    jPanel2.setLayout(borderLayout2);
    jPanel1.setLayout(xYLayout2);
    jLabel1.setText("请选择查询类型：");
    jLabel2.setText("请输入查询时间段：");
    jLabel3.setText("开始时间：");
    jLabel4.setText("格式如：2000-10-12 或 2000-10-12 5:20");
    jLabel5.setText("截止时间：");
    jRadioButton1.setSelected(true);
    jRadioButton1.setText("出场信息");
    jRadioButton2.setText("入场信息");
    jButton1.setText("确 定");
    jButton1.addActionListener(new InOutSearchDialog_jButton1_actionAdapter(this));
    jButton2.setText("清 空");
    jPanel3.setLayout(xYLayout1);
    jdbNavToolBar1.setButtonStateInsert(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStateDelete(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStatePost(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStateCancel(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStateDitto(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStateSave(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStateRefresh(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jLabel6.setText("Find:");
    jdbNavField1.setText("jdbNavField1");
    jdbNavField1.setColumnName("CarNum");
    jdbNavField1.setDataSet(queryDataSet1);
    jdbStatusLabel1.setText("record of 2");
    jdbStatusLabel1.setDataSet(queryDataSet1);
    database1.setConnection(new ConnectionDescriptor(
        "jdbc:microsoft:sqlserver://Localhost:1433;DatabaseName=parkingdb",
        "sa", "123456", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet1.setQuery(new QueryDescriptor(database1,
        "select * from event where InTime is null", null, true, Load.ALL));
    EventID.setAlignment(com.borland.dx.text.Alignment.CENTER |
                         com.borland.dx.text.Alignment.MIDDLE);
    EventID.setColumnName("EventID");
    EventID.setDataType(com.borland.dx.dataset.Variant.INT);
    EventID.setRowId(true);
    EventID.setTableName("event");
    EventID.setServerColumnName("EventID");
    EventID.setSqlType(4);
    CardID.setAlignment(com.borland.dx.text.Alignment.CENTER |
                         com.borland.dx.text.Alignment.MIDDLE);
    CardID.setColumnName("CardID");
    CardID.setDataType(com.borland.dx.dataset.Variant.INT);
    CardID.setTableName("event");
    CardID.setServerColumnName("CardID");
    CardID.setSqlType(4);
    UserID.setAlignment(com.borland.dx.text.Alignment.CENTER |
                         com.borland.dx.text.Alignment.MIDDLE);
    UserID.setColumnName("UserID");
    UserID.setDataType(com.borland.dx.dataset.Variant.INT);
    UserID.setTableName("event");
    UserID.setServerColumnName("UserID");
    UserID.setSqlType(4);
    CarNum.setAlignment(com.borland.dx.text.Alignment.CENTER |
                         com.borland.dx.text.Alignment.MIDDLE);
    CarNum.setColumnName("CarNum");
    CarNum.setDataType(com.borland.dx.dataset.Variant.STRING);
    CarNum.setPrecision(50);
    CarNum.setTableName("event");
    CarNum.setServerColumnName("CarNum");
    CarNum.setSqlType(12);
    InTime.setAlignment(com.borland.dx.text.Alignment.CENTER |
                         com.borland.dx.text.Alignment.MIDDLE);
    InTime.setColumnName("InTime");
    InTime.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    InTime.setTableName("event");
    InTime.setServerColumnName("InTime");
    InTime.setSqlType(93);
    OutTime.setAlignment(com.borland.dx.text.Alignment.CENTER |
                         com.borland.dx.text.Alignment.MIDDLE);
    OutTime.setColumnName("OutTime");
    OutTime.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    OutTime.setTableName("event");
    OutTime.setServerColumnName("OutTime");
    OutTime.setSqlType(93);
    jdbTable1.setDataSet(queryDataSet1);
    getContentPane().add(panel1);
    panel1.add(jSplitPane1, java.awt.BorderLayout.CENTER);
    jSplitPane1.add(jPanel1, JSplitPane.TOP);
    jSplitPane1.add(jPanel2, JSplitPane.BOTTOM);
    jPanel2.add(jPanel3, java.awt.BorderLayout.NORTH);
    jPanel1.add(jLabel1, new XYConstraints(28, 15, 99, 22));
    jSplitPane1.setDividerLocation(100);
    buttonGroup1.add(jRadioButton1);
    jPanel1.add(jLabel2, new XYConstraints(28, 43, 114, 22));
    buttonGroup1.add(jRadioButton2);
    jPanel1.add(jLabel4, new XYConstraints(156, 42, 229, 22));
    jPanel1.add(jRadioButton2, new XYConstraints(265, 15, -1, -1));
    jPanel1.add(jTextField1, new XYConstraints(107, 71, 99, 22));
    jPanel1.add(jLabel5, new XYConstraints(214, 71, 74, 22));
    jPanel1.add(jTextField2, new XYConstraints(294, 71, 99, 22));
    jPanel1.add(jButton1, new XYConstraints(408, 20, -1, -1));
    jPanel1.add(jButton2, new XYConstraints(408, 63, -1, -1));
    jPanel1.add(jLabel3, new XYConstraints(28, 71, 80, 22));
    jPanel1.add(jRadioButton1, new XYConstraints(156, 15, -1, -1));
    jPanel3.add(jdbNavToolBar1, new XYConstraints(1, 1, 177, 36));
    jPanel3.add(jdbNavField1, new XYConstraints(235, 11, 120, -1));
    jPanel3.add(jLabel6, new XYConstraints(188, 13, -1, -1));
    jPanel2.add(tableScrollPane1, java.awt.BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1);
    this.getContentPane().add(jdbStatusLabel1, java.awt.BorderLayout.SOUTH);
    queryDataSet1.setColumns(new Column[] {EventID, CardID, UserID, CarNum,
                             InTime, OutTime});
  }

  public void jButton1_actionPerformed(ActionEvent actionEvent) {
    queryDataSet1.close();
    String beginTime=jTextField1.getText().trim();
    String endTime=jTextField2.getText().trim();
    String query="";
    if(jRadioButton1.isSelected()){
      query="select * from event where OutTime >='"+beginTime+"'and OutTime <='"+endTime+"'";

    }else if(jRadioButton2.isSelected()){
      query="select * from event where InTime >='"+beginTime+"'and InTime <='"+endTime+"'";

    }
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1,query,null,true,Load.ALL));
    queryDataSet1.refresh();
  }
}

class InOutSearchDialog_jButton1_actionAdapter
    implements ActionListener {
  private InOutSearchDialog adaptee;
  InOutSearchDialog_jButton1_actionAdapter(InOutSearchDialog adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent actionEvent) {
    adaptee.jButton1_actionPerformed(actionEvent);
  }
}