KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > content > SelectGroupContentChilds


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 public class SelectGroupContentChilds extends TKPrepQuery
7 {
8
9     public final static boolean PREPARED = true;
10
11     public final static String JavaDoc[] ORDER = { "CONTENT_NODE_ID" };
12
13     public final static Object JavaDoc[][] TYPES = null;
14
15     public final static boolean[] RELEVANTS = { true };
16
17     public final static String JavaDoc SQL_STRING =
18         "SELECT CT.CONTENT_NODE_ID, CT.CONTENT_NODE_NAME, CT.CONTENT_NODE_SHORTNAME, " +
19         "CI.INSTANCE_ID " +
20         "FROM CONTENT_TREE CT, CONTENT_INSTANCE CI WHERE CT.CONTENT_NODE_PARENT = ? AND " +
21         "CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID";
22
23     public void initQuery(Connection JavaDoc con) {
24         super.initQuery(
25             con,
26             PREPARED,
27             ORDER,
28             TYPES,
29             RELEVANTS,
30             SQL_STRING );
31     }
32
33 }
Popular Tags