KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sitetree > SdUpdate


1 package com.teamkonzept.webman.mainint.db.queries.sitetree;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7
8 /**
9  * OBSOLETE
10  *
11  * Description: <describe the CsDelOnStSub class here>
12  * @author marwan
13  * @version
14  */

15
16
17 public class SdUpdate extends TKPrepQuery {
18
19     public final static boolean ISPREPARED =
20         true;
21     
22     public final static String JavaDoc[] PARAMORDER =
23         {
24             PRESENTATION_ID,
25             DOCUMENT_NAME,
26             DOCUMENT_SHORTNAME,
27             INHERITABLE,
28             DOCUMENT_TYPE,
29             EXTERNAL_URL,
30             INHERIT_END_LEVEL,
31             INHERIT_BEGIN_LEVEL,
32             SITE_NODE_ID,
33             SITE_NODE_DOC_IDX
34         };
35     
36     public final static Object JavaDoc[][] PARAMTYPES =
37         {{"EXTERNAL_URL", new Integer JavaDoc(Types.VARCHAR)}};
38     
39     public final static boolean[] SETRELEVANTS =
40         null;
41         
42     public final static String JavaDoc SQLSTRING =
43      
44         "UPDATE " +
45         " SITE_DOCUMENT " +
46         "SET " +
47         " PRESENTATION_ID = ?," +
48         " DOCUMENT_NAME = ?," +
49         " DOCUMENT_SHORTNAME = ?," +
50         " INHERITABLE = ?, " +
51         " DOCUMENT_TYPE = ?, " +
52         " EXTERNAL_URL = ?, " +
53         " INHERIT_END_LEVEL = ?, " +
54         " INHERIT_BEGIN_LEVEL = ? " +
55         "WHERE " +
56         " SITE_NODE_ID = ? " +
57         "AND " +
58         " SITE_NODE_DOC_IDX = ? ";
59     public void initQuery(Connection con) {
60         super.initQuery(
61             con,
62             ISPREPARED,
63             PARAMORDER,
64             PARAMTYPES,
65             SETRELEVANTS,
66             SQLSTRING );
67     }
68
69 }
70
71
72 /* @(#)CsDelOnStSub.java */
73
Popular Tags