01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/TKWMDBSisterNodes.java,v 1.6 2001/09/18 15:28:53 markus Exp $
03: *
04: */
05: package com.teamkonzept.webman.refsel.db.queries;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: /*
12: * TKWMDBSisterNodes
13: * @author
14: * @version
15: */
16: public class TKWMDBSisterNodes extends TKPrepQuery {
17:
18: public final static boolean IS_PREPARED = true;
19:
20: public final static String[] PARAM_ORDER = { SITE_NODE_ID };
21:
22: public final static Object[][] PARAM_TYPES = null;
23:
24: public final static boolean[] SET_RELEVANTS = { true };
25:
26: public final static String SQL_STRING =
27:
28: "SELECT "
29: + " SITE_NODE_ID "
30: + "FROM "
31: + " SITE_TREE "
32: + "WHERE "
33: + " SITE_NODE_PARENT = (SELECT SITE_NODE_PARENT FROM SITE_TREE WHERE SITE_NODE_ID = ? ) "
34: + "ORDER BY " + " LEFT_NR ";
35:
36: public void initQuery(Connection con) {
37: super.initQuery(con, IS_PREPARED, PARAM_ORDER, PARAM_TYPES,
38: SET_RELEVANTS, SQL_STRING);
39: }
40: }
|