|
1
4 package com.teamkonzept.webman.mainint.db.queries.oracle;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBListContentVersions extends TKPrepQuery {
10
11 public final static boolean IS_PREPARED =
12 true;
13
14 public final static String  [] PARAM_ORDER =
15 { "INSTANCE_ID", "INSTANCE_ID" };
16
17 public final static Object [][] PARAM_TYPES =
18 null;
19
20 public final static boolean[] SET_RELEVANTS =
21 { true };
22
23 public final static String SQL_STRING =
24 "SELECT * FROM (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 IS_PREPARED,
41 PARAM_ORDER,
42 PARAM_TYPES,
43 SET_RELEVANTS,
44 SQL_STRING );
45 }
46 }
47 |
Popular Tags |
Java API By Example, From Geeks To Geeks.