KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > duplication > TKDBSiteTreeRenameRecursive


1 package com.teamkonzept.webman.mainint.db.queries.duplication;
2
3 import com.teamkonzept.db.*;
4 //import com.teamkonzept.lib.*;
5
6 import java.io.*;
7 import java.util.*;
8 import java.sql.*;
9
10
11 /**
12  * fügt an die Namen aller Knoten im Sitetree unterhalb des Knotens
13  * mit ID ROOT_ID
14  * die Erweiterung NAME_EXT an, vorne wenn POS == 0, sonst hinten.
15  * SITE_NODE_NAME und SITE_NODE_SHORTNAME werden veraendert
16  */
17 public class TKDBSiteTreeRenameRecursive extends TKPrepQuery{
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         { "NAME_EXT", "POS" , "ROOT_ID" };
24     
25     public final static Object JavaDoc[][] paramTypes =
26         {{ "NAME_EXT ", new Integer JavaDoc(Types.VARCHAR) }};
27                 
28     public final static boolean[] setRelevants =
29         null;
30         
31     public final static String JavaDoc sqlString =
32
33       
34       
35 /* Vorne oder hinten anhŠngen einer Namenserweiterung im Site Tree bei allen Kindern eines Nodes */
36
37   " DECLARE @NAME_EXT varchar(100) "
38  + " DECLARE @ROOT_ID int "
39  + " DECLARE @RIGHT_NR int "
40  + " DECLARE @LEFT_NR int "
41  + " DECLARE @POS int "
42
43  + " SELECT @NAME_EXT = ? "
44  + " SELECT @POS = ? "
45  + " SELECT @ROOT_ID = ? "
46  + " SELECT @RIGHT_NR = RIGHT_NR "
47  + " FROM SITE_TREE "
48  + " WHERE "
49  + " SITE_NODE_ID = @ROOT_ID "
50           
51  + " SELECT @LEFT_NR = LEFT_NR "
52  + " FROM SITE_TREE "
53  + " WHERE "
54  + " SITE_NODE_ID = @ROOT_ID "
55  + " IF (@POS = 0) "
56  + " BEGIN " /* vorne anfuegen */
57  + " UPDATE SITE_TREE "
58  + " set SITE_NODE_NAME = stuff(SITE_NODE_NAME, 1, 0, @NAME_EXT) "
59  + " WHERE LEFT_NR > @LEFT_NR "
60  + " AND "
61  + " RIGHT_NR < @RIGHT_NR "
62     
63     
64  + " UPDATE SITE_TREE "
65  + " set SITE_NODE_SHORTNAME = stuff(SITE_NODE_SHORTNAME, 1, 0, @NAME_EXT) "
66  + " WHERE LEFT_NR > @LEFT_NR "
67  + " AND "
68  + " RIGHT_NR < @RIGHT_NR "
69  + " END "
70  + " ELSE "
71  + " BEGIN " /* hinten anfuegen */
72  + " UPDATE SITE_TREE "
73  + " set SITE_NODE_NAME = stuff(@NAME_EXT, 1, 0, SITE_NODE_NAME) "
74  + " WHERE LEFT_NR > @LEFT_NR "
75  + " AND "
76  + " RIGHT_NR < @RIGHT_NR "
77      
78       
79  + " UPDATE SITE_TREE "
80  + " set SITE_NODE_SHORTNAME = stuff(@NAME_EXT, 1, 0, SITE_NODE_SHORTNAME) "
81  + " WHERE LEFT_NR > @LEFT_NR "
82  + " AND "
83  + " RIGHT_NR < @RIGHT_NR "
84  + " END " ;
85     
86     
87     public void initQuery(Connection con) {
88         super.initQuery(
89             con,
90             isPrepared,
91             paramOrder,
92             paramTypes,
93             setRelevants,
94             sqlString );
95     }
96 }
97
98
99
Popular Tags