KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > form > db > queries > SelectReferencedDocumentTypes


1 package de.webman.form.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.TKPrepQuery;
5 import de.webman.form.db.FormConstants;
6
7 /**
8  * Selects all document types referenced by the specified form definition.
9  * <TABLE>
10  * <TR>
11  * <TD><B>Order</B></TD>
12  * <TD><B>Name</B></TD>
13  * <TD><B>Type</B></TD>
14  * </TR>
15  * <TR>
16  * <TD COLSPAN="3"><I>Parameters</I></TD>
17  * </TR>
18  * <TR>
19  * <TD><TT>1</TT></TD>
20  * <TD><TT>de.webman.form.db.FormConstants.FORM_ID</TT></TD>
21  * <TD><TT>java.lang.Integer</TT></TD>
22  * </TR>
23  * <TR>
24  * <TD COLSPAN="3"><I>Results</I></TD>
25  * </TR>
26  * <TR>
27  * <TD><TT>1</TT></TD>
28  * <TD><TT>PRESENTATION.PRESENTATION_ID</TT></TD>
29  * <TD><TT>java.lang.String</TT></TD>
30  * </TR>
31  * <TR>
32  * <TD><TT>2</TT></TD>
33  * <TD><TT>PRESENTATION.PRESENTATION_NAME</TT></TD>
34  * <TD><TT>java.lang.String</TT></TD>
35  * </TR>
36  * <TR>
37  * <TD><TT>3</TT></TD>
38  * <TD><TT>PRESENTATION_COMPONENT.PRESENTATION_COMPONENT_IDX</TT></TD>
39  * <TD><TT>java.lang.String</TT></TD>
40  * </TR>
41  * <TR>
42  * <TD><TT>4</TT></TD>
43  * <TD><TT>PRESENTATION_COMPONENT.INTEGRATION_NAME</TT></TD>
44  * <TD><TT>java.lang.String</TT></TD>
45  * </TR>
46  * </TABLE>
47  *
48  * @author $Author: uli $
49  * @version $Revision: 1.4 $
50  */
51 public class SelectReferencedDocumentTypes
52     extends TKPrepQuery
53 {
54
55     // Constants.
56
57     /**
58      * The preparation state.
59      */
60     private final static boolean IS_PREPARED = true;
61
62     /**
63      * The parameter order.
64      */
65     private final static String JavaDoc[] PARAMETER_ORDER =
66     {
67         FormConstants.COLUMN_NAMES[FormConstants.FORM_ID]
68     };
69
70     /**
71      * The parameter types.
72      */
73     private final static Object JavaDoc[][] PARAMETER_TYPES =
74     {
75         {FormConstants.COLUMN_NAMES[FormConstants.FORM_ID], FormConstants.COLUMN_TYPES[FormConstants.FORM_ID]}
76     };
77
78     /**
79      * The relevance state.
80      */
81     private final static boolean[] SET_RELEVANTS =
82     {
83         true
84     };
85
86     /**
87      * The SQL statement.
88      */
89     private final static String JavaDoc SQL_STRING = "SELECT DISTINCT P.PRESENTATION_ID, P.PRESENTATION_NAME, PC.PRESENTATION_COMPONENT_IDX, PC.INTEGRATION_NAME " +
90                                              "FROM PRESENTATION P, PRESENTATION_COMPONENT PC, PRESENTATION_CONTENT PCO " +
91                                              "WHERE PCO.FORM_ID = ? " +
92                                              "AND PCO.PRESENTATION_COMPONENT_IDX = PC.PRESENTATION_COMPONENT_IDX " +
93                                              "AND PCO.PRESENTATION_ID = PC.PRESENTATION_ID " +
94                                              "AND PCO.PRESENTATION_ID = P.PRESENTATION_ID " +
95                                              "ORDER BY P.PRESENTATION_ID, PC.PRESENTATION_COMPONENT_IDX";
96
97
98     // Implementation of 'com.teamkonzept.db.TKQuery'
99
100     /**
101      * Initializes the query with the given connection.
102      *
103      * @param connection the connection.
104      */
105     public void initQuery (Connection JavaDoc connection)
106     {
107         super.initQuery(connection,
108                         IS_PREPARED,
109                         PARAMETER_ORDER,
110                         PARAMETER_TYPES,
111                         SET_RELEVANTS,
112                         SQL_STRING);
113     }
114
115 }
116
Popular Tags