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 QueryStockInfor extends JInternalFrame {  JPanel jPanel1 = new JPanel();  JPanel jPanel2 = new JPanel();  JLabel jLabel1 = new JLabel();  JComboBox foodName = new JComboBox();  GridLayout gridLayout1 = new GridLayout(1,4);  JLabel jLabel2 = new JLabel();  JLabel jLabel3 = new JLabel();  JButton cancel = new JButton();  JButton ok = new JButton();  JDesktopPane desktop;  public QueryStockInfor(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("");    cancel.setText("取消");    cancel.addActionListener(new QueryStockInfor_cancel_actionAdapter(this));    ok.setText("確定");    ok.addActionListener(new QueryStockInfor_ok_actionAdapter(this));    this.getContentPane().add(jPanel1,  BorderLayout.NORTH);    jPanel1.add(jLabel2, null);    jPanel1.add(jLabel1, null);    jPanel1.add(foodName, null);    jPanel1.add(jLabel3, null);    this.getContentPane().add(jPanel2,  BorderLayout.SOUTH);    jPanel2.add(ok, null);    jPanel2.add(cancel, null);    this.prepareShow();  }  void cancel_actionPerformed(ActionEvent e) {     this.dispose();  }  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 distinct commodity from commodityIn");      rs=ps.executeQuery();      while(rs.next()){        foodName.addItem(rs.getString("commodity"));      }    }    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 ok_actionPerformed(ActionEvent e) {       QueryStockResult dlg = new QueryStockResult("查詢結(jié)果",this.foodName.getSelectedItem().toString());       dlg.setVisible(true);       desktop.add(dlg);       try {           dlg.setSelected(true);       } catch (java.beans.PropertyVetoException ex) {}  }}class QueryStockInfor_cancel_actionAdapter implements java.awt.event.ActionListener {  QueryStockInfor adaptee;  QueryStockInfor_cancel_actionAdapter(QueryStockInfor adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.cancel_actionPerformed(e);  }}class QueryStockInfor_ok_actionAdapter implements java.awt.event.ActionListener {  QueryStockInfor adaptee;  QueryStockInfor_ok_actionAdapter(QueryStockInfor adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.ok_actionPerformed(e);  }}