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);
      //  frm.updateTree(tmpe.get(1),tmpe.get(2).toString(),3);//更新樹
      txtkucun.setText("0");
        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);
  }
}