KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/oracle/Attic/TKDBPresDelete.java,v 1.4 2001/06/11 09:14:12 alex Exp $
3  *
4  */

5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */

8 package com.teamkonzept.webman.mainint.db.queries.oracle;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
14 import com.teamkonzept.webman.mainint.db.queries.presentation.*;
15
16 /*
17  * TKDBPresDelete
18  * input "PRESENTATION_ID"
19  * output none
20  * loescht aus PRESENTATION sowie alle referentiellen Verweise
21  */

22 public class TKDBPresDelete extends TKExtendedPrepQuery
23 {
24
25     public final static boolean isPrepared = true;
26
27     public final static String JavaDoc[] order = { "PRESENTATION_ID" };
28
29     public final static Object JavaDoc[][] types = null;
30
31     public final static boolean[] setRelevants = { false };
32
33 /* public final static String sqlString =
34         "DECLARE @PID int " +
35         "SELECT @PID = ? " +
36
37         "BEGIN TRANSACTION " +
38
39         "DELETE FROM " +
40         " PRESENTATION_REFERENCE " +
41         "WHERE " +
42         " PRESENTATION_ID = @PID " +
43
44         "DELETE FROM " +
45         " PRESENTATION_CONTENT " +
46         "WHERE " +
47         " PRESENTATION_ID = @PID " +
48
49         "DELETE FROM " +
50         " PRESENTATION_COMPONENT " +
51         "WHERE " +
52         " PRESENTATION_ID = @PID " +
53
54         "DELETE FROM " +
55         " PRESENTATION " +
56         "WHERE " +
57         " PRESENTATION_ID = @PID " +
58
59         "COMMIT "; */

60
61     protected static Class JavaDoc[] queryClasses = {
62     DeleteFromPresentationReferenceSimple.class,
63     DeleteFromPresentationContentSimple.class,
64     DeleteFromPresentationComponentSimple.class,
65     DeleteFromPresentationSimple.class
66     };
67
68     public boolean execute()
69     {
70     try
71     {
72         init(queryClasses);
73
74         Integer JavaDoc presId = (Integer JavaDoc) queryParams.get("PRESENTATION_ID");
75
76         boolean isNotOpen = aTKDBConnection.isAutoCommit();
77         if (isNotOpen)
78         {
79         TKDBManager.beginTransaction();
80         }
81
82         // DELETE FROM PRESENTATION_REFERENCE WHERE PRESENTATION_ID = @PID
83
queries[0].setQueryParams("PRESENTATION_ID", presId);
84           queries[0].execute();
85
86         // DELETE FROM PRESENTATION_CONTENT WHERE PRESENTATION_ID = @PID
87
queries[1].setQueryParams("PRESENTATION_ID", presId);
88           queries[1].execute();
89
90         // DELETE FROM PRESENTATION_COMPONENT WHERE PRESENTATION_ID = @PID
91
queries[2].setQueryParams("PRESENTATION_ID", presId);
92           queries[2].execute();
93
94         // DELETE FROM PRESENTATION WHERE PRESENTATION_ID = @PID
95
queries[3].setQueryParams("PRESENTATION_ID", presId);
96           queries[3].execute();
97
98         if (isNotOpen)
99         {
100         TKDBManager.commitTransaction();
101         }
102
103     }
104     catch(Throwable JavaDoc t)
105     {
106         TKDBManager.safeRollbackTransaction(t);
107     }
108     return hasResults();
109     }
110
111     public void initQuery(Connection con)
112     {
113     super.initQuery(con, isPrepared, order, types, setRelevants, null);
114     }
115 }
116
Popular Tags