1 package de.webman.generator.db.queries.postgresql; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 15 public class GenSiteTree 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 " ST.SITE_NODE_ID, " + 32 " ST.SITE_NODE_PARENT, " + 33 " ST.SITE_NODE_TYPE, " + 34 " ST.SITE_NODE_SHORTNAME, " + 35 " ST.SITE_NODE_NAME, "+ 36 " ST.PG_CONTENT_NODE, " + 37 " CS.SELECTION_TYPE, " + 38 " CS.SELECTION_DATA " + 39 "FROM " + 40 " SITE_TREE ST LEFT JOIN CONTENT_SELECTION CS ON ( ST.PG_SELECTION_ID = CS.SELECTION_ID ) " + 41 "ORDER BY " + 42 " LEFT_NR "; 43 44 45 public void initQuery(Connection con) { 46 super.initQuery( 47 con, 48 isPrepared, 49 paramOrder, 50 paramTypes, 51 setRelevants, 52 sqlString ); 53 } 54 } 55 | Popular Tags |