KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > XMLStructuredContentDescribe


1 package de.webman.content.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.Types JavaDoc;
5 import com.teamkonzept.db.TKPrepQuery;
6 import de.webman.content.db.ContentConstants;
7 import de.webman.content.db.StructuredContentConstants;
8 import de.webman.form.db.FormConstants;
9
10 /**
11  * Retrieves the description of an existing structured content from the database.
12  * <TABLE>
13  * <TR>
14  * <TD><B>Order</B></TD>
15  * <TD><B>Name</B></TD>
16  * <TD><B>Type</B></TD>
17  * </TR>
18  * <TR>
19  * <TD COLSPAN="3"><I>Parameters<I/></TD>
20  * </TR>
21  * <TR>
22  * <TD><TT>1</TT></TD>
23  * <TD><TT>de.webman.content.db.ContentConstants.CONTENT_ID</TT></TD>
24  * <TD><TT>java.lang.Integer</TT></TD>
25  * </TR>
26  * <TR>
27  * <TD COLSPAN="3"><I>Results<I/></TD>
28  * </TR>
29  * <TR>
30  * <TD><TT>1</TT></TD>
31  * <TD><TT>de.webman.content.db.StructuredContentConstants.FORM_ID</TT></TD>
32  * <TD><TT>java.lang.Integer</TT></TD>
33  * </TR>
34  * <TR>
35  * <TD><TT>2</TT></TD>
36  * <TD><TT>de.webman.form.db.FormConstants.FORM_NAME</TT></TD>
37  * <TD><TT>java.lang.String</TT></TD>
38  * </TR>
39  * <TR>
40  * <TD><TT>3</TT></TD>
41  * <TD><TT>de.webman.form.db.FormConstants.FORM_DESCRIPTION</TT></TD>
42  * <TD><TT>java.lang.String</TT></TD>
43  * </TR>
44  * </TABLE>
45  *
46  * @author <A HREF="mailto:unl@webman.de">Ulrich Nicolas Liss&eacute;</A>,
47  * &copy; 2001 Webman AG.
48  * @version $Revision: 1.1 $
49  */

50 public class XMLStructuredContentDescribe
51     extends TKPrepQuery
52 {
53     // $Id: XMLStructuredContentDescribe.java,v 1.1 2001/09/28 14:50:36 uli Exp $
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         ContentConstants.CONTENT_ID
68     };
69
70     /**
71      * The parameter types.
72      */

73     private final static Object JavaDoc[][] PARAMETER_TYPES =
74     {
75         {ContentConstants.CONTENT_ID, new Integer JavaDoc(Types.INTEGER)}
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 = (new StringBuffer JavaDoc()).append("SELECT STRUCTURED_CONTENT.FORM_ID, FORM.FORM_NAME, FORM.FORM_DESCRIPTION ")
90                                                                  .append("FROM CONTENT, STRUCTURED_CONTENT, FORM ")
91                                                                  .append("WHERE CONTENT.CONTENT_ID = ? ")
92                                                                  .append("AND CONTENT.CONTENT_ID = STRUCTURED_CONTENT.CONTENT_ID ")
93                                                                  .append("AND STRUCTURED_CONTENT.FORM_ID = FORM.FORM_ID")
94                                                                  .toString();
95
96
97     // Implementation of 'com.teamkonzept.db.TKQuery'
98

99     /**
100      * Initializes the query with the given connection.
101      *
102      * @param connection the connection.
103      */

104     public void initQuery (Connection JavaDoc connection)
105     {
106         super.initQuery(connection,
107                         IS_PREPARED,
108                         PARAMETER_ORDER,
109                         PARAMETER_TYPES,
110                         SET_RELEVANTS,
111                         SQL_STRING);
112     }
113
114 }
115
Popular Tags