01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class InsertContentTree extends TKPrepQuery {
07:
08: public final static boolean prepared = true;
09:
10: public final static String[] order = { "CONTENT_NODE_ID",
11: "CONTENT_NODE_NAME", "CONTENT_NODE_SHORTNAME",
12: "CONTENT_NODE_TYPE", "LEFT_NR", "RIGHT_NR", "CONTENT_FORM",
13: "CONTENT_NODE_PARENT" };
14:
15: public final static Object[][] types = {
16: { "CONTENT_NODE_NAME", new Integer(java.sql.Types.VARCHAR) },
17: { "CONTENT_NODE_SHORTNAME",
18: new Integer(java.sql.Types.VARCHAR) } };
19:
20: public final static boolean[] relevants = { true };
21:
22: public final static String sqlString = (new StringBuffer(
23: "INSERT INTO CONTENT_TREE ")
24: .append(
25: " (CONTENT_NODE_ID, CONTENT_NODE_NAME, CONTENT_NODE_SHORTNAME, ")
26: .append(
27: " CONTENT_NODE_TYPE, LEFT_NR, RIGHT_NR, CONTENT_FORM, CONTENT_NODE_PARENT) ")
28: .append(" VALUES (?, ?, ?, ?, ?, ?, ?, ?)")).toString();
29:
30: public void initQuery(Connection con) {
31: super.initQuery(con, prepared, order, types, relevants,
32: sqlString);
33: }
34:
35: }
|