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 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