📄 inoutsearchdialog.java~42~
字号:
package parkingsystem;
import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import java.text.*;
import com.borland.dx.dataset.*;
public class InOutSearchDialog extends JDialog {
BorderLayout borderLayout2 = new BorderLayout();
JLabel jLabel4 = new JLabel();
JPanel jPanel1 = new JPanel();
JLabel jLabel2 = new JLabel();
JTextField jTextField2 = new JTextField();
JSplitPane jSplitPane1 = new JSplitPane();
XYLayout xYLayout1 = new XYLayout();
JLabel jLabel6 = new JLabel();
JRadioButton jRadioButton1 = new JRadioButton();
JPanel jPanel2 = new JPanel();
JTextField jTextField1 = new JTextField();
JLabel jLabel3 = new JLabel();
JRadioButton jRadioButton2 = new JRadioButton();
JLabel jLabel5 = new JLabel();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
BorderLayout borderLayout1 = new BorderLayout();
TableScrollPane tableScrollPane1 = new TableScrollPane();
JdbTable jdbTable1 = new JdbTable();
Column column1 = new Column();
Column column3 = new Column();
Column column5 = new Column();
Column column7 = new Column();
ButtonGroup buttonGroup1 = new ButtonGroup();
JPanel jPanel3 = new JPanel();
JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
JLabel jLabel1 = new JLabel();
XYLayout xYLayout2 = new XYLayout();
Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
Column column2 = new Column();
Column column6 = new Column();
JdbNavField jdbNavField1 = new JdbNavField();
JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel(); Column column4 = new Column(); Column column8 = new Column(); Column column9 = new Column(); Column column10 = new Column(); Column column11 = new Column();
public InOutSearchDialog(Frame frame, String title, boolean modal) {
super(frame, title, modal);
try {
jbInit();
pack();
}
catch(Exception ex) {
ex.printStackTrace();
}
}
public InOutSearchDialog() {
this(null, "", false);
}
private void jbInit() throws Exception {
jPanel1.setPreferredSize(new Dimension(500, 103));
jPanel1.setFont(new java.awt.Font("Dialog", 0, 12));
jPanel1.setLayout(xYLayout1);
jLabel4.setText("结束时间：");
jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel4.setText("截止时间：");
this.getContentPane().setLayout(borderLayout2);
jLabel2.setText("选择卡类型：");
jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel2.setText("请输入查询时间段：");
jTextField2.setFont(new java.awt.Font("Dialog", 0, 12));
jTextField2.setText(" ");
jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
jSplitPane1.setOpaque(true);
jSplitPane1.setPreferredSize(new Dimension(500, 400));
jLabel6.setText("请输入查询时间段：");
jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel6.setText("格式如: 2000-10-12 或 2000-10-12 5:20");
jRadioButton1.setText("出场信息");
jRadioButton1.setSelected(true);
jRadioButton1.setFont(new java.awt.Font("Dialog", 0, 12));
jTextField1.setText(" ");
jTextField1.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel3.setText("请输入查询时间段：");
jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel3.setText("开始时间：");
jRadioButton2.setFont(new java.awt.Font("Dialog", 0, 12));
jRadioButton2.setSelected(false);
jRadioButton2.setText("入场信息");
jLabel5.setText("请输入查询时间段：");
jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel5.setText("请选择查询类型：");
jSplitPane1.setDividerLocation(120);
jButton1.setFont(new java.awt.Font("Dialog", 0, 12));
jButton1.setText("确 定");
jButton1.addActionListener(new InOutSearchDialog_jButton1_actionAdapter(this));
jButton2.setText("清 空");
jButton2.addActionListener(new InOutSearchDialog_jButton2_actionAdapter(this));
jButton2.setFont(new java.awt.Font("Dialog", 0, 12));
jPanel2.setLayout(borderLayout1);
jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
jdbTable1.setDataSet(queryDataSet1);
column1.setCaption("用户ID号");
column1.setColumnName("UserID");
column1.setDataType(com.borland.dx.dataset.Variant.INT);
column1.setRowId(true);
column1.setTableName("users");
column1.setHidden(true);
column1.setServerColumnName("UserID");
column1.setSqlType(4);
column3.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
column3.setCaption("操作员");
column3.setColumnName("UserName");
column3.setDataType(com.borland.dx.dataset.Variant.STRING);
column3.setPrecision(10);
column3.setTableName("users");
column3.setWidth(6);
column3.setServerColumnName("UserName");
column3.setSqlType(12);
column5.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
column5.setCaption("出入口");
column5.setColumnName("InOutName");
column5.setDataType(com.borland.dx.dataset.Variant.STRING);
column5.setPrecision(20);
column5.setTableName("event");
column5.setWidth(10);
column5.setServerColumnName("InOutName");
column5.setSqlType(12);
column7.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE);
column7.setCaption("离开时间");
column7.setColumnName("OutTime");
column7.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
column7.setTableName("event");
column7.setServerColumnName("OutTime");
column7.setSqlType(93);
jPanel3.setAlignmentX((float) 0.0);
jPanel3.setPreferredSize(new Dimension(500, 35));
jPanel3.setLayout(xYLayout2);
jdbNavToolBar1.setAlignmentY((float) 0.5);
jdbNavToolBar1.setMinimumSize(new Dimension(367, 39));
jdbNavToolBar1.setPreferredSize(new Dimension(150, 25));
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);
jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel1.setText("Find:");
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=carparkingdb", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
column2.setColumnName("BeginTime");
column2.setDataType(com.borland.dx.dataset.Variant.STRING);
column2.setDisplayMask("");
column2.setDefault("");
column2.setServerColumnName("NewColumn1");
column2.setSqlType(0);
column6.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE); column6.setColumnName("CarNum");
column6.setDataType(com.borland.dx.dataset.Variant.STRING);
column6.setPrecision(50);
column6.setTableName("event");
column6.setWidth(10);
column6.setServerColumnName("CarNum");
column6.setSqlType(12);
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from event where InTime is null", null, true, Load.ALL));
jdbNavField1.setText("jdbNavField1");
jdbNavField1.setColumnName("CarNum");
jdbNavField1.setDataSet(queryDataSet1);
jdbStatusLabel1.setText("jdbStatusLabel1");
column4.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE); column4.setColumnName("EventID"); column4.setDataType(com.borland.dx.dataset.Variant.INT); column4.setRowId(true); column4.setTableName("event"); column4.setServerColumnName("EventID"); column4.setSqlType(4); column8.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE); column8.setColumnName("CardID"); column8.setDataType(com.borland.dx.dataset.Variant.INT); column8.setTableName("event"); column8.setServerColumnName("CardID"); column8.setSqlType(4); column9.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE); column9.setColumnName("UserID"); column9.setDataType(com.borland.dx.dataset.Variant.INT); column9.setTableName("event"); column9.setServerColumnName("UserID"); column9.setSqlType(4); column10.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE); column10.setColumnName("InTime"); column10.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP); column10.setTableName("event"); column10.setServerColumnName("InTime"); column10.setSqlType(93); column11.setAlignment(com.borland.dx.text.Alignment.CENTER | com.borland.dx.text.Alignment.MIDDLE); column11.setColumnName("OutTime"); column11.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP); column11.setTableName("event"); column11.setServerColumnName("OutTime"); column11.setSqlType(93); queryDataSet1.setColumns(new Column[] {column4, column8, column9, column6, column10, column11}); jPanel1.add(jLabel2, new XYConstraints(18, 36, 118, 31));
jPanel1.add(jLabel3, new XYConstraints(18, 71, 72, 31));
jPanel1.add(jLabel5, new XYConstraints(18, 5, 108, 31));
jPanel1.add(jTextField1, new XYConstraints(98, 73, 96, -1));
jPanel1.add(jLabel4, new XYConstraints(206, 72, 63, 31));
jPanel1.add(jTextField2, new XYConstraints(269, 73, 107, 24));
jPanel1.add(jLabel6, new XYConstraints(144, 36, 220, 31));
jPanel1.add(jRadioButton1, new XYConstraints(122, 8, 92, 28));
jPanel1.add(jRadioButton2, new XYConstraints(220, 8, 105, 28));
jPanel1.add(jButton1, new XYConstraints(405, 27, 74, -1));
jPanel1.add(jButton2, new XYConstraints(405, 74, 74, -1));
jSplitPane1.add(jPanel2, JSplitPane.BOTTOM);
jPanel2.add(tableScrollPane1, BorderLayout.CENTER);
jPanel2.add(jPanel3, BorderLayout.NORTH);
jPanel3.add(jLabel1, new XYConstraints(164, 8, 49, -1));
jPanel3.add(jdbNavField1, new XYConstraints(212, 6, 106, -1)); jPanel3.add(jdbNavToolBar1, new XYConstraints(5, 4, -1, -1));
jPanel2.add(jdbStatusLabel1, BorderLayout.SOUTH);
tableScrollPane1.getViewport().add(jdbTable1, null);
jSplitPane1.add(jPanel1, JSplitPane.TOP);
this.getContentPane().add(jSplitPane1, BorderLayout.NORTH);
buttonGroup1.add(jRadioButton1);
buttonGroup1.add(jRadioButton2);
}
void jButton2_actionPerformed(ActionEvent e) {
jTextField1.setText("");
jTextField2.setText("");
}
void jButton1_actionPerformed(ActionEvent e) {
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_jButton2_actionAdapter implements java.awt.event.ActionListener {
InOutSearchDialog adaptee;
InOutSearchDialog_jButton2_actionAdapter(InOutSearchDialog adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class InOutSearchDialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
InOutSearchDialog adaptee;
InOutSearchDialog_jButton1_actionAdapter(InOutSearchDialog adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -