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