UpdateContentInstanceGenerated


1   package com.teamkonzept.webman.mainint.db.queries.content;
2   
3   import java.sql.Connection  ;
4   import com.teamkonzept.db.*;
5   
6   /**
7    * @author Markus Freitag
8    * @version 1.0
9    */
10  public class UpdateContentInstanceGenerated extends TKPrepQuery
11  {
12  
13      public final static boolean PREPARED = true;
14  
15      public final static String  [] ORDER = {
16              "INCREMENT", "INSTANCE_ID"
17          };
18  
19      public final static Object  [][] TYPES = {
20              {"INCREMENT", new Integer  (java.sql.Types.INTEGER)},
21              {"INSTANCE_ID", new Integer  (java.sql.Types.INTEGER)}
22          };
23  
24      public final static boolean[] RELEVANTS = { false };
25  
26      public final static String   SQLSTRING = (new StringBuffer  (
27          "UPDATE CONTENT_INSTANCE SET GENERATED = " + DBStringFactory.nvl() + "(GENERATED,0) + ? ")
28          .append("WHERE INSTANCE_ID = ?")
29      ).toString();
30  
31      public void initQuery(Connection   con) {
32          super.initQuery(
33              con,
34              PREPARED,
35              ORDER,
36              TYPES,
37              RELEVANTS,
38              SQLSTRING );
39      }
40  
41  }

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

Popular Tags