KickJava   Java API By Example, From Geeks To Geeks.

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


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