01: package com.teamkonzept.webman.mainint.db.queries.presentation;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class UpdatePresentationComponent extends TKPrepQuery {
07:
08: public final static boolean prepared = true;
09:
10: public final static String[] order = {
11: "PRESENTATION_COMPONENT_IDX", "PRESENTATION_ID" };
12:
13: public final static Object[][] types = null;
14:
15: public final static boolean[] relevants = { true };
16:
17: public final static String sqlString = (new StringBuffer(
18: "UPDATE PRESENTATION_COMPONENT ")
19: .append(
20: "SET PRESENTATION_COMPONENT_IDX =PRESENTATION_COMPONENT_IDX - 1 ")
21: .append("WHERE ")
22: .append("PRESENTATION_COMPONENT_IDX > ? AND PRESENTATION_ID = ?"))
23: .toString();
24:
25: public void initQuery(Connection con) {
26: super.initQuery(con, prepared, order, types, relevants,
27: sqlString);
28: }
29:
30: }
|