KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/TKWMDBSubtreeNodes.java,v 1.3 2001/09/18 15:29:29 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  * TKWMDBSisterNodes
13  * @author
14  * @version
15  */

16 public class TKWMDBSubtreeNodes 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"};
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 " +
32         " SITE_NODE_ID " +
33         "FROM " +
34         " SITE_TREE " +
35         "WHERE " +
36         " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID=?) " +
37         " AND RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID=?) " +
38         "ORDER BY " +
39         " LEFT_NR ";
40     
41     public void initQuery(Connection con) {
42         super.initQuery(
43             con,
44             IS_PREPARED,
45             PARAM_ORDER,
46             PARAM_TYPES,
47             SET_RELEVANTS,
48             SQL_STRING );
49     }
50 }
51
52
Popular Tags