KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBSiteDocDelete.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  * TKDBSiteDocDelete
13  * input -> PK: SITE_NODE_ID, SITE_NODE_DOC_IDX
14  * ouput none
15  */

16 public class TKDBSiteDocDelete extends TKPrepQuery{
17
18     public final static boolean isPrepared =
19         true;
20     
21     public final static String JavaDoc[] paramOrder =
22         {"SITE_NODE_ID", "SITE_NODE_DOC_IDX" };
23     
24     public final static Object JavaDoc[][] paramTypes =
25         null;
26         
27     public final static boolean[] setRelevants =
28         { false };
29         
30     public final static String JavaDoc sqlString =
31         "DECLARE @ID int " +
32         "DECLARE @IDX int " +
33         
34         "SELECT @ID = ? " +
35         "SELECT @IDX = ? " +
36         
37         "CREATE TABLE #temp (SELECTION_ID int) " +
38
39         "BEGIN TRANSACTION " +
40         
41         "DELETE FROM " +
42         " DOCUMENT_REFERENCE " +
43         "WHERE " +
44         " SRC_SITE_NODE_ID = @ID " +
45         "AND " +
46         " SRC_SITE_NODE_DOC_IDX = @IDX " +
47
48         "INSERT INTO " +
49         " #temp " +
50         " (SELECTION_ID) " +
51         "SELECT " +
52         " SELECTION_ID " +
53         "FROM " +
54         " DOCUMENT_CONTENT " +
55         "WHERE " +
56         " SITE_NODE_ID = @ID " +
57         "AND " +
58         " SITE_NODE_DOC_IDX = @IDX " +
59         "AND " +
60         " SELECTION_ID IS NOT NULL " +
61
62         "DELETE FROM " +
63         " DOCUMENT_CONTENT " +
64         "WHERE " +
65         " SITE_NODE_ID = @ID " +
66         "AND " +
67         " SITE_NODE_DOC_IDX = @IDX " +
68         
69         "DELETE FROM " +
70         " CONTENT_SELECTION " +
71         "WHERE " +
72         " SELECTION_ID IN ( " +
73             "SELECT " +
74             " SELECTION_ID " +
75             "FROM " +
76             " #temp " +
77           ") " +
78
79         "DELETE FROM " +
80         " SITE_DOCUMENT " +
81         "WHERE " +
82         " SITE_NODE_ID = @ID " +
83         "AND " +
84         " SITE_NODE_DOC_IDX = @IDX " +
85         
86         "COMMIT TRANSACTION " +
87         
88         "DROP TABLE #temp ";
89     
90     public void initQuery(Connection con) {
91         super.initQuery(
92             con,
93             isPrepared,
94             paramOrder,
95             paramTypes,
96             setRelevants,
97             sqlString );
98     }
99 }
100
101
Popular Tags