1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 8 14 15 public class DocDependency extends TKPrepQuery { 16 17 public final static boolean IS_PREPARED = 18 true; 19 20 public final static String [] PARAM_ORDER = 21 { 22 "SITE_NODE_ID", "SITE_NODE_ID", "SITE_NODE_ID", "SITE_NODE_ID" 23 }; 24 25 public final static Object [][] PARAM_TYPES = 26 null; 27 28 public final static boolean[] SET_RELEVANTS = {true}; 29 30 public final static String 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 |