01: package de.webman.content.db.queries;
02:
03: import de.webman.content.db.queries.DeleteContentAttrValueByValue;
04: import de.webman.content.db.queries.DeleteContentAttrByValue;
05:
06: import com.teamkonzept.db.*;
07: import java.sql.*;
08:
09: /**
10: * <pre>
11: * Used Queries:
12: * {@link de.webman.content.db.queries.DeleteContentAttrValueByValue DeleteContentAttrValueByValue}
13: * {@link de.webman.content.db.queries.DeleteContentAttrByValue DeleteContentAttrByValue}
14: * Params:
15: * {"VALUE_ID"}
16: * </pre>
17: * @author markus
18: * @version
19: */
20: public class TKDBContentAttributeDelete extends TKExtendedPrepQuery {
21:
22: public final static boolean ISPREPARED = true;
23: public final static String[] PARAMORDER = { "VALUE_ID" };
24: public final static Object[][] PARAMTYPES = null;
25: public final static boolean[] SETRELEVANTS = { false };
26:
27: protected static Class[] queryClasses = {
28: DeleteContentAttrValueByValue.class, // [0]
29: DeleteContentAttrByValue.class, // [1]
30: };
31:
32: public boolean execute() {
33: try {
34:
35: init(queryClasses); // init query objects
36:
37: // BEGIN TRANSACTION
38: boolean isNotOpen = aTKDBConnection.isAutoCommit();
39: if (isNotOpen) {
40: TKDBManager.beginTransaction(); // begin transaction
41: }
42:
43: // [0]
44: queries[0].setQueryParams("VALUE_ID", queryParams
45: .get("VALUE_ID"));
46: queries[0].execute();
47: // [1]
48: queries[1].setQueryParams("VALUE_ID", queryParams
49: .get("VALUE_ID"));
50: queries[1].execute();
51:
52: // COMMIT TRANSACTION
53: if (isNotOpen) {
54: aTKDBConnection.commitTransaction(); // commit all changes
55: }
56:
57: } catch (Throwable t) {
58: TKDBManager.safeRollbackTransaction(t);
59: }
60: return hasResults();
61: }
62:
63: public void initQuery(Connection con) {
64: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
65: SETRELEVANTS, null);
66: }
67: }
|