KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /**
8  * TKDBStructContentGetContentID
9  *
10  * holt die contentid zu einem durch site_node_id und form_id bestimmten sitestructureparameter
11  *
12  * Input: SITE_NODE_ID, FORM_ID
13  * Output: Content_ID
14  *
15  * @author $Author: gregor $
16  * @version $Revision: 1.2 $
17  */
18 public class TKDBStructContentGetContentID extends TKPrepQuery{
19
20     /** @see TKPrepQuery */
21     public static boolean ISPREPARED =
22         true;
23     
24     /** @see TKPrepQuery */
25     public static String JavaDoc[] PARAMORDER =
26         {"SITE_NODE_ID", "FORM_ID"};
27     
28     /** @see TKPrepQuery */
29     public static Object JavaDoc[][] PARAMTYPES =
30         null;
31     
32     /** @see TKPrepQuery */
33     public static boolean[] SETRELEVANTS =
34         { true };
35         
36     /** die Query */
37     public static String JavaDoc SQLSTRING =
38         "SELECT " +
39         "CONTENT_ID " +
40         "FROM " +
41         "STRUCTURED_CONTENT " +
42         "WHERE " +
43         "SITE_NODE_ID = ? " +
44         "AND " +
45         "FORM_ID = ? ";
46     
47     /** @see TKPrepQuery */
48     public void initQuery(Connection con) {
49         super.initQuery(
50             con,
51             ISPREPARED,
52             PARAMORDER,
53             PARAMTYPES,
54             SETRELEVANTS,
55             SQLSTRING );
56     }
57 }
Popular Tags