KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sitetree > InheritedSiteStucture


1 package com.teamkonzept.webman.mainint.db.queries.sitetree;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7
8 /**
9  * OBSOLETE
10  *
11  * Description: <describe the CsDelOnStSub class here>
12  * @author marwan
13  * @version
14  */

15
16
17 public class InheritedSiteStucture extends TKPrepQuery {
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         {
24             FORM_ID,
25             SITE_NODE_ID,
26             SITE_NODE_ID
27         };
28     
29     public final static Object JavaDoc[][] paramTypes =
30         null;
31     
32     public final static boolean[] setRelevants =
33         {true};
34         
35     public final static String JavaDoc sqlString =
36      
37            " SELECT * "
38          + " FROM "
39          + " SITE_TREE S_T, STRUCTURED_CONTENT S_C "
40          + " WHERE "
41          + " S_T.SITE_NODE_ID = S_C.SITE_NODE_ID "
42          + " AND S_C.FORM_ID = ? "
43          + " AND "
44          + " S_T.LEFT_NR <= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) "
45          + " AND "
46          + " S_T.RIGHT_NR >= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) "
47          + " ORDER BY LEFT_NR DESC "
48         ;
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 }
61
62
63 /* @(#)CsDelOnStSub.java */
64
Popular Tags