KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > TKDBContentAttributeUpdate


1
2 package de.webman.content.db.queries;
3
4 import com.teamkonzept.db.*;
5 import java.sql.*;
6
7 /**
8  * <pre>
9  * UPDATE CONTENT_ATTRIBUTE SET STR_VALUE = {"STR_VALUE"}, INT_VALUE = {"INT_VALUE"}, DATE_VALUE = {"DATE_VALUE"}
10  * WHERE VALUE_ID = {"VALUE_ID"}
11  * </pre>
12  * @author markus
13  * @version
14  */
15 public class TKDBContentAttributeUpdate extends TKPrepQuery {
16
17     public final static boolean ISPREPARED = true;
18     public final static String JavaDoc[] PARAMORDER = { "STR_VALUE", "INT_VALUE", "DATE_VALUE", "VALUE_ID" };
19     
20     public final static Object JavaDoc[][] PARAMTYPES =
21         { {"STR_VALUE", new Integer JavaDoc(Types.VARCHAR)},
22           {"DATE_VALUE", new Integer JavaDoc(Types.TIMESTAMP)} };
23         
24     public final static boolean[] SETRELEVANTS = { false };
25
26     public final static String JavaDoc 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(
32             con,
33             ISPREPARED,
34             PARAMORDER,
35             PARAMTYPES,
36             SETRELEVANTS,
37             SQLSTRING );
38     }
39 }
40
Popular Tags