KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/oracle/Attic/TKDBDocContentDCGet.java,v 1.4 2001/09/04 09:01:35 ralf Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.oracle;
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  */
18 public class TKDBDocContentDCGet extends TKPrepQuery
19 {
20
21     public final static boolean IS_PREPARED = true;
22
23     public final static String JavaDoc[] PARAM_ORDER =
24     { "PRESENTATION_ID", "SITE_NODE_ID", "SITE_NODE_DOC_IDX" };
25
26     public final static Object JavaDoc[][] PARAM_TYPES = null;
27
28     public final static boolean[] SET_RELEVANTS = { true };
29
30     public final static String JavaDoc SQL_STRING =
31     "SELECT " +
32     " DC.*, " +
33     " CS.SELECTION_TYPE, " +
34     " CS.SELECTION_DATA, " +
35     " CT.CONTENT_NODE_NAME " +
36     "FROM " +
37     " PRESENTATION_COMPONENT PM, DOCUMENT_CONTENT DC, CONTENT_SELECTION CS, "
38     + " CONTENT_TREE CT " + "WHERE " + " PM.PRESENTATION_ID = ? " +
39     "AND " + " PM.COMPONENT_TYPE = 3 " + "AND " +
40     " DC.SITE_NODE_ID = ? " + "AND " + " DC.SITE_NODE_DOC_IDX = ? " +
41     "AND " +
42     " DC.PRESENTATION_COMPONENT_IDX = PM.PRESENTATION_COMPONENT_IDX " +
43     "AND " + " CS.SELECTION_ID(+) = DC.SELECTION_ID " + "AND " +
44     " CT.CONTENT_NODE_ID(+) = DC.CONTENT_NODE_ID " + "ORDER BY " +
45     " PM.PRESENTATION_COMPONENT_IDX";
46
47
48     public void initQuery(Connection con)
49     {
50     super.initQuery(con,
51             IS_PREPARED,
52             PARAM_ORDER, PARAM_TYPES, SET_RELEVANTS, SQL_STRING);
53     }
54 }
55
Popular Tags