1 4 package com.teamkonzept.field.db.queries; 5 6 import com.teamkonzept.db.*; 7 import java.sql.*; 8 9 public class TKDBContentNodeGet extends TKPrepQuery { 10 11 public final static boolean isPrepared = 12 true; 13 14 public final static String [] paramOrder = 15 { "CONTENT_ID" }; 16 17 public final static Object [][] paramTypes = 18 null; 19 20 public final static boolean[] setRelevants = 21 { true }; 22 23 public final static String sqlString = 24 "SELECT " + 25 " CONTENT_ID, CONTENT_NODE_ID, LEFT_NR, RIGHT_NR, NAME " + 26 "FROM " + 27 " CONTENT_NODE " + 28 "WHERE " + 29 " CONTENT_ID = ? " + 30 "ORDER BY " + 31 " CONTENT_NODE_ID"; 32 33 34 public void initQuery(Connection con) { 35 super.initQuery( 36 con, 37 isPrepared, 38 paramOrder, 39 paramTypes, 40 setRelevants, 41 sqlString ); 42 } 43 } 44 | Popular Tags |