KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/sybase/TKWMDBCousinsNodes.java,v 1.1 2001/09/18 15:53:39 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  * TKWMDBCousinNodes
13  * holt alle knoten, die einen gemeinsamen "Grossmutter"-Knoten haben.
14  * @author
15  * @version
16  */

17 public class TKWMDBCousinsNodes extends TKPrepQuery {
18
19     public final static boolean ISPREPARED =
20         true;
21     
22     public final static String JavaDoc[] PARAMORDER =
23         {"SITE_NODE_ID"};
24     
25     public final static Object JavaDoc[][] PARAMTYPES =
26         null;
27                 
28     public final static boolean[] SETRELEVANTS =
29         { true };
30         
31     public final static String JavaDoc SQLSTRING =
32         
33         "DECLARE @ID int " +
34         
35         // zunaechst die grossmutter suchen
36
"SELECT " +
37         " @ID = T1.SITE_NODE_PARENT " +
38         "FROM " +
39         " SITE_TREE T1, " +
40         " SITE_TREE T2 " +
41         "WHERE " +
42         " T2.SITE_NODE_ID = ? " +
43         "AND " +
44         " T2.SITE_NODE_PARENT = T1.SITE_NODE_ID " +
45         
46         // jetzt die enkel dazu
47
"SELECT DISTINCT " +
48         " T1.SITE_NODE_ID " +
49         "FROM " +
50         " SITE_TREE T1, " +
51         " SITE_TREE T2 " +
52         "WHERE " +
53         " T1.SITE_NODE_PARENT = T2.SITE_NODE_ID " +
54         "AND " +
55         " T2.SITE_NODE_PARENT = @ID " +
56         "ORDER BY " +
57         " T1.LEFT_NR ";
58     
59     public void initQuery(Connection con) {
60         super.initQuery(
61             con,
62             ISPREPARED,
63             PARAMORDER,
64             PARAMTYPES,
65             SETRELEVANTS,
66             SQLSTRING );
67     }
68 }
69
70
Popular Tags