KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.sitetree;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /**
8  * DocuRefDelOnStSubtree.java
9  *
10  * Description: <describe the DocuRefDelOnStSubtree class here>
11  * @author marwan
12  * @version
13  */
14
15
16 public class DocuRefDelOnStSubtree extends TKPrepQuery{
17
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         /* DocuRefDelOnStSubtree */
35      " DELETE FROM DOCUMENT_REFERENCE "
36      + " WHERE SRC_SITE_NODE_ID IN "
37      + " ( "
38      + " SELECT SITE_NODE_ID "
39      + " FROM SITE_TREE "
40      + " WHERE "
41      + " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
42      + " AND "
43      + " RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
44      + " ) "
45             ;
46     
47     public void initQuery(Connection con) {
48         super.initQuery(
49             con,
50             isPrepared,
51             paramOrder,
52             paramTypes,
53             setRelevants,
54             sqlString );
55     }
56
57
58 }
59
60
61 /* @(#)DocuRefDelOnStSubtree.java */
62
Popular Tags