1 package de.webman.generator.db.queries; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 15 public class GenSiteRefs 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 " DR.*, " + 32 " PC.COMPONENT_TYPE, " + 33 " PC.INTEGRATION_TYPE, " + 34 " PC.INTEGRATION_SHORTNAME, " + 35 " PC.PRESENTATION_COMPONENT_IDX, " + 36 " ST.LEFT_NR " + 37 "FROM " + 38 " SITE_TREE ST, SITE_DOCUMENT SD, PRESENTATION_COMPONENT PC, DOCUMENT_REFERENCE DR " + 39 "WHERE " + 40 " ST.SITE_NODE_ID = SD.SITE_NODE_ID " + 41 "AND " + 42 " PC.PRESENTATION_ID = SD.PRESENTATION_ID " + 43 "AND " + 44 " DR.SRC_SITE_NODE_ID = SD.SITE_NODE_ID " + 45 "AND " + 46 " DR.SRC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX " + 47 "AND " + 48 " DR.SRC_PRESENTATION_COMPONENT_IDX = PC.PRESENTATION_COMPONENT_IDX " + 49 "AND " + 50 " PC.COMPONENT_TYPE <= 2 " + 51 "ORDER BY " + 52 " ST.LEFT_NR, DR.SRC_SITE_NODE_DOC_IDX, DR.SRC_PRESENTATION_COMPONENT_IDX"; 53 54 55 public void initQuery(Connection con) { 56 super.initQuery( 57 con, 58 isPrepared, 59 paramOrder, 60 paramTypes, 61 setRelevants, 62 sqlString ); 63 } 64 } 65 | Popular Tags |