KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > db > queries > TKDBGetAllNodeContentsSortedByName


1 package com.teamkonzept.field.db.queries;
2
3 import com.teamkonzept.db.*;
4 import com.teamkonzept.lib.*;
5
6 import java.io.*;
7 import java.util.*;
8 import java.sql.*;
9
10
11 /**
12  * TKDBGetAllNodeContentsSorted
13  * Holt alle Contents eines Content-Tree-Knotens
14  *
15  * Input: CONTENT_NODE_ID
16  * Output: CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME
17  * @author
18  * @version
19 */
20
21 public class TKDBGetAllNodeContentsSortedByName extends TKPrepQuery{
22
23     public final static boolean ISPREPARED =
24         true;
25     
26     public final static String JavaDoc[] PARAMORDER =
27         { "CONTENT_NODE_ID" };
28     
29     public final static Object JavaDoc[][] PARAMTYPES =
30         null;
31                 
32     public final static boolean[] SETRELEVANTS =
33         { true };
34         
35     /** Das sql-stm. */
36     public final static String JavaDoc SQLSTRING =
37         "SELECT " +
38         " CONTENT_NODE_ID, CONTENT_NODE_NAME, CONTENT_NODE_SHORTNAME " +
39         "FROM " +
40         " CONTENT_TREE " +
41         "WHERE " +
42         " CONTENT_NODE_PARENT = ? " +
43
44         "ORDER BY " + DBStringFactory.upper_order() + "(CONTENT_NODE_NAME) ";
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