KickJava   Java API By Example, From Geeks To Geeks.

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


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  * TKDBGetAllNodeContentsSorted
12  * Holt alle Contents eines Content-Tree-Knotens
13  *
14  * Input: CONTENT_NODE_ID
15  * Output: CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME
16  * @author
17  * @version
18 */

19
20 public class TKDBGetAllNodeContentsWithInstanceID extends TKPrepQuery{
21
22     public final static boolean ISPREPARED =
23         true;
24     
25     public final static String JavaDoc[] PARAMORDER =
26         { "CONTENT_NODE_ID" };
27     
28     public final static Object JavaDoc[][] PARAMTYPES =
29         null;
30                 
31     public final static boolean[] SETRELEVANTS =
32         { true };
33     
34     /** Das sql-stm. */
35     public final static String JavaDoc SQLSTRING =
36         "SELECT " +
37         " T.*, CI.INSTANCE_ID " +
38         "FROM " +
39         " CONTENT_TREE T, CONTENT_INSTANCE CI " +
40         "WHERE " +
41         " T.CONTENT_NODE_PARENT = ? AND T.CONTENT_NODE_ID=CI.CONTENT_NODE_ID " +
42
43         "ORDER BY " + DBStringFactory.upper_order() + "(T.CONTENT_NODE_NAME) ";
44
45     
46     public void initQuery(Connection con) {
47         super.initQuery(
48             con,
49             ISPREPARED,
50             PARAMORDER,
51             PARAMTYPES,
52             SETRELEVANTS,
53             SQLSTRING );
54     }
55 }
Popular Tags