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 TKWMDBDaughterNodes extends TKPrepQuery { 17 18 public final static boolean IS_PREPARED = 19 true; 20 21 public final static String [] PARAM_ORDER = 22 {"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 32 "SELECT " + 33 " SITE_NODE_ID " + 34 "FROM " + 35 " SITE_TREE " + 36 "WHERE " + 37 " SITE_NODE_PARENT = ? " + 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 |