KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > generator > db > queries > GenSiteDocStructConts


1 package de.webman.generator.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * DBGenSiteDocStructConts
8  * Holt alle verwendeten Struktur-Inhalt-Integrationen aller Dokumente der Site
9  *
10  * Input: Keiner
11  * Output: alle verwendeten Struktur-Inhalt-Integrationen aller Dokumente der Site
12  * @author $Author: alex $
13  * @version $Revision: 1.1 $
14  */

15 public class GenSiteDocStructConts 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         " SD.SITE_NODE_ID, " +
32         " SD.SITE_NODE_DOC_IDX, " +
33         " PC.PRESENTATION_COMPONENT_IDX, " +
34         " PC.INTEGRATION_SHORTNAME, " +
35         " PCN.FORM_ID " +
36         "FROM " +
37         " SITE_TREE ST, SITE_DOCUMENT SD, PRESENTATION_COMPONENT PC, PRESENTATION_CONTENT PCN " +
38         "WHERE " +
39         " ST.SITE_NODE_ID = SD.SITE_NODE_ID " +
40         "AND " +
41         " PC.PRESENTATION_ID = SD.PRESENTATION_ID " +
42         "AND " +
43         " PC.COMPONENT_TYPE = 4 " +
44         "AND " +
45         " PCN.PRESENTATION_COMPONENT_IDX = PC.PRESENTATION_COMPONENT_IDX " +
46         "AND " +
47         " PCN.PRESENTATION_ID = PC.PRESENTATION_ID " +
48         "ORDER BY " +
49         " ST.LEFT_NR, SD.SITE_NODE_DOC_IDX, PC.PRESENTATION_COMPONENT_IDX";
50
51
52     
53     public void initQuery(Connection con) {
54         super.initQuery(
55             con,
56             isPrepared,
57             paramOrder,
58             paramTypes,
59             setRelevants,
60             sqlString );
61     }
62 }
63
Popular Tags