KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/TKWMDBCousinsNodes.java,v 1.6 2001/09/18 15:22:28 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  * TKWMDBCousinNodes
13  * holt alle knoten, die einen gemeinsamen "Grossmutter"-Knoten haben.
14  * @author
15  * @version
16  */
17 public class TKWMDBCousinsNodes extends TKPrepQuery {
18
19     public final static boolean IS_PREPARED =
20         true;
21     
22     public final static String JavaDoc[] PARAM_ORDER =
23         {"SITE_NODE_ID"};
24     
25     public final static Object JavaDoc[][] PARAM_TYPES =
26         null;
27                 
28     public final static boolean[] SET_RELEVANTS =
29         { true };
30         
31     public final static String JavaDoc SQL_STRING =
32         
33          " SELECT COUSINS.* FROM SITE_TREE COUSINS, SITE_TREE GRANDMA "
34  + " WHERE "
35  + " GRANDMA.SITE_NODE_ID = (SELECT SITE_NODE_PARENT FROM SITE_TREE "
36  + " WHERE "
37  + " SITE_NODE_ID = (SELECT SITE_NODE_PARENT "
38  + " FROM SITE_TREE "
39  + " WHERE "
40  + " SITE_NODE_ID = ? ) "
41  + " ) "
42  + " AND "
43  + " COUSINS.SITE_NODE_PARENT IN (SELECT SITE_NODE_ID FROM SITE_TREE WHERE SITE_NODE_PARENT = GRANDMA.SITE_NODE_ID) "
44
45 ;
46     
47     public void initQuery(Connection con) {
48         super.initQuery(
49             con,
50             IS_PREPARED,
51             PARAM_ORDER,
52             PARAM_TYPES,
53             SET_RELEVANTS,
54             SQL_STRING );
55     }
56 }
57
58
Popular Tags