selectdialog1.java

是适合于使用的管理系统 可以在现实中使用

package mysiloer;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.border.*;
import com.borland.jbcl.layout.*;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;

/**
 * <p>Title: MySiloer</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: yskey</p>
 * @author 杨涛
 * @version 1.0
 */

public class SelectDialog1 extends JDialog {

  private static final int FINDALL = 0;
  private static final int BYID = 1;
  private static final int BYNAME = 2;
  private static final int BYDATE = 3;
  private static final int BYQUANTITY = 4;
  private static final int BYPRICE = 5;

  private int findBy = this.FINDALL;

  private JPanel radioPanel = new JPanel();
  private SiloPanel parentPanel = null;
  private GridLayout gridLayout1 = new GridLayout();
  private ButtonGroup buttonGroup1 = new ButtonGroup();
  private ButtonGroup buttonGroup2 = new ButtonGroup();
  private JRadioButton rdButt1 = new JRadioButton();
  private JRadioButton rdButt8 = new JRadioButton();
  private JRadioButton rdButt7 = new JRadioButton();
  private JRadioButton rdButt6 = new JRadioButton();
  private JRadioButton rdButt5 = new JRadioButton();
  private JRadioButton rdButt4 = new JRadioButton();
  private JRadioButton rdButt3 = new JRadioButton();
  private JRadioButton rdButt2 = new JRadioButton();
  private JRadioButton[] rdButts = {rdButt1, rdButt2, rdButt3, rdButt4,
    rdButt5, rdButt6, rdButt7, rdButt8};
  private JRadioButton biggerRadio = new JRadioButton("大于");
  private JRadioButton smallerRadio = new JRadioButton("小于");
  private BorderLayout borderLayout1 = new BorderLayout();
  private JPanel mainPanel = new JPanel();
  private BorderLayout borderLayout2 = new BorderLayout();
  private JPanel buttonPanel = new JPanel();
  private JButton cancelButton = new JButton("取 消");
  private JButton okButton = new JButton("确 定");
  private JPanel contentPanel = new JPanel();
  private JTextField param1 = new JTextField("", 10);
  private JTextField param2 = new JTextField("", 10);
  private FlowLayout flowLayout1 = new FlowLayout();
  private Border border1;
  private FlowLayout flowLayout2 = new FlowLayout();
  private JLabel jLabel1 = new JLabel();
  private Connection con;
  Vector colNamesVector, colClassesVector;
  String sql = "select * from  " +Type.SILOTABLE;
//  private DataBase dataBase;

  public SelectDialog1(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {

    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

//  public SelectDialog(JPanel panel, DataBase dataBase) {
  public SelectDialog1(SiloPanel panel, boolean model) {
    this(null, "查询对话框", model);
    try{
      parentPanel = panel;
      this.con = panel.dataBase.connection;
      getColMeta(con);
      jbInit();
      pack();
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    border1 = BorderFactory.createEmptyBorder(10,10,10,10);
    int colCount = colNamesVector.size();
    if(colCount%2 ==0)
      gridLayout1.setRows(colCount/2);
    else
      gridLayout1.setRows(colCount/2 + 1);
//    gridLayout1.setRows(colCount/2 + 1);
    gridLayout1.setColumns(2);
    radioPanel.setLayout(gridLayout1);
    rdButt1.setSelected(true);
    rdButt1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt1_actionPerformed(e);
      }
    });
    for(int i = 0 ; i<colNamesVector.size(); i++){
      if(i == 0)
        rdButts[i].setText("查询全部");
      else
        rdButts[i].setText("按"+(String)colNamesVector.elementAt(i-1)+"查询");
      radioPanel.add(rdButts[i]);
      buttonGroup1.add(rdButts[i]);
    }

    okButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        okButton_actionPerformed(e);
      }
    });
    cancelButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        cancelButton_actionPerformed(e);
      }
    });
    rdButt8.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt8_actionPerformed(e);
      }
    });
    rdButt7.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt7_actionPerformed(e);
      }
    });
    rdButt6.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt6_actionPerformed(e);
      }
    });
    rdButt5.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt5_actionPerformed(e);
      }
    });
    rdButt4.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt4_actionPerformed(e);
      }
    });
    rdButt3.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt3_actionPerformed(e);
      }
    });
    biggerRadio.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        biggerRadio_actionPerformed(e);
      }
    });
    smallerRadio.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        smallerRadio_actionPerformed(e);
      }
    });
    rdButt2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        rdButt2_actionPerformed(e);
      }
    });
    this.getContentPane().add(mainPanel, BorderLayout.CENTER);
    mainPanel.setLayout(borderLayout1);
    mainPanel.add(radioPanel, BorderLayout.NORTH);
    buttonPanel.add(okButton, null);
    buttonPanel.add(jLabel1, null);
    buttonPanel.add(cancelButton, null);
    mainPanel.add(buttonPanel, BorderLayout.SOUTH);
    mainPanel.add(contentPanel,  BorderLayout.CENTER);
  }



//  void rdButt4_actionPerformed(ActionEvent e) {
  /*  setFindBy(this.BYDATE);
    contentPanel.removeAll();
    contentPanel.add(new JLabel("请输入起始时间："));
    contentPanel.add(param1);
    contentPanel.add(new JLabel("请输入中止时间时间："));
    contentPanel.add(param2);
    pack();
    validate();
    repaint();*/
//  }


  void cancelButton_actionPerformed(ActionEvent e) {
    this.setVisible(false);
    this.dispose();
  }
  void okButton_actionPerformed(ActionEvent e) {
    if(e.getSource() != rdButt1)
        sql += param1.getText();
    try{
      Statement sta = con.createStatement();
      ResultSet set = sta.executeQuery(sql);
//      ResultSet set = sta.executeQuery("select * from "+Type.SILOTABLE);
      ResultSetMetaData meta = set.getMetaData();
      int colCount = meta.getColumnCount();
      int rowCount = parentPanel.tablePanel.tbModel.getRowCount();
      for(int i = 0; i < rowCount; i++){
        parentPanel.tablePanel.tbModel.removeRow(0);
      }
      Vector row;
      parentPanel.tablePanel.tbModel.setColumnIdentifiers(colNamesVector);
      while(set.next()){
        row = new Vector();
        for(int i = 1; i <= colCount; i++){
          row.add(set.getString(i));
//          System.out.print(set.getString(i)+"   ");
        }
        parentPanel.tablePanel.tbModel.addRow(row);
      }
    }
    catch(Exception ex){
      System.err.println(e.toString());
    }
  }
private void getColMeta(Connection con){
  colNamesVector = new Vector();
  colClassesVector = new Vector();
  try{
    Statement sta = con.createStatement();
    ResultSet set = sta.executeQuery("select * from "+Type.SILOTABLE);
    ResultSetMetaData metaData = set.getMetaData();
    int colCount = metaData.getColumnCount();
    for(int i = 0; i<colCount; i++){
      colNamesVector.add(metaData.getColumnLabel(i+1));
      colClassesVector.add(metaData.getColumnClassName(i+1));
//      System.out.println(metaData.getColumnLabel(i+1));
    }
    set.close();
    sta.close();
  }
  catch(Exception e){
    System.err.print(e.toString());
  }
}


void rdButt1_actionPerformed(ActionEvent e) {
  System.out.println("radioButton1");
  contentPanel.removeAll();
  pack();
  validate();
  repaint();
}

void rdButt2_actionPerformed(ActionEvent e) {
    System.out.println("radioButton2");
  if(((String)colClassesVector.elementAt(0)).indexOf("String")>0)
    sql = "select * from "+Type.SILOTABLE+" where "+((String)colNamesVector.elementAt(0))+" like ";
  System.out.println(sql);
  JLabel label1 = new JLabel("请输入要查询的"+colNamesVector.elementAt(0));
  contentPanel.removeAll();
  contentPanel.add(label1);
  contentPanel.add(param1);
  pack();
  validate();
  repaint();
}

  void rdButt8_actionPerformed(ActionEvent e) {
      System.out.println("radioButton8");
  }

  void rdButt7_actionPerformed(ActionEvent e) {
  System.out.println("radioButton7");
  }

  void rdButt6_actionPerformed(ActionEvent e) {
  System.out.println("radioButton6");
  }

  void rdButt5_actionPerformed(ActionEvent e) {
  System.out.println("radioButton5");
  }

  void rdButt4_actionPerformed(ActionEvent e) {
 System.out.println("radioButton4");
  }

  void rdButt3_actionPerformed(ActionEvent e) {
 System.out.println("radioButton3");
  }

  void biggerRadio_actionPerformed(ActionEvent e) {
 System.out.println("Bigger");
  }

  void smallerRadio_actionPerformed(ActionEvent e) {
 System.out.println("smoller");
  }

}