Changeset 14312 for greenstone3/trunk/src/java/org/greenstone/gsdl3/util/DerbyWrapper.java

Timestamp:

2007-08-06T11:44:49+12:00 (17 years ago)

Author:

qq6

Message:

updated modify user's info

File:

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

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

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