KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBDocReferenceUpdate.java,v 1.5 2000/05/22 15:01:47 careck Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBDocReferenceUpdate
13  * Schreibt einen DS fuer eine Document_Reference
14  *
15  * Input: Kompl. DS
16  * Output: none
17  */
18 public class TKDBDocReferenceUpdate extends TKPrepQuery{
19
20     public final static boolean isPrepared =
21         true;
22     
23     public final static String JavaDoc[] paramOrder =
24         {
25           "REFERENCE_TYPE",
26           "DEST_SITE_NODE_ID", "DEST_SITE_NODE_DOC_SHORTNAME",
27           "SELECTION_TYPE", "SELECTION_DATA",
28           "SRC_SITE_NODE_ID", "SRC_SITE_NODE_DOC_IDX", "SRC_PRESENTATION_COMPONENT_IDX"
29          };
30     
31     public final static Object JavaDoc[][] paramTypes =
32         {
33             {"SELECTION_TYPE", new Integer JavaDoc(Types.VARCHAR)},
34             {"SRC_SITE_NODE_DOC_SHORTNAME", new Integer JavaDoc(Types.VARCHAR)},
35             {"SELECTION_DATA", new Integer JavaDoc(Types.LONGVARCHAR)}
36          };
37                 
38     public final static boolean[] setRelevants =
39         { false };
40         
41     public final static String JavaDoc sqlString =
42     
43         "UPDATE " +
44         " DOCUMENT_REFERENCE " +
45         "SET " +
46         " REFERENCE_TYPE = ?, " +
47         " DEST_SITE_NODE_ID = ?, " +
48         " DEST_SITE_NODE_DOC_SHORTNAME = ?, " +
49         " SELECTION_TYPE = ?, " +
50         " SELECTION_DATA = ? " +
51         "WHERE " +
52         " SRC_SITE_NODE_ID = ? " +
53         "AND " +
54         " SRC_SITE_NODE_DOC_IDX = ? " +
55         "AND " +
56         " SRC_PRESENTATION_COMPONENT_IDX = ? ";
57     
58     public void initQuery(Connection con) {
59         super.initQuery(
60             con,
61             isPrepared,
62             paramOrder,
63             paramTypes,
64             setRelevants,
65             sqlString );
66     }
67 }
68
69
Popular Tags