KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > generator > db > queries > GenContNodeConts


1 package de.webman.generator.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * DBGenContNodeConts
8  * Holt alle verwendeten Inhaltsknoten und Inhalte der Site
9  *
10  * @deprecated wird abgelöst durch DBGenContNodeConts_Part_1 und DBGenContNodeConts_Part_2
11  * aus Gründend der Oracle-Compatibilität
12  *
13  * Input: Keiner
14  * Output: alle verwendeten Inhaltsknoten und Inhalte der Site
15  * @author $Author: alex $
16  * @version $Revision: 1.1 $
17  */
18 public class GenContNodeConts extends TKPrepQuery {
19   
20     public static boolean isPrepared =
21         true;
22     
23     public static String JavaDoc[] paramOrder =
24         null;
25     
26     public static Object JavaDoc[][] paramTypes =
27         null;
28         
29     public static boolean[] setRelevants =
30         { true, true };
31         
32     public static String JavaDoc sqlString =
33         "SELECT DISTINCT " +
34         " CONTENT_NODE_ID " +
35         "INTO " +
36         " #temp " +
37         "FROM " +
38         " DOCUMENT_CONTENT " +
39         "WHERE " +
40         " CONTENT_NODE_ID != NULL " +
41         "UNION " +
42         "SELECT DISTINCT " +
43         " PG_CONTENT_NODE " +
44         "FROM " +
45         " SITE_TREE " +
46         "WHERE " +
47         " PG_CONTENT_NODE != NULL " +
48         
49         "SELECT " +
50         " CT.CONTENT_NODE_ID, " +
51         " CT.CONTENT_NODE_SHORTNAME, " +
52         " CT.CONTENT_NODE_NAME, " +
53         " CT.CONTENT_NODE_TYPE, " +
54         " CT.CONTENT_FORM " +
55         "FROM " +
56         " CONTENT_TREE CT, #temp T " +
57         "WHERE " +
58         " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " +
59
60         "SELECT CV.*, CI.NAME, CT.CONTENT_NODE_ID, CT.CONTENT_NODE_TYPE, CT.CONTENT_NODE_NAME, " +
61         " CT.CONTENT_NODE_SHORTNAME, T.CONTENT_NODE_ID AS REF_NODE_ID " +
62         " FROM CONTENT_TREE CT, CONTENT_INSTANCE CI, #temp T, CONTENT_VERSION CV " +
63         "WHERE " +
64
65         " ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR " +
66         " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " +
67         " ) AND " +
68         
69         " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND " +
70         " CI.INSTANCE_ID = CV.INSTANCE_ID " +
71
72         "ORDER BY T.CONTENT_NODE_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID " +
73
74         "DROP TABLE #temp ";
75
76     
77     public void initQuery(Connection con) {
78         super.initQuery(
79             con,
80             isPrepared,
81             paramOrder,
82             paramTypes,
83             setRelevants,
84             sqlString );
85     }
86 }
87
Popular Tags