01: /**
02: * Jedes Selectstatement erhaelt eine eigene Klasse
03: */package com.teamkonzept.webman.mainint.db.queries;
04:
05: import com.teamkonzept.db.*;
06: import java.sql.*;
07:
08: public class TKDBListContentVersions extends TKPrepQuery {
09:
10: public final static boolean isPrepared = true;
11:
12: public final static String[] paramOrder = { "INSTANCE_ID",
13: "INSTANCE_ID" };
14:
15: public final static Object[][] paramTypes = null;
16:
17: public final static boolean[] setRelevants = { true };
18:
19: public final static String sqlString = "(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 "
20: + "WHERE "
21: + " CV.INSTANCE_ID = ? AND "
22: + " ST.STATUS_ID = CV.STATUS_ID AND "
23: + " CV.CONTENT_ID IS NOT NULL "
24: + " UNION "
25: + " 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 "
26: + "WHERE "
27: + " CV.INSTANCE_ID = ? AND "
28: + " ST.STATUS_ID = CV.STATUS_ID AND "
29: + " CV.CONTENT_ID IS NULL) "
30: + " ORDER BY CONTENT_ID DESC, VERSION_DATE DESC ";
31:
32: public void initQuery(Connection con) {
33: super.initQuery(con, isPrepared, paramOrder, paramTypes,
34: setRelevants, sqlString);
35: }
36: }
|