KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPropUpdate.java,v 1.3 2001/02/19 11:38:45 ralf Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBPropUpdate
13  * input "PROP_NAME"
14  * input "PROP_VALUE"
15  * output neuer DS
16  * changes entry in PROPERTIES
17  */
18 public class TKDBPropUpdate extends TKPrepQuery{
19     
20     public final static boolean isPrepared =
21     true;
22     
23     public final static String JavaDoc[] paramOrder =
24     { "PROP_NAME",
25       "PROP_VALUE",
26       "PROP_ID" };
27     
28     public final static Object JavaDoc[][] paramTypes =
29     {{"PROP_NAME", new Integer JavaDoc(Types.VARCHAR)},
30      {"PROP_VALUE", new Integer JavaDoc(Types.LONGVARCHAR)}, //=> text
31 {"PROP_ID", new Integer JavaDoc(Types.INTEGER)}};
32     
33     public final static boolean[] setRelevants =
34     { true };
35     
36     public final static String JavaDoc sqlString =
37     "UPDATE " +
38     "PROPERTY " +
39     " SET NAME = ? , VALUE = ? " +
40     "WHERE " +
41     " PROPERTY_ID = ? ";
42     
43     public void initQuery(Connection con) {
44     super.initQuery(
45             con,
46             isPrepared,
47             paramOrder,
48             paramTypes,
49             setRelevants,
50             sqlString );
51     }
52 }
53
54
Popular Tags