KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * TKDBContentTreeUpdateNode
8  * Update eines Nodes
9  * Input: CONTENT_NODE_ID (der zu akt. Knoten)
10  * "CONTENT_NODE_NAME", "CONTENT_NODE_TYPE", "CONTENT_FORM"
11  * Output: Keiner
12  */
13 public class TKDBContentTreeUpdateNode extends TKPrepQuery{
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "CONTENT_NODE_NAME", "CONTENT_NODE_SHORTNAME", "CONTENT_NODE_TYPE" ,
20           "CONTENT_FORM", "TREE_ID", "PROTOTYPE_ID", "CONTENT_NODE_ID", };
21     
22     public final static Object JavaDoc[][] paramTypes =
23         {{ "CONTENT_NODE_NAME", new Integer JavaDoc(Types.VARCHAR) },
24          { "CONTENT_NODE_SHORTNAME", new Integer JavaDoc(Types.VARCHAR) }};
25         
26     public final static boolean[] setRelevants =
27         { false };
28         
29     public final static String JavaDoc sqlString =
30         "UPDATE " +
31         " CONTENT_TREE " +
32         "SET " +
33         " CONTENT_NODE_NAME = ?, " +
34         " CONTENT_NODE_SHORTNAME = ?, " +
35         " CONTENT_NODE_TYPE = ?, " +
36         " CONTENT_FORM = ?, " +
37         " TREE_ID = ?, " +
38         " PROTOTYPE_ID = ? " +
39         "WHERE " +
40         " CONTENT_NODE_ID = ? ";
41         
42     
43     public void initQuery(Connection con) {
44         super.initQuery(
45             con,
46             isPrepared,
47             paramOrder,
48             paramTypes,
49             setRelevants,
50             sqlString );
51     }
52 }
53
Popular Tags