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