KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/postgresql/Attic/TKDBDocContentPCGet.java,v 1.1 2001/11/02 15:55:19 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.postgresql;
6
7 import java.sql.*;
8 import com.teamkonzept.db.*;
9
10 /*
11  * TKDBDocContentPCGet
12  * Holt alle PresentationComponents eines Site-Document-Knotens
13  *
14  * Input: PRESENTATION_ID, SITE_NODE_ID, SITE_NODE_DOC_IDX
15  * Output: SITE_NODE_ID, SITE_NODE_DOC_IDX und alles aus PRESENT_COM, PRES_CON
16  * @author
17  * @version
18  */
19 public class TKDBDocContentPCGet extends TKPrepQuery
20 {
21
22     public final static boolean IS_PREPARED = true;
23
24     public final static String JavaDoc[] PARAM_ORDER =
25     { "SITE_NODE_ID", "SITE_NODE_DOC_IDX", "PRESENTATION_ID" };
26
27     public final static Object JavaDoc[][] PARAM_TYPES = null;
28
29     public final static boolean[] SET_RELEVANTS = { true };
30
31     public final static String JavaDoc SQL_STRING =
32     "SELECT ? AS \"SITE_NODE_ID\", ? AS \"SITE_NODE_DOC_IDX\", " +
33     " PM.PRESENTATION_ID AS \"PRESENTATION_ID\", " +
34     " PM.PRESENTATION_COMPONENT_IDX AS \"PRESENTATION_COMPONENT_IDX\", " +
35     " PM.COMPONENT_TYPE AS \"COMPONENT_TYPE\", " +
36     " PM.INTEGRATION_TYPE AS \"INTEGRATION_TYPE\", " +
37     " PM.INTEGRATION_NAME AS \"INTEGRATION_NAME\", " +
38     " PM.INTEGRATION_SHORTNAME AS \"INTEGRATION_SHORTNAME\", " +
39     " PN.FORM_ID AS \"FORM_ID\" " +
40     "FROM " +
41     " PRESENTATION_COMPONENT PM LEFT JOIN PRESENTATION_CONTENT PN USING ( PRESENTATION_ID, PRESENTATION_COMPONENT_IDX ) " +
42     "WHERE " +
43     " PM.PRESENTATION_ID = ? " +
44     "AND " +
45     " PM.COMPONENT_TYPE BETWEEN 1 AND 3 " +
46     "ORDER BY PM.PRESENTATION_COMPONENT_IDX";
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