dlg_test_zsquerydataset.java

实现oracle查询数据集分页

package support;

import java.awt.*;
import javax.swing.*;
import javax.swing.border.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import wisesoft.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Dlg_test_ZsQueryDataSet extends JDialog {
  JPanel panel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  JPanel jPanel2 = new JPanel();
  Database database1 = new Database();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  BorderLayout borderLayout2 = new BorderLayout();
  JButton jButton1 = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JdbTable jdbTable1 = new JdbTable();
  ZSQueryDataSet queryDataSet1 = new ZSQueryDataSet();
  JCheckBox jCheckBox1 = new JCheckBox();
  JLabel jLabel1 = new JLabel();
  JButton jButton6 = new JButton();

  public Dlg_test_ZsQueryDataSet(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public Dlg_test_ZsQueryDataSet() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    panel1.setLayout(borderLayout1);
    jPanel1.setBorder(titledBorder2);
    jPanel1.setPreferredSize(new Dimension(10, 40));
    jPanel1.setLayout(xYLayout1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:oracle:thin:@168.192.13.44:1521:oracsid1", "chenrong", "12345", false, "oracle.jdbc.driver.OracleDriver"));
    database1.setDatabaseName("");
    jPanel2.setLayout(borderLayout2);
    jButton1.setToolTipText("");
    jButton1.setVerifyInputWhenFocusTarget(true);
    jButton1.setText("退出");
    jButton1.addActionListener(new Dlg_test_ZsQueryDataSet_jButton1_actionAdapter(this));
    jButton2.setText("首页");
    jButton2.addActionListener(new Dlg_test_ZsQueryDataSet_jButton2_actionAdapter(this));
    jButton3.setText("前页");
    jButton3.addActionListener(new Dlg_test_ZsQueryDataSet_jButton3_actionAdapter(this));
    jButton4.setText("下页");
    jButton4.addActionListener(new Dlg_test_ZsQueryDataSet_jButton4_actionAdapter(this));
    jButton5.setText("末页");
    jButton5.addActionListener(new Dlg_test_ZsQueryDataSet_jButton5_actionAdapter(this));
    jdbTable1.setDebugGraphicsOptions(0);
    jdbTable1.setDataSet(queryDataSet1);
    queryDataSet1.setIRowsInPage(30);
    queryDataSet1.setQueryByPage("select * from dt_fixpoint",database1);
    //queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from dt_airport", null, true, Load.ALL));
    jCheckBox1.setSelected(true);
    jCheckBox1.setText("分页显示");
    jCheckBox1.addActionListener(new Dlg_test_ZsQueryDataSet_jCheckBox1_actionAdapter(this));
    jLabel1.setText("jLabel1");
    jButton6.setText("jButton6");
    jButton6.addActionListener(new Dlg_test_ZsQueryDataSet_jButton6_actionAdapter(this));
    this.getContentPane().add(panel1, BorderLayout.CENTER);
    panel1.add(jPanel1, BorderLayout.SOUTH);
    jPanel1.add(jButton2,   new XYConstraints(88, 4, -1, -1));
    jPanel1.add(jButton3, new XYConstraints(147, 4, -1, -1));
    jPanel1.add(jButton4, new XYConstraints(207, 4, -1, -1));
    jPanel1.add(jButton5, new XYConstraints(267, 4, -1, -1));
    jPanel1.add(jCheckBox1,  new XYConstraints(0, 2, -1, -1));
    jPanel1.add(jButton1, new XYConstraints(409, 3, -1, -1));
    jPanel1.add(jLabel1,  new XYConstraints(351, 9, -1, -1));
    jPanel1.add(jButton6,   new XYConstraints(475, 6, -1, -1));
    panel1.add(jPanel2, BorderLayout.CENTER);
    jPanel2.add(tableScrollPane1, BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    dispose();
  }

  void jButton2_actionPerformed(ActionEvent e) {
    //queryDataSet1.firstPage();
    //ZSCom_Func.Showmessage(ZSCom_Func.IntToString(queryDataSet1.getIRowByKey("trim(callsign)||'-'||to_char(pointid)","BDDXT-53")),"");;
    ZSCom_Func.Showmessage(ZSCom_Func.IntToString(queryDataSet1.getTotalPages()),"");

  }

  void jButton3_actionPerformed(ActionEvent e) {
    queryDataSet1.priorPage();
    jdbTable1.setDataSet(queryDataSet1);
  }

  void jButton4_actionPerformed(ActionEvent e) {
    queryDataSet1.nextPage();
    jdbTable1.setDataSet(queryDataSet1);
  }

  void jButton5_actionPerformed(ActionEvent e) {
    queryDataSet1.lastPage();
    jdbTable1.setDataSet(queryDataSet1);
  }

  void jCheckBox1_actionPerformed(ActionEvent e) {
    if(jCheckBox1.isSelected())
    {
      queryDataSet1.firstPage();
      jdbTable1.setDataSet(queryDataSet1);
      jLabel1.setText(ZSCom_Func.IntToString(queryDataSet1.getRecordCount()));
    }
    else
    {
      queryDataSet1.allPage();
      jdbTable1.setDataSet(queryDataSet1);
      jLabel1.setText(ZSCom_Func.IntToString(queryDataSet1.getRecordCount()));
    }
  }

  void jButton6_actionPerformed(ActionEvent e) {

    JdbComboBox comboBox = new JdbComboBox();
    comboBox.addItem("F");
    comboBox.addItem("S");
    comboBox.setDataSet(queryDataSet1);
    comboBox.setColumnName("rank");
    jdbTable1.getColumn("RANK").setCellEditor(new DefaultCellEditor(comboBox));
/*
    if (!queryDataSet1.isOpen())
    {
      queryDataSet1.open();
    }
    //queryDataSet1.empty();
   queryDataSet1.insertRow(false);
   queryDataSet1.setString("col1","ad1");
   queryDataSet1.setString("col2","a12");
   queryDataSet1.setString("col3","a13");

   queryDataSet1.insertRow(false);
   queryDataSet1.setString("col1","ad2");
   queryDataSet1.setString("col2","a22");
   queryDataSet1.setString("col3","a33");
*/
  }
}

class Dlg_test_ZsQueryDataSet_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jButton1_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Dlg_test_ZsQueryDataSet_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jButton2_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class Dlg_test_ZsQueryDataSet_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jButton3_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class Dlg_test_ZsQueryDataSet_jButton4_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jButton4_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class Dlg_test_ZsQueryDataSet_jButton5_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jButton5_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class Dlg_test_ZsQueryDataSet_jCheckBox1_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jCheckBox1_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCheckBox1_actionPerformed(e);
  }
}

class Dlg_test_ZsQueryDataSet_jButton6_actionAdapter implements java.awt.event.ActionListener {
  Dlg_test_ZsQueryDataSet adaptee;

  Dlg_test_ZsQueryDataSet_jButton6_actionAdapter(Dlg_test_ZsQueryDataSet adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}