/*
- * put your module comment here
+ * 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 the com.oreilly.servlet library, 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 mir.storage;
import java.sql.*;
* Treiber, Host, User und Passwort, ueber den der Zugriff auf die
* Datenbank erfolgt.
*
- * @version $Revision: 1.22 $ $Date: 2002/08/25 19:00:09 $
+ * @version $Revision: 1.21.2.3 $ $Date: 2002/12/10 09:05:07 $
* @author $Author: mh $
*
- * $Log: Database.java,v $
- * Revision 1.22 2002/08/25 19:00:09 mh
- * merge of localization branch into HEAD. mh and zap
- *
- * Revision 1.21 2002/08/04 23:38:22 mh
- * fix up the webdb_create update stuff
- *
- * Revision 1.20 2002/07/21 22:32:25 mh
- * on insert, the "webdb_lastchange" field should get a value
- *
- * Revision 1.19 2002/06/29 15:44:46 mh
- * make the webdb_create update be called webdb_create_update. it breaks things otherwise. a fixme case I know..
- *
- * Revision 1.18 2002/06/28 20:42:13 mh
- * added necessary bits in templates and Database.java to make webdb_create modifiable. make the conversion from sql/Timestamp to String more robust
- *
- *
*/
public class Database implements StorageObject {
int size = metadataFields.size();
for (int i = 0; i < size; i++) {
// alle durchlaufen bis nix mehr da
-
theType = metadataTypes[i];
if (theType == java.sql.Types.LONGVARBINARY) {
InputStreamReader is = (InputStreamReader)rs.getCharacterStream(i + 1);
// insert into db
StringBuffer sqlBuf = new StringBuffer("insert into ").append(theTable).append("(").append(f).append(") values (").append(v).append(")");
String sql = sqlBuf.toString();
- theLog.printInfo("INSERT: " + sql);
+ //theLog.printInfo("INSERT: " + sql);
con = getPooledCon();
con.setAutoCommit(false);
pstmt = con.prepareStatement(sql);
}
}
sql.append(" where id=").append(id);
- theLog.printInfo("UPDATE: " + sql);
+ //theLog.printInfo("UPDATE: " + sql);
// execute sql
try {
con = getPooledCon();
Statement stmt = null; Connection con = null;
int res = 0;
String sql="delete from "+theTable+" where "+thePKeyName+"='"+id+"'";
- theLog.printInfo("DELETE " + sql);
+ //theLog.printInfo("DELETE " + sql);
try {
con = getPooledCon(); stmt = con.createStatement();
res = stmt.executeUpdate(sql);
throws SQLException,StorageObjectException
{
long startTime = System.currentTimeMillis();
- String sql = "SELECT Count(*) FROM "+ theTable;
- if (where != null && !(where.length() == 0))
- sql = sql + " where " + where;
+ String sql = "SELECT count(*) FROM "+ theTable + " where " + where;
Connection con = null;
Statement stmt = null;
int result = 0;
freeConnection(con,stmt);
}
//theLog.printInfo(theTable + " has "+ result +" rows where " + where);
- theLog.printInfo((System.currentTimeMillis() - startTime) + "ms. for: "
- + sql);
+ //theLog.printInfo((System.currentTimeMillis() - startTime) + "ms. for: " + sql);
return result;
}
try
{
rs = stmt.executeUpdate(sql);
- theLog.printInfo((new java.util.Date().getTime() - startTime) + "ms. for: "
- + sql);
+ //theLog.printInfo((new java.util.Date().getTime() - startTime) + "ms. for: " + sql);
}
catch (SQLException e)
{
result = pstmt.executeUpdate();
}
catch (Exception e) {
- theLog.printDebugInfo("settimage :: setImage gescheitert: "+e.toString());
+ theLog.printDebugInfo("executeUpdate failed: "+e.toString());
throw new StorageObjectException("executeUpdate failed: "+e.toString());
}
finally { freeConnection(con,pstmt); }
- theLog.printInfo((new java.util.Date().getTime() - startTime) + "ms. for: "
- + sql);
+ //theLog.printInfo((new java.util.Date().getTime() - startTime) + "ms. for: " + sql);
return result;
}
try {
con = getPooledCon();
pstmt = con.prepareStatement(sql);
- theLog.printInfo("METADATA: " + sql);
+ //theLog.printInfo("METADATA: " + sql);
ResultSet rs = pstmt.executeQuery();
evalMetaData(rs.getMetaData());
rs.close();