update query error. HELP

conn = Connect.ConnectDB();
        String sql = "Update [SoapTbl] set [SoapName] ='"+txtNAME.getText()+"', [SoapQty] ='"+txtQUANTITY.getText()+"', [SoapPrice] ='"+txtPRICE.getText()+"', where [SoapID] ='"+txtID.getText()+"";

        try{
            pst = conn.prepareStatement(sql);
            pst.executeUpdate();
            JOptionPane.showMessageDialog(null, "Soap Table has been updated!");
            UpdateSoapTbl();
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, e);
        }