KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBPresCompUpdate


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresCompUpdate.java,v 1.5 2000/05/22 15:01:48 careck Exp $
3  *
4  */
5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */
8 package com.teamkonzept.webman.mainint.db.queries;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13
14 /*
15  * TKDBPresCompUpdate
16  * input "COMPONENT_TYPE", "INTEGRATION_TYPE",
17  * "INTEGRATION_NAME", "INTEGRATION_SHORTNAME",
18  * "PRESENTATION_ID", "PRESENTATION_COMPONENT_IDX"
19  * output none
20  */
21 public class TKDBPresCompUpdate extends TKPrepQuery{
22
23     public final static boolean isPrepared =
24         true;
25     
26     public final static String JavaDoc[] paramOrder =
27         { "COMPONENT_TYPE", "INTEGRATION_TYPE",
28          "INTEGRATION_NAME", "INTEGRATION_SHORTNAME",
29          "PRESENTATION_ID", "PRESENTATION_COMPONENT_IDX" };
30     
31     public final static Object JavaDoc[][] paramTypes =
32         {{"PRESENTATION_NAME", new Integer JavaDoc(Types.VARCHAR)},
33          {"PRESENTATION_SHORTNAME", new Integer JavaDoc(Types.VARCHAR)}};
34         
35     public final static boolean[] setRelevants =
36         { false };
37         
38     public final static String JavaDoc sqlString =
39         "UPDATE " +
40         " PRESENTATION_COMPONENT " +
41         "SET " +
42         " COMPONENT_TYPE = ?, " +
43         " INTEGRATION_TYPE = ?, " +
44         " INTEGRATION_NAME = ?, " +
45         " INTEGRATION_SHORTNAME = ? " +
46         "WHERE " +
47         " PRESENTATION_ID = ? " +
48         "AND " +
49         " PRESENTATION_COMPONENT_IDX = ? ";
50
51     
52     public void initQuery(Connection con) {
53         super.initQuery(
54             con,
55             isPrepared,
56             paramOrder,
57             paramTypes,
58             setRelevants,
59             sqlString );
60     }
61 }
62
63
Popular Tags