KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBSiteTreeIsChild.java,v 1.2 2001/08/15 12:50:09 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sybase;
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     public final static boolean isPrepared =
21         true;
22     
23     public final static String JavaDoc[] paramOrder =
24         { "CHILD_ID", "PARENT_ID" };
25     
26     public final static Object JavaDoc[][] paramTypes =
27         null;
28         
29     public final static boolean[] setRelevants =
30         { true };
31         
32     public final static String JavaDoc sqlString =
33         "DECLARE @ISCHILD int " +
34         "DECLARE @LNR int " +
35         "DECLARE @RNR int " +
36         
37         "SELECT " +
38         " @LNR = LEFT_NR, " +
39         " @RNR = RIGHT_NR " +
40         "FROM " +
41         " SITE_TREE " +
42         "WHERE " +
43         " SITE_NODE_ID = ? " +
44         
45         "SELECT @ISCHILD = 0 " +
46         
47         "IF EXISTS ( " +
48             "SELECT " +
49             " 1 " +
50             "FROM " +
51             " SITE_TREE " +
52             "WHERE " +
53             " LEFT_NR < @LNR " +
54             "AND " +
55             " RIGHT_NR > @RNR " +
56             "AND " +
57             " SITE_NODE_ID = ? " +
58             ") " +
59                 " SELECT @ISCHILD = 1 " +
60         "SELECT @ISCHILD AS ISCHILD ";
61             
62     
63     public void initQuery(Connection con) {
64         super.initQuery(
65             con,
66             isPrepared,
67             paramOrder,
68             paramTypes,
69             setRelevants,
70             sqlString );
71     }
72 }
73
74
Popular Tags