KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.generator.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * DBGenSiteTree
8  * Holt alle Knoten aus dem SITE_TREE
9  *
10  * Input: Keiner
11  * Output: alle Knoten aus Sitetree
12  * @author $Author: markus $
13  * @version $Revision: 1.2 $
14  */
15 public class GenSiteTree 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         " ST.SITE_NODE_ID, " +
32         " ST.SITE_NODE_PARENT, " +
33         " ST.SITE_NODE_TYPE, " +
34         " ST.SITE_NODE_SHORTNAME, " +
35         " ST.SITE_NODE_NAME, "+
36         " ST.PG_CONTENT_NODE, " +
37         " CS.SELECTION_TYPE, " +
38         " CS.SELECTION_DATA " +
39         "FROM " +
40         " SITE_TREE ST, CONTENT_SELECTION CS " +
41         "WHERE " +
42         DBStringFactory.leftOuterJoin(" ST.PG_SELECTION_ID ", " CS.SELECTION_ID ") +
43         "ORDER BY " +
44         " LEFT_NR ";
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