1 package de.webman.generator.db.queries.oracle; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 15 public class GenSiteContNodes extends TKPrepQuery { 16 17 public static boolean isPrepared = 18 true; 19 20 public static String [] paramOrder = 21 null; 22 23 public static Object [][] paramTypes = 24 null; 25 26 public static boolean[] setRelevants = 27 { true }; 28 29 public static String sqlString = 30 "SELECT " + 31 " DC.SITE_NODE_ID, " + 32 " DC.SITE_NODE_DOC_IDX, " + 33 " DC.PRESENTATION_COMPONENT_IDX, " + 34 " DC.CONTENT_NODE_ID, " + 35 " CS.SELECTION_TYPE, " + 36 " CS.SELECTION_DATA, " + 37 " PC.INTEGRATION_TYPE, " + 38 " PC.INTEGRATION_SHORTNAME, " + 39 " ST.LEFT_NR " + 40 "FROM " + 41 " SITE_TREE ST, SITE_DOCUMENT SD, PRESENTATION_COMPONENT PC, DOCUMENT_CONTENT DC, CONTENT_SELECTION CS " + 42 "WHERE " + 43 " ST.SITE_NODE_ID = SD.SITE_NODE_ID " + 44 "AND " + 45 " PC.PRESENTATION_ID = SD.PRESENTATION_ID " + 46 "AND " + 47 " DC.SITE_NODE_ID = SD.SITE_NODE_ID " + 48 "AND " + 49 " DC.SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX " + 50 "AND " + 51 " DC.PRESENTATION_COMPONENT_IDX = PC.PRESENTATION_COMPONENT_IDX " + 52 "AND " + 53 " PC.COMPONENT_TYPE = 3 " + 54 "AND " + 55 DBStringFactory.leftOuterJoin(" DC.SELECTION_ID ", "CS.SELECTION_ID ") + 56 "ORDER BY " + 57 " ST.LEFT_NR, DC.SITE_NODE_DOC_IDX, DC.PRESENTATION_COMPONENT_IDX"; 58 59 60 public void initQuery(Connection con) { 61 super.initQuery( 62 con, 63 isPrepared, 64 paramOrder, 65 paramTypes, 66 setRelevants, 67 sqlString ); 68 } 69 } 70 | Popular Tags |