1 package com.teamkonzept.webman.mainint.db.queries.presentation; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class UpdatePresentationComponent extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = { "PRESENTATION_COMPONENT_IDX", "PRESENTATION_ID" }; 12 13 public final static Object [][] types = null; 14 15 public final static boolean[] relevants = { true }; 16 17 public final static String sqlString = (new StringBuffer ("UPDATE PRESENTATION_COMPONENT ") 18 .append("SET PRESENTATION_COMPONENT_IDX =PRESENTATION_COMPONENT_IDX - 1 ") 19 .append("WHERE ") 20 .append("PRESENTATION_COMPONENT_IDX > ? AND PRESENTATION_ID = ?")).toString(); 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 |