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