KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sitetree > CheckDocumentDependency


1 package com.teamkonzept.webman.mainint.db.queries.sitetree;
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: alex $
12  * @version $Revision: 1.2 $
13  */
14 public class CheckDocumentDependency extends TKPrepQuery {
15
16     public final static boolean IS_PREPARED =
17         true;
18     
19     public final static String JavaDoc[] PARAM_ORDER =
20         {
21             SITE_NODE_ID,
22             DOCUMENT_SHORTNAME
23         };
24     
25     public final static Object JavaDoc[][] PARAM_TYPES =
26         null;
27     
28     public final static boolean[] SET_RELEVANTS =
29         { true };
30         
31     public final static String JavaDoc SQL_STRING =
32      
33         "SELECT * FROM " +
34         " DOCUMENT_REFERENCE DR , SITE_DOCUMENT SD" +
35         " WHERE " +
36         " DR.DEST_SITE_NODE_ID = ? " +
37         " AND " +
38         " DR.DEST_SITE_NODE_DOC_SHORTNAME = ? AND" +
39         " DR.REFERENCE_TYPE = 1" + // absolute Referenz
40 " AND " +
41         " DR.SRC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX AND " +
42         " DR.SRC_SITE_NODE_ID = SD.SITE_NODE_ID" ;
43
44     public void initQuery(Connection con) {
45         super.initQuery(
46             con,
47             IS_PREPARED,
48             PARAM_ORDER,
49             PARAM_TYPES,
50             SET_RELEVANTS,
51             SQL_STRING );
52     }
53
54 }
55
56
Popular Tags