1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 10 public class TKIntershopContentInstanceGet extends TKPrepQuery { 11 12 public final static boolean isPrepared = 13 true; 14 15 public final static String [] paramOrder = 16 { "CONTENT_NODE_SHORTNAME" }; 17 18 public final static Object [][] paramTypes = 19 null; 20 21 public final static boolean[] setRelevants = 22 { true }; 23 24 public final static String sqlString = 25 "SELECT INSTANCE_ID, CONTENT_NODE_ID FROM CONTENT_INSTANCE " + 26 "WHERE CONTENT_NODE_ID = (SELECT MAX(CONTENT_NODE_ID) FROM CONTENT_TREE WHERE " + 27 "CONTENT_NODE_SHORTNAME = ?) "; 28 29 public void initQuery(Connection con) { 30 super.initQuery( 31 con, 32 isPrepared, 33 paramOrder, 34 paramTypes, 35 setRelevants, 36 sqlString ); 37 } 38 } 39 | Popular Tags |