KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.sitetree;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7
8 /**
9  * CsDelOnStSub.java
10  *
11  * Description: <describe the CsDelOnStSub class here>
12  * @author marwan
13  * @version
14  */
15
16
17 public class CsClear extends TKPrepQuery {
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         null;
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
34       " DELETE FROM CONTENT_SELECTION "
35      + " WHERE SELECTION_ID NOT IN "
36      + " ( "
37      + " SELECT PG_SELECTION_ID "
38      + " FROM SITE_TREE "
39      + " UNION "
40      + " SELECT SELECTION_ID "
41      + " FROM DOCUMENT_CONTENT "
42      + " ) " ;
43
44     public void initQuery(Connection con) {
45         super.initQuery(
46             con,
47             isPrepared,
48             paramOrder,
49             paramTypes,
50             setRelevants,
51             sqlString );
52     }
53
54 }
55
56
57 /* @(#)CsDelOnStSub.java */
58
Popular Tags