Changeset 14341

Timestamp:

2007-08-08T15:06:50+12:00 (17 years ago)

Author:

qq6

Message:

fixed modifyUserInfo()

File:

• greenstone3/trunk/src/java/org/greenstone/gsdl3/util/DerbyWrapper.java (modified) (1 diff)

greenstone3/trunk/src/java/org/greenstone/gsdl3/util/DerbyWrapper.java

@@ -198 +198 @@
     String sql_modify_user_info="update " + USERS +" set ";
     if (new_password!=null && !new_password.equals("")){
-        sql_modify_user_info += "password='" + new_password +"', ";
-    }
-    
-    sql_modify_user_info += "groups='" + groups + "'" + ", accountstatus='" + accountstatus + "'" + ", comment='" + comment + "'" + " where username='" + username+"'";
+        sql_modify_user_info += "password='" + new_password +"'";
+    }
+
+    if (groups!=null && accountstatus!=null && comment!=null){
+    sql_modify_user_info += ", groups='" + groups + "'" + ", accountstatus='" + accountstatus + "'" + ", comment='" + comment + "'";
+    }
+    sql_modify_user_info +=" where username='" + username+"'";
+    
     try{
         System.out.println(sql_modify_user_info);