KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > generator > db > queries > sybase > GenContNodeConts_Part_2


1 package de.webman.generator.db.queries.sybase;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6
7
8 /**
9  * DBGenContNodeConts_Part_2
10  * renders the second resultset of the query DBGenContNodeConts
11  *
12  * @see DBGenContNodeConts
13  * @author $Author: markus $
14  * @version $Revision: 1.1 $
15  */

16 public class GenContNodeConts_Part_2 extends TKPrepQuery {
17
18     public static boolean isPrepared =
19         true;
20
21     public static String JavaDoc[] paramOrder =
22         null;
23
24     public static Object JavaDoc[][] paramTypes =
25         null;
26
27     public static boolean[] setRelevants =
28         { true };
29
30     public static String JavaDoc sqlString =
31
32
33         "SELECT DISTINCT " +
34         " CONTENT_NODE_ID " +
35         "INTO " +
36         " #temp " +
37         "FROM " +
38         " DOCUMENT_CONTENT " +
39         "WHERE " +
40         " CONTENT_NODE_ID " + DBStringFactory.notEqualsNull() +
41         "UNION " +
42         "SELECT DISTINCT " +
43         " PG_CONTENT_NODE " +
44         "FROM " +
45         " SITE_TREE " +
46         "WHERE " +
47         " PG_CONTENT_NODE " + DBStringFactory.notEqualsNull() +
48
49         /* Alex - was soll das auch ?
50         "SELECT " +
51         " CT.CONTENT_NODE_ID, " +
52         " CT.CONTENT_NODE_SHORTNAME, " +
53         " CT.CONTENT_NODE_NAME, " +
54         " CT.CONTENT_NODE_TYPE, " +
55         " CT.CONTENT_FORM " +
56         "FROM " +
57         " CONTENT_TREE CT, #temp T " +
58         "WHERE " +
59         " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " +
60         */

61         "SELECT CV.*, CI.NAME, CT.CONTENT_NODE_ID, CT.CONTENT_NODE_TYPE, CT.CONTENT_NODE_NAME, CT.CONTENT_FORM, " +
62         " CT.CONTENT_NODE_SHORTNAME, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID " +
63         " FROM CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_INSTANCE CI, #temp T, CONTENT_VERSION CV " +
64         "WHERE " +
65
66         " ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR " +
67         " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " +
68         " ) AND " +
69
70         " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND " +
71         " CI.INSTANCE_ID = CV.INSTANCE_ID AND" +
72         " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT " +
73
74         "ORDER BY T.CONTENT_NODE_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID " +
75
76         "DROP TABLE #temp ";
77
78
79     public void initQuery(Connection con) {
80         super.initQuery(
81             con,
82             isPrepared,
83             paramOrder,
84             paramTypes,
85             setRelevants,
86             sqlString );
87     }
88 }
89
Popular Tags