KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBDocContentUpdate.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  * TKDBDocContentUpdate
13  * Schreibt einen DS fuer einen Document_Content
14  *
15  * Input: Kompl. DS
16  * Output: none
17  */
18 public class TKDBDocContentUpdate 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",
26           "SITE_NODE_ID", "SITE_NODE_DOC_IDX",
27           "PRESENTATION_COMPONENT_IDX", "CONTENT_NODE_ID",
28           "SITE_NODE_ID", "SITE_NODE_DOC_IDX",
29           "PRESENTATION_COMPONENT_IDX"
30          };
31     
32     public final static Object JavaDoc[][] paramTypes =
33         {
34             {"SELECTION_TYPE", new Integer JavaDoc(Types.VARCHAR)},
35             {"SELECTION_DATA", new Integer JavaDoc(Types.LONGVARCHAR)}
36         };
37                 
38     public final static boolean[] setRelevants =
39         { false };
40         
41     public final static String JavaDoc sqlString =
42     
43         "DECLARE @ST VARCHAR(80) " +
44         "DECLARE @SID INT " +
45         "DECLARE @OLDSID INT " +
46
47         "SELECT @ST = ? " +
48         "SELECT @SID = NULL " +
49         "SELECT @OLDSID = NULL " +
50
51         "BEGIN TRANSACTION " +
52
53         "IF ( @ST IS NOT NULL ) " +
54         "BEGIN " +
55             "SELECT " +
56             " @SID = ISNULL(MAX(SELECTION_ID) + 1,0) " +
57             "FROM " +
58             " CONTENT_SELECTION " +
59             
60             "INSERT INTO "+
61             " CONTENT_SELECTION " +
62             " (SELECTION_ID, SELECTION_TYPE, SELECTION_DATA) " +
63             "VALUES " +
64             " (@SID, @ST, ?) " +
65         "END " +
66
67         "SELECT " +
68         " @OLDSID = SELECTION_ID " +
69         "FROM " +
70         " DOCUMENT_CONTENT " +
71         "WHERE " +
72         " SITE_NODE_ID = ? " +
73         "AND " +
74         " SITE_NODE_DOC_IDX = ? " +
75         "AND " +
76         " PRESENTATION_COMPONENT_IDX = ? " +
77
78         "UPDATE " +
79         " DOCUMENT_CONTENT " +
80         "SET " +
81         " CONTENT_NODE_ID = ?, " +
82         " SELECTION_ID = @SID " +
83         "WHERE " +
84         " SITE_NODE_ID = ? " +
85         "AND " +
86         " SITE_NODE_DOC_IDX = ? " +
87         "AND " +
88         " PRESENTATION_COMPONENT_IDX = ? " +
89         
90         "IF (@OLDSID IS NOT NULL) " +
91         "BEGIN " +
92             "DELETE FROM " +
93             " CONTENT_SELECTION " +
94             "WHERE " +
95             " SELECTION_ID = @OLDSID " +
96         "END " +
97         
98         "COMMIT TRANSACTION ";
99     
100     public void initQuery(Connection con) {
101         super.initQuery(
102             con,
103             isPrepared,
104             paramOrder,
105             paramTypes,
106             setRelevants,
107             sqlString );
108     }
109 }
110
111
112
Popular Tags