KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/sybase/TKWMDBSubtreeNodes.java,v 1.1 2001/09/18 15:53:40 markus Exp $
3  *
4  */

5 package com.teamkonzept.webman.refsel.db.queries.sybase;
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 ISPREPARED =
19         true;
20     
21     public final static String JavaDoc[] PARAMORDER =
22         {"SITE_NODE_ID"};
23     
24     public final static Object JavaDoc[][] PARAMTYPES =
25         null;
26                 
27     public final static boolean[] SETRELEVANTS =
28         { true };
29         
30     public final static String JavaDoc SQLSTRING =
31         "DECLARE @L_NR int " +
32         "DECLARE @R_NR int " +
33         
34         "SELECT " +
35         " @L_NR = LEFT_NR, " +
36         " @R_NR = RIGHT_NR " +
37         "FROM " +
38         " SITE_TREE " +
39         "WHERE " +
40         " SITE_NODE_ID = ? " +
41         
42         "SELECT " +
43         " SITE_NODE_ID " +
44         "FROM " +
45         " SITE_TREE " +
46         "WHERE " +
47         " LEFT_NR >= @L_NR " +
48         " AND RIGHT_NR <= @R_NR " +
49         "ORDER BY " +
50         " LEFT_NR ";
51     
52     public void initQuery(Connection con) {
53         super.initQuery(
54             con,
55             ISPREPARED,
56             PARAMORDER,
57             PARAMTYPES,
58             SETRELEVANTS,
59             SQLSTRING );
60     }
61 }
62
63
Popular Tags