querybyoperator.java

以一个酒店的进销存系统为例

package com.csbook.restaurant;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author pengtao
 * @version 1.0
 */

public class QueryByOperator extends JInternalFrame {
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JComboBox operator = new JComboBox();
  GridLayout gridLayout1 = new GridLayout(1,4);
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JPanel jPanel4 = new JPanel();
  JPanel jPanel5 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JCheckBox byTime = new JCheckBox();
  GridLayout gridLayout2 = new GridLayout();
  JLabel jLabel8 = new JLabel();
  JTextField endYear = new JTextField();
  JTextField startDay = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField startYear = new JTextField();
  JTextField endMonth = new JTextField();
  JTextField startMonth = new JTextField();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JTextField endDay = new JTextField();
  JLabel jLabel5 = new JLabel();
  GridLayout gridLayout3 = new GridLayout(2,7);
  JButton cancel = new JButton();
  JButton ok = new JButton();
  JDesktopPane desktop;

  public QueryByOperator(String title,boolean resizable,boolean closable,boolean maximizable,boolean iconifiable,JDesktopPane desktop) {
    super(title,resizable,closable,maximizable,iconifiable);
    this.desktop=desktop;
    try {
      jbInit();
      pack();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    jLabel1.setText("业务员：");
    jPanel1.setLayout(gridLayout1);
    jLabel2.setText("");
    jLabel3.setText("");
    jPanel2.setLayout(borderLayout1);
    byTime.setText("按时间查询");
    byTime.addActionListener(new QueryByOperator_byTime_actionAdapter(this));
    jPanel5.setLayout(gridLayout2);
    jLabel8.setText("结束时间:");
    endYear.setEditable(false);
    endYear.setText("");
    startDay.setEditable(false);
    startDay.setText("");
    jLabel4.setText("起始时间:");
    startYear.setEditable(false);
    startYear.setText("");
    endMonth.setEditable(false);
    endMonth.setText("");
    startMonth.setEditable(false);
    startMonth.setText("");
    jLabel6.setText("月");
    jLabel11.setHorizontalTextPosition(SwingConstants.CENTER);
    jLabel11.setText("年");
    jLabel7.setText("年");
    jLabel9.setText("日");
    jLabel10.setText("月");
    endDay.setEditable(false);
    endDay.setText("");
    endDay.setEditable(false);
    endDay.setText("");
    jLabel5.setText("日");
    jPanel4.setLayout(gridLayout3);
    cancel.setText("取消");
    cancel.addActionListener(new QueryByOperator_cancel_actionAdapter(this));
    ok.setText("确定");
    ok.addActionListener(new QueryByOperator_ok_actionAdapter(this));
    this.getContentPane().add(jPanel1,  BorderLayout.NORTH);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jLabel1, null);
    jPanel1.add(operator, null);
    jPanel1.add(jLabel3, null);
    this.getContentPane().add(jPanel2,  BorderLayout.CENTER);
    this.getContentPane().add(jPanel3, BorderLayout.SOUTH);
    jPanel3.add(ok, null);
    jPanel3.add(cancel, null);
    jPanel2.add(jPanel5, BorderLayout.NORTH);
    jPanel5.add(byTime, null);
    jPanel2.add(jPanel4, BorderLayout.CENTER);
    jPanel4.add(jLabel4, null);
    jPanel4.add(startYear, null);
    jPanel4.add(jLabel11, null);
    jPanel4.add(startMonth, null);
    jPanel4.add(jLabel6, null);
    jPanel4.add(startDay, null);
    jPanel4.add(jLabel9, null);
    jPanel4.add(jLabel8, null);
    jPanel4.add(endYear, null);
    jPanel4.add(jLabel7, null);
    jPanel4.add(endMonth, null);
    jPanel4.add(jLabel10, null);
    jPanel4.add(endDay, null);
    jPanel4.add(jLabel5, null);
    this.prepareShow();
  }

  void byTime_actionPerformed(ActionEvent e) {
    if(byTime.isSelected()){
            this.startYear.setEditable(true);
            this.startMonth.setEditable(true);
            this.startDay.setEditable(true);
            this.endYear.setEditable(true);
            this.endMonth.setEditable(true);
            this.endDay.setEditable(true);
          }
    else{
             this.startYear.setEditable(false);
             this.startMonth.setEditable(false);
             this.startDay.setEditable(false);
             this.endYear.setEditable(false);
             this.endMonth.setEditable(false);
             this.endDay.setEditable(false);
        }
  }

  void ok_actionPerformed(ActionEvent e) {
    String startDate;
    String endDate;
    if(byTime.isSelected()){
              int startY = Integer.parseInt(startYear.getText());
              int startM = Integer.parseInt(startMonth.getText());
              int startD = Integer.parseInt(startDay.getText());
              int endY = Integer.parseInt(endYear.getText());
              int endM = Integer.parseInt(endMonth.getText());
              int endD = Integer.parseInt(endDay.getText());
              startDate = startY + "-" + startM + "-" + startD;
              endDate = endY + "-" + endM + "-" + endD;
    }
    else{
              startDate = "1980-12-12";
              endDate = "2100-12-12";
    }
    QueryByOperatorResult dlg = new QueryByOperatorResult("查询结果",operator.getSelectedItem().toString(),startDate,endDate);
    dlg.setVisible(true);
    desktop.add(dlg);
    try {
            dlg.setSelected(true);
        }
   catch (java.beans.PropertyVetoException ex) {}
  }

  private void prepareShow(){
 Connection conn=null;
 PreparedStatement ps=null;
 ResultSet rs=null;
 try{
 conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant;user=user;password=user");
 ps=conn.prepareStatement("select id from operator");
 rs=ps.executeQuery();
 while(rs.next()){
  operator.addItem(rs.getString("id"));
 }
 }
 catch(SQLException e){
 e.printStackTrace();
 }
 finally{
 if(rs!=null)try{rs.close();}catch(SQLException ignore){}
 if(ps!=null)try{ps.close();}catch(SQLException ignore){}
 if(conn!=null)try{conn.close();}catch(SQLException ignore){}
 }
 }

  void cancel_actionPerformed(ActionEvent e) {
  this.dispose();
  }

}

class QueryByOperator_byTime_actionAdapter implements java.awt.event.ActionListener {
  QueryByOperator adaptee;

  QueryByOperator_byTime_actionAdapter(QueryByOperator adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.byTime_actionPerformed(e);
  }
}

class QueryByOperator_ok_actionAdapter implements java.awt.event.ActionListener {
  QueryByOperator adaptee;

  QueryByOperator_ok_actionAdapter(QueryByOperator adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.ok_actionPerformed(e);
  }
}

class QueryByOperator_cancel_actionAdapter implements java.awt.event.ActionListener {
  QueryByOperator adaptee;

  QueryByOperator_cancel_actionAdapter(QueryByOperator adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.cancel_actionPerformed(e);
  }
}