-/*\r
- * Copyright (C) 2001, 2002 The Mir-coders group\r
- *\r
- * This file is part of Mir.\r
- *\r
- * Mir is free software; you can redistribute it and/or modify\r
- * it under the terms of the GNU General Public License as published by\r
- * the Free Software Foundation; either version 2 of the License, or\r
- * (at your option) any later version.\r
- *\r
- * Mir is distributed in the hope that it will be useful,\r
- * but WITHOUT ANY WARRANTY; without even the implied warranty of\r
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\r
- * GNU General Public License for more details.\r
- *\r
- * You should have received a copy of the GNU General Public License\r
- * along with Mir; if not, write to the Free Software\r
- * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA\r
- *\r
- * In addition, as a special exception, The Mir-coders gives permission to link\r
- * the code of this program with the com.oreilly.servlet library, any library\r
- * licensed under the Apache Software License, The Sun (tm) Java Advanced\r
- * Imaging library (JAI), The Sun JIMI library (or with modified versions of\r
- * the above that use the same license as the above), and distribute linked\r
- * combinations including the two. You must obey the GNU General Public\r
- * License in all respects for all of the code used other than the above\r
- * mentioned libraries. If you modify this file, you may extend this exception\r
- * to your version of the file, but you are not obligated to do so. If you do\r
- * not wish to do so, delete this exception statement from your version.\r
- */\r
-\r
-package mircoders.storage;\r
-\r
-import java.sql.Connection;\r
-import java.sql.SQLException;\r
-import java.sql.Statement;\r
-\r
-import mir.log.LoggerWrapper;\r
-import mir.storage.Database;\r
-import mir.storage.StorageObject;\r
-import mir.storage.StorageObjectFailure;\r
-import freemarker.template.SimpleList;\r
-\r
-/**\r
- * <b>This class implements the access to the comment-table for the\r
- * media table.\r
- *\r
- *\r
- */\r
-\r
-public class DatabaseComment extends Database implements StorageObject{\r
-\r
- private static DatabaseComment instance;\r
-\r
- // the following *has* to be sychronized cause this static method\r
- // could get preemted and we could end up with 2 instances of DatabaseFoo..\r
- // see the "Singletons with needles and thread" article at JavaWorld -mh\r
- public synchronized static DatabaseComment getInstance() throws\r
- StorageObjectFailure {\r
- if (instance == null) {\r
- instance = new DatabaseComment();\r
- instance.myselfDatabase = instance;\r
- }\r
- return instance;\r
- }\r
-\r
- private DatabaseComment() throws StorageObjectFailure {\r
- super();\r
- hasTimestamp = false;\r
- theTable = "comment";\r
- logger = new LoggerWrapper("Database.Comment");\r
-\r
- try {\r
- this.theEntityClass = Class.forName("mircoders.entity.EntityComment");\r
- }\r
- catch (Exception e) {\r
- throw new StorageObjectFailure(e);\r
- }\r
- }\r
-\r
- public SimpleList getPopupData() throws StorageObjectFailure {\r
- return getPopupData("title", true);\r
- }\r
-\r
- public boolean deleteByContentId(String id) throws StorageObjectFailure {\r
- Statement stmt = null;\r
- Connection con = null;\r
- String sql;\r
- int res = 0;\r
-\r
- /** @todo comments and topics should be deleted */\r
- sql = "delete from " + theTable + " where to_media=" + id;\r
- logger.info("DELETE "+ sql);\r
-\r
- try {\r
- con = getPooledCon();\r
- stmt = con.createStatement();\r
- res = stmt.executeUpdate(sql);\r
- }\r
- catch (SQLException sqe) {\r
- new StorageObjectFailure(sqe);\r
- return false;\r
- }\r
- finally {\r
- freeConnection(con, stmt);\r
- }\r
- return true;\r
- }\r
-}\r
+/*
+ * 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.
+ */
+
+package mircoders.storage;
+
+import java.sql.Connection;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import mir.log.LoggerWrapper;
+import mir.storage.Database;
+import mir.storage.DatabaseFailure;
+
+public class DatabaseComment extends Database {
+
+ private static DatabaseComment instance;
+
+ public synchronized static DatabaseComment getInstance() {
+ if (instance == null) {
+ instance = new DatabaseComment();
+ }
+ return instance;
+ }
+
+ private DatabaseComment() {
+ super();
+ mainTable = "comment";
+ logger = new LoggerWrapper("Database.Comment");
+
+ entityClass = mircoders.entity.EntityComment.class;
+ }
+
+ public boolean deleteByContentId(String id) throws DatabaseFailure {
+ Statement stmt = null;
+ Connection con = null;
+ String sql;
+
+ /** todo comments and topics should be deleted */
+ sql = "delete from " + mainTable + " where to_media=" + id;
+ logger.info("DELETE "+ sql);
+
+ try {
+ con = obtainConnection();
+ stmt = con.createStatement();
+ stmt.executeUpdate(sql);
+ }
+ catch (SQLException sqe) {
+ new DatabaseFailure(sqe);
+ return false;
+ }
+ finally {
+ freeConnection(con, stmt);
+ }
+ return true;
+ }
+}