KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBSiteTreeIsChild.java,v 1.10 2001/11/22 08:39:31 ralf 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  * TKDBSiteTreeIsChild
13  * Sagt ob die CHILD_ID ein Nachfolger von PARENT_ID im SITE_TREE ist
14  *
15  * Input: PARENT_ID CHILD_ID
16  * Output: ISCHILD = 1 oder 0
17  * @author
18  * @version
19  */
20 public class TKDBSiteTreeIsChild extends TKPrepQuery
21 {
22
23     public static final boolean ISPREPARED = true;
24     public static final String JavaDoc[] PARAMORDER =
25     { PARENT_ID, CHILD_ID, PARENT_ID, CHILD_ID };
26     public static final Object JavaDoc[][] PARAMTYPES = null;
27     public static final boolean[] SETRELEVANTS = { true };
28
29     public static final String JavaDoc SQLSTRING = (new StringBuffer JavaDoc(
30     "SELECT (CASE WHEN COUNT(*) > 0 THEN 1 ELSE 0 END ) AS ISCHILD FROM SITE_TREE")
31     .append(" WHERE LEFT_NR > (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?)")
32     .append(" AND LEFT_NR <= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?)")
33     .append(" AND RIGHT_NR < (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?)")
34     .append(" AND RIGHT_NR >= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?)")
35     ).toString();
36
37     public void initQuery(Connection con)
38     {
39     super.initQuery(con,
40             ISPREPARED,
41             PARAMORDER, PARAMTYPES, SETRELEVANTS, SQLSTRING);
42     }
43 }
44
Popular Tags