KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.content.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 /**
7  *
8  * @author
9  * @version
10  */
11 public class SelectContentTreeAndForm extends TKPrepQuery
12 {
13
14     public final static boolean PREPARED = true;
15
16     public final static String JavaDoc[] ORDER = { "CONTENT_NODE_ID" };
17
18     public final static Object JavaDoc[][] TYPES = null;
19
20     public final static boolean[] RELEVANTS = { true };
21
22     /** die Query */
23     public final static String JavaDoc SQL_STRING =
24     "SELECT CT.CONTENT_NODE_ID, CT.CONTENT_NODE_NAME, CT.CONTENT_NODE_SHORTNAME, " +
25     "FI.FIELD_SHOW_NAME AS FORM_NAME " +
26     "FROM CONTENT_TREE CT, FORM FO, FIELD FI WHERE CONTENT_NODE_ID = ? AND CT.CONTENT_FORM=FO.FORM_ID " +
27     " AND FO.FORM_ID = FI.FORM_ID " +
28     " AND " +
29     " FI.FIELD_ID = 0 " ;
30
31     public void initQuery(Connection JavaDoc con) {
32         super.initQuery(
33             con,
34             PREPARED,
35             ORDER,
36             TYPES,
37             RELEVANTS,
38             SQL_STRING );
39     }
40
41 }
42
Popular Tags