|
1 package com.teamkonzept.webman.mainint.db.queries.content.postgresql;
2
3 import java.sql.Connection  ;
4 import com.teamkonzept.db.*;
5
6
10 public class SelectSiteNodeId extends TKPrepQuery
11 {
12
13 public static final boolean PREPARED = true;
14 public static final String [] ORDER = {};
15 public static final Object [][] TYPES = null;
16 public static final boolean[] RELEVANTS = { true };
17
18 public static String SQLSTRING =
19
20 "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 " +
21 "FROM WEBMAN_TEMP2 T2 LEFT JOIN SITE_DOCUMENT SD ON ( T2.DC_SITE_NODE_ID = SD.SITE_NODE_ID AND T2.DC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX ) " +
22 "ORDER BY T2.CONTENT_NODE_SHORTNAME ";
23
24 public void initQuery(Connection con) {
25 super.initQuery(
26 con,
27 PREPARED,
28 ORDER,
29 TYPES,
30 RELEVANTS,
31 SQLSTRING );
32 }
33
34 }
35 |
Popular Tags |
Java API By Example, From Geeks To Geeks.