KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBSiteDocUpdate.java,v 1.6 2000/10/26 19:08:13 phrank 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  * TKDBSiteDocUpdate
13  * input -> PK: SITE_NODE_ID, SITE_NODE_DOC_IDX
14  * input -> update: der Resr jetzt ohne Praeser
15  * ouput none
16  */

17 public class TKDBSiteDocUpdate extends TKPrepQuery{
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         {"DOCUMENT_NAME", "DOCUMENT_SHORTNAME",
24          "INHERITABLE", "DOCUMENT_TYPE", "EXTERNAL_URL", "INHERIT_END_LEVEL", "INHERIT_BEGIN_LEVEL",
25          "SITE_NODE_ID", "SITE_NODE_DOC_IDX", };
26     
27     public final static Object JavaDoc[][] paramTypes =
28         {{"EXTERNAL_URL", new Integer JavaDoc(Types.VARCHAR)}};
29         
30     public final static boolean[] setRelevants =
31         { false };
32         
33     public final static String JavaDoc sqlString =
34         "UPDATE " +
35         " SITE_DOCUMENT " +
36         "SET " +
37         " DOCUMENT_NAME = ?," +
38         " DOCUMENT_SHORTNAME = ?," +
39         " INHERITABLE = ?, " +
40         " DOCUMENT_TYPE = ?, " +
41         " EXTERNAL_URL = ?, " +
42         " INHERIT_END_LEVEL = ?, " +
43         " INHERIT_BEGIN_LEVEL = ? " +
44         "WHERE " +
45         " SITE_NODE_ID = ? " +
46         "AND " +
47         " SITE_NODE_DOC_IDX = ? ";
48     
49     public void initQuery(Connection con) {
50         super.initQuery(
51             con,
52             isPrepared,
53             paramOrder,
54             paramTypes,
55             setRelevants,
56             sqlString );
57     }
58 }
59
60
Popular Tags