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