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);
        this.dispose();
      }
      //關閉對話框
    }
    else {
      lk.close();
      return;
    }
  }

//  public void jComboBox1_actionPerformed(ActionEvent e) { //商品名
//    String leibie = (String) cmbleibie.getSelectedItem();
//    if (cmbleibie.getSelectedItem().equals("商品類別") ||
//        cmbleibie.getSelectedItem().equals("")) {
//      JOptionPane.showMessageDialog(null, "請選擇商品類別", "錯誤",
//                                    JOptionPane.ERROR_MESSAGE);
//      return;
//    }
//    Link lk = new Link();
//    lk.connection();
//    String sql = "select name from shopping where kindname='" + leibie + "'";
//    ResultSet rs = lk.Select(sql);
//
//    cmbleibie.removeAllItems();
////    cmbname.r
//    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();
//  }

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