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
12: * @author
13: * @version
14: */
15: public class TKDBContentTreeGetTypeOrderByName extends TKPrepQuery {
16:
17: public final static boolean ISPREPARED = true;
18:
19: public final static String[] PARAMORDER = { "CONTENT_NODE_TYPE" };
20:
21: public final static Object[][] PARAMTYPES = null;
22:
23: public final static boolean[] SETRELEVANTS = { true };
24:
25: /** Das sql-stm. */
26: public final static String SQLSTRING = "SELECT " + " * " + "FROM "
27: + " CONTENT_TREE " + "WHERE " + " CONTENT_NODE_TYPE = ? "
28: + "ORDER BY " + DBStringFactory.upper_order()
29: + " (CONTENT_NODE_NAME) ";
30:
31: public void initQuery(Connection con) {
32: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
33: SETRELEVANTS, SQLSTRING);
34: }
35: }
|