KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * TKDBContentTreeGetParents
8  * Holt Infos ueber mich und Papa
9  *
10  * Input: CONTENT_NODE_ID
11  * Output: CONTENT_ID, CONTENT_NODE_SHORTNAME
12  */
13 public class TKDBContentTreeGetParentInfo extends TKPrepQuery {
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "CONTENT_NODE_ID", "CONTENT_NODE_ID" };
20     
21     public final static Object JavaDoc[][] paramTypes =
22         null;
23                 
24     public final static boolean[] setRelevants =
25         { true };
26         
27     public final static String JavaDoc sqlString =
28         
29         "SELECT " +
30         " CONTENT_NODE_ID, CONTENT_NODE_SHORTNAME, CONTENT_NODE_TYPE, CONTENT_FORM, CONTENT_NODE_NAME " +
31         "FROM " +
32         " CONTENT_TREE " +
33         "WHERE " +
34         " CONTENT_NODE_ID=? " +
35         "OR " +
36         " CONTENT_NODE_ID = (SELECT CONTENT_NODE_PARENT FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ?) " +
37         "ORDER BY " +
38         " LEFT_NR ";
39         
40
41     
42     public void initQuery(Connection con) {
43         super.initQuery(
44             con,
45             isPrepared,
46             paramOrder,
47             paramTypes,
48             setRelevants,
49             sqlString );
50     }
51 }
52
Popular Tags