rebuilding head

[mir.git] / source / mircoders / storage / DatabaseComment.java

diff --git a/source/mircoders/storage/DatabaseComment.java b/source/mircoders/storage/DatabaseComment.java
index 25ada19..400b3fa 100755 (executable)
--- a/source/mircoders/storage/DatabaseComment.java
+++ b/source/mircoders/storage/DatabaseComment.java
@@ -1,15 +1,43 @@
-package mircoders.storage;
+/*
+ * Copyright (C) 2001, 2002 The Mir-coders group
+ *
+ * This file is part of Mir.
+ *
+ * Mir is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * Mir is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with Mir; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+ *
+ * In addition, as a special exception, The Mir-coders gives permission to link
+ * the code of this program with  any library licensed under the Apache Software License,
+ * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library
+ * (or with modified versions of the above that use the same license as the above),
+ * and distribute linked combinations including the two.  You must obey the
+ * GNU General Public License in all respects for all of the code used other than
+ * the above mentioned libraries.  If you modify this file, you may extend this
+ * exception to your version of the file, but you are not obligated to do so.
+ * If you do not wish to do so, delete this exception statement from your version.
+ */
 
-import java.lang.*;
-import java.sql.*;
-import java.io.*;
-import java.util.*;
+package mircoders.storage;
 
-import freemarker.template.*;
+import java.sql.Connection;
+import java.sql.SQLException;
+import java.sql.Statement;
 
-import mir.storage.*;
-import mir.entity.*;
-import mir.misc.*;
+import mir.log.LoggerWrapper;
+import mir.storage.Database;
+import mir.storage.StorageObject;
+import mir.storage.StorageObjectFailure;
 
 /**
  * <b>This class implements the access to the comment-table for the
@@ -20,51 +48,45 @@ import mir.misc.*;
 
 public class DatabaseComment extends Database implements StorageObject{
 
-       private static DatabaseComment instance;
+  private static DatabaseComment instance;
 
-       public static DatabaseComment getInstance() throws StorageObjectException {
-               if (instance == null) {
-                       instance = new DatabaseComment();
-                       instance.myselfDatabase = instance;
-               }
-               return instance;
-       }
+  public synchronized static DatabaseComment getInstance() {
+    if (instance == null) {
+      instance = new DatabaseComment();
+    }
+    return instance;
+  }
 
-       private DatabaseComment() throws StorageObjectException
-       {
-               super();
-               this.hasTimestamp = false;
-               this.cache = new HashMap();
-               this.theTable="comment";
-               try {
-                       this.theEntityClass = Class.forName("mircoders.entity.EntityComment");
-               }
-               catch (Exception e) { throw new StorageObjectException(e.toString());   }
-       }
+  private DatabaseComment() {
+    super();
+    hasTimestamp = false;
+    mainTable = "comment";
+    logger = new LoggerWrapper("Database.Comment");
 
-       public SimpleList getPopupData() { return getPopupData("title",true); }
+    this.theEntityClass = mircoders.entity.EntityComment.class;
+  }
 
-       public boolean deleteByContentId(String id)
-               throws StorageObjectException {
-               Statement   stmt=null;
-               Connection  con=null;
-               String      sql;
-               int         res = 0;
+  public boolean deleteByContentId(String id) throws StorageObjectFailure {
+    Statement stmt = null;
+    Connection con = null;
+    String sql;
 
-               /** @todo comments and topics should be deleted */
-               sql = "delete from "+ theTable + " where to_media="+id;
-               //theLog.printInfo("DELETE "+ sql);
+    /** todo comments and topics should be deleted */
+    sql = "delete from " + mainTable + " where to_media=" + id;
+    logger.info("DELETE "+ sql);
 
-               try {
-                       con=getPooledCon();
-                       stmt = con.createStatement();
-                       res = stmt.executeUpdate(sql);
-               }       catch (SQLException sqe) {
-                       new StorageObjectException(sqe.toString());
-                       return false;
-               } finally {
-                       freeConnection(con,stmt);
-               }
-               return true;
-       }
+    try {
+      con = obtainConnection();
+      stmt = con.createStatement();
+      stmt.executeUpdate(sql);
+    }
+    catch (SQLException sqe) {
+      new StorageObjectFailure(sqe);
+      return false;
+    }
+    finally {
+      freeConnection(con, stmt);
+    }
+    return true;
+  }
 }