KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StUpdate.java,v 1.2 2000/12/13 11:29:31 marwan Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sitetree;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11
12 public class StUpdate extends TKPrepQuery {
13     public final static boolean isPrepared =
14         true;
15     
16     public final static String JavaDoc[] paramOrder =
17         {
18             SITE_NODE_TYPE,
19             SITE_NODE_NAME,
20             SITE_NODE_SHORTNAME,
21             PG_CONTENT_NODE,
22             PG_SELECTION_ID,
23             SITE_NODE_ID
24         };
25     
26     public final static Object JavaDoc[][] paramTypes =
27     {
28         { SITE_NODE_NAME, new Integer JavaDoc(Types.VARCHAR) },
29         { SITE_NODE_SHORTNAME, new Integer JavaDoc(Types.VARCHAR) }
30     };
31     public final static boolean[] setRelevants =
32         null;
33         
34     public final static String JavaDoc sqlString =
35         
36             " update SITE_TREE " +
37             " set SITE_NODE_TYPE = ?, SITE_NODE_NAME = ? , SITE_NODE_SHORTNAME = ?, " +
38             " PG_CONTENT_NODE = ?, PG_SELECTION_ID = ? " +
39             " where SITE_NODE_ID = ? ";
40     
41     public void initQuery(Connection con) {
42         super.initQuery(
43             con,
44             isPrepared,
45             paramOrder,
46             paramTypes,
47             setRelevants,
48             sqlString );
49     }
50 }
51
52
53
Popular Tags