KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > acl > db > TKDBGetNodeInfo


1 package de.webman.acl.db;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKDBGetNodeInfo
9  * input (CONTENT_NODE_ID)
10  * output (CONTENT_NODE_ID, CONTENT_NODE_NAME, CONTENT_NODE_SHORTNAME, CONTENT_NODE_TYPE)
11  */
12 public class TKDBGetNodeInfo extends TKPrepQuery{
13
14     public final static boolean IS_PREPARED =
15         true;
16     
17     public final static String JavaDoc[] PARAM_ORDER =
18         {"CONTENT_NODE_ID"};
19     
20     public final static Object JavaDoc[][] PARAM_TYPES =
21         {{"CONTENT_NODE_ID", new Integer JavaDoc(Types.INTEGER)}};
22         
23     public final static boolean[] SET_RELEVANTS =
24         { true };
25         
26     public final static String JavaDoc SQL_STRING =
27         "SELECT " +
28         " CONTENT_NODE_ID, CONTENT_NODE_NAME, CONTENT_NODE_SHORTNAME, CONTENT_NODE_TYPE " +
29         "FROM " +
30         " CONTENT_TREE where " +
31         " CONTENT_NODE_ID = ? ";
32
33     
34     public void initQuery(Connection con) {
35         super.initQuery(
36             con,
37             IS_PREPARED,
38             PARAM_ORDER,
39             PARAM_TYPES,
40             SET_RELEVANTS,
41             SQL_STRING );
42     }
43 }
44
45
Popular Tags