KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.generator.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /**
7  * DBGenContNodeConts_Part_1
8  * renders the first resultset of the query DBGenContNodeConts
9  *
10  * @see DBGenContNodeConts
11  * Input: Keiner
12  * Output: alle verwendeten Inhaltsknoten und Inhalte der Site
13  * @author $Author: alex $
14  * @version $Revision: 1.1 $
15  */
16 public class GenContNodeConts_Part_1 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         /* DBGenContNodeConts_Part_1 */
32
33         
34        " SELECT CONTENT_TREE.* "
35      + " FROM CONTENT_TREE, SITE_TREE "
36      + " WHERE CONTENT_NODE_ID = PG_CONTENT_NODE "
37
38      + " UNION "
39
40      + " SELECT CONTENT_TREE.* "
41      + " FROM CONTENT_TREE, DOCUMENT_CONTENT "
42      + " WHERE CONTENT_TREE.CONTENT_NODE_ID = DOCUMENT_CONTENT.CONTENT_NODE_ID "
43
44 ;
45
46     
47     public void initQuery(Connection con) {
48         super.initQuery(
49             con,
50             isPrepared,
51             paramOrder,
52             paramTypes,
53             setRelevants,
54             sqlString );
55     }
56 }
57
Popular Tags