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