1 package com.teamkonzept.field.db.queries; 2 3 import com.teamkonzept.db.*; 4 import com.teamkonzept.lib.*; 5 6 import java.io.*; 7 import java.util.*; 8 import java.sql.*; 9 10 19 20 public class TKDBGetAllNodeContentsWithInstanceID extends TKPrepQuery{ 21 22 public final static boolean ISPREPARED = 23 true; 24 25 public final static String [] PARAMORDER = 26 { "CONTENT_NODE_ID" }; 27 28 public final static Object [][] PARAMTYPES = 29 null; 30 31 public final static boolean[] SETRELEVANTS = 32 { true }; 33 34 35 public final static String SQLSTRING = 36 "SELECT " + 37 " T.*, CI.INSTANCE_ID " + 38 "FROM " + 39 " CONTENT_TREE T, CONTENT_INSTANCE CI " + 40 "WHERE " + 41 " T.CONTENT_NODE_PARENT = ? AND T.CONTENT_NODE_ID=CI.CONTENT_NODE_ID " + 42 43 "ORDER BY " + DBStringFactory.upper_order() + "(T.CONTENT_NODE_NAME) "; 44 45 46 public void initQuery(Connection con) { 47 super.initQuery( 48 con, 49 ISPREPARED, 50 PARAMORDER, 51 PARAMTYPES, 52 SETRELEVANTS, 53 SQLSTRING ); 54 } 55 } | Popular Tags |