KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresUpdate.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  * TKDBPresUpdate
16  * input "PRESENTATION_NAME", "PRESENTATION_SHORTNAME",
17           "TEMPLATE_ID", "PRESENTATION_ID"
18  * output none
19  */
20 public class TKDBPresUpdate extends TKPrepQuery{
21
22     public final static boolean isPrepared =
23         true;
24     
25     public final static String JavaDoc[] paramOrder =
26         {"PRESENTATION_NAME", "PRESENTATION_SHORTNAME",
27           "TEMPLATE_ID", "PRESENTATION_ID" };
28     
29     public final static Object JavaDoc[][] paramTypes =
30         {{"PRESENTATION_NAME", new Integer JavaDoc(Types.VARCHAR)},
31          {"PRESENTATION_SHORTNAME", new Integer JavaDoc(Types.VARCHAR)}};
32         
33     public final static boolean[] setRelevants =
34         { false };
35         
36     public final static String JavaDoc sqlString =
37         "UPDATE " +
38         " PRESENTATION " +
39         "SET " +
40         " PRESENTATION_NAME = ?, " +
41         " PRESENTATION_SHORTNAME = ?, " +
42         " TEMPLATE_ID = ? " +
43         "WHERE " +
44         " PRESENTATION_ID = ? ";
45
46     
47     public void initQuery(Connection con) {
48         super.initQuery(
49             con,
50             isPrepared,
51             paramOrder,
52             paramTypes,
53             setRelevants,
54             sqlString );
55     }
56 }
57
58
Popular Tags