KickJava   Java API By Example, From Geeks To Geeks.

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


1
2 package com.teamkonzept.webman.mainint.db.queries.sitetree;
3
4 import java.sql.*;
5
6 import com.teamkonzept.db.*;
7
8
9 /**
10  * StDelSub.java
11  *
12  * Description: <describe the StDelSub class here>
13  * @author marwan
14  * @version
15  */
16
17
18 public class StDelSub extends TKPrepQuery {
19
20 public final static boolean isPrepared =
21         true;
22     
23     public final static String JavaDoc[] paramOrder =
24         {
25             SITE_NODE_ID, SITE_NODE_ID
26         };
27     
28     public final static Object JavaDoc[][] paramTypes =
29         null;
30     
31     public final static boolean[] setRelevants =
32         null;
33         
34     public final static String JavaDoc sqlString =
35       
36     /* StDelSub */
37
38       " DELETE 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
59
60 /* @(#)StDelSub.java */
61
Popular Tags