2 * Copyright (C) 2001, 2002 The Mir-coders group
\r
4 * This file is part of Mir.
\r
6 * Mir is free software; you can redistribute it and/or modify
\r
7 * it under the terms of the GNU General Public License as published by
\r
8 * the Free Software Foundation; either version 2 of the License, or
\r
9 * (at your option) any later version.
\r
11 * Mir is distributed in the hope that it will be useful,
\r
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
\r
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
\r
14 * GNU General Public License for more details.
\r
16 * You should have received a copy of the GNU General Public License
\r
17 * along with Mir; if not, write to the Free Software
\r
18 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
\r
20 * In addition, as a special exception, The Mir-coders gives permission to link
\r
21 * the code of this program with the com.oreilly.servlet library, any library
\r
22 * licensed under the Apache Software License, The Sun (tm) Java Advanced
\r
23 * Imaging library (JAI), The Sun JIMI library (or with modified versions of
\r
24 * the above that use the same license as the above), and distribute linked
\r
25 * combinations including the two. You must obey the GNU General Public
\r
26 * License in all respects for all of the code used other than the above
\r
27 * mentioned libraries. If you modify this file, you may extend this exception
\r
28 * to your version of the file, but you are not obligated to do so. If you do
\r
29 * not wish to do so, delete this exception statement from your version.
\r
32 package mircoders.storage;
\r
38 import freemarker.template.*;
\r
39 import mir.storage.*;
\r
40 import mir.entity.*;
\r
46 * <b>Diese Klasse implementiert die Datenbankverbindung zur MetaObjekt-Tabelle
\r
50 public class DatabaseLinksImcs extends Database
\r
51 implements StorageObject {
\r
52 private static DatabaseLinksImcs instance;
\r
55 * put your documentation comment here
\r
57 * @exception StorageObjectException
\r
59 // the following *has* to be sychronized cause this static method
\r
60 // could get preemted and we could end up with 2 instances of DatabaseFoo..
\r
61 // see the "Singletons with needles and thread" article at JavaWorld -mh
\r
62 public synchronized static DatabaseLinksImcs getInstance() throws
\r
63 StorageObjectException {
\r
64 if (instance == null) {
\r
65 instance = new DatabaseLinksImcs();
\r
66 instance.myselfDatabase = instance;
\r
72 * put your documentation comment here
\r
74 private DatabaseLinksImcs() throws StorageObjectException {
\r
76 ////this.cache = new HashMap();
\r
77 this.hasTimestamp = false;
\r
78 this.theTable = "links_imcs";
\r
80 this.theEntityClass = Class.forName("mircoders.entity.EntityLinksImcs");
\r
82 catch (Exception e) {
\r
83 throw new StorageObjectException(e.toString());
\r
87 /** @todo toooo much copy/paste in this class //rk */
\r
89 public String insert(Entity theEntity) throws StorageObjectException {
\r
90 String returnId = "0";
\r
91 Connection con = null;
\r
92 PreparedStatement pstmt = null;
\r
94 invalidatePopupCache();
\r
96 HashMap theEntityValues = theEntity.getValues();
\r
97 ArrayList streamedInput = theEntity.streamedInput();
\r
98 StringBuffer f = new StringBuffer();
\r
99 StringBuffer v = new StringBuffer();
\r
100 String aField, aValue;
\r
101 boolean firstField = true;
\r
103 for (int i = 0; i < getFields().size(); i++) {
\r
104 aField = (String) getFields().get(i);
\r
105 if (!aField.equals(thePKeyName)) {
\r
108 if (aField.equals("webdb_create")) {
\r
112 if (streamedInput != null && streamedInput.contains(aField)) {
\r
116 if (theEntityValues.containsKey(aField)) {
\r
117 if (aField.equals("to_parent_id")) {
\r
118 aValue = JDBCStringRoutines.escapeStringLiteral((String) theEntityValues.get(aField));
\r
121 aValue = "'" + JDBCStringRoutines.escapeStringLiteral((String) theEntityValues.get(aField)) + "'";
\r
126 // wenn Wert gegeben, dann einbauen
\r
127 if (aValue != null) {
\r
128 if (firstField == false) {
\r
133 firstField = false;
\r
141 StringBuffer sqlBuf = new StringBuffer("insert into ").append(theTable).
\r
142 append("(").append(f).append(") values (").append(v).append(")");
\r
143 String sql = sqlBuf.toString();
\r
144 theLog.printInfo("INSERT: " + sql);
\r
145 con = getPooledCon();
\r
146 con.setAutoCommit(false);
\r
147 pstmt = con.prepareStatement(sql);
\r
148 if (streamedInput != null) {
\r
149 for (int i = 0; i < streamedInput.size(); i++) {
\r
150 String inputString = (String) theEntityValues.get(streamedInput.get(i));
\r
151 pstmt.setBytes(i + 1, inputString.getBytes());
\r
155 pstmt = con.prepareStatement(theAdaptor.getLastInsertSQL( (Database)
\r
157 ResultSet rs = pstmt.executeQuery();
\r
159 returnId = rs.getString(1);
\r
160 theEntity.setId(returnId);
\r
162 catch (SQLException sqe) {
\r
163 throwSQLException(sqe, "insert");
\r
167 con.setAutoCommit(true);
\r
169 catch (Exception e) {
\r
172 freeConnection(con, pstmt);
\r
177 public void update(Entity theEntity) throws StorageObjectException {
\r
178 Connection con = null;
\r
179 PreparedStatement pstmt = null;
\r
180 ArrayList streamedInput = theEntity.streamedInput();
\r
181 HashMap theEntityValues = theEntity.getValues();
\r
182 String id = theEntity.getId();
\r
184 StringBuffer fv = new StringBuffer();
\r
185 boolean firstField = true;
\r
187 invalidatePopupCache();
\r
188 // build sql statement
\r
189 for (int i = 0; i < getFields().size(); i++) {
\r
190 aField = (String) metadataFields.get(i);
\r
191 // only normal cases
\r
192 if (! (aField.equals(thePKeyName) || aField.equals("webdb_create") ||
\r
193 aField.equals("webdb_lastchange") ||
\r
194 (streamedInput != null && streamedInput.contains(aField)))) {
\r
195 if (theEntityValues.containsKey(aField)) {
\r
196 if (firstField == false) {
\r
200 firstField = false;
\r
202 if (aField.equals("to_parent_id")) {
\r
203 fv.append(aField).append("=").append(JDBCStringRoutines.escapeStringLiteral((String)theEntityValues.get(aField)));
\r
206 fv.append(aField).append("='").append(JDBCStringRoutines.escapeStringLiteral((String)theEntityValues.get(aField))).append("'");
\r
211 StringBuffer sql = new StringBuffer("update ").append(theTable).append(
\r
212 " set ").append(fv);
\r
214 if (metadataFields.contains("webdb_lastchange")) {
\r
215 sql.append(",webdb_lastchange=NOW()");
\r
217 if (streamedInput != null) {
\r
218 for (int i = 0; i < streamedInput.size(); i++) {
\r
219 sql.append(",").append(streamedInput.get(i)).append("=?");
\r
222 sql.append(" where id=").append(id);
\r
223 theLog.printInfo("UPDATE: " + sql);
\r
226 con = getPooledCon();
\r
227 con.setAutoCommit(false);
\r
228 pstmt = con.prepareStatement(sql.toString());
\r
229 if (streamedInput != null) {
\r
230 for (int i = 0; i < streamedInput.size(); i++) {
\r
231 String inputString = (String) theEntityValues.get(streamedInput.get(i));
\r
232 pstmt.setBytes(i + 1, inputString.getBytes());
\r
235 pstmt.executeUpdate();
\r
237 catch (SQLException sqe) {
\r
238 throwSQLException(sqe, "update");
\r
242 con.setAutoCommit(true);
\r
244 catch (Exception e) {
\r
247 freeConnection(con, pstmt);
\r