KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/TKWMDBGreatGrandMotherNode.java,v 1.2 2001/09/18 15:25:17 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  * TKWMDBGreatGrandMotherNode
13  * @author
14  * @version
15  */
16 public class TKWMDBGreatGrandMotherNode 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"};
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         "SELECT SITE_NODE_PARENT FROM SITE_TREE " +
32         " WHERE SITE_NODE_ID = " +
33         " ( " +
34         " SELECT SITE_NODE_PARENT FROM SITE_TREE " +
35         " WHERE SITE_NODE_ID = " +
36         " ( " +
37         " SELECT SITE_NODE_PARENT FROM SITE_TREE WHERE SITE_NODE_ID = ? " +
38         " ) "+
39         " ) ";
40         
41     
42     public void initQuery(Connection con) {
43         super.initQuery(
44             con,
45             IS_PREPARED,
46             PARAM_ORDER,
47             PARAM_TYPES,
48             SET_RELEVANTS,
49             SQL_STRING );
50     }
51 }
52
53
54
Popular Tags