KickJava   Java API By Example, From Geeks To Geeks.

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


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  * TKDBGetAllNodeContents
11  * Holt alle Contents eines Content-Tree-Knotens
12  *
13  * Input: CONTENT_NODE_ID
14  * Output: CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME
15  */
16 public class TKDBGetAllNodeContents extends TKPrepQuery{
17
18     public final static boolean isPrepared =
19         true;
20     
21     public final static String JavaDoc[] paramOrder =
22         { "CONTENT_NODE_ID" };
23     
24     public final static Object JavaDoc[][] paramTypes =
25         null;
26                 
27     public final static boolean[] setRelevants =
28         { true };
29         
30     public final static String JavaDoc sqlString =
31         "SELECT " +
32         " CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME " +
33         "FROM " +
34         " CONTENT " +
35         "WHERE " +
36         " CONTENT_NODE_ID = ?";
37
38     
39     public void initQuery(Connection con) {
40         super.initQuery(
41             con,
42             isPrepared,
43             paramOrder,
44             paramTypes,
45             setRelevants,
46             sqlString );
47     }
48 }
49
50
Popular Tags