|
1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection  ;
4 import com.teamkonzept.db.*;
5
6 public class InsertContentTree extends TKPrepQuery
7 {
8
9 public final static boolean prepared = true;
10
11 public final static String [] order = {
12 "CONTENT_NODE_ID",
13 "CONTENT_NODE_NAME",
14 "CONTENT_NODE_SHORTNAME",
15 "CONTENT_NODE_TYPE",
16 "LEFT_NR",
17 "RIGHT_NR",
18 "CONTENT_FORM",
19 "CONTENT_NODE_PARENT"
20 };
21
22 public final static Object [][] types = {
23 { "CONTENT_NODE_NAME", new Integer (java.sql.Types.VARCHAR)},
24 { "CONTENT_NODE_SHORTNAME", new Integer (java.sql.Types.VARCHAR)}
25 };
26
27 public final static boolean[] relevants = { true };
28
29 public final static String sqlString = (new StringBuffer ("INSERT INTO CONTENT_TREE ")
30 .append(" (CONTENT_NODE_ID, CONTENT_NODE_NAME, CONTENT_NODE_SHORTNAME, ")
31 .append(" CONTENT_NODE_TYPE, LEFT_NR, RIGHT_NR, CONTENT_FORM, CONTENT_NODE_PARENT) ")
32 .append(" VALUES (?, ?, ?, ?, ?, ?, ?, ?)")).toString();
33
34 public void initQuery(Connection con) {
35 super.initQuery(
36 con,
37 prepared,
38 order,
39 types,
40 relevants,
41 sqlString );
42 }
43
44 } |
Popular Tags |
Java API By Example, From Geeks To Geeks.