01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/content/ContInsert.java,v 1.2 2000/12/13 11:25:51 marwan Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.content;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: public class ContInsert extends TKPrepQuery {
12:
13: public final static boolean isPrepared = true;
14:
15: public final static String[] paramOrder = null;
16: public final static Object[][] paramTypes = null;
17:
18: public final static boolean[] setRelevants = null;
19:
20: public final static String sqlString =
21: /*
22: " INSERT INTO CONTENT (CONTENT_ID) SELECT "+ DBStringFactory.nvl() +"(max(CONTENT_ID) +1,0) FROM CONTENT ";
23: */
24: " INSERT INTO " + " CONTENT " + " (CONTENT_ID)" + " SELECT "
25: + DBStringFactory.nvl()
26: + "(max(CONTENT_ID) + 1,0) FROM CONTENT ";
27:
28: public void initQuery(Connection con) {
29: super.initQuery(con, isPrepared, paramOrder, paramTypes,
30: setRelevants, sqlString);
31: }
32: }
|