KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBSiteTreeGetParents.java,v 1.6 2001/08/15 13:18:08 markus Exp $
3  *
4  */

5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBSiteTreeGetParents
13  * Holt alle Knoten aus dem SITE_TREE
14  *
15  * Input: SITE_NODE_ID
16  * Output: alle DS aus Sitetreen die verwandt sind
17  *
18  */

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