UpdatePresentationContent


1   package com.teamkonzept.webman.mainint.db.queries.presentation;
2   
3   import java.sql.Connection  ;
4   import com.teamkonzept.db.*;
5   
6   public class UpdatePresentationContent 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_CONTENT ")
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  }

A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame

Popular Tags