01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresRefDelAll.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: * TKDBPresRefDelAll
15: *
16: * Loescht alle Eintraege in PRESENTATION_REFERENCE zu gleicher presId und presCompIdx
17: *
18: * Input: PRESENTATION_ID, PRESENTATION_COMPONENT_IDX
19: * Output: none
20: */
21: public class TKDBPresRefDelAll extends TKPrepQuery {
22:
23: public final static boolean isPrepared = true;
24:
25: public final static String[] paramOrder = { "PRESENTATION_ID",
26: "PRESENTATION_COMPONENT_IDX" };
27:
28: public final static Object[][] paramTypes = null;
29:
30: public final static boolean[] setRelevants = { false };
31:
32: public final static String sqlString = "DELETE FROM "
33: + " PRESENTATION_REFERENCE " + "WHERE "
34: + " PRESENTATION_ID = ? " + "AND "
35: + " PRESENTATION_COMPONENT_IDX = ? ";
36:
37: public void initQuery(Connection con) {
38: super.initQuery(con, isPrepared, paramOrder, paramTypes,
39: setRelevants, sqlString);
40: }
41: }
|