KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > duplication > TKDBContentTreeGetParentsNames


1 package com.teamkonzept.webman.mainint.db.queries.duplication;
2
3 import com.teamkonzept.db.*;
4 //import com.teamkonzept.lib.*;
5
6 import java.io.*;
7 import java.util.*;
8 import java.sql.*;
9
10
11
12 /*
13  * TKDBContentTreeGetParentsNames
14  * Holt Namen aller Papas und meinen aus Content-Tree
15  *
16  * Input: CONTENT_NODE_ID
17  * Output: CONTENT_NODE_NAME
18  */
19 public class TKDBContentTreeGetParentsNames extends TKPrepQuery{
20
21     public final static boolean isPrepared =
22         true;
23     
24     public final static String JavaDoc[] paramOrder =
25         { "CONTENT_NODE_ID", "CONTENT_NODE_ID" };
26     
27     public final static Object JavaDoc[][] paramTypes =
28         null;
29                 
30     public final static boolean[] setRelevants =
31         { true };
32         
33     public final static String JavaDoc sqlString =
34         /*
35         
36         "DECLARE @LEFT_NR int " +
37         "DECLARE @RIGHT_NR int " +
38         
39         "SELECT " +
40         " @LEFT_NR = LEFT_NR, " +
41         " @RIGHT_NR = RIGHT_NR " +
42         "FROM " +
43         " CONTENT_TREE " +
44         "WHERE " +
45         " CONTENT_NODE_ID = ? " +
46         */
47         "SELECT " +
48         " CONTENT_NODE_NAME " +
49         "FROM " +
50         " CONTENT_TREE " +
51         "WHERE " +
52         " LEFT_NR <= (SELECT LEFT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ? ) " +
53         "AND " +
54         " RIGHT_NR >=(SELECT LEFT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ? ) " +
55         "ORDER BY " +
56         " LEFT_NR ";
57         
58
59     
60     public void initQuery(Connection con) {
61         super.initQuery(
62             con,
63             isPrepared,
64             paramOrder,
65             paramTypes,
66             setRelevants,
67             sqlString );
68     }
69 }
70
71
72
Popular Tags