KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > oracle > TKDBGetAllTreeContentVersions


1 package com.teamkonzept.webman.mainint.db.queries.oracle;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5 import com.teamkonzept.lib.templates.*;
6
7 /**
8  * TKDBGetAllTreeNodeContentVersions
9  * Holt alle versionen aller aktuellen Contents eines Content-Tree-Knotens
10  *
11  * @author $Author: alex $
12  * @version $Revision: 1.11 $
13  */
14 public class TKDBGetAllTreeContentVersions extends TKUnprepQuery {
15
16     public static Object JavaDoc[][] paramTypes =
17         { {"SEARCH", new Integer JavaDoc(Types.VARCHAR)},
18           {"SEARCH_UNC", new Integer JavaDoc(Types.VARCHAR)} };
19
20     public static boolean[] setRelevants =
21         { true };
22
23     /** der SQL String */
24     public static String JavaDoc sqlString =
25         "SELECT " +
26         " CV.VERSION_ID, CV.INSTANCE_ID, CI.CONTENT_NODE_ID, CV.CONTENT_ID, CV.STATUS_ID, CV.VERSION_DATE, CV.AUTHOR, CV.INFO, VS.STATUS, " +
27         " CT.CONTENT_NODE_NAME, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE,CT.CONTENT_NODE_PARENT, CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_FORM, CT.CONTENT_NODE_TYPE, CI.NAME " +
28         "FROM " +
29         " CONTENT C,<TK_CASE:KENNUNG> CONTENT_VALUE CVALUE,</TK_CASE> CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_VERSION CV, VERSION_STATUS VS, CONTENT_INSTANCE CI " +
30         "WHERE " +
31
32         " CT.LEFT_NR > (SELECT LEFT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = <TK_CONTENT_NODE_ID>) AND " +
33         " CT.RIGHT_NR < (SELECT RIGHT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = <TK_CONTENT_NODE_ID>) AND " +
34
35         " CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID AND " +
36         " CV.INSTANCE_ID = CI.INSTANCE_ID AND " +
37         " C.CONTENT_ID = CV.CONTENT_ID AND " +
38         " CV.STATUS_ID = VS.STATUS_ID AND " +
39         " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT " +
40         
41         " <TK_CASE:KENNUNG> AND " +
42         " CVALUE.CONTENT_ID = CV.CONTENT_ID " +
43         " <TK_IF:KENNUNG=0> " +
44         " AND (<TK_LIST:SEARCH_STRING>(DBMS_LOB.INSTR(CVALUE.VALUE, <TK:SEARCH_UNC>) > 0) <TK:CONN> </TK_LIST>) " +
45         " </TK_IF:KENNUNG=0> " +
46         " <TK_IF:KENNUNG=1> " +
47         " AND " +
48         " ((<TK_LIST:SEARCH_STRING>(CT.CONTENT_NODE_NAME LIKE <TK:SEARCH> ESCAPE '\\' ) <TK:CONN> </TK_LIST>) " +
49         " OR " +
50         " (<TK_LIST:SEARCH_STRING>(CT.CONTENT_NODE_SHORTNAME LIKE <TK:SEARCH> ESCAPE '\\' ) <TK:CONN> </TK_LIST>)) " +
51         " </TK_IF> " +
52         " </TK_CASE> " +
53         
54         "ORDER BY " +
55         " CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID ";
56
57     public static TKTemplateSyntax sqlTmplSyntax;
58
59     public void initQuery(Connection con) {
60         try
61         {
62             sqlTmplSyntax = new TKTemplateSyntax(sqlString,"");
63         }
64         catch(com.teamkonzept.lib.TKTemplateSyntaxException e)
65         {
66             sqlString = sqlString; // für JTest
67 }
68         
69         super.initQuery(
70             con,
71             paramTypes,
72             setRelevants,
73             sqlTmplSyntax );
74     }
75 }
76
Popular Tags