KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/sybase/TKWMDBSisterNodes.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 TKWMDBSisterNodes 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 @ID int " +
32         
33         "SELECT " +
34         " @ID = SITE_NODE_PARENT " +
35         "FROM " +
36         " SITE_TREE " +
37         "WHERE " +
38         " SITE_NODE_ID = ? " +
39         
40         "SELECT " +
41         " SITE_NODE_ID " +
42         "FROM " +
43         " SITE_TREE " +
44         "WHERE " +
45         " SITE_NODE_PARENT = @ID " +
46         "ORDER BY " +
47         " LEFT_NR ";
48     
49     public void initQuery(Connection con) {
50         super.initQuery(
51             con,
52             ISPREPARED,
53             PARAMORDER,
54             PARAMTYPES,
55             SETRELEVANTS,
56             SQLSTRING );
57     }
58 }
59
60
Popular Tags