01: package com.teamkonzept.webman.mainint.db.queries.sitetree;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: *
09: * @author marwan
10: * @version
11: */
12:
13: public class ScDelOnStSub extends TKPrepQuery {
14:
15: public final static boolean isPrepared = true;
16:
17: public final static String[] paramOrder = { SITE_NODE_ID,
18: SITE_NODE_ID };
19:
20: public final static Object[][] paramTypes = null;
21:
22: public final static boolean[] setRelevants = null;
23:
24: public final static String sqlString =
25:
26: /* SdDelOnStSub */
27: " DELETE FROM STRUCTURED_CONTENT "
28: + " WHERE SITE_NODE_ID IN "
29: + " ( "
30: + " SELECT SITE_NODE_ID "
31: + " FROM SITE_TREE "
32: + " WHERE "
33: + " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
34: + " AND "
35: + " RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /* ? SITE_NODE_ID */
36: + " ) ";
37:
38: public void initQuery(Connection con) {
39: super .initQuery(con, isPrepared, paramOrder, paramTypes,
40: setRelevants, sqlString);
41: }
42:
43: }
44:
45: /* @(#)SdDelOnStSub.java */
|