foodconfiguration.java~4~

实现了一个简单的餐饮行业进销存系统

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 FoodConfiguration extends JInternalFrame {
  JPanel panel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  Column column2 = new Column();
  Column column4 = new Column();
  Column column6 = new Column();
  Column column8 = new Column();
  JPanel jPanel2 = new JPanel();
  JComboBox producer = new JComboBox();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JTextField producePlace = new JTextField();
  JTextField foodName = new JTextField();
  JTextField foodUnit = new JTextField();
  JComboBox foodType = new JComboBox();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JTextField note = new JTextField();
  JTextField retailPrice = new JTextField();
  JPanel jPanel1 = new JPanel();
  GridLayout gridLayout1 = new GridLayout(4,4);
  JLabel jLabel2 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JTextField price = new JTextField();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel5 = new JLabel();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JLabel jLabel10 = new JLabel();
  JButton deleteFood = new JButton();
  JButton addFood = new JButton();
  JPanel jPanel5 = new JPanel();
  JButton close = new JButton();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  Column column3 = new Column();
  Column column5 = new Column();
  Column column7 = new Column();
  Column column9 = new Column();
  Column column10 = new Column();
  Column column11 = new Column();
  Column column12 = new Column();
  JdbTable jdbTable1 = new JdbTable();
  JdbNavToolBar DBNavToolBar = new JdbNavToolBar();
  JButton modify = new JButton();

  public FoodConfiguration(String title,boolean resizable,boolean closable,boolean maximizable,boolean iconifiable) {
    super(title,resizable,closable,maximizable,iconifiable);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    panel1.setLayout(borderLayout1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant", "user", "user", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    column2.setCaption("食品名称");
    column2.setColumnName("name");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(30);
    column2.setSchemaName("dbo");
    column2.setTableName("food");
    column2.setWidth(10);
    column2.setServerColumnName("name");
    column2.setSqlType(1);
    column4.setCaption("单位");
    column4.setColumnName("unit");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(8);
    column4.setSchemaName("dbo");
    column4.setTableName("food");
    column4.setWidth(5);
    column4.setServerColumnName("unit");
    column4.setSqlType(1);
    column6.setCaption("批发价");
    column6.setColumnName("price");
    column6.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column6.setSchemaName("dbo");
    column6.setTableName("food");
    column6.setWidth(8);
    column6.setServerColumnName("price");
    column6.setSqlType(6);
    column8.setCaption("生产厂商");
    column8.setColumnName("producer");
    column8.setDataType(com.borland.dx.dataset.Variant.STRING);
    column8.setPrecision(30);
    column8.setSchemaName("dbo");
    column8.setTableName("food");
    column8.setServerColumnName("producer");
    column8.setSqlType(1);
    jLabel8.setText("酒菜名称：");
    jLabel4.setText("批发价：");
    producePlace.setText("");
    foodName.setText("");
    foodUnit.setText("");
    jLabel3.setText("零售价：");
    jLabel7.setText("生产地点：");
    note.setText("");
    retailPrice.setText("");
    jPanel1.setLayout(gridLayout1);
    jLabel2.setText("生产厂商：");
    jLabel6.setText("酒菜类型：");
    price.setText("");
    jLabel9.setText("备注");
    jLabel5.setText("单位：");
    jPanel2.setLayout(borderLayout2);
    jLabel10.setText("酒菜设置");
    deleteFood.setActionCommand("删除食品");
    deleteFood.setText("删除食品");
    deleteFood.addActionListener(new FoodConfiguration_deleteFood_actionAdapter(this));
    addFood.setText("增加食品");
    addFood.addActionListener(new FoodConfiguration_addFood_actionAdapter(this));
    close.setText("关闭窗口");
    close.addActionListener(new FoodConfiguration_close_actionAdapter(this));
    queryDataSet1.setColumns(new Column[] {column8, column6, column4, column2});
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT food.name,food.proPlace,food.unit,food.foodType,food.price,food.retailPrice,food.producer,food" +
      ".remark FROM Restaurant.dbo.food", null, true, Load.ALL));
    column1.setCaption("酒菜名称");
    column1.setColumnName("name");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(30);
    column1.setRowId(true);
    column1.setSchemaName("dbo");
    column1.setTableName("food");
    column1.setWidth(10);
    column1.setServerColumnName("name");
    column1.setSqlType(1);
    column3.setCaption("生产地");
    column3.setColumnName("proPlace");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(30);
    column3.setSchemaName("dbo");
    column3.setTableName("food");
    column3.setWidth(10);
    column3.setServerColumnName("proPlace");
    column3.setSqlType(1);
    column5.setCaption("单位");
    column5.setColumnName("unit");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(8);
    column5.setSchemaName("dbo");
    column5.setTableName("food");
    column5.setWidth(5);
    column5.setServerColumnName("unit");
    column5.setSqlType(1);
    column7.setCaption("酒菜类型");
    column7.setColumnName("foodType");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(30);
    column7.setSchemaName("dbo");
    column7.setTableName("food");
    column7.setWidth(8);
    column7.setServerColumnName("foodType");
    column7.setSqlType(1);
    column9.setCaption("单价");
    column9.setColumnName("price");
    column9.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column9.setSchemaName("dbo");
    column9.setTableName("food");
    column9.setWidth(8);
    column9.setServerColumnName("price");
    column9.setSqlType(6);
    column10.setCaption("零售价");
    column10.setColumnName("retailPrice");
    column10.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column10.setSchemaName("dbo");
    column10.setTableName("food");
    column10.setWidth(8);
    column10.setServerColumnName("retailPrice");
    column10.setSqlType(6);
    column11.setCaption("生产者");
    column11.setColumnName("producer");
    column11.setDataType(com.borland.dx.dataset.Variant.STRING);
    column11.setPrecision(30);
    column11.setSchemaName("dbo");
    column11.setTableName("food");
    column11.setWidth(10);
    column11.setServerColumnName("producer");
    column11.setSqlType(1);
    column12.setCaption("备注");
    column12.setColumnName("remark");
    column12.setDataType(com.borland.dx.dataset.Variant.STRING);
    column12.setPrecision(255);
    column12.setSchemaName("dbo");
    column12.setTableName("food");
    column12.setWidth(12);
    column12.setServerColumnName("remark");
    column12.setSqlType(1);
    queryDataSet1.setColumns(new Column[] {column1, column3, column5, column7, column9, column10, column11, column12});
    jdbTable1.setDataSet(queryDataSet1);
    DBNavToolBar.setVisible(false);
    modify.setText("提交修改信息");