KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > db > queries > TKDBFormTablesDelete


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/field/db/queries/TKDBFormTablesDelete.java,v 1.6 2001/10/15 09:59:51 markus Exp $
3  *
4  */
5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */
8 package com.teamkonzept.field.db.queries;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13 import com.teamkonzept.webman.mainint.db.queries.field.*;
14 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
15
16 /**
17  * @author
18  * @version
19  */
20 public class TKDBFormTablesDelete extends TKExtendedPrepQuery
21 {
22
23     public final static boolean ISPREPARED = true;
24
25     public final static String JavaDoc[] PARAMORDER =
26     { "FORM_ID", "FORM_ID", "FORM_ID" };
27
28     public final static Object JavaDoc[][] PARAMTYPESLOCAL = null;
29
30     public final static boolean[] SETRELEVANTS = { false, false, false };
31
32     protected static Class JavaDoc[] queryClasses = {
33     DeleteFieldAttribute.class,
34     DeleteSubField.class,
35     DeleteField.class
36     };
37
38     public boolean execute()
39     {
40     try
41     {
42         init(queryClasses); // init query objects
43 boolean isNotOpen = aTKDBConnection.isAutoCommit();
44         if (isNotOpen)
45         {
46         TKDBManager.beginTransaction();
47         }
48
49         Object JavaDoc formId = queryParams.get("FORM_ID");
50
51           queries[0].setQueryParams("FORM_ID", formId);
52           queries[0].execute(); // execute first query
53
54           queries[1].setQueryParams("FORM_ID", formId);
55           queries[1].execute();
56
57           queries[2].setQueryParams("FORM_ID", formId);
58           queries[2].execute();
59
60         if (isNotOpen)
61         {
62         aTKDBConnection.commitTransaction();
63         }
64     }
65     catch(Throwable JavaDoc t)
66     {
67         TKDBManager.safeRollbackTransaction(t);
68     }
69     return hasResults();
70     }
71
72
73     public void initQuery(Connection con)
74     {
75     super.initQuery(con,
76             ISPREPARED,
77             PARAMORDER, PARAMTYPESLOCAL, SETRELEVANTS, null);
78     }
79 }
80
Popular Tags