KickJava   Java API By Example, From Geeks To Geeks.

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


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 CsDelOnStSubViaDoc class here>
12  * @author marwan
13  * @version
14  */
15
16
17 public class CsDelOnStSubViaDoc extends TKPrepQuery{
18
19 public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         {
24             SITE_NODE_ID, SITE_NODE_ID
25         };
26     
27     public final static Object JavaDoc[][] paramTypes =
28         null;
29     
30     public final static boolean[] setRelevants =
31         null;
32         
33     public final static String JavaDoc sqlString =
34     /* CsDelOnStSubViaDoc */
35
36       " DELETE FROM CONTENT_SELECTION "
37      + " WHERE SELECTION_ID IN "
38      + " ( "
39      + " SELECT SELECTION_ID "
40      + " FROM DOCUMENT_CONTENT, SITE_TREE "
41      + " WHERE "
42      + " DOCUMENT_CONTENT.SITE_NODE_ID = SITE_TREE.SITE_NODE_ID "
43      + " AND "
44      + " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
45      + " AND "
46      + " RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
47      + " ) " ;
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
61 }
62
63
64 /* @(#)CsDelOnStSubViaDoc.java */
65
Popular Tags