KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPropGroupUpdate.java,v 1.2 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 TKDBPropGroupUpdate extends TKPrepQuery{
19     
20     public final static boolean isPrepared =
21     true;
22     
23     public final static String JavaDoc[] paramOrder =
24     { "PROPGROUP_NAME",
25       "PROPGROUP_ID" };
26     
27     public final static Object JavaDoc[][] paramTypes =
28     {{"PROPGROUP_NAME", new Integer JavaDoc(Types.VARCHAR)},
29      {"PROPGROUP_ID", new Integer JavaDoc(Types.INTEGER)}};
30     
31     public final static boolean[] setRelevants =
32     { true };
33     
34     public final static String JavaDoc sqlString =
35     "UPDATE " +
36     "PROPERTY_GROUP " +
37     " SET NAME = ? " +
38     "WHERE " +
39     " PROPERTY_GROUP_ID = ? ";
40     
41     public void initQuery(Connection con) {
42     super.initQuery(
43             con,
44             isPrepared,
45             paramOrder,
46             paramTypes,
47             setRelevants,
48             sqlString );
49     }
50 }
51
52
Popular Tags