1 package de.webman.generator.db.queries; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 15 public class GenStructureConts 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 " SC.SITE_NODE_ID, " + 32 " SC.CONTENT_ID, " + 33 " SC.FORM_ID, " + 34 " ST.LEFT_NR " + 35 "FROM " + 36 " STRUCTURED_CONTENT SC, SITE_TREE ST " + 37 "WHERE " + 38 " ST.SITE_NODE_ID = SC.SITE_NODE_ID " + 39 "ORDER BY " + 40 " ST.LEFT_NR "; 41 60 61 public void initQuery(Connection con) { 62 super.initQuery( 63 con, 64 isPrepared, 65 paramOrder, 66 paramTypes, 67 setRelevants, 68 sqlString ); 69 } 70 } 71 | Popular Tags |