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: * TKDBGetAllNodeContents
12: * Holt alle Contents eines Content-Tree-Knotens
13: *
14: * Input: CONTENT_NODE_ID
15: * Output: CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME
16: */
17: public class TKDBGetAllNodeContents extends TKPrepQuery {
18:
19: public final static boolean isPrepared = true;
20:
21: public final static String[] paramOrder = { "CONTENT_NODE_ID" };
22:
23: public final static Object[][] paramTypes = null;
24:
25: public final static boolean[] setRelevants = { true };
26:
27: public final static String sqlString = "SELECT "
28: + " CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME " + "FROM "
29: + " CONTENT " + "WHERE " + " CONTENT_NODE_ID = ?";
30:
31: public void initQuery(Connection con) {
32: super.initQuery(con, isPrepared, paramOrder, paramTypes,
33: setRelevants, sqlString);
34: }
35: }
|