KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sybase > TKDBSiteTreeUpdateNode


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBSiteTreeUpdateNode.java,v 1.2 2001/08/15 12:50:09 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sybase;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBSiteTreeUpdateNode
13  * Update eines Nodes
14  * Input: SITE_NODE_ID (der zu akt. Knoten)
15  * "SITE_NODE_TYPE, SITE_NODE_NAME, SITE_NODE_SHORTNAME "
16  * Output: Keiner
17  */
18 public class TKDBSiteTreeUpdateNode extends TKPrepQuery{
19
20     public final static boolean isPrepared =
21         true;
22     
23     public final static String JavaDoc[] paramOrder =
24         {
25             "SELECTION_TYPE", "SELECTION_DATA", "SITE_NODE_ID",
26             "SITE_NODE_TYPE", "SITE_NODE_NAME", "SITE_NODE_SHORTNAME" ,
27             "PG_CONTENT_NODE", "SITE_NODE_ID"
28         };
29     
30     public final static Object JavaDoc[][] paramTypes =
31         {
32             {"SELECTION_TYPE", new Integer JavaDoc(Types.VARCHAR)},
33             {"SELECTION_DATA", new Integer JavaDoc(Types.LONGVARCHAR)},
34             { "SITE_NODE_NAME", new Integer JavaDoc(Types.VARCHAR) },
35             { "SITE_NODE_SHORTNAME", new Integer JavaDoc(Types.VARCHAR) }
36         };
37         
38     public final static boolean[] setRelevants =
39         { false };
40         
41     public final static String JavaDoc sqlString =
42         "DECLARE @ST VARCHAR(80) " +
43         "DECLARE @SID INT " +
44         "DECLARE @OLDSID INT " +
45
46         "SELECT @ST = ? " +
47         "SELECT @SID = NULL " +
48
49         "BEGIN TRANSACTION " +
50
51         "IF ( @ST IS NOT NULL ) " +
52         "BEGIN " +
53             "SELECT " +
54             " @SID = ISNULL(MAX(SELECTION_ID) + 1,0) " +
55             "FROM " +
56             " CONTENT_SELECTION " +
57             
58             "INSERT INTO "+
59             " CONTENT_SELECTION " +
60             " (SELECTION_ID, SELECTION_TYPE, SELECTION_DATA) " +
61             "VALUES " +
62             " (@SID, @ST, ?) " +
63         "END " +
64
65         "SELECT " +
66         " @OLDSID = PG_SELECTION_ID " +
67         "FROM " +
68         " SITE_TREE " +
69         "WHERE " +
70         " SITE_NODE_ID = ? " +
71     
72         "UPDATE " +
73         " SITE_TREE " +
74         "SET " +
75         " SITE_NODE_TYPE = ?, " +
76         " SITE_NODE_NAME = ?, " +
77         " SITE_NODE_SHORTNAME = ?, " +
78         " PG_CONTENT_NODE = ?, " +
79         " PG_SELECTION_ID = @SID " +
80         "WHERE " +
81         " SITE_NODE_ID = ? " +
82         
83         "IF (@OLDSID IS NOT NULL) " +
84         "BEGIN " +
85             "DELETE FROM " +
86             " CONTENT_SELECTION " +
87             "WHERE " +
88             " SELECTION_ID = @OLDSID " +
89         "END " +
90         
91         "COMMIT TRANSACTION ";
92         
93     
94     public void initQuery(Connection con) {
95         super.initQuery(
96             con,
97             isPrepared,
98             paramOrder,
99             paramTypes,
100             setRelevants,
101             sqlString );
102     }
103 }
104
105
Popular Tags