1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class SelectGroupContentChilds extends TKPrepQuery 7 { 8 9 public final static boolean PREPARED = true; 10 11 public final static String [] ORDER = { "CONTENT_NODE_ID" }; 12 13 public final static Object [][] TYPES = null; 14 15 public final static boolean[] RELEVANTS = { true }; 16 17 public final static String SQL_STRING = 18 "SELECT CT.CONTENT_NODE_ID, CT.CONTENT_NODE_NAME, CT.CONTENT_NODE_SHORTNAME, " + 19 "CI.INSTANCE_ID " + 20 "FROM CONTENT_TREE CT, CONTENT_INSTANCE CI WHERE CT.CONTENT_NODE_PARENT = ? AND " + 21 "CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID"; 22 23 public void initQuery(Connection con) { 24 super.initQuery( 25 con, 26 PREPARED, 27 ORDER, 28 TYPES, 29 RELEVANTS, 30 SQL_STRING ); 31 } 32 33 } | Popular Tags |