KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/postgresql/Attic/TKDBDocContentDCGet.java,v 1.6 2002/03/21 22:09:09 sebastian Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.postgresql;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /**
12  * TKDBDocContentDCGet
13  * Holt alle Document Contents eines Site-Document-Knotens
14  *
15  * Input: PRESENTATION_ID, SITE_NODE_ID, SITE_NODE_DOC_IDX
16  * Output: alles aus PRESENT_COM, PRES_CON sowie CONTENT_NODE_NAME
17  * @author $Author: sebastian $
18  * @version $Revision: 1.6 $
19  */
20 public class TKDBDocContentDCGet extends TKPrepQuery{
21
22     public final static boolean ISPREPARED = true;
23
24     /**
25      * parameter order
26      */
27     public final static String JavaDoc[] PARAMORDER = { "PRESENTATION_ID", "SITE_NODE_ID", "SITE_NODE_DOC_IDX"};
28
29     /**
30      * parameter types
31      */
32     public final static Object JavaDoc[][] PARAMTYPES = null;
33
34     public final static boolean[] SETRELEVANTS = { true };
35
36     /** der SQL String */
37     public final static String JavaDoc SQLSTRING =
38         "SELECT " +
39         " DC.*, " +
40         " CS.SELECTION_TYPE, " +
41         " CS.SELECTION_DATA, " +
42         " CT.CONTENT_NODE_NAME " +
43         "FROM " +
44         " PRESENTATION_COMPONENT PM, " +
45         
46     // " CONTENT_SELECTION CS RIGHT OUTER JOIN DOCUMENT_CONTENT DC USING (SELECTION_ID), " +
47 // " CONTENT_TREE CT RIGHT OUTER JOIN DOCUMENT_CONTENT DC2 USING (CONTENT_NODE_ID) " +
48 /* geändert von sebastian@webman-ag.de (2 righter join auf gleiche Tabelle erzeugen doppelte DS) */
49         " (CONTENT_SELECTION CS RIGHT OUTER JOIN DOCUMENT_CONTENT DC USING (SELECTION_ID)) " +
50         " LEFT OUTER JOIN CONTENT_TREE CT USING (CONTENT_NODE_ID) " +
51     
52         "WHERE " +
53         " PM.PRESENTATION_ID = ? " +
54         "AND " +
55         " PM.COMPONENT_TYPE = 3 " +
56         "AND " +
57         " DC.SITE_NODE_ID = ? " +
58         "AND " +
59         " DC.SITE_NODE_DOC_IDX = ? " +
60         "AND " +
61         " DC.PRESENTATION_COMPONENT_IDX = PM.PRESENTATION_COMPONENT_IDX " +
62         "ORDER BY " +
63         " PM.PRESENTATION_COMPONENT_IDX";
64
65     public void initQuery(Connection con) {
66         super.initQuery(
67             con,
68             ISPREPARED,
69             PARAMORDER,
70             PARAMTYPES,
71             SETRELEVANTS,
72             SQLSTRING );
73     }
74 }
75
76
77
Popular Tags