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