01: package com.teamkonzept.field.db.queries;
02:
03: import com.teamkonzept.db.*;
04: import com.teamkonzept.lib.*;
05:
06: import java.io.*;
07: import java.util.*;
08: import java.sql.*;
09:
10: /**
11: * TKDBGetAllNodeContentsSorted
12: * Holt alle Contents eines Content-Tree-Knotens
13: *
14: * Input: CONTENT_NODE_ID
15: * Output: CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME
16: * @author
17: * @version
18: */
19:
20: public class TKDBGetAllNodeContentsWithInstanceID extends TKPrepQuery {
21:
22: public final static boolean ISPREPARED = true;
23:
24: public final static String[] PARAMORDER = { "CONTENT_NODE_ID" };
25:
26: public final static Object[][] PARAMTYPES = null;
27:
28: public final static boolean[] SETRELEVANTS = { true };
29:
30: /** Das sql-stm. */
31: public final static String SQLSTRING = "SELECT "
32: + " T.*, CI.INSTANCE_ID "
33: + "FROM "
34: + " CONTENT_TREE T, CONTENT_INSTANCE CI "
35: + "WHERE "
36: + " T.CONTENT_NODE_PARENT = ? AND T.CONTENT_NODE_ID=CI.CONTENT_NODE_ID "
37: +
38:
39: "ORDER BY " + DBStringFactory.upper_order()
40: + "(T.CONTENT_NODE_NAME) ";
41:
42: public void initQuery(Connection con) {
43: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
44: SETRELEVANTS, SQLSTRING);
45: }
46: }
|