01: package com.teamkonzept.webman.mainint.db.queries;
02:
03: import com.teamkonzept.db.*;
04: import java.sql.*;
05:
06: /*
07: * TKDBContentTreeGetType
08: * Holt alle Contents eines Content-Tree-Knotens
09: *
10: * Input: CONTENT_NODE_TYPE
11: * Output: alle Datensaetze des Typs order by LEFT_NR
12: */
13: public class TKDBContentTreeGetType extends TKPrepQuery {
14:
15: public final static boolean isPrepared = true;
16:
17: public final static String[] paramOrder = { "CONTENT_NODE_TYPE" };
18:
19: public final static Object[][] paramTypes = null;
20:
21: public final static boolean[] setRelevants = { true };
22:
23: public final static String sqlString = "SELECT " + " * " + "FROM "
24: + " CONTENT_TREE " + "WHERE " + " CONTENT_NODE_TYPE = ? "
25: + "ORDER BY " + " LEFT_NR ";
26:
27: public void initQuery(Connection con) {
28: super.initQuery(con, isPrepared, paramOrder, paramTypes,
29: setRelevants, sqlString);
30: }
31: }
|