KickJava   Java API By Example, From Geeks To Geeks.

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


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 /**
13  * fügt an die Namen eines Site Knoten
14  * die Erweiterung NAME_EXT an, vorne wenn POS == 0, sonst hinten.
15  * NODE_NAME und NODE_SHORTNAME werden veraendert
16  */
17 public class TKDBSiteNodeNameExtend extends TKPrepQuery{
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         { "NAME_EXT", "POS" , "SITE_NODE_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   " DECLARE @NAME_EXT varchar(100) "
35  + " DECLARE @SITE_NODE_ID int "
36  + " DECLARE @POS int "
37
38  + " SELECT @NAME_EXT = ? "
39  + " SELECT @POS = ? "
40  + " SELECT @SITE_NODE_ID = ? "
41
42  + " IF (@POS = 0) "
43  + " BEGIN " /* vorne anfuegen */
44  + " UPDATE SITE_TREE "
45  + " set SITE_NODE_NAME = stuff(SITE_NODE_NAME, 1, 0, @NAME_EXT) "
46  + " WHERE SITE_NODE_ID = @SITE_NODE_ID "
47     
48  + " UPDATE SITE_TREE "
49  + " set SITE_NODE_SHORTNAME = stuff(SITE_NODE_SHORTNAME, 1, 0, @NAME_EXT) "
50  + " WHERE SITE_NODE_ID = @SITE_NODE_ID "
51  + " END "
52  
53  + " ELSE "
54  + " BEGIN " /* hinten anfuegen */
55  + " UPDATE SITE_TREE "
56  + " set SITE_NODE_NAME = stuff(@NAME_EXT, 1, 0, SITE_NODE_NAME) "
57  + " WHERE SITE_NODE_ID = @SITE_NODE_ID "
58  
59       
60  + " UPDATE SITE_TREE "
61  + " set SITE_NODE_SHORTNAME = stuff(@NAME_EXT, 1, 0, SITE_NODE_SHORTNAME) "
62  + " WHERE SITE_NODE_ID = @SITE_NODE_ID "
63  + " END " ;
64     
65     
66     public void initQuery(Connection con) {
67         super.initQuery(
68             con,
69             isPrepared,
70             paramOrder,
71             paramTypes,
72             setRelevants,
73             sqlString );
74     }
75 }
76
77
78
Popular Tags