01: package com.teamkonzept.webman.mainint.db.queries;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: * TKDBStructContentGetContentID
09: *
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 = true;
22:
23: /** @see TKPrepQuery */
24: public static String[] PARAMORDER = { "SITE_NODE_ID", "FORM_ID" };
25:
26: /** @see TKPrepQuery */
27: public static Object[][] PARAMTYPES = null;
28:
29: /** @see TKPrepQuery */
30: public static boolean[] SETRELEVANTS = { true };
31:
32: /** die Query */
33: public static String SQLSTRING = "SELECT " + "CONTENT_ID "
34: + "FROM " + "STRUCTURED_CONTENT " + "WHERE "
35: + "SITE_NODE_ID = ? " + "AND " + "FORM_ID = ? ";
36:
37: /** @see TKPrepQuery */
38: public void initQuery(Connection con) {
39: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
40: SETRELEVANTS, SQLSTRING);
41: }
42: }
|