KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/oracle/Attic/TKDBSiteTreeIsChild.java,v 1.4 2001/09/04 09:01:35 ralf Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.oracle;
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  */
18 public class TKDBSiteTreeIsChild extends TKPrepQuery
19 {
20
21     public final static boolean IS_PREPARED = true;
22
23     public final static String JavaDoc[] PARAM_ORDER =
24     { PARENT_ID, CHILD_ID, PARENT_ID, CHILD_ID };
25
26     public final static Object JavaDoc[][] PARAM_TYPES = null;
27
28     public final static boolean[] SET_RELEVANTS = { true };
29
30     public final static String JavaDoc SQL_STRING =
31     " SELECT (case when COUNT(*) > 0 then 1 else 0 end ) ISCHILD FROM SITE_TREE "
32     + " WHERE LEFT_NR > ( SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) " /* PARENT_ID */
33     + " AND " + " LEFT_NR <= ( SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) " /* CHILD_ID */
34     + " AND " + " RIGHT_NR < ( SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) " /* PARENT_ID */
35     + " AND " + " RIGHT_NR > = ( SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " /*CHILD_ID */
36      ;
37
38
39     public void initQuery(Connection con)
40     {
41     super.initQuery(con,
42             IS_PREPARED,
43             PARAM_ORDER, PARAM_TYPES, SET_RELEVANTS, SQL_STRING);
44     }
45 }
46
Popular Tags