productselectdialog.java~1~

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

package mysiloer;

import java.awt.*;
import javax.swing.*;
import javax.swing.border.Border;
import java.sql.Connection;
import java.awt.event.ActionEvent;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import java.awt.event.ActionListener;

/**
 * <p>Title: MySiloer</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: yskey</p>
 *
 * @author 杨涛
 * @version 1.0
 */
public class ProductSelectDialog
    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 static final int BYMARQUE = 6;

  private int findBy = this.FINDALL;
  private String sql = "";

  private JPanel radioPanel = new JPanel();
  private Toolkit kit = Toolkit.getDefaultToolkit();
  private SiloPanel parentPanel = null;
  private GridLayout gridLayout1 = new GridLayout();
  private ButtonGroup buttonGroup1 = new ButtonGroup();
  private ButtonGroup buttonGroup2 = new ButtonGroup();
  private JRadioButton findAll = new JRadioButton();
  private JRadioButton jRadioButton2 = new JRadioButton();
  private JRadioButton jRadioButton3 = new JRadioButton();
  private JRadioButton findByPrice = new JRadioButton();
  private JRadioButton findByQuantity = new JRadioButton();
  private JRadioButton findByDate = new JRadioButton();
  private JRadioButton findByName = new JRadioButton();
  private JRadioButton findById = new JRadioButton();
  private JRadioButton equalRadio = new JRadioButton("等于");
  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;

  JPanel panel1 = new JPanel();
  JRadioButton findByMarque = new JRadioButton();
  //  BorderLayout borderLayout1 = new BorderLayout();

  public ProductSelectDialog(Frame owner, String title, boolean modal) {
    super(owner, title, modal);
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      Dimension frameSize = getSize();
      if (frameSize.height > screenSize.height) {
        frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width) {
        frameSize.width = screenSize.width;
      }
      setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2 - 150);
      setResizable(false);
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  public ProductSelectDialog(JFrame frame, SiloPanel panel, boolean model) {
    this(frame, "成品库查询对话框", true);
    parentPanel = panel;
    this.con = panel.dataBase.connection;
  }

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

  private void jbInit() throws Exception {
    border1 = BorderFactory.createEmptyBorder(5, 10, 5, 5);
    radioPanel.setLayout(gridLayout1);
    gridLayout1.setHgap(3);
    gridLayout1.setColumns(2);
    gridLayout1.setRows(4);
    param1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        okButton_actionPerformed(e);
      }
    });
    param2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        okButton_actionPerformed(e);
      }
    });
    findAll.setSelected(true);
    findAll.setText("查询全部");
    findAll.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findAll_actionPerformed(e);
      }
    });
    jRadioButton2.setText("jRadioButton2");
    jRadioButton3.setText("jRadioButton3");
    findByPrice.setText("按价格查询");
    findByPrice.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findByPrice_actionPerformed(e);
      }
    });
    findByQuantity.setText("按数量查询");
    findByQuantity.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findByQuantity_actionPerformed(e);
      }
    });
    findByDate.setText("按入库时间查询");
    findByDate.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findByDate_actionPerformed(e);
      }
    });
    findByName.setText("按名称查询");
    findByName.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findByName_actionPerformed(e);
      }
    });
    findById.setText("按序号查询");
    findById.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findById_actionPerformed(e);
      }
    });
    this.getContentPane().setLayout(borderLayout1);
    mainPanel.setLayout(borderLayout2);
//    getContentPane().add(radioPanel, BorderLayout.CENTER);
    cancelButton.setText("取   消");
    cancelButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        cancelButton_actionPerformed(e);
      }
    });
    okButton.setText("查   询");
    okButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        okButton_actionPerformed(e);
      }
    });
    contentPanel.setLayout(flowLayout1);
    radioPanel.setBorder(border1);
    buttonPanel.setLayout(flowLayout2);
    jLabel1.setText("          ");
    findByMarque.setText("按类型查询");
    findByMarque.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        findByMarque_actionPerformed(e);
      }
    });
    radioPanel.add(findAll, null);
    radioPanel.add(findById, null);
    radioPanel.add(findByName, null);
    radioPanel.add(findByMarque);
    radioPanel.add(findByDate, null);
    radioPanel.add(findByQuantity, null);
    radioPanel.add(findByPrice, null);
//    radioPanel.add(jRadioButton3, null);
//    radioPanel.add(jRadioButton2, null);
    buttonGroup1.add(findAll);
    buttonGroup1.add(findByName);
    buttonGroup1.add(findByQuantity);
    buttonGroup1.add(findByMarque);
    buttonGroup1.add(findById);
    buttonGroup1.add(findByDate);
    buttonGroup1.add(findByPrice);
//    buttonGroup1.add(jRadioButton2);
    this.getContentPane().add(mainPanel, BorderLayout.CENTER);
    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 findByName_actionPerformed(ActionEvent e) {
    setFindBy(this.BYNAME);
    contentPanel.removeAll();
    contentPanel.add(new JLabel("请输入产品名称："));
    contentPanel.add(param1);
    clearFilds();
    pack();
    validate();
    repaint();
  }

  void findAll_actionPerformed(ActionEvent e) {
    setFindBy(this.FINDALL);
    contentPanel.removeAll();
    clearFilds();
    pack();
    validate();
    repaint();
  }

  void findById_actionPerformed(ActionEvent e) {
    setFindBy(this.BYID);
    contentPanel.removeAll();
    contentPanel.add(new JLabel("请输入查询序号："));
    contentPanel.add(param1);
    clearFilds();
    pack();
    validate();
    repaint();
  }

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

  void findByQuantity_actionPerformed(ActionEvent e) {
    setFindBy(this.BYQUANTITY);
    contentPanel.removeAll();
    contentPanel.add(new JLabel("请输入产品数量："));
    contentPanel.add(param1);
//    biggerRadio.setSelected(true);
    equalRadio.setSelected(true);
    contentPanel.add(equalRadio);
    contentPanel.add(biggerRadio);
    contentPanel.add(smallerRadio);
    buttonGroup2.add(equalRadio);
    buttonGroup2.add(biggerRadio);
    buttonGroup2.add(smallerRadio);
    clearFilds();
    pack();
    validate();
    repaint();
  }

  void findByPrice_actionPerformed(ActionEvent e) {
    setFindBy(this.BYPRICE);
    contentPanel.removeAll();
    contentPanel.add(new JLabel("请输入产品价格："));
    contentPanel.add(param1);
//    biggerRadio.setSelected(true);
    equalRadio.setSelected(true);
    contentPanel.add(equalRadio);
    contentPanel.add(biggerRadio);
    contentPanel.add(smallerRadio);
    buttonGroup2.add(equalRadio);
    buttonGroup2.add(biggerRadio);
    buttonGroup2.add(smallerRadio);
    clearFilds();
    pack();
    validate();
    repaint();
  }

  void cancelButton_actionPerformed(ActionEvent e) {
    this.setVisible(false);
    this.dispose();
  }

  private void setFindBy(int findBy) {
    this.findBy = findBy;
  }

  public void okButton_actionPerformed(ActionEvent e) {
    switch (findBy) {
      case FINDALL:
        sql = "select * from " + Type.PRODUCTTABLE;
        break;
      case BYID:
        sql = "select * from " + Type.PRODUCTTABLE + " where 序号=" +
            param1.getText();
        break;
      case BYNAME:
        sql = "select * from " + Type.PRODUCTTABLE + " where 成品名称 like '" +
            param1.getText() + "'";
        break;
      case BYDATE:
        sql = "select * from " + Type.PRODUCTTABLE + " where 入库时间 >'" +
            param1.getText() + "' and 入库时间<'" + param2.getText() + "'";
        break;
      case BYMARQUE:
        sql = "select * from " + Type.PRODUCTTABLE + " where 产品类型 ='" +
            param1.getText() + "'";
        break;
      case BYQUANTITY:
        String quality = param1.getText();
        int pointIndex1 = quality.indexOf(".");
        if (pointIndex1 < 0) {
          quality += ".0";
        }
        if (biggerRadio.isSelected()) {
          sql = "select * from " + Type.PRODUCTTABLE + " where 数量>" + quality;
        }
        else if (smallerRadio.isSelected()) {
          sql = "select * from " + Type.PRODUCTTABLE + " where 数量<" + quality;
        }
        else {
          sql = "select * from " + Type.PRODUCTTABLE + " where 数量=" + quality;
        }
        break;
      case BYPRICE:
        String price = param1.getText();
        int pointIndex = price.indexOf(".");
        if (pointIndex < 0) {
          price += ".0";
        }
        if (biggerRadio.isSelected()) {
          sql = "select * from " + Type.PRODUCTTABLE + " where 单价>" + price;
        }
        else if (smallerRadio.isSelected()) {
          sql = "select * from " + Type.PRODUCTTABLE + " where 单价<" + price;
        }
        else {
          sql = "select * from " + Type.PRODUCTTABLE + " where 单价=" + price;
        }
        break;
    }
    try {
      System.out.println(sql);
      Statement sta = con.createStatement();
      ResultSet set = sta.executeQuery(sql);
      ResultSetMetaData meta = set.getMetaData();
      int colCount = meta.getColumnCount();
//    parentPanel.tablePanel.tbModel = new DefaultTableModel();
      int rowCount = parentPanel.tablePanel.tbModel.getRowCount();
//      System.out.print(rowCount);
      for (int i = 0; i < rowCount; i++) {
        parentPanel.tablePanel.tbModel.removeRow(0);
      }
      Vector colNames = new Vector();
      Vector row;
      for (int i = 1; i <= colCount; i++) {
        colNames.add(meta.getColumnLabel(i));
      }
      parentPanel.tablePanel.tbModel.setColumnIdentifiers(colNames);
      while (set.next()) {
        row = new Vector();
        for (int i = 1; i <= colCount; i++) {
          String temp = set.getString(i);

//          if(i == 3 || i == 4){//单价和数量取两位小数
          if (i == 5) {
            temp = temp.substring(0, temp.length() - 2);
          }
//
          if (temp.indexOf(" ") >= 0) {
            temp = temp.substring(0, temp.indexOf(" "));
          }
          row.add(temp);
//          System.out.print(set.getString(i)+"   ");
        }
//        System.out.println();
        parentPanel.tablePanel.tbModel.addRow(row);
      } //end while
      if (parentPanel.tablePanel.tbModel.getRowCount() <= 0) {
        kit.beep();
        JOptionPane.showMessageDialog(this, "对不起，没有符合查找条件的记录,请修改数据重新查找！！");
      }
    }
    catch (SQLException ex) {
      System.err.println(e.toString());
      kit.beep();
      JOptionPane.showMessageDialog(this, "查询错误，请检查输入是否正确！！");
    }
    catch (Exception ex2) {
      System.err.println(ex2.toString());
      kit.beep();
      JOptionPane.showMessageDialog(this, "查询错误！！！！");
    }
    validate();
    repaint();
//    System.out.println(sql);
  }

  private Vector getColNames(Connection con) {
    Vector colNames = new Vector();
//    Vector colClasses = new Vector();
    try {
      Statement sta = con.createStatement();
      ResultSet set = sta.executeQuery("select * from " + Type.PRODUCTTABLE);
      ResultSetMetaData metaData = set.getMetaData();
      int colCount = metaData.getColumnCount();
      for (int i = 0; i < colCount; i++) {
        colNames.add(metaData.getColumnLabel(i + 1));
//        colClasses.add(metaData.getColumn());
      }
    }
    catch (Exception e) {
      System.err.print(e.toString());
    }
    return colNames;
  }

  private void clearFilds() {
    param1.setText("");
    param2.setText("");
  }

  public void findByMarque_actionPerformed(ActionEvent e) {
    setFindBy(this.BYMARQUE);
    contentPanel.removeAll();
    contentPanel.add(new JLabel("请输入产品类型："));
    contentPanel.add(param1);
    clearFilds();
    pack();
    validate();
    repaint();
  }
}