01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class SelectContentNodeIDContentNodeShortnameFromContentTree
07: extends TKPrepQuery {
08:
09: public final static boolean prepared = true;
10:
11: public final static String[] order = { "LEFT_NR", "RIGHT_NR" };
12:
13: public final static Object[][] types = null;
14:
15: public final static boolean[] relevants = { true };
16:
17: public final static String sqlString = "SELECT CONTENT_NODE_ID, CONTENT_NODE_SHORTNAME FROM CONTENT_TREE WHERE LEFT_NR <= ? AND RIGHT_NR >= ? ORDER BY LEFT_NR";
18:
19: public void initQuery(Connection con) {
20: super.initQuery(con, prepared, order, types, relevants,
21: sqlString);
22: }
23:
24: }
|