KickJava   Java API By Example, From Geeks To Geeks.

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


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