package bar;import java.awt.*;import javax.swing.*;import com.borland.dbswing.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class cardQueryPanel extends JPanel {  BorderLayout borderLayout1 = new BorderLayout();  JSplitPane jSplitPane1 = new JSplitPane();  JPanel jPanel1 = new JPanel();  JScrollPane jScrollPane1 = new JScrollPane();  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  Database database1 = new Database();  public cardQueryPanel(mainFrame mFrame1,int ID) {    try {      Frame1 = mFrame1;      CardID = ID;      jbInit();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    this.setLayout(borderLayout1);    jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);    jPanel1.setLayout(null);    jLabel1.setFont(new java.awt.Font("Serif", 0, 16));    jLabel1.setText("卡號：");    jLabel1.setBounds(new Rectangle(140, 20, 65, 25));    jLabel2.setText(Integer.toString(CardID));    jLabel2.setBounds(new Rectangle(205, 20, 55, 25));/*    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select CardId,ComputerID,BeginTime,EndTime from dbo.Event where CardID = "+CardID, null, true, Load.ALL));*/    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://keweixing:1433;DatabaseName=dbbar", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT CardID, ComputerID, BeginTime, EndTime FROM Event WHERE CardID = 12345678", null, true, Load.ALL));    jdbTable1.setDataSet(queryDataSet1);    column1.setCaption("卡號");    column1.setColumnName("CardID");    column1.setDataType(com.borland.dx.dataset.Variant.INT);    column1.setTableName("Event");    column1.setServerColumnName("CardID");    column1.setSqlType(4);    column2.setCaption("機器號");    column2.setColumnName("ComputerID");    column2.setDataType(com.borland.dx.dataset.Variant.INT);    column2.setTableName("Event");    column2.setServerColumnName("ComputerID");    column2.setSqlType(4);    column3.setCaption("開始時間");    column3.setColumnName("BeginTime");    column3.setDataType(com.borland.dx.dataset.Variant.TIME);    column3.setTableName("Event");    column3.setServerColumnName("BeginTime");    column3.setSqlType(93);    column4.setCaption("結束時間");    column4.setColumnName("EndTime");    column4.setDataType(com.borland.dx.dataset.Variant.TIME);    column4.setTableName("Event");    column4.setServerColumnName("EndTime");    column4.setSqlType(93);    this.add(jSplitPane1, BorderLayout.CENTER);    jSplitPane1.add(jPanel1, JSplitPane.LEFT);    jPanel1.add(jLabel1, null);    jPanel1.add(jLabel2, null);    jSplitPane1.add(jScrollPane1, JSplitPane.RIGHT);    jScrollPane1.getViewport().add(tableScrollPane1, null);    tableScrollPane1.getViewport().add(jdbTable1, null);    jSplitPane1.setDividerLocation(60);    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4});    Frame1.login_false();    Frame1.SetCardID(0);  }  private mainFrame Frame1;  private int CardID;  QueryDataSet queryDataSet1 = new QueryDataSet();  Column column1 = new Column();  Column column2 = new Column();  Column column3 = new Column();  Column column4 = new Column();}