KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5 import org.apache.log4j.Category;
6
7 /**
8  *
9  * @author
10  * @version
11  */
12 public class SelectFromContentTreeContentInstanceTempTable extends TKPrepQuery
13 {
14
15     public final static boolean PREPARED = true;
16     public final static String JavaDoc[] ORDER = null;
17     public final static Object JavaDoc[][] TYPES = null;
18     public final static boolean[] RELEVANTS = { true };
19
20
21
22     public final static String JavaDoc SQLSTRING = (new StringBuffer JavaDoc("SELECT CT.CONTENT_NODE_ID, CI.INSTANCE_ID, CI.NAME, CT.CONTENT_NODE_NAME, ")
23         .append(" CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_TYPE, CT.LEFT_NR, CT.RIGHT_NR, ")
24         .append(" CT.CONTENT_FORM, CT.CONTENT_NODE_PARENT, T.NODE_ID ")
25         .append(" FROM CONTENT_INSTANCE CI, CONTENT_TREE CT, WEBMAN_TEMP_2 T ")
26                                             // .append(DBStringFactory.rightOuterJoinFrom(new String[]{" CI.CONTENT_NODE_ID "," CT.CONTENT_NODE_ID "}," CONTENT_INSTANCE CI ", " CONTENT_TREE CT "))
27 // .append(", WEBMAN_TEMP_2 T ")
28 .append(" WHERE ")
29         .append(" CI.CONTENT_NODE_ID (+) = CT.CONTENT_NODE_ID AND ")
30         .append(" CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID ")
31         .append(" ORDER BY CT.LEFT_NR ")).toString();
32
33     public void initQuery(Connection JavaDoc con) {
34         super.initQuery(
35             con,
36             PREPARED,
37             ORDER,
38             TYPES,
39             RELEVANTS,
40             SQLSTRING );
41     }
42
43 }
44
Popular Tags