1 5 package com.teamkonzept.webman.refsel.db.queries.sybase; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 17 public class TKWMDBCousinsNodes extends TKPrepQuery { 18 19 public final static boolean ISPREPARED = 20 true; 21 22 public final static String [] PARAMORDER = 23 {"SITE_NODE_ID"}; 24 25 public final static Object [][] PARAMTYPES = 26 null; 27 28 public final static boolean[] SETRELEVANTS = 29 { true }; 30 31 public final static String SQLSTRING = 32 33 "DECLARE @ID int " + 34 35 "SELECT " + 37 " @ID = T1.SITE_NODE_PARENT " + 38 "FROM " + 39 " SITE_TREE T1, " + 40 " SITE_TREE T2 " + 41 "WHERE " + 42 " T2.SITE_NODE_ID = ? " + 43 "AND " + 44 " T2.SITE_NODE_PARENT = T1.SITE_NODE_ID " + 45 46 "SELECT DISTINCT " + 48 " T1.SITE_NODE_ID " + 49 "FROM " + 50 " SITE_TREE T1, " + 51 " SITE_TREE T2 " + 52 "WHERE " + 53 " T1.SITE_NODE_PARENT = T2.SITE_NODE_ID " + 54 "AND " + 55 " T2.SITE_NODE_PARENT = @ID " + 56 "ORDER BY " + 57 " T1.LEFT_NR "; 58 59 public void initQuery(Connection con) { 60 super.initQuery( 61 con, 62 ISPREPARED, 63 PARAMORDER, 64 PARAMTYPES, 65 SETRELEVANTS, 66 SQLSTRING ); 67 } 68 } 69 70 | Popular Tags |