01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class UpdateContentTreeLeftRightNr extends TKPrepQuery {
07:
08: public final static boolean PREPARED = true;
09:
10: public final static String[] ORDER = { "MAX_RIGHT", "MAX_RIGHT",
11: "LEFT_NR", "RIGHT_NR" };
12:
13: public final static Object[][] TYPES = null;
14:
15: public final static boolean[] RELEVANTS = { true };
16:
17: public final static String SQLSTRING = "UPDATE CONTENT_TREE SET RIGHT_NR = RIGHT_NR + ?, LEFT_NR = LEFT_NR + ? WHERE LEFT_NR >= ? AND RIGHT_NR <= ?";
18:
19: public void initQuery(Connection con) {
20: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
21: SQLSTRING);
22: }
23:
24: }
|