1 5 package com.teamkonzept.webman.mainint.db.queries; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 21 public class TKDBDocContentDRGet extends TKPrepQuery{ 22 23 public final static boolean ISPREPARED = 24 true; 25 26 public final static String [] PARAMORDER = 27 { "PRESENTATION_ID", "SITE_NODE_ID", "SITE_NODE_DOC_IDX"}; 28 29 public final static Object [][] PARAMTYPES = 30 null; 31 32 public final static boolean[] SETRELEVANTS = 33 { true }; 34 35 public final static String SQLSTRING = 36 37 "SELECT DR.*, ST.SITE_NODE_NAME AS DEST_SITE_NODE_NAME, " + 38 " ST.SITE_NODE_SHORTNAME AS DEST_SITE_NODE_SHORTNAME " + 39 "FROM PRESENTATION_COMPONENT PM, DOCUMENT_REFERENCE DR, SITE_TREE ST " + 40 "WHERE PM.PRESENTATION_ID = ? AND PM.COMPONENT_TYPE BETWEEN 1 AND 2 " + 41 " AND DR.SRC_SITE_NODE_ID = ? AND DR.SRC_SITE_NODE_DOC_IDX = ? " + 42 " AND DR.SRC_PRESENTATION_COMPONENT_IDX = PM.PRESENTATION_COMPONENT_IDX " + 43 " AND DR.DEST_SITE_NODE_ID = ST.SITE_NODE_ID " + 44 "ORDER BY PM.PRESENTATION_COMPONENT_IDX"; 45 46 47 public void initQuery(Connection con) { 48 super.initQuery( 49 con, 50 ISPREPARED, 51 PARAMORDER, 52 PARAMTYPES, 53 SETRELEVANTS, 54 SQLSTRING ); 55 } 56 } 57 58 | Popular Tags |