KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPropDelete.java,v 1.3 2001/08/15 13:16:22 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.WebmanExceptionHandler;
11 import com.teamkonzept.webman.mainint.db.queries.properties.*;
12
13 /*
14  * TKDBPropDelete
15  * input "PROP_NAME"
16  * output nada
17  * delete entry in PROPERTIES
18  */
19 public class TKDBPropDelete extends TKExtendedPrepQuery
20 {
21
22     public final static boolean isPrepared = true;
23
24     public final static String JavaDoc[] order = { "PROP_ID", "PROP_ID" };
25
26     public final static Object JavaDoc[][] types =
27     { {"PROP_ID", new Integer JavaDoc(Types.INTEGER)} };
28
29     public final static boolean[] setRelevants = { true };
30
31 /* public final static String sqlString =
32     "BEGIN TRANSACTION " +
33
34     "delete " +
35     "PROPERTY_GROUP_MEMBER " +
36     "where "+
37     " PROPERTY_ID = ? " +
38
39     "delete " +
40     "PROPERTY " +
41     "where " +
42     " PROPERTY_ID = ? " +
43
44     "COMMIT TRANSACTION " ; */
45
46
47     protected static Class JavaDoc[] queryClasses = {
48     DeleteFromPropertyGroupMember.class,
49     DeleteFromProperty.class
50     };
51
52     public boolean execute()
53     {
54     try
55     {
56         init(queryClasses);
57
58         boolean isNotOpen = aTKDBConnection.isAutoCommit();
59         if (isNotOpen)
60         {
61         TKDBManager.beginTransaction();
62         }
63
64         // DELETE PROPERTY_GROUP_MEMBER WHERE PROPERTY_ID = ?
65 queries[0].setQueryParams("PROPERTY_ID",
66                       queryParams.get("PROP_ID"));
67           queries[0].execute();
68
69         // delete PROPERTY where PROPERTY_ID = ?
70
71          queries[1].setQueryParams("PROPERTY_ID", queryParams.get("PROP_ID"));
72           queries[1].execute();
73
74         if (isNotOpen)
75         {
76         TKDBManager.commitTransaction();
77         }
78
79     }
80     catch(Throwable JavaDoc t)
81     {
82         TKDBManager.safeRollbackTransaction(t);
83     }
84     return hasResults();
85     }
86
87     public void initQuery(Connection con)
88     {
89     super.initQuery(con,
90             isPrepared, order, types, setRelevants, sqlString);
91     }
92 }
93
Popular Tags