KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.generator.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * DBGenSiteDocs
8  * Holt alle Dokumente aller Knoten aus dem SITE_TREE
9  *
10  * Input: Keiner
11  * Output: alle Dokumente aller Knoten aus aus Sitetree
12  * @author $Author: alex $
13  * @version $Revision: 1.1 $
14  */

15 public class GenSiteDocs 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         " SD.*, " +
32         " T.TEMPLATE_NAME, " +
33         " ST.LEFT_NR " +
34         "FROM " +
35         " SITE_TREE ST, SITE_DOCUMENT SD, PRESENTATION P, TEMPLATE T " +
36         "WHERE " +
37         " ST.SITE_NODE_ID = SD.SITE_NODE_ID " +
38         "AND " +
39         " SD.PRESENTATION_ID = P.PRESENTATION_ID " +
40         "AND " +
41         " P.TEMPLATE_ID = T.TEMPLATE_ID " +
42         "ORDER BY " +
43         " ST.LEFT_NR, SD.SITE_NODE_DOC_IDX";
44
45     
46     public void initQuery(Connection con) {
47         super.initQuery(
48             con,
49             isPrepared,
50             paramOrder,
51             paramTypes,
52             setRelevants,
53             sqlString );
54     }
55 }
56
Popular Tags