KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.generator.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * DBGenStructureConts
8  * Holt alle verwendeten Struktur-Inhalte der Site
9  *
10  * Input: Keiner
11  * Output: alle verwendeten Struktur-Inhalte der Site
12  * @author $Author: alex $
13  * @version $Revision: 1.1 $
14  */

15 public class GenStructureConts extends TKPrepQuery {
16
17     public static boolean isPrepared =
18         true;
19     
20     public static String JavaDoc[] paramOrder =
21         null;
22     
23     public static Object JavaDoc[][] paramTypes =
24         null;
25         
26     public static boolean[] setRelevants =
27         { true };
28     
29         public static String JavaDoc sqlString =
30         "SELECT " +
31         " SC.SITE_NODE_ID, " +
32         " SC.CONTENT_ID, " +
33         " SC.FORM_ID, " +
34         " ST.LEFT_NR " +
35         "FROM " +
36         " STRUCTURED_CONTENT SC, SITE_TREE ST " +
37         "WHERE " +
38         " ST.SITE_NODE_ID = SC.SITE_NODE_ID " +
39         "ORDER BY " +
40         " ST.LEFT_NR ";
41         /*frank original version geht nicht da structure contet noch
42         nicht in Versionsverwaltung...
43         public final static String sqlString =
44         "SELECT " +
45         " SC.SITE_NODE_ID, " +
46         " SC.CONTENT_ID, " +
47         " SC.FORM_ID, " +
48         " ST.LEFT_NR " +
49         "FROM " +
50         " STRUCTURED_CONTENT SC, SITE_TREE ST, CONTENT_VERSION CV, " +
51         " CONTENT_INSTANCE CI, CONTENT_TREE CT " +
52         "WHERE " +
53         " ST.SITE_NODE_ID = SC.SITE_NODE_ID AND " +
54         " CV.CONTENT_ID = SC.CONTENT_ID AND " +
55         " CI.INSTANCE_ID = CV.INSTANCE_ID AND " +
56         " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID " +
57         "ORDER BY " +
58         " ST.LEFT_NR, CT.CONTENT_NODE_SHORTNAME ";
59         */

60     
61     public void initQuery(Connection con) {
62         super.initQuery(
63             con,
64             isPrepared,
65             paramOrder,
66             paramTypes,
67             setRelevants,
68             sqlString );
69     }
70 }
71
Popular Tags