1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class SelectChildExists extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = 12 { 13 "LEFT_NR", 14 "RIGHT_NR", 15 "PARENT_ID" 16 }; 17 18 public final static Object [][] types = null; 19 20 public final static boolean[] relevants = { true }; 21 22 public final static String sqlString = "SELECT 1 FROM CONTENT_TREE WHERE LEFT_NR < ? AND RIGHT_NR > ? AND CONTENT_NODE_ID = ?"; 23 24 public void initQuery(Connection con) { 25 super.initQuery( 26 con, 27 prepared, 28 order, 29 types, 30 relevants, 31 sqlString ); 32 } 33 34 } | Popular Tags |