KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > workflow > db > queries > DeleteFilter


1 package de.webman.content.workflow.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
7 import de.webman.content.workflow.db.queries.DeleteVersionStatusFilterRule;
8 import de.webman.content.workflow.db.queries.DeleteVersionStatusFilter;
9
10 /*
11  *
12  * deletes entries in VERSION_STATUS_FILTER_RULE and VERSION_STATUS_FILTER
13  * @author
14  * @version
15  */
16 public class DeleteFilter extends TKExtendedPrepQuery
17 {
18
19     public final static boolean ISPREPARED = true;
20     public final static String JavaDoc[] ORDER = { "FILTER_ID" };
21     public final static Object JavaDoc[][] TYPES =
22     { {"FILTER_ID", new Integer JavaDoc(Types.INTEGER)} };
23     public final static boolean[] SETRELEVANTS = { true };
24
25     protected static Class JavaDoc[] queryClasses = {
26     DeleteVersionStatusFilterRule.class,
27     DeleteVersionStatusFilter.class
28     };
29
30     public boolean execute()
31     {
32     try
33     {
34         init(queryClasses);
35
36         boolean isNotOpen = aTKDBConnection.isAutoCommit();
37         if (isNotOpen)
38         {
39         TKDBManager.beginTransaction();
40         }
41
42         // DELETE FROM VERSION_STATUS_FILTER_RULE WHERE FILTER_ID = ?
43 queries[0].setQueryParams("FILTER_ID", queryParams.get("FILTER_ID"));
44         queries[0].execute();
45
46         // DELETE FROM VERSION_STATUS_FILTER WHERE FILTER_ID = ?
47
48         queries[1].setQueryParams("FILTER_ID", queryParams.get("FILTER_ID"));
49         queries[1].execute();
50
51         if (isNotOpen)
52         {
53         TKDBManager.commitTransaction();
54         }
55
56     }
57     catch(Throwable JavaDoc t)
58     {
59         TKDBManager.safeRollbackTransaction(t);
60     }
61     return hasResults();
62     }
63
64     public void initQuery(Connection con)
65     {
66     super.initQuery(con,
67             ISPREPARED, ORDER, TYPES, SETRELEVANTS, sqlString);
68     }
69 }
70
Popular Tags