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 SdDelOnStSub extends TKPrepQuery { 18 19 public final static boolean isPrepared = 20 true; 21 22 public final static String [] paramOrder = 23 { 24 SITE_NODE_ID, SITE_NODE_ID 25 }; 26 27 public final static Object [][] paramTypes = 28 null; 29 30 public final static boolean[] setRelevants = 31 null; 32 33 public final static String sqlString = 34 35 36 " DELETE FROM SITE_DOCUMENT " 37 + " WHERE SITE_NODE_ID IN " 38 + " ( " 39 + " SELECT SITE_NODE_ID " 40 + " FROM SITE_TREE " 41 + " WHERE " 42 + " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " 43 + " AND " 44 + " RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " 45 + " ) " ; 46 47 public void initQuery(Connection con) { 48 super.initQuery( 49 con, 50 isPrepared, 51 paramOrder, 52 paramTypes, 53 setRelevants, 54 sqlString ); 55 } 56 57 } 58 59 60 61 | Popular Tags |