KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/DrUpdateRelRefs.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 DrUpdateRelRefs extends TKPrepQuery{
13
14     public final static boolean isPrepared =
15         true;
16     
17     public final static String JavaDoc[] paramOrder =
18         {
19             NODE_ID,
20             SITE_NODE_DOC_IDX,
21             NEW_ID,
22             NEW_IDX
23          };
24     
25     public final static Object JavaDoc[][] paramTypes =
26         null;
27         
28     public final static boolean[] setRelevants =
29         null;
30         
31     public final static String JavaDoc sqlString =
32         
33 /* updates references that belong to a certain site_document */
34   " DECLARE "
35  + " new_id INTEGER; "
36  + " new_idx INTEGER; "
37  + " old_id INTEGER; "
38  + " old_idx INTEGER; "
39  + " BEGIN "
40  + " old_id := ?; " /* ?OLD_ID */
41  + " old_idx := ?; " /* ?OLD_IDX */
42  + " new_id := ?; " /* ?NEW_ID */
43  + " new_idx := ?; " /* ?NEW_IDX */
44     
45  + " UPDATE DOCUMENT_REFERENCE "
46  + " SET DEST_SITE_NODE_ID = adjust_relative_refs(old_id, old_idx, SRC_PRESENTATION_COMPONENT_IDX, new_id, new_idx) "
47  + " WHERE "
48  + " SRC_SITE_NODE_ID = new_id "
49  + " AND "
50  + " SRC_SITE_NODE_DOC_IDX = new_idx; "
51  + " END; "
52 ;
53         
54         
55
56         
57
58     public void initQuery(Connection con) {
59         super.initQuery(
60             con,
61             isPrepared,
62             paramOrder,
63             paramTypes,
64             setRelevants,
65             sqlString );
66     }
67 }
68
Popular Tags