1 4 package com.teamkonzept.webman.mainint.db.queries; 5 6 import com.teamkonzept.db.*; 7 import java.sql.*; 8 9 public class TKDBListContentVersions extends TKPrepQuery { 10 11 public final static boolean isPrepared = 12 true; 13 14 public final static String [] paramOrder = 15 { "INSTANCE_ID", "INSTANCE_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 CV.VERSION_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.STATUS_ID, CV.VERSION_DATE, CV.INFO, CV.AUTHOR, ST.STATUS FROM CONTENT_VERSION CV, VERSION_STATUS ST " + 25 "WHERE " + 26 " CV.INSTANCE_ID = ? AND " + 27 " ST.STATUS_ID = CV.STATUS_ID AND " + 28 " CV.CONTENT_ID IS NOT NULL " + 29 " UNION " + 30 " SELECT CV.VERSION_ID, CV.INSTANCE_ID, -1, CV.STATUS_ID, CV.VERSION_DATE, CV.INFO, CV.AUTHOR, ST.STATUS FROM CONTENT_VERSION CV, VERSION_STATUS ST " + 31 "WHERE " + 32 " CV.INSTANCE_ID = ? AND " + 33 " ST.STATUS_ID = CV.STATUS_ID AND " + 34 " CV.CONTENT_ID IS NULL) " + 35 " ORDER BY CONTENT_ID DESC, VERSION_DATE DESC "; 36 37 public void initQuery(Connection con) { 38 super.initQuery( 39 con, 40 isPrepared, 41 paramOrder, 42 paramTypes, 43 setRelevants, 44 sqlString ); 45 } 46 } 47 | Popular Tags |