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