KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBPropGroupDelete


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPropGroupDelete.java,v 1.2 2001/08/15 13:16:28 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10 import com.teamkonzept.webman.mainint.db.queries.properties.*;
11 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
12
13 /*
14  * TKDBPropDelete
15  * input "PROP_NAME"
16  * output nada
17  * delete entry in PROPERTIES
18  */
19 public class TKDBPropGroupDelete extends TKExtendedPrepQuery
20 {
21
22     public final static boolean isPrepared = true;
23
24     public final static String JavaDoc[] paramOrder =
25     { "PROPGROUP_ID", "PROPGROUP_ID" };
26
27     public final static Object JavaDoc[][] paramTypes =
28     { {"PROPGROUP_ID", new Integer JavaDoc(Types.INTEGER)} };
29
30     public final static boolean[] setRelevants = { true };
31
32     /* public final static String sqlString =
33
34        "BEGIN TRANSACTION " +
35
36        "delete " +
37        "PROPERTY_GROUP_MEMBER " +
38        "where "+
39        " PROPERTY_GROUP_ID = ? " +
40
41        "delete " +
42        "PROPERTY_GROUP " +
43        "where " +
44        " PROPERTY_GROUP_ID = ? " +
45
46        "COMMIT TRANSACTION " ; */
47
48     protected static Class JavaDoc[] queryClasses = {
49     DeletePropertyGroupMember.class, // [0]
50 DeletePropertyGroup.class // [1]
51 };
52
53     public boolean execute()
54     {
55     try
56     {
57
58         init(queryClasses); // init query objects
59
60         // BEGIN TRANSACTION
61 boolean isNotOpen = aTKDBConnection.isAutoCommit();
62         if (isNotOpen)
63         {
64         TKDBManager.beginTransaction(); // begin transaction
65 }
66
67         Object JavaDoc propGroupId = queryParams.get("PROPGROUP_ID");
68         // NEW: DELETE PROPERTY_GROUP_MEMBER WHERE PROPERTY_GROUP_ID = ?
69 // PARAMS: PROPGROUP_ID
70 // CLASS: DeletePropertyGroupMember.class
71 // [0]
72 queries[0].setQueryParams("PROPGROUP_ID", propGroupId);
73           queries[0].execute();
74
75
76         // DELETE PROPERTY_GROUP WHERE PROPERTY_GROUP_ID = ?
77 // PARAMS: PROPGROUP_ID
78 // CLASS: DeletePropertyGroup.class
79 // [1]
80 queries[1].setQueryParams("PROPGROUP_ID", propGroupId);
81           queries[1].execute();
82
83         // COMMIT TRANSACTION
84 if (isNotOpen)
85         {
86         aTKDBConnection.commitTransaction(); // commit all changes
87 }
88
89     }
90     catch(Throwable JavaDoc t)
91     {
92         TKDBManager.safeRollbackTransaction(t);
93     }
94     return hasResults();
95     }
96
97     public void initQuery(Connection con)
98     {
99     super.initQuery(con,
100             isPrepared,
101             paramOrder, paramTypes, setRelevants, sqlString);
102     }
103 }
104
Popular Tags