querystockresult.java

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

package com.csbook.restaurant;

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;
import com.borland.dbswing.*;
import java.awt.event.*;

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

public class QueryStockResult extends JInternalFrame {
  private String Food;

  public QueryStockResult(String title,String Food) {
    super(title,true);
    this.Food=Food;
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant", "user", "USER", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    column1.setColumnName("curFood");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    parameterRow.setColumns(new Column[] {column1});
    parameterRow.setString("curFood",Food);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT COMMODITYIN.COMMODITY,COMMODITYIN.STOCKNO,COMMODITYIN.OPERATOR,COMMODITYIN.SUPPLIER,COMMODITYI" +
      "N.AMOUNT,COMMODITYIN.PRICE,COMMODITYIN.DISCOUNT,COMMODITYIN.TOTALPRICE,COMMODITYIN.STOCKDATE,COMMODIT" +
      "YIN.REMARK FROM RESTAURANT.DBO.COMMODITYIN WHERE COMMODITYIN.COMMODITY=:curFood", parameterRow, true, Load.ALL));
    column2.setCaption("库存编号");
    column2.setColumnName("stockNo");
    column2.setDataType(com.borland.dx.dataset.Variant.INT);
    column2.setRowId(true);
    column2.setSchemaName("DBO");
    column2.setTableName("COMMODITYIN");
    column2.setServerColumnName("stockNo");
    column2.setSqlType(4);
    column2.setHidden(true);
    column3.setCaption("商品名称");
    column3.setColumnName("COMMODITY");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(25);
    column3.setSchemaName("DBO");
    column3.setTableName("COMMODITYIN");
    column3.setServerColumnName("COMMODITY");
    column3.setSqlType(12);
    column4.setCaption("库存编号");
    column4.setColumnName("STOCKNO1");
    column4.setDataType(com.borland.dx.dataset.Variant.INT);
    column4.setSchemaName("DBO");
    column4.setTableName("COMMODITYIN");
    column4.setServerColumnName("STOCKNO");
    column4.setSqlType(4);
    column5.setCaption("业务员");
    column5.setColumnName("OPERATOR");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(25);
    column5.setSchemaName("DBO");
    column5.setTableName("COMMODITYIN");
    column5.setServerColumnName("OPERATOR");
    column5.setSqlType(12);
    column6.setCaption("供应商");
    column6.setColumnName("SUPPLIER");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(25);
    column6.setSchemaName("DBO");
    column6.setTableName("COMMODITYIN");
    column6.setServerColumnName("SUPPLIER");
    column6.setSqlType(12);
    column7.setCaption("数量");
    column7.setColumnName("AMOUNT");
    column7.setDataType(com.borland.dx.dataset.Variant.INT);
    column7.setSchemaName("DBO");
    column7.setTableName("COMMODITYIN");
    column7.setServerColumnName("AMOUNT");
    column7.setSqlType(4);
    column8.setCaption("单价");
    column8.setColumnName("PRICE");
    column8.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column8.setSchemaName("DBO");
    column8.setTableName("COMMODITYIN");
    column8.setServerColumnName("PRICE");
    column8.setSqlType(6);
    column9.setCaption("折扣");
    column9.setColumnName("DISCOUNT");
    column9.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column9.setSchemaName("DBO");
    column9.setTableName("COMMODITYIN");
    column9.setServerColumnName("DISCOUNT");
    column9.setSqlType(6);
    column10.setCaption("总金额");
    column10.setColumnName("TOTALPRICE");
    column10.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column10.setSchemaName("DBO");
    column10.setTableName("COMMODITYIN");
    column10.setServerColumnName("TOTALPRICE");
    column10.setSqlType(6);
    column11.setCaption("进货日期");
    column11.setColumnName("STOCKDATE");
    column11.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column11.setSchemaName("DBO");
    column11.setTableName("COMMODITYIN");
    column11.setServerColumnName("STOCKDATE");
    column11.setSqlType(93);
    column12.setCaption("备注");
    column12.setColumnName("REMARK");
    column12.setDataType(com.borland.dx.dataset.Variant.STRING);
    column12.setPrecision(255);
    column12.setSchemaName("DBO");
    column12.setTableName("COMMODITYIN");
    column12.setServerColumnName("REMARK");
    column12.setSqlType(12);
    queryDataSet1.setColumns(new Column[] {column2, column3, column4, column5, column6, column7, column8, column9, column10, column11, column12});
    close.setText("关闭");
    close.addActionListener(new QueryStockResult_close_actionAdapter(this));
    close.addActionListener(new QueryStockResult_close_actionAdapter(this));
    jdbTable1.setDataSet(queryDataSet1);
    jPanel2.setLayout(borderLayout1);
    title.setText("入库单列表");
    stockTotal.setBackground(Color.lightGray);
    stockTotal.setEnabled(true);
    stockTotal.setEditable(false);
    this.getContentPane().add(jPanel1, BorderLayout.NORTH);
    jPanel1.add(title, null);
    this.getContentPane().add(jPanel2, BorderLayout.CENTER);
    jPanel2.add(tableScrollPane1,  BorderLayout.CENTER);
    jPanel2.add(stockTotal,  BorderLayout.SOUTH);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    this.getContentPane().add(jPanel3, BorderLayout.SOUTH);
    jPanel3.add(close, null);
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    this.showTotalInfo();
  }
  Database database1 = new Database();
  ParameterRow parameterRow = new ParameterRow();
  Column column1 = new Column();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  Column column8 = new Column();
  Column column9 = new Column();
  Column column10 = new Column();
  Column column11 = new Column();
  Column column12 = new Column();
  JPanel jPanel1 = new JPanel();
  JLabel title = new JLabel();
  JPanel jPanel2 = new JPanel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JButton close = new JButton();
  JPanel jPanel3 = new JPanel();
  JdbTable jdbTable1 = new JdbTable();
  BorderLayout borderLayout1 = new BorderLayout();
  JTextField stockTotal = new JTextField();
  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
  void close_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  private void showTotalInfo()
  {
    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 stockInfo.amount,food.unit from stockInfo,food where stockInfo.commodity=food.name and stockInfo.commodity=?");
     ps.setString(1,this.Food);
     rs=ps.executeQuery();
     String totalInfo;
     if(rs.next())
        totalInfo="仓库中还存有"+rs.getFloat("amount")+rs.getString("unit")+this.Food;
     else
        totalInfo="仓库中没有"+this.Food+"的存货";
     stockTotal.setText(totalInfo);
    }
    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){}
   }
  }
}

class QueryStockResult_close_actionAdapter implements java.awt.event.ActionListener {
  QueryStockResult adaptee;

  QueryStockResult_close_actionAdapter(QueryStockResult adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.close_actionPerformed(e);
  }
}