KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > generator > db > queries > postgresql > GenSiteContNodes


1 package de.webman.generator.db.queries.postgresql;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * DBGenSiteContNodes
8  * Holt alle Inhaltsknoten aller Dokumente aller Knoten aus dem SITE_TREE
9  *
10  * Input: Keiner
11  * Output: alle Inhalte aller Dokumente aller Knoten aus Sitetree
12  * @author $Author: markus $
13  * @version $Revision: 1.1 $
14  */
15 public class GenSiteContNodes extends TKPrepQuery {
16
17     public static boolean isPrepared =
18         true;
19
20     public static String JavaDoc[] paramOrder =
21         null;
22
23     public static Object JavaDoc[][] paramTypes =
24         null;
25
26     public static boolean[] setRelevants =
27         { true };
28
29     public static String JavaDoc sqlString =
30         "SELECT " +
31         " DC.SITE_NODE_ID, " +
32         " DC.SITE_NODE_DOC_IDX, " +
33         " DC.PRESENTATION_COMPONENT_IDX, " +
34         " DC.CONTENT_NODE_ID, " +
35         " CS.SELECTION_TYPE, " +
36         " CS.SELECTION_DATA, " +
37         " PC.INTEGRATION_TYPE, " +
38         " PC.INTEGRATION_SHORTNAME, " +
39         " ST.LEFT_NR " +
40         "FROM " +
41         " SITE_TREE ST, SITE_DOCUMENT SD, PRESENTATION_COMPONENT PC, DOCUMENT_CONTENT DC LEFT JOIN CONTENT_SELECTION CS USING(SELECTION_ID) " +
42         "WHERE " +
43         " ST.SITE_NODE_ID = SD.SITE_NODE_ID " +
44         "AND " +
45         " PC.PRESENTATION_ID = SD.PRESENTATION_ID " +
46         "AND " +
47         " DC.SITE_NODE_ID = SD.SITE_NODE_ID " +
48         "AND " +
49         " DC.SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX " +
50         "AND " +
51         " DC.PRESENTATION_COMPONENT_IDX = PC.PRESENTATION_COMPONENT_IDX " +
52         "AND " +
53         " PC.COMPONENT_TYPE = 3 " +
54         "ORDER BY " +
55         " ST.LEFT_NR, DC.SITE_NODE_DOC_IDX, DC.PRESENTATION_COMPONENT_IDX";
56
57
58     public void initQuery(Connection con) {
59         super.initQuery(
60             con,
61             isPrepared,
62             paramOrder,
63             paramTypes,
64             setRelevants,
65             sqlString );
66     }
67 }
68
Popular Tags