KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sybase > TKDBContentTreeDependentST


1 package com.teamkonzept.webman.mainint.db.queries.sybase;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * TKDBContentTreeDependentST
8  * Liefert alle SITE_NODE_ID 's die im CONTENT_TREE zu C_NODE_ID auf
9  * SITE_TREE ref. Christian diese Liste bitte durchgehen und jeden Node einzeln
10  * loeschen
11  * Input: CONTENT_NODE_ID
12  * Output: liste SITE_NODE_ID
13  */
14 public class TKDBContentTreeDependentST extends TKPrepQuery {
15
16     public final static boolean isPrepared =
17         true;
18     
19     public final static String JavaDoc[] paramOrder =
20         { "CONTENT_NODE_ID" };
21     
22     public final static Object JavaDoc[][] paramTypes =
23         null;
24         
25     public final static boolean[] setRelevants =
26         { true };
27         
28     public final static String JavaDoc sqlString =
29         "DECLARE @L_NR INT " +
30         "DECLARE @R_NR INT " +
31     
32         "SELECT " +
33         " @L_NR = LEFT_NR, @R_NR = RIGHT_NR " +
34         "FROM " +
35         " CONTENT_TREE " +
36         "WHERE " +
37         " CONTENT_NODE_ID = ? " +
38         
39         "SELECT DISTINCT " +
40         " ST.SITE_NODE_ID " +
41         "FROM " +
42         " SITE_TREE ST, CONTENT_TREE CT " +
43         "WHERE " +
44         " ST.PG_CONTENT_NODE = CT.CONTENT_NODE_ID " +
45         "AND " +
46         " CT.LEFT_NR >= @L_NR " +
47         "AND " +
48         " CT.RIGHT_NR <= @R_NR ";
49
50     public void initQuery(Connection con) {
51         super.initQuery(
52             con,
53             isPrepared,
54             paramOrder,
55             paramTypes,
56             setRelevants,
57             sqlString );
58     }
59 }
60
Popular Tags