01: package com.teamkonzept.webman.mainint.db.queries.sitetree;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: * checkt, ob ein Dokument absolut referenziert wird
09: *
10: * @author $Author: alex $
11: * @version $Revision: 1.2 $
12: */
13: public class CheckDocumentDependency extends TKPrepQuery {
14:
15: public final static boolean IS_PREPARED = true;
16:
17: public final static String[] PARAM_ORDER = { SITE_NODE_ID,
18: DOCUMENT_SHORTNAME };
19:
20: public final static Object[][] PARAM_TYPES = null;
21:
22: public final static boolean[] SET_RELEVANTS = { true };
23:
24: public final static String SQL_STRING =
25:
26: "SELECT * FROM " + " DOCUMENT_REFERENCE DR , SITE_DOCUMENT SD"
27: + " WHERE " + " DR.DEST_SITE_NODE_ID = ? "
28: + " AND "
29: + " DR.DEST_SITE_NODE_DOC_SHORTNAME = ? AND"
30: + " DR.REFERENCE_TYPE = 1"
31: + // absolute Referenz
32: " AND "
33: + " DR.SRC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX AND "
34: + " DR.SRC_SITE_NODE_ID = SD.SITE_NODE_ID";
35:
36: public void initQuery(Connection con) {
37: super.initQuery(con, IS_PREPARED, PARAM_ORDER, PARAM_TYPES,
38: SET_RELEVANTS, SQL_STRING);
39: }
40:
41: }
|