KickJava   Java API By Example, From Geeks To Geeks.

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


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