KickJava   Java API By Example, From Geeks To Geeks.

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


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.FieldAttributeConstants;
6 import de.webman.form.db.FormConstants;
7
8 /**
9  * Selects the dependency state of the specified form definition.
10  * <TABLE>
11  * <TR>
12  * <TD><B>Order</B></TD>
13  * <TD><B>Name</B></TD>
14  * <TD><B>Type</B></TD>
15  * </TR>
16  * <TR>
17  * <TD COLSPAN="3"><I>Parameters</I></TD>
18  * </TR>
19  * <TR>
20  * <TD><TT>1</TT></TD>
21  * <TD><TT>de.webman.form.db.FormConstants.FORM_ID</TT></TD>
22  * <TD><TT>java.lang.Integer</TT></TD>
23  * </TR>
24  * <TR>
25  * <TD COLSPAN="3"><I>Results</I></TD>
26  * </TR>
27  * <TR>
28  * <TD><TT>1</TT></TD>
29  * <TD><TT>'1'</TT></TD>
30  * <TD><TT>java.lang.Integer</TT></TD>
31  * </TR>
32  * </TABLE>
33  *
34  * @author $Author: uli $
35  * @version $Revision: 1.1 $
36  */
37 public class FormDepends
38     extends TKPrepQuery
39 {
40
41     // Constants.
42
43     /**
44      * The preparation state.
45      */
46     private final static boolean IS_PREPARED = true;
47
48     /**
49      * The parameter order.
50      */
51     private final static String JavaDoc[] PARAMETER_ORDER =
52     {
53         FieldAttributeConstants.COLUMN_NAMES[FieldAttributeConstants.VALUE],
54         FormConstants.COLUMN_NAMES[FormConstants.FORM_ID],
55         FormConstants.COLUMN_NAMES[FormConstants.FORM_ID],
56         FormConstants.COLUMN_NAMES[FormConstants.FORM_ID]
57     };
58
59     /**
60      * The parameter types.
61      */
62     private final static Object JavaDoc[][] PARAMETER_TYPES =
63     {
64         {FieldAttributeConstants.COLUMN_NAMES[FieldAttributeConstants.VALUE], FieldAttributeConstants.COLUMN_TYPES[FieldAttributeConstants.VALUE]},
65         {FormConstants.COLUMN_NAMES[FormConstants.FORM_ID], FormConstants.COLUMN_TYPES[FormConstants.FORM_ID]},
66         {FormConstants.COLUMN_NAMES[FormConstants.FORM_ID], FormConstants.COLUMN_TYPES[FormConstants.FORM_ID]},
67         {FormConstants.COLUMN_NAMES[FormConstants.FORM_ID], FormConstants.COLUMN_TYPES[FormConstants.FORM_ID]}
68     };
69
70
71     /**
72      * The relevance state.
73      */
74     private final static boolean[] SET_RELEVANTS =
75     {
76         true
77     };
78
79     /**
80      * The SQL statement.
81      */
82     private final static String JavaDoc SQL_STRING = "SELECT 1 FROM FIELD_ATTRIBUTE WHERE NAME = 'FORM_ID' AND VALUE = ? " +
83                                              "UNION " +
84                                              "SELECT 1 FROM CONTENT_TREE WHERE CONTENT_FORM = ? " +
85                                              "UNION " +
86                                              "SELECT 1 FROM PRESENTATION_CONTENT WHERE FORM_ID = ? " +
87                                              "UNION " +
88                                              "SELECT 1 FROM STRUCTURED_CONTENT WHERE FORM_ID = ? ";
89
90
91     // Implementation of 'com.teamkonzept.db.TKQuery'
92
93     /**
94      * Initializes the query with the given connection.
95      *
96      * @param connection the connection.
97      */
98     public void initQuery (Connection JavaDoc connection)
99     {
100         super.initQuery(connection,
101                         IS_PREPARED,
102                         PARAMETER_ORDER,
103                         PARAMETER_TYPES,
104                         SET_RELEVANTS,
105                         SQL_STRING);
106     }
107
108     /**
109      * Sets a query parameter.
110      *
111      * @param name the parameter name.
112      * @param value the parameter value.
113      */
114     public final void setQueryParams (String JavaDoc name, Object JavaDoc value)
115     {
116         if (FormConstants.COLUMN_NAMES[FormConstants.FORM_ID].equals(name))
117         {
118             super.setQueryParams(FieldAttributeConstants.COLUMN_NAMES[FieldAttributeConstants.VALUE],
119                                  value != null ? value.toString() : (String JavaDoc) null);
120         }
121
122         super.setQueryParams(name, value);
123     }
124
125 }
126
Popular Tags