KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBDocContentDCGet.java,v 1.6 2001/09/25 17:59:27 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
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
18  * @version
19  */
20 public class TKDBDocContentDCGet extends TKPrepQuery{
21
22     public final static boolean ISPREPARED =
23         true;
24     
25     public final static String JavaDoc[] PARAMORDER =
26         { "PRESENTATION_ID", "SITE_NODE_ID", "SITE_NODE_DOC_IDX"};
27     
28     public final static Object JavaDoc[][] PARAMTYPES =
29         null;
30                 
31     public final static boolean[] SETRELEVANTS =
32         { true };
33         
34     public final static String JavaDoc SQLSTRING =
35          
36         "SELECT " +
37         " DC.*, " +
38         " CS.SELECTION_TYPE, " +
39         " CS.SELECTION_DATA, " +
40         " CT.CONTENT_NODE_NAME " +
41         "FROM " +
42         " PRESENTATION_COMPONENT PM, DOCUMENT_CONTENT DC, CONTENT_SELECTION CS, " +
43         " CONTENT_TREE CT " +
44         "WHERE " +
45         " PM.PRESENTATION_ID = ? " +
46         "AND " +
47         " PM.COMPONENT_TYPE = 3 " +
48         "AND " +
49         " DC.SITE_NODE_ID = ? " +
50         "AND " +
51         " DC.SITE_NODE_DOC_IDX = ? " +
52         "AND " +
53         " DC.PRESENTATION_COMPONENT_IDX = PM.PRESENTATION_COMPONENT_IDX " +
54         "AND " +
55         DBStringFactory.rightOuterJoin( " CS.SELECTION_ID "," DC.SELECTION_ID ") +
56         "AND " +
57         DBStringFactory.rightOuterJoin( " CT.CONTENT_NODE_ID "," DC.CONTENT_NODE_ID ") +
58         "ORDER BY " +
59         " PM.PRESENTATION_COMPONENT_IDX";
60
61     
62     public void initQuery(Connection con) {
63         super.initQuery(
64             con,
65             ISPREPARED,
66             PARAMORDER,
67             PARAMTYPES,
68             SETRELEVANTS,
69             SQLSTRING );
70     }
71 }
72
73
74
Popular Tags