01: package de.webman.content.db.queries;
02:
03: import com.teamkonzept.db.*;
04: import java.sql.*;
05:
06: /**
07: * <pre>
08: * UPDATE CONTENT_ATTRIBUTE SET STR_VALUE = {"STR_VALUE"}, INT_VALUE = {"INT_VALUE"}, DATE_VALUE = {"DATE_VALUE"}
09: * WHERE VALUE_ID = {"VALUE_ID"}
10: * </pre>
11: * @author markus
12: * @version
13: */
14: public class TKDBContentAttributeUpdate extends TKPrepQuery {
15:
16: public final static boolean ISPREPARED = true;
17: public final static String[] PARAMORDER = { "STR_VALUE",
18: "INT_VALUE", "DATE_VALUE", "VALUE_ID" };
19:
20: public final static Object[][] PARAMTYPES = {
21: { "STR_VALUE", new Integer(Types.VARCHAR) },
22: { "DATE_VALUE", new Integer(Types.TIMESTAMP) } };
23:
24: public final static boolean[] SETRELEVANTS = { false };
25:
26: public final static String SQLSTRING =
27:
28: "UPDATE CONTENT_ATTRIBUTE SET STR_VALUE = ?, INT_VALUE = ?, DATE_VALUE = ? WHERE VALUE_ID = ? ";
29:
30: public void initQuery(Connection con) {
31: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
32: SETRELEVANTS, SQLSTRING);
33: }
34: }
|