01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class UpdateContentTreeSetLeftNrPlus extends TKPrepQuery {
07:
08: public final static boolean prepared = true;
09:
10: public final static String[] order = { "DIFF", "LEFT_NR",
11: "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 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: }
|