KickJava   Java API By Example, From Geeks To Geeks.

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


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