Changeset 14335

Timestamp:

2007-08-08T09:23:06+12:00 (17 years ago)

Author:

qq6

Message:

added a method deleteAllUser()

File:

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

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

@@ -130 +130 @@
     return "succeed";
     }
-    
+
+    public boolean deleteAllUser() throws SQLException{
+    conn.setAutoCommit(false);
+    try{
+        state.execute("delete from " + USERS);
+        conn.commit();
+    }catch(Throwable e){
+        System.out.println("exception thrown:");
+        if (e instanceof SQLException){
+        printSQLError((SQLException) e);
+        }else{
+        e.printStackTrace();
+        }
+        closeDatabase();
+        return false;
+    }
+    closeDatabase();    
+    return true;
+    }
+
     public UserQueryResult findUser(String username, String password)throws SQLException{
     UserQueryResult userQueryResult=new UserQueryResult();