KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBPresCompDelete


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresCompDelete.java,v 1.10.6.1 2002/05/06 14:08:32 ralf Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
11 import com.teamkonzept.webman.mainint.db.queries.presentation.*;
12
13 /**
14  * TKDBPresCompDelete
15  * input "PRESENTATION_ID", "PRESENTATION_COMPONENT_IDX",
16  * ouptut none
17  *
18  * loescht Eintrag in PRESENTATION_COMPONENT + alle referentiellen Bezuege in
19  * PRESENTATION_COTNENT, PRESENTATION_REFERENCE
20  *
21  * PRESENTATION_COMPONENT_IDX wird neu nummeriert in
22  * PRESENTATION_COMPONENT, PRESENTATION_COTNENT, PRESENTATION_REFERENCE
23  * @author
24  * @version
25  */
26 public class TKDBPresCompDelete extends TKExtendedPrepQuery
27 {
28
29     public final static boolean ISPREPARED = true;
30
31     public final static String JavaDoc[] ORDER =
32     { "PRESENTATION_ID", "PRESENTATION_COMPONENT_IDX" };
33
34     public final static Object JavaDoc[][] TYPES = null;
35
36     public final static boolean[] SETRELEVANTS = { false };
37
38     protected static Class JavaDoc[] queryClasses = {
39     DeleteFromPresentationContent.class, // [0]
40 DeleteFromPresentationReference.class, // [1]
41 DeleteFromPresentationComponent.class, // [2]
42 DeleteFromDocumentReference.class, // [3]
43 DeleteFromDocumentContent.class // [4]
44 };
45
46     public boolean execute()
47     {
48     try
49     {
50         init(queryClasses);
51
52         Integer JavaDoc presId = (Integer JavaDoc) queryParams.get("PRESENTATION_ID");
53         Integer JavaDoc presCompIdx =
54         (Integer JavaDoc) queryParams.get("PRESENTATION_COMPONENT_IDX");
55
56         boolean isNotOpen = aTKDBConnection.isAutoCommit();
57         if (isNotOpen)
58         {
59         TKDBManager.beginTransaction();
60         }
61
62         //DELETE FROM PRESENTATION_CONTENT
63 //WHERE PRESENTATION_ID = ? AND PRESENTATION_COMPONENT_IDX = ?
64 queries[0].setQueryParams("PRESENTATION_ID", presId);
65           queries[0].setQueryParams("PRESENTATION_COMPONENT_IDX", presCompIdx);
66           queries[0].execute();
67
68           //DELETE FROM PRESENTATION_REFERENCE
69 //WHERE PRESENTATION_ID = ? AND PRESENTATION_COMPONENT_IDX = ?
70 queries[1].setQueryParams("PRESENTATION_ID", presId);
71           queries[1].setQueryParams("PRESENTATION_COMPONENT_IDX", presCompIdx);
72           queries[1].execute();
73
74           //DELETE FROM PRESENTATION_COMPONENT
75 //WHERE PRESENTATION_ID = ? AND PRESENTATION_COMPONENT_IDX = ?
76 queries[2].setQueryParams("PRESENTATION_ID", presId);
77           queries[2].setQueryParams("PRESENTATION_COMPONENT_IDX", presCompIdx);
78           queries[2].execute();
79
80           //DELETE FROM DOCUMENT_REFERENCE
81 //WHERE SRC_PRESENTATION_COMPONENT_IDX = ? AND
82 // SRC_SITE_NODE_ID IN
83 // ( SELECT S.SITE_NODE_ID FROM SITE_DOCUMENT S, DOCUMENT_REFERENCE D
84 // WHERE PRESENTATION_ID = ? AND S.SITE_NODE_ID = D.SRC_SITE_NODE_ID AND
85 // S.SITE_NODE_DOC_IDX = D.SRC_SITE_NODE_DOC_IDX )
86 // AND SRC_SITE_NODE_DOC_IDX IN
87 // ( SELECT S.SITE_NODE_DOC_IDX FROM SITE_DOCUMENT S, DOCUMENT_REFERENCE D
88 // WHERE PRESENTATION_ID = ? AND S.SITE_NODE_ID = D.SRC_SITE_NODE_ID AND
89 // S.SITE_NODE_DOC_IDX = D.SRC_SITE_NODE_DOC_IDX )
90 queries[3].setQueryParams("PRESENTATION_ID", presId);
91           queries[3].setQueryParams("PRESENTATION_COMPONENT_IDX", presCompIdx);
92           queries[3].execute();
93
94           //DELETE FROM DOCUMENT_CONTENT
95 //WHERE PRESENTATION_COMPONENT_IDX = ? AND SITE_NODE_ID IN
96 // ( SELECT S.SITE_NODE_ID FROM SITE_DOCUMENT S, DOCUMENT_CONTENT D
97 // WHERE PRESENTATION_ID = ? AND S.SITE_NODE_ID = D.SITE_NODE_ID AND
98 // S.SITE_NODE_DOC_IDX = D.SITE_NODE_DOC_IDX )
99 // AND SITE_NODE_DOC_IDX IN
100 // ( SELECT S.SITE_NODE_DOC_IDX FROM SITE_DOCUMENT S, DOCUMENT_CONTENT D
101 // WHERE PRESENTATION_ID = ? AND S.SITE_NODE_ID = D.SITE_NODE_ID AND
102 // S.SITE_NODE_DOC_IDX = D.SITE_NODE_DOC_IDX )
103 queries[4].setQueryParams("PRESENTATION_ID", presId);
104           queries[4].setQueryParams("PRESENTATION_COMPONENT_IDX", presCompIdx);
105           queries[4].execute();
106
107         if (isNotOpen)
108         {
109         TKDBManager.commitTransaction();
110         }
111
112     }
113     catch(Throwable JavaDoc t)
114     {
115         TKDBManager.safeRollbackTransaction(t);
116     }
117     return hasResults();
118     }
119
120     public void initQuery(Connection con)
121     {
122     super.initQuery(con, ISPREPARED, ORDER, TYPES, SETRELEVANTS, null);
123     }
124 }
125
Popular Tags