KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.refsel.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKWMDBGrandMotherNode
9  * @author
10  * @version
11  */
12 public class TKWMDBGrandMotherNode extends TKPrepQuery {
13
14     public final static boolean IS_PREPARED =
15         true;
16     
17     public final static String JavaDoc[] PARAM_ORDER =
18         {SITE_NODE_ID};
19     
20     public final static Object JavaDoc[][] PARAM_TYPES =
21         null;
22                 
23     public final static boolean[] SET_RELEVANTS =
24         { true };
25         
26     public final static String JavaDoc SQL_STRING =
27         " SELECT SITE_NODE_PARENT FROM SITE_TREE "
28  + " WHERE "
29  + " SITE_NODE_ID = (SELECT SITE_NODE_PARENT "
30  + " FROM SITE_TREE "
31  + " WHERE "
32  + " SITE_NODE_ID = ? ) " ;
33         
34     
35     public void initQuery(Connection con) {
36         super.initQuery(
37             con,
38             IS_PREPARED,
39             PARAM_ORDER,
40             PARAM_TYPES,
41             SET_RELEVANTS,
42             SQL_STRING );
43     }
44 }
45
46
47
Popular Tags