1 5 package com.teamkonzept.webman.mainint.db.queries.sitetree; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 12 public class StShiftRightNrs extends TKPrepQuery{ 13 14 public final static boolean isPrepared = 15 true; 16 17 public final static String [] paramOrder = 18 {NODE_ID}; 19 public final static Object [][] paramTypes = 20 null; 21 22 public final static boolean[] setRelevants = 23 null; 24 25 public final static String sqlString = 26 27 28 29 " update SITE_TREE " 30 + " set RIGHT_NR = RIGHT_NR + 2 " 31 + " where RIGHT_NR >= " 32 + " ( " 33 + " select RIGHT_NR " 34 + " from SITE_TREE " 35 + " where SITE_NODE_ID = ? " 36 + " ) " ; 37 38 public void initQuery(Connection con) { 39 super.initQuery( 40 con, 41 isPrepared, 42 paramOrder, 43 paramTypes, 44 setRelevants, 45 sqlString ); 46 } 47 } 48 49 50 51 52 | Popular Tags |