1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 import com.teamkonzept.webman.mainint.WebmanExceptionHandler; 6 import com.teamkonzept.webman.mainint.db.queries.content.*; 7 8 16 public class TKDBContentTreeGetParents extends TKPrepQuery 17 { 18 19 public final static boolean isPrepared = true; 20 21 public final static String [] paramOrder = { CONTENT_NODE_ID, CONTENT_NODE_ID }; 22 23 public final static Object [][] paramTypes = null; 24 25 public final static boolean[] setRelevants = { true }; 26 27 public final static String sqlString = 28 " SELECT " 29 + " * " 30 + " FROM " 31 + " CONTENT_TREE " 32 + " WHERE " 33 + " LEFT_NR <= (SELECT LEFT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ?) " 34 + " AND " 35 + " RIGHT_NR >= (SELECT RIGHT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = ?) " 36 + " ORDER BY " 37 + " LEFT_NR " ; 38 39 40 public void initQuery(Connection con) { 41 super.initQuery( 42 con, 43 isPrepared, 44 paramOrder, 45 paramTypes, 46 setRelevants, 47 sqlString ); 48 } 49 } 50 51 52 | Popular Tags |