KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.duplication.oracle;
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 "
35      + " name_ext VARCHAR2(255); "
36      + " si_node_id INTEGER; "
37      + " pos INTEGER; "
38      + " BEGIN "
39      + " name_ext := ? ; "
40      + " pos := ?; "
41      + " si_node_id := ?; "
42       
43      + " IF (pos = 0) THEN " /* vorne anfuegen */
44      + " UPDATE SITE_TREE "
45      + " set SITE_NODE_NAME = name_ext || SITE_NODE_NAME "
46      + " WHERE SITE_NODE_ID = si_node_id; "
47         
48      + " UPDATE SITE_TREE "
49      + " set SITE_NODE_SHORTNAME = name_ext || SITE_NODE_SHORTNAME "
50      + " WHERE SITE_NODE_ID = si_node_id; "
51      + " ELSE " /* hinten anfuegen */
52      + " UPDATE SITE_TREE "
53      + " set SITE_NODE_NAME = SITE_NODE_NAME || name_ext "
54      + " WHERE SITE_NODE_ID = si_node_id; "
55      
56           
57      + " UPDATE SITE_TREE "
58      + " set SITE_NODE_SHORTNAME = SITE_NODE_SHORTNAME || name_ext "
59      + " WHERE SITE_NODE_ID = si_node_id; "
60      + " END IF ; "
61      + " END; "
62         
63 ;
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