KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBDocReferencePut.java,v 1.5 2000/05/22 15:01:46 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  * TKDBDocReferencePut
13  * Schreibt einen DS fuer eine Document_Reference
14  *
15  * Input: Kompl. DS
16  * Output: none
17  */
18 public class TKDBDocReferencePut extends TKPrepQuery{
19
20     public final static boolean isPrepared =
21         true;
22     
23     public final static String JavaDoc[] paramOrder =
24         {
25           "SRC_SITE_NODE_ID", "SRC_SITE_NODE_DOC_IDX",
26           "SRC_PRESENTATION_COMPONENT_IDX", "REFERENCE_TYPE",
27           "DEST_SITE_NODE_ID", "DEST_SITE_NODE_DOC_SHORTNAME",
28           "SELECTION_TYPE", "SELECTION_DATA"
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     
44         "INSERT INTO " +
45         " DOCUMENT_REFERENCE " +
46         " (SRC_SITE_NODE_ID, SRC_SITE_NODE_DOC_IDX, " +
47         " SRC_PRESENTATION_COMPONENT_IDX, REFERENCE_TYPE, " +
48         " DEST_SITE_NODE_ID, DEST_SITE_NODE_DOC_SHORTNAME, " +
49         " SELECTION_TYPE, SELECTION_DATA ) " +
50         "VALUES " +
51         "(?, ?, ?, ?, ?, ?, ?, ?) ";
52     
53     public void initQuery(Connection con) {
54         super.initQuery(
55             con,
56             isPrepared,
57             paramOrder,
58             paramTypes,
59             setRelevants,
60             sqlString );
61     }
62 }
63
64
Popular Tags