KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > acl > db > queries > EventDelete


1 package de.webman.acl.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.Types JavaDoc;
5 import java.sql.SQLException JavaDoc;
6 import com.teamkonzept.db.*;
7 import com.teamkonzept.webman.mainint.db.queries.accesscontrol.*;
8 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
9
10 /**
11  * $Header: /cvsroot/webman-cms/source/webman/de/webman/acl/db/queries/EventDelete.java,v 1.2 2001/09/19 11:51:38 markus Exp $
12  *
13  * @version 0.10
14  * @since 0.10
15  * @author © 2000 Team-Konzept
16  */
17 public class EventDelete
18     extends TKExtendedPrepQuery
19 {
20
21     // Constants
22
23     public static final String JavaDoc[] ORDER =
24     {
25         "WM_EVENT_ID",
26         "WM_EVENT_ID"
27     };
28
29     public static final Object JavaDoc[][] TYPES =
30     {
31         {"WM_EVENT_ID", new Integer JavaDoc(Types.INTEGER)},
32         {"WM_EVENT_ID", new Integer JavaDoc(Types.INTEGER)}
33     };
34
35     public static final boolean[] RELEVANTS =
36     {
37         false
38     };
39
40 /* public static final String SQL = (new StringBuffer()).append("DELETE FROM WM_ACTION_EVENT WHERE WM_EVENT_ID = ? ")
41                                                          .append("DELETE FROM WM_EVENT WHERE WM_EVENT_ID = ?")
42                                                          .toString(); */
43
44
45   public static final String JavaDoc SQL = null;
46
47     protected static Class JavaDoc[] queryClasses = { DeleteWMActionEvent.class, DeleteWMEvent.class };
48
49     // Method implementations
50
51   public boolean execute() {
52     try {
53         init(queryClasses);
54
55         boolean isNotOpen = aTKDBConnection.isAutoCommit();
56         if (isNotOpen) { aTKDBConnection.beginTransaction(); }
57
58         queries[0].setQueryParams("WM_EVENT_ID", queryParams.get("WM_EVENT_ID"));
59         queries[0].execute(); // execute first query
60
61         queries[1].setQueryParams("WM_EVENT_ID", queryParams.get("WM_EVENT_ID"));
62         queries[1].execute(); // ...and execute it
63
64         if (isNotOpen) { aTKDBConnection.commitTransaction(); }
65     }
66     catch (SQLException JavaDoc sqle) {
67       WebmanExceptionHandler.getException(sqle);
68       try {
69         aTKDBConnection.rollbackTransaction();
70       }
71       catch (SQLException JavaDoc sqle2) {
72         WebmanExceptionHandler.getException(sqle2);
73       }
74     }
75     finally {
76         return hasResults();
77     }
78   }
79
80     public void initQuery (Connection JavaDoc connection)
81     {
82         super.initQuery(connection,
83                         true,
84                         ORDER,
85                         TYPES,
86                         RELEVANTS,
87                         SQL);
88     }
89
90 }
91
Popular Tags