KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > refsel > db > queries > TKWMDBRSDaughters


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/TKWMDBRSDaughters.java,v 1.7 2001/09/18 15:26:39 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.refsel.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKWMDBRSDaughters
13  * @author
14  * @version
15  */
16 public class TKWMDBRSDaughters extends TKPrepQuery {
17
18     public final static boolean IS_PREPARED =
19         true;
20     
21     public final static String JavaDoc[] PARAM_ORDER =
22         {SITE_NODE_ID, SITE_NODE_ID, SITE_NODE_ID};
23     
24     public final static Object JavaDoc[][] PARAM_TYPES =
25         null;
26                 
27     public final static boolean[] SET_RELEVANTS =
28         { true };
29         
30     public final static String JavaDoc SQL_STRING =
31     
32  " SELECT INNER.LEFT_NR LEFT_NR, INNER.DOCUMENT_SHORTNAME DOCUMENT_SHORTNAME, SD_OUTER.DOCUMENT_NAME DOCUMENT_NAME "
33  + " FROM "
34  + " (SELECT MAX(ST.LEFT_NR) LEFT_NR, SD.DOCUMENT_SHORTNAME "
35  + " FROM SITE_TREE ST, SITE_DOCUMENT SD "
36  + " WHERE "
37  + " ST.SITE_NODE_ID = SD.SITE_NODE_ID "
38  + " AND "
39  + " ( "
40  + " ST.LEFT_NR <= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* SITE_NODE_ID */
41  + " AND "
42  + " ST.RIGHT_NR >= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* SITE_NODE_ID */
43  + " AND "
44  + " SD.INHERITABLE = 1 "
45  + " ) "
46  + " OR "
47  + " ST.SITE_NODE_PARENT = ? " /* SITE_NODE_ID */
48  + " GROUP BY SD.DOCUMENT_SHORTNAME "
49  + " ) "
50  + " INNER, SITE_DOCUMENT SD_OUTER, SITE_TREE ST_OUTER "
51  + " WHERE "
52  + " INNER.LEFT_NR = ST_OUTER.LEFT_NR "
53  + " AND "
54  + " ST_OUTER.SITE_NODE_ID = SD_OUTER.SITE_NODE_ID "
55  + " AND "
56  + " INNER.DOCUMENT_SHORTNAME = SD_OUTER.DOCUMENT_SHORTNAME "
57  + " ORDER BY LEFT_NR "
58 ;
59         
60     
61     public void initQuery(Connection con) {
62         super.initQuery(
63             con,
64             IS_PREPARED,
65             PARAM_ORDER,
66             PARAM_TYPES,
67             SET_RELEVANTS,
68             SQL_STRING );
69     }
70 }
71
72
Popular Tags