KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBContentTreeGetParents


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
6 import com.teamkonzept.webman.mainint.db.queries.content.*;
7
8 /*
9  * Standard SQL
10  * TKDBContentTreeGetParents
11  * Holt alle Papas und mich eines Content-Tree-Knotens
12  *
13  * Input: CONTENT_NODE_ID
14  * Output: CONTENT_ID, CONTENT_NODE_SHORTNAME
15  */

16 public class TKDBContentTreeGetParents extends TKPrepQuery
17 {
18
19     public final static boolean isPrepared = true;
20
21     public final static String JavaDoc[] paramOrder = { CONTENT_NODE_ID, CONTENT_NODE_ID };
22
23     public final static Object JavaDoc[][] paramTypes = null;
24
25     public final static boolean[] setRelevants = { true };
26
27     public final static String JavaDoc sqlString =
28          " SELECT "
29          + " * "
30          + " FROM "
31          + " CONTENT_TREE "
32          + " WHERE "
33          + " LEFT_NR <= (SELECT LEFT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ?) " /*?CONTENT_NODE_ID */
34          + " AND "
35          + " RIGHT_NR >= (SELECT RIGHT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ?) " /*?CONTENT_NODE_ID */
36          + " ORDER BY "
37          + " LEFT_NR " ;
38          
39          
40     public void initQuery(Connection con) {
41         super.initQuery(
42             con,
43             isPrepared,
44             paramOrder,
45             paramTypes,
46             setRelevants,
47             sqlString );
48     }
49 }
50         
51    
52
Popular Tags