KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/field/db/queries/TKDBFormDelete.java,v 1.6 2001/10/15 09:58:27 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 TKDBFormDelete extends TKExtendedPrepQuery
21 {
22
23     public final static boolean ISPREPARED = true;
24
25     public final static String JavaDoc[] PARAMORDER = { "FORM_ID", "FORM_ID" };
26
27     public final static Object JavaDoc[][] PARAMTYPESLOCAL = null;
28
29     public final static boolean[] SETRELEVANTS = { false };
30
31     protected static Class JavaDoc[] queryClasses =
32     { DeleteStructuredContent.class, DeleteForm.class };
33
34
35     public boolean execute()
36     {
37     try
38     {
39         init(queryClasses); // init query objects
40
41         boolean isNotOpen = aTKDBConnection.isAutoCommit();
42         if (isNotOpen)
43         {
44         TKDBManager.beginTransaction();
45         }
46
47         Object JavaDoc formId = queryParams.get("FORM_ID");
48
49           queries[0].setQueryParams("FORM_ID", formId);
50           queries[0].execute(); // execute first query
51
52           queries[1].setQueryParams("FORM_ID", formId);
53           queries[1].execute(); // ...and execute it
54
55         if (isNotOpen)
56         {
57         aTKDBConnection.commitTransaction();
58         }
59
60     }
61     catch(Throwable JavaDoc t)
62     {
63         TKDBManager.safeRollbackTransaction(t);
64     }
65     return hasResults();
66     }
67
68     public void initQuery(Connection con)
69     {
70     super.initQuery(con,
71             ISPREPARED,
72             PARAMORDER, PARAMTYPESLOCAL, SETRELEVANTS, null);
73     }
74 }
75
Popular Tags