01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresUpdate.java,v 1.5 2000/05/22 15:01:48 careck Exp $
03: *
04: */
05: /**
06: * Jedes Selectstatement erhaelt eine eigene Klasse
07: */package com.teamkonzept.webman.mainint.db.queries;
08:
09: import java.sql.*;
10:
11: import com.teamkonzept.db.*;
12:
13: /*
14: * TKDBPresUpdate
15: * input "PRESENTATION_NAME", "PRESENTATION_SHORTNAME",
16: "TEMPLATE_ID", "PRESENTATION_ID"
17: * output none
18: */
19: public class TKDBPresUpdate extends TKPrepQuery {
20:
21: public final static boolean isPrepared = true;
22:
23: public final static String[] paramOrder = { "PRESENTATION_NAME",
24: "PRESENTATION_SHORTNAME", "TEMPLATE_ID", "PRESENTATION_ID" };
25:
26: public final static Object[][] paramTypes = {
27: { "PRESENTATION_NAME", new Integer(Types.VARCHAR) },
28: { "PRESENTATION_SHORTNAME", new Integer(Types.VARCHAR) } };
29:
30: public final static boolean[] setRelevants = { false };
31:
32: public final static String sqlString = "UPDATE " + " PRESENTATION "
33: + "SET " + " PRESENTATION_NAME = ?, "
34: + " PRESENTATION_SHORTNAME = ?, " + " TEMPLATE_ID = ? "
35: + "WHERE " + " PRESENTATION_ID = ? ";
36:
37: public void initQuery(Connection con) {
38: super.initQuery(con, isPrepared, paramOrder, paramTypes,
39: setRelevants, sqlString);
40: }
41: }
|