KickJava   Java API By Example, From Geeks To Geeks.

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


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