KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.sybase;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * TKDBContentTreeIsChild
8  * Sagt ob die CHILD_ID ein Nachfolger von PARENT_ID im CONTENT_TREE ist
9  *
10  * Input: PARENT_ID CHILD_ID
11  * Output: ISCHILD = 1 oder 0
12  */
13 public class TKDBContentTreeIsChild extends TKPrepQuery {
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "CHILD_ID", "PARENT_ID" };
20     
21     public final static Object JavaDoc[][] paramTypes =
22         null;
23         
24     public final static boolean[] setRelevants =
25         { true };
26         
27     public final static String JavaDoc sqlString =
28         "DECLARE @ISCHILD int " +
29         "DECLARE @LNR int " +
30         "DECLARE @RNR int " +
31         
32         "SELECT " +
33         " @LNR = LEFT_NR, " +
34         " @RNR = RIGHT_NR " +
35         "FROM " +
36         " CONTENT_TREE " +
37         "WHERE " +
38         " CONTENT_NODE_ID = ? " +
39         
40         "SELECT @ISCHILD = 0 " +
41         
42         "IF EXISTS ( " +
43             "SELECT " +
44             " 1 " +
45             "FROM " +
46             " CONTENT_TREE " +
47             "WHERE " +
48             " LEFT_NR < @LNR " +
49             "AND " +
50             " RIGHT_NR > @RNR " +
51             "AND " +
52             " CONTENT_NODE_ID = ? " +
53             ") " +
54                 " SELECT @ISCHILD = 1 " +
55         "SELECT @ISCHILD AS ISCHILD ";
56             
57     
58     public void initQuery(Connection con) {
59         super.initQuery(
60             con,
61             isPrepared,
62             paramOrder,
63             paramTypes,
64             setRelevants,
65             sqlString );
66     }
67 }
68
Popular Tags