column15.setColumnName("FOOD");    column15.setDataType(com.borland.dx.dataset.Variant.STRING);    column15.setPrecision(25);    column15.setSchemaName("DBO");    column15.setTableName("SALES");    column15.setServerColumnName("FOOD");    column15.setSqlType(1);    column16.setCaption("數量");    column16.setColumnName("AMOUNT");    column16.setDataType(com.borland.dx.dataset.Variant.INT);    column16.setSchemaName("DBO");    column16.setTableName("SALES");    column16.setServerColumnName("AMOUNT");    column16.setSqlType(4);    column17.setCaption("折扣");    column17.setColumnName("DISCOUNT");    column17.setDataType(com.borland.dx.dataset.Variant.DOUBLE);    column17.setSchemaName("DBO");    column17.setTableName("SALES");    column17.setServerColumnName("DISCOUNT");    column17.setSqlType(6);    column18.setCaption("已付帳");    column18.setColumnName("PAID");    column18.setDataType(com.borland.dx.dataset.Variant.BOOLEAN);    column18.setSchemaName("DBO");    column18.setTableName("SALES");    column18.setServerColumnName("PAID");    column18.setSqlType(-7);    column19.setCaption("消費日期");    column19.setColumnName("CONSUMEDATE");    column19.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);    column19.setSchemaName("DBO");    column19.setTableName("SALES");    column19.setServerColumnName("CONSUMEDATE");    column19.setSqlType(93);    jPanel5.setLayout(borderLayout3);    DBNavToolBar.setVisible(false);    DBNavToolBar.setButtonStateFirst(JdbNavToolBar.AUTO_ENABLED);    DBNavToolBar.setButtonStateInsert(JdbNavToolBar.AUTO_ENABLED);    close.setText("關閉窗口");    close.addActionListener(new MenuInfo_close_actionAdapter(this));    column20.setCaption("備注");    column20.setColumnName("REMARK");    column20.setDataType(com.borland.dx.dataset.Variant.STRING);    column20.setPrecision(255);    column20.setSchemaName("DBO");    column20.setTableName("SALES");    column20.setServerColumnName("REMARK");    column20.setSqlType(1);    queryDataSet1.setColumns(new Column[] {column5, column10, column13, column14, column15, column16, column17, column18, column19, column20});    getContentPane().add(panel1, BorderLayout.NORTH);    panel1.add(jPanel2, BorderLayout.CENTER);    jPanel2.add(jLabel3, null);    jPanel2.add(foodName, null);    jPanel2.add(jLabel4, null);    jPanel2.add(foodAmount, null);    jPanel2.add(jLabel5, null);    jPanel2.add(discount, null);    jPanel2.add(jLabel1, null);    jPanel2.add(remark, null);    jPanel2.add(remark, null);    panel1.add(jPanel3,  BorderLayout.NORTH);    jPanel3.add(jLabel2, null);    panel1.add(jPanel4, BorderLayout.SOUTH);    jPanel4.add(addFood, null);    this.getContentPane().add(jPanel1,  BorderLayout.CENTER);    jPanel1.add(jPanel5,  BorderLayout.CENTER);    jPanel5.add(tableScrollPane1,  BorderLayout.CENTER);    jPanel5.add(DBNavToolBar,  BorderLayout.SOUTH);    tableScrollPane1.getViewport().add(jdbTable1, null);    jPanel1.add(jPanel6,  BorderLayout.SOUTH);    jPanel6.add(close, null);    this.prepareShow();  }  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 name from food order by name");       rs=ps.executeQuery();       while(rs.next()){        foodName.addItem(rs.getString("name"));       }       }       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 addFood_actionPerformed(ActionEvent e) {    Connection conn=null;    PreparedStatement ps=null;    ResultSet rs=null;    try{       String requestedFood=foodName.getSelectedItem().toString();       float curAmount=0;       int action=0;       float requestedAmount=Float.parseFloat(foodAmount.getText());       conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant;user=user;password=user");       //查詢是否有足夠的庫存并作出選擇       ps=conn.prepareStatement("select amount from stockInfo where commodity=?");       ps.setString(1,requestedFood);       rs=ps.executeQuery();       if(rs.next())          curAmount=rs.getFloat("amount");       if(requestedAmount>curAmount)          action=JOptionPane.showConfirmDialog(this,"您選擇的食品只有"+curAmount+"要繼續訂購嗎？","提示",JOptionPane.YES_NO_OPTION);       if(action==1)          return;      //更新庫存      java.sql.Date currentDate=new java.sql.Date(System.currentTimeMillis());      ps=conn.prepareStatement("update stockInfo set amount=?,updateTime=? where commodity=?");      if(curAmount>=requestedAmount)         ps.setFloat(1,curAmount-requestedAmount);      else         ps.setFloat(1,0);      ps.setDate(2,currentDate);      ps.setString(3,requestedFood);      ps.executeUpdate();      //添加銷售信息      ps=conn.prepareStatement("insert into sales(operator,room,customer,tel,food,amount,discount,paid,consumeDate,remark) values(?,?,?,?,?,?,?,?,?,?)");      ps.setString(1,operator);      ps.setString(2,roomNo);      ps.setString(3,customer);      ps.setString(4,tel);      ps.setString(5,requestedFood);      if(curAmount>=requestedAmount)          ps.setFloat(6,requestedAmount);      else          ps.setFloat(6,curAmount);      ps.setFloat(7,Float.parseFloat(discount.getText()));      ps.setBoolean(8,false);      ps.setDate(9,currentDate);      ps.setString(10,remark.getText());      ps.executeUpdate();      //刷新列表顯示      JButton refreshButton=DBNavToolBar.getRefreshButton();      refreshButton.doClick();      }    catch(SQLException ex){      ex.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();  }  QueryDataSet queryDataSet1 = new QueryDataSet();  Column column2 = new Column();  JdbTable jdbTable1 = new JdbTable();  Column column5 = new Column();  Column column10 = new Column();  Column column13 = new Column();  Column column14 = new Column();  Column column15 = new Column();  Column column16 = new Column();  Column column17 = new Column();  Column column18 = new Column();  Column column19 = new Column();  BorderLayout borderLayout3 = new BorderLayout();  JdbNavToolBar DBNavToolBar = new JdbNavToolBar();  JButton close = new JButton();  Column column20 = new Column();  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();  void close_actionPerformed(ActionEvent e) {     this.dispose();  }/*  void delete_actionPerformed(ActionEvent e) {    JButton deleteButton=DBNavToolBar.getDeleteButton();    deleteButton.doClick();    JOptionPane.showConfirmDialog(this,"已成功刪除該酒菜","提示",JOptionPane.PLAIN_MESSAGE);  }*/}class MenuInfo_addFood_actionAdapter implements java.awt.event.ActionListener {  MenuInfo adaptee;  MenuInfo_addFood_actionAdapter(MenuInfo adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.addFood_actionPerformed(e);  }}class MenuInfo_close_actionAdapter implements java.awt.event.ActionListener {  MenuInfo adaptee;  MenuInfo_close_actionAdapter(MenuInfo adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.close_actionPerformed(e);  }}