menuinfo.java

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

    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);
  }
}