update.java

基于java+sql2000超市货品进销存管理

  }

  public void btngengai_actionPerformed(ActionEvent e) { //修改
    //验证
    if (txtkucun.getText().trim().equals("") ||
        txtprice.getText().trim().equals("") ||
        txtdanwei.getText().trim().equals("") ||
        txtid.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "信息输入不完整，请认真核实!", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    if (cmbleibie.getSelectedItem().equals("商品类别")) { //判断类别是否被选种
      JOptionPane.showMessageDialog(null, "请选择商品类别", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    Link lk = new Link();
    lk.connection();
    String sql = "update shopping set kindname='" +

        cmbleibie.getSelectedItem().toString() +
        "',name='" + txtname.getText() + "',price=" + txtprice.getText() +
        ",total=" + txtkucun.getText() + ",abate=" + txtzhekou.getText() +
        ",danwei='" + txtdanwei.getText().trim() + "',beizhu='" +
        taxbeizhu.getText() + "' where id='" + txtid.getText() +
        "'";

    //此方法返回0则为确认,1则为取消
    if (JOptionPane.showConfirmDialog(null, "确认修改?", "确认",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      int count = lk.Update(sql);
      if (count > 0) {
        JOptionPane.showMessageDialog(null, "更新成功!", "成功",
                                      JOptionPane.INFORMATION_MESSAGE);

        lk.close();
         //当哪一行被选中后取出表中这个列的所有值
          Vector tmpe = (Vector) vt.get(count);
        this.dispose();
      }
      //关闭对话框
    }
    else {
      lk.close();
      return;
    }
  }

  public void cmbleibie_actionPerformed(ActionEvent e) {

  }

  public void txtprice_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btngengai_actionPerformed(null);
    }
  }

  public void txtkucun_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btngengai_actionPerformed(null);
    }
  }

  public void txtdanwei_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btngengai_actionPerformed(null);
    }
  }

  public void txtzhekou_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btngengai_actionPerformed(null);
    }
  }

  public void taxbeizhu_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btngengai_actionPerformed(null);
    }
  }

  public void cmbleibie_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btngengai_actionPerformed(null);
    }
  }

  //  public void cmbname_mouseReleased(MouseEvent e) {
//    String leibie = (String) cmbleibie.getSelectedItem();
//        if (cmbleibie.getSelectedItem().equals("商品类别")) {
//          JOptionPane.showMessageDialog(null, "请选择商品类别", "错误",
//                                        JOptionPane.ERROR_MESSAGE);
//          return;
//        }
//        Link lk = new Link();
//        lk.connection();
//        String sql = "select name form shopping where kindname='" + leibie + "'";
//        ResultSet rs = lk.Select(sql);
//        cmbname.addItem("商品名");
//        cmbleibie.removeAllItems();
//
//        try {
//          if (rs != null) {
//            while (rs.next()) {
//              cmbname.addItem(rs.getString(1));
//            }
//          }
//          else {
//            JOptionPane.showMessageDialog(null, "没有该类商品", "提示",
//                                          JOptionPane.INFORMATION_MESSAGE);
//          }
//          rs.close();
//        }
//        catch (SQLException ex) {
//        }
//    lk.close();
//  }

}

class Update_taxbeizhu_keyAdapter
    extends KeyAdapter {
  private Update adaptee;
  Update_taxbeizhu_keyAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.taxbeizhu_keyPressed(e);
  }
}

class Update_txtzhekou_keyAdapter
    extends KeyAdapter {
  private Update adaptee;
  Update_txtzhekou_keyAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtzhekou_keyPressed(e);
  }
}

class Update_txtdanwei_keyAdapter
    extends KeyAdapter {
  private Update adaptee;
  Update_txtdanwei_keyAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtdanwei_keyPressed(e);
  }
}

class Update_txtkucun_keyAdapter
    extends KeyAdapter {
  private Update adaptee;
  Update_txtkucun_keyAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtkucun_keyPressed(e);
  }
}

class Update_cmbleibie_actionAdapter
    implements ActionListener {
  private Update adaptee;
  Update_cmbleibie_actionAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.cmbleibie_actionPerformed(e);
  }
}

class Update_cmbleibie_keyAdapter
    extends KeyAdapter {
  private Update adaptee;
  Update_cmbleibie_keyAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.cmbleibie_keyPressed(e);
  }
}

class Update_cmbleibie_mouseAdapter
    extends MouseAdapter {
  private Update adaptee;
  Update_cmbleibie_mouseAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }
}

class Update_btnhuanhui_actionAdapter
    implements ActionListener {
  private Update adaptee;
  Update_btnhuanhui_actionAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnhuanhui_actionPerformed(e);
  }
}

class Update_btngengai_actionAdapter
    implements ActionListener {
  private Update adaptee;
  Update_btngengai_actionAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btngengai_actionPerformed(e);
  }
}

class Update_txtprice_keyAdapter
    extends KeyAdapter {
  private Update adaptee;
  Update_txtprice_keyAdapter(Update adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {

    adaptee.txtprice_keyPressed(e);
  }
}