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