1 5 package com.teamkonzept.webman.refsel.db.queries.sybase; 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 ISPREPARED = 19 true; 20 21 public final static String [] PARAMORDER = 22 {"SITE_NODE_ID"}; 23 24 public final static Object [][] PARAMTYPES = 25 null; 26 27 public final static boolean[] SETRELEVANTS = 28 { true }; 29 30 public final static String SQLSTRING = 31 "DECLARE @L_NR int " + 32 "DECLARE @R_NR int " + 33 34 "SELECT " + 35 " @L_NR = LEFT_NR, " + 36 " @R_NR = RIGHT_NR " + 37 "FROM " + 38 " SITE_TREE " + 39 "WHERE " + 40 " SITE_NODE_ID = ? " + 41 42 "SELECT " + 43 " SITE_NODE_ID " + 44 "FROM " + 45 " SITE_TREE " + 46 "WHERE " + 47 " LEFT_NR >= @L_NR " + 48 " AND RIGHT_NR <= @R_NR " + 49 "ORDER BY " + 50 " LEFT_NR "; 51 52 public void initQuery(Connection con) { 53 super.initQuery( 54 con, 55 ISPREPARED, 56 PARAMORDER, 57 PARAMTYPES, 58 SETRELEVANTS, 59 SQLSTRING ); 60 } 61 } 62 63 | Popular Tags |