KickJava   Java API By Example, From Geeks To Geeks.

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


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  */

13 public class TKDBContentTreeGetFormType extends TKPrepQuery {
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "CONTENT_NODE_TYPE", "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         " * " +
30         "FROM " +
31         " CONTENT_TREE " +
32         "WHERE " +
33         " CONTENT_NODE_TYPE = ? " +
34         "AND " +
35         " CONTENT_FORM = ? " +
36         "ORDER BY " +
37         " LEFT_NR ";
38
39     
40     public void initQuery(Connection con) {
41         super.initQuery(
42             con,
43             isPrepared,
44             paramOrder,
45             paramTypes,
46             setRelevants,
47             sqlString );
48     }
49 }
50
Popular Tags