KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5 import com.teamkonzept.webman.mainint.DatabaseDefaults;
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  */
13 public class TKDBContentTreeGetFormSingle extends TKPrepQuery implements DatabaseDefaults {
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "CONTENT_FORM" };
20     
21     public final static Object JavaDoc[][] paramTypes =
22         null;
23                 
24     public final static boolean[] setRelevants =
25         { true };
26         
27     public final static String JavaDoc sqlString =
28          " SELECT "
29          + " C_T.* "
30          + " FROM "
31          + " CONTENT_TREE C_T, CONTENT_TREE PARENT "
32          + " WHERE "
33          + " C_T.CONTENT_NODE_PARENT = PARENT.CONTENT_NODE_ID "
34          + " AND "
35          + " C_T.CONTENT_NODE_TYPE = " + SINGLE
36          + " AND "
37          + " PARENT.CONTENT_NODE_TYPE != "+ GROUP
38          + " AND "
39          + " C_T.CONTENT_FORM = ? "
40          + " ORDER BY "
41          + " C_T.LEFT_NR " ;
42
43     
44     public void initQuery(Connection con) {
45         super.initQuery(
46             con,
47             isPrepared,
48             paramOrder,
49             paramTypes,
50             setRelevants,
51             sqlString );
52     }
53 }
54
Popular Tags