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