KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.sitetree;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7
8 /**
9  *
10  * @author marwan
11  * @version
12  */
13
14
15 public class ScDelOnStSub extends TKPrepQuery {
16
17 public final static boolean isPrepared =
18         true;
19     
20     public final static String JavaDoc[] paramOrder =
21         {
22             SITE_NODE_ID, SITE_NODE_ID
23         };
24     
25     public final static Object JavaDoc[][] paramTypes =
26         null;
27     
28     public final static boolean[] setRelevants =
29         null;
30         
31     public final static String JavaDoc sqlString =
32
33 /* SdDelOnStSub */
34   " DELETE FROM STRUCTURED_CONTENT "
35  + " WHERE SITE_NODE_ID IN "
36  + " ( "
37  + " SELECT SITE_NODE_ID "
38  + " FROM SITE_TREE "
39  + " WHERE "
40  + " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
41  + " AND "
42  + " RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
43  + " ) " ;
44  
45  public void initQuery(Connection con) {
46         super.initQuery(
47             con,
48             isPrepared,
49             paramOrder,
50             paramTypes,
51             setRelevants,
52             sqlString );
53     }
54
55 }
56
57
58 /* @(#)SdDelOnStSub.java */
59
Popular Tags