KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBDocContentPCGet.java,v 1.9 2001/11/09 15:33:45 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  * TKDBDocContentPCGet
13  * Holt alle PresentationComponents eines Site-Document-Knotens
14  *
15  * Input: PRESENTATION_ID, SITE_NODE_ID, SITE_NODE_DOC_IDX
16  * Output: SITE_NODE_ID, SITE_NODE_DOC_IDX und alles aus PRESENT_COM, PRES_CON
17  */
18 public class TKDBDocContentPCGet extends TKPrepQuery
19 {
20
21     public final static boolean IS_PREPARED = true;
22
23     public final static String JavaDoc[] PARAM_ORDER =
24     { "SITE_NODE_ID", "SITE_NODE_DOC_IDX", "PRESENTATION_ID" };
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
32     "SELECT ? AS SITE_NODE_ID, ? AS SITE_NODE_DOC_IDX, " +
33     " PM.PRESENTATION_ID, " +
34     " PM.PRESENTATION_COMPONENT_IDX, " +
35     " PM.COMPONENT_TYPE, " +
36     " PM.INTEGRATION_TYPE, " +
37     " PM.INTEGRATION_NAME, " +
38     " PM.INTEGRATION_SHORTNAME, " +
39     " PN.FORM_ID " +
40     "FROM " +
41     " PRESENTATION_COMPONENT PM, PRESENTATION_CONTENT PN " +
42     "WHERE " +
43     " PM.PRESENTATION_ID = ? " +
44     "AND " +
45     " PM.COMPONENT_TYPE BETWEEN 1 AND 3 " +
46     "AND " +
47     DBStringFactory.leftOuterJoin(" PM.PRESENTATION_ID", "PN.PRESENTATION_ID ") +
48         //" PM.PRESENTATION_ID = PN.PRESENTATION_ID(+) " +
49 "AND " +
50     DBStringFactory.leftOuterJoin(" PM.PRESENTATION_COMPONENT_IDX","PN.PRESENTATION_COMPONENT_IDX ") +
51         //" PM.PRESENTATION_COMPONENT_IDX = PN.PRESENTATION_COMPONENT_IDX(+) " +
52 "ORDER BY " + " PM.PRESENTATION_COMPONENT_IDX";
53
54     public void initQuery(Connection con)
55     {
56     super.initQuery(con,
57             IS_PREPARED,
58             PARAM_ORDER, PARAM_TYPES, SET_RELEVANTS, SQL_STRING);
59     }
60 }
61
Popular Tags