1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class UpdateContentTreeLeftNr extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = 12 { 13 "DIFF", "LEFT_NR" 14 }; 15 16 public final static Object [][] types = null; 17 18 public final static boolean[] relevants = { true }; 19 20 public final static String sqlString = "UPDATE CONTENT_TREE SET LEFT_NR = LEFT_NR - ? WHERE LEFT_NR >= ?"; 21 22 public void initQuery(Connection con) { 23 super.initQuery( 24 con, 25 prepared, 26 order, 27 types, 28 relevants, 29 sqlString ); 30 } 31 32 } | Popular Tags |