01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StShiftRightNrs.java,v 1.2 2000/12/13 11:29:31 marwan Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.sitetree;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: public class StShiftRightNrs extends TKPrepQuery {
12:
13: public final static boolean isPrepared = true;
14:
15: public final static String[] paramOrder = { NODE_ID };
16: public final static Object[][] paramTypes = null;
17:
18: public final static boolean[] setRelevants = null;
19:
20: public final static String sqlString =
21:
22: " update SITE_TREE " + " set RIGHT_NR = RIGHT_NR + 2 "
23: + " where RIGHT_NR >= " + " ( " + " select RIGHT_NR "
24: + " from SITE_TREE " + " where SITE_NODE_ID = ? "
25: + " ) ";
26:
27: public void initQuery(Connection con) {
28: super.initQuery(con, isPrepared, paramOrder, paramTypes,
29: setRelevants, sqlString);
30: }
31: }
|