KickJava   Java API By Example, From Geeks To Geeks.

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


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 InsertTempTableContentNodeIdNodeId extends TKPrepQuery
7 {
8
9     public final static boolean prepared = true;
10
11     public final static String JavaDoc[] order = null;
12
13     public final static Object JavaDoc[][] types = null;
14
15     public final static boolean[] relevants = { true };
16
17     public final static String JavaDoc sqlString = (new StringBuffer JavaDoc("INSERT INTO WEBMAN_TEMP_2 SELECT CONTENT_NODE_ID, CONTENT_NODE_ID FROM CONTENT_TREE ")
18                                            .append(" WHERE CONTENT_NODE_PARENT IN ( SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP ) ")
19                                          .append(" OR ")
20                                            .append(" CONTENT_NODE_ID IN ( SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP ) ")).toString();
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