KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 /**
7  * @author
8  * @version
9  */
10 public class SelectSiteNodeId extends TKPrepQuery
11 {
12
13     /** prepariert ? */
14     public static final boolean PREPARED = true;
15     public static final String JavaDoc[] ORDER = {};
16     public static final Object JavaDoc[][] TYPES = null;
17     public static final boolean[] RELEVANTS = { true };
18
19     /** die sql-query */
20     public static String JavaDoc SQLSTRING =
21
22         "SELECT T2.SITE_NODE_ID AS ST_SITE_NODE_ID, T2.CONTENT_NODE_ID AS CT_CONTENT_NODE_ID, T2.CONTENT_NODE_SHORTNAME AS CT_CONTENT_NODE_NAME, T2.CONTENT_NODE_TYPE AS CT_CONTENT_NODE_TYPE, SD.SITE_NODE_ID AS SD_SITE_NODE_ID, SD.SITE_NODE_DOC_IDX AS SD_SITE_NODE_DOC_IDX, SD.DOCUMENT_NAME AS SD_DOCUMENT_NAME, SD.DOCUMENT_SHORTNAME AS SD_DOCUMENT_SHORTNAME FROM WEBMAN_TEMP2 T2, SITE_DOCUMENT SD WHERE T2.DC_SITE_NODE_ID = SD.SITE_NODE_ID (+) " +
23         " AND T2.DC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX (+) ORDER BY " + DBStringFactory.upper_order() + " (T2.CONTENT_NODE_SHORTNAME) ";
24
25     public void initQuery(Connection JavaDoc con) {
26         super.initQuery(
27             con,
28             PREPARED,
29             ORDER,
30             TYPES,
31             RELEVANTS,
32             SQLSTRING );
33     }
34
35 }
36
Popular Tags