KickJava   Java API By Example, From Geeks To Geeks.

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


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 InsertTempTable3ContentId 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 = "INSERT INTO WEBMAN_TEMP_3 (CONTENT_ID) SELECT C.CONTENT_ID FROM WEBMAN_TEMP_4 T, CONTENT_VERSION CV, CONTENT C WHERE T.INSTANCE_ID = CV.INSTANCE_ID AND CV.CONTENT_ID = C.CONTENT_ID";
18
19     public void initQuery(Connection JavaDoc con) {
20         super.initQuery(
21             con,
22             prepared,
23             order,
24             types,
25             relevants,
26             sqlString );
27     }
28
29 }
Popular Tags