01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/db/queries/TKWMDBDaughterNodes.java,v 1.6 2001/09/18 15:23:22 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: * TKWMDBDaughterNodes
13: * @author
14: * @version
15: */
16: public class TKWMDBDaughterNodes 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 " + " SITE_NODE_ID " + "FROM " + " SITE_TREE " + "WHERE "
29: + " SITE_NODE_PARENT = ? " + "ORDER BY " + " LEFT_NR ";
30:
31: public void initQuery(Connection con) {
32: super.initQuery(con, IS_PREPARED, PARAM_ORDER, PARAM_TYPES,
33: SET_RELEVANTS, SQL_STRING);
34: }
35: }
|