KickJava   Java API By Example, From Geeks To Geeks.

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


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 SelectDistinctFromSiteTreeContentTree extends TKPrepQuery
7 {
8
9     public final static boolean prepared = true;
10
11     public final static String JavaDoc[] order =
12   {
13     "LEFT_NR", "RIGHT_NR"
14   };
15
16     public final static Object JavaDoc[][] types = null;
17
18     public final static boolean[] relevants = { true };
19
20     public final static String JavaDoc sqlString = "SELECT DISTINCT ST.SITE_NODE_ID FROM SITE_TREE ST, CONTENT_TREE CT WHERE ST.PG_CONTENT_NODE = CT.CONTENT_NODE_ID AND CT.LEFT_NR >= ? AND CT.RIGHT_NR <= ?";
21
22     public void initQuery(Connection JavaDoc con) {
23         super.initQuery(
24             con,
25             prepared,
26             order,
27             types,
28             relevants,
29             sqlString );
30     }
31
32 }
Popular Tags