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 TKDBGetAllNodeContentsSortedByName 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: + " CONTENT_NODE_ID, CONTENT_NODE_NAME, CONTENT_NODE_SHORTNAME "
33: + "FROM " + " CONTENT_TREE " + "WHERE "
34: + " CONTENT_NODE_PARENT = ? " +
35:
36: "ORDER BY " + DBStringFactory.upper_order()
37: + "(CONTENT_NODE_NAME) ";
38:
39: public void initQuery(Connection con) {
40: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
41: SETRELEVANTS, SQLSTRING);
42: }
43: }
|