1 package com.teamkonzept.webman.mainint.db.queries.sitetree; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 8 15 16 17 public class InheritedSiteStucture extends TKPrepQuery { 18 19 public final static boolean isPrepared = 20 true; 21 22 public final static String [] paramOrder = 23 { 24 FORM_ID, 25 SITE_NODE_ID, 26 SITE_NODE_ID 27 }; 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 * " 38 + " FROM " 39 + " SITE_TREE S_T, STRUCTURED_CONTENT S_C " 40 + " WHERE " 41 + " S_T.SITE_NODE_ID = S_C.SITE_NODE_ID " 42 + " AND S_C.FORM_ID = ? " 43 + " AND " 44 + " S_T.LEFT_NR <= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) " 45 + " AND " 46 + " S_T.RIGHT_NR >= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ? ) " 47 + " ORDER BY LEFT_NR DESC " 48 ; 49 50 public void initQuery(Connection con) { 51 super.initQuery( 52 con, 53 isPrepared, 54 paramOrder, 55 paramTypes, 56 setRelevants, 57 sqlString ); 58 } 59 60 } 61 62 63 64 | Popular Tags |