01: /*
02: * $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 $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries;
06:
07: import java.sql.*;
08:
09: 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 = true;
21:
22: public final static String[] paramOrder = { "PROPGROUP_NAME",
23: "PROPGROUP_ID" };
24:
25: public final static Object[][] paramTypes = {
26: { "PROPGROUP_NAME", new Integer(Types.VARCHAR) },
27: { "PROPGROUP_ID", new Integer(Types.INTEGER) } };
28:
29: public final static boolean[] setRelevants = { true };
30:
31: public final static String sqlString = "UPDATE "
32: + "PROPERTY_GROUP " + " SET NAME = ? " + "WHERE "
33: + " PROPERTY_GROUP_ID = ? ";
34:
35: public void initQuery(Connection con) {
36: super.initQuery(con, isPrepared, paramOrder, paramTypes,
37: setRelevants, sqlString);
38: }
39: }
|