01: package com.teamkonzept.webman.mainint.db.queries.sitetree;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: * CsDelOnStSub.java
09: *
10: * Description: <describe the CsDelOnStSub class here>
11: * @author marwan
12: * @version
13: */
14:
15: public class CsClear extends TKPrepQuery {
16:
17: public final static boolean isPrepared = true;
18:
19: public final static String[] paramOrder = null;
20:
21: public final static Object[][] paramTypes = null;
22:
23: public final static boolean[] setRelevants = null;
24:
25: public final static String sqlString =
26:
27: " DELETE FROM CONTENT_SELECTION " + " WHERE SELECTION_ID NOT IN "
28: + " ( " + " SELECT PG_SELECTION_ID " + " FROM SITE_TREE "
29: + " UNION " + " SELECT SELECTION_ID "
30: + " FROM DOCUMENT_CONTENT " + " ) ";
31:
32: public void initQuery(Connection con) {
33: super .initQuery(con, isPrepared, paramOrder, paramTypes,
34: setRelevants, sqlString);
35: }
36:
37: }
38:
39: /* @(#)CsDelOnStSub.java */
|