KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBContentTreeGetFormType2


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /**
7  * TKDBContentTreeGetFormType
8  * Holt alle Contents eines Content-Tree-Knotens
9  *
10  * Input: CONTENT_NODE_TYPE, CONTENT_FORM
11  * Output: alle Datensaetze des Typs order by LEFT_NR
12  * @author $Author: sebastian $
13  * @version $Revision: 1.4 $
14  */
15
16 public class TKDBContentTreeGetFormType2 extends TKPrepQuery {
17
18     public final static boolean IS_PREPARED =
19         true;
20     
21     public final static String JavaDoc[] PARAM_ORDER =
22         { "CONTENT_NODE_TYPE", "CONTENT_FORM" };
23     
24     public final static Object JavaDoc[][] PARAM_TYPES =
25         null;
26                 
27     public final static boolean[] SET_RELEVANTS =
28         { true };
29         
30     /** Das sql-stm. */
31     public final static String JavaDoc SQL_STRING =
32         "SELECT " +
33         " T.*, CI.INSTANCE_ID " +
34         "FROM " +
35         " CONTENT_TREE T, CONTENT_INSTANCE CI " +
36         "WHERE " +
37         " T.CONTENT_NODE_TYPE = ? AND T.CONTENT_NODE_ID=CI.CONTENT_NODE_ID " +
38         "AND " +
39         " T.CONTENT_FORM = ? " +
40         "ORDER BY " +
41         DBStringFactory.upper_order() + "(T.CONTENT_NODE_NAME) ";
42
43     
44     public void initQuery(Connection con) {
45         super.initQuery(
46             con,
47             IS_PREPARED,
48             PARAM_ORDER,
49             PARAM_TYPES,
50             SET_RELEVANTS,
51             SQL_STRING );
52     }
53 }
54
Popular Tags