KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > content > InsertTempTable4InstanceId


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 public class InsertTempTable4InstanceId extends TKPrepQuery
7 {
8
9     public final static boolean prepared = true;
10
11     public final static String JavaDoc[] order =
12   {
13     "LEFT_ID", "RIGHT_ID"
14   };
15
16     public final static Object JavaDoc[][] types = null;
17
18     public final static boolean[] relevants = { true };
19
20     public final static String JavaDoc sqlString = "INSERT INTO WEBMAN_TEMP_4 (INSTANCE_ID) SELECT CI.INSTANCE_ID FROM CONTENT_TREE CT, CONTENT_INSTANCE CI WHERE CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND CT.LEFT_NR >= ? AND CT.RIGHT_NR <= ?";
21
22     public void initQuery(Connection JavaDoc con) {
23         super.initQuery(
24             con,
25             prepared,
26             order,
27             types,
28             relevants,
29             sqlString );
30     }
31
32 }
Popular Tags