KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7
8 /**
9  * checkt, ob ein Dokument absolut referenziert wird
10  *
11  * @author $Author: markus $
12  * @version $Revision: 1.9 $
13  */

14
15 public class DocDependency extends TKPrepQuery {
16
17     public final static boolean IS_PREPARED =
18         true;
19     
20     public final static String JavaDoc[] PARAM_ORDER =
21         {
22             "SITE_NODE_ID", "SITE_NODE_ID", "SITE_NODE_ID", "SITE_NODE_ID"
23         };
24     
25     public final static Object JavaDoc[][] PARAM_TYPES =
26         null;
27     
28     public final static boolean[] SET_RELEVANTS = {true};
29         
30     public final static String JavaDoc SQL_STRING =
31         "SELECT "+
32         " DR.SRC_SITE_NODE_ID AS SITE_NODE_ID, "+
33         " DR.SRC_SITE_NODE_DOC_IDX, "+
34         " DR.DEST_SITE_NODE_ID, "+
35         " DR.DEST_SITE_NODE_DOC_SHORTNAME, "+
36         " SD.DOCUMENT_SHORTNAME "+
37         "FROM DOCUMENT_REFERENCE DR , SITE_DOCUMENT SD, SITE_TREE ST "+
38         "WHERE "+
39         " DR.DEST_SITE_NODE_ID = ST.SITE_NODE_ID AND "+
40         " ST.LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) AND "+
41         " ST.RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) AND "+
42         " DR.REFERENCE_TYPE = 1 AND "+
43         " DR.SRC_SITE_NODE_ID = SD.SITE_NODE_ID AND "+
44         " DR.SRC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX AND "+
45         " DR.SRC_SITE_NODE_ID NOT IN "+
46         " (SELECT SITE_NODE_ID FROM SITE_TREE "+
47         " WHERE LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?)" +
48         " AND RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?))";
49
50     public void initQuery(Connection con) {
51         super.initQuery(
52             con,
53             IS_PREPARED,
54             PARAM_ORDER,
55             PARAM_TYPES,
56             SET_RELEVANTS,
57             SQL_STRING );
58     }
59
60 }
61
62
Popular Tags