KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > acl > db > queries > ActionInsert


1 package de.webman.acl.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.SQLException JavaDoc;
5 import java.sql.ResultSet JavaDoc;
6 import java.sql.Types JavaDoc;
7 import com.teamkonzept.webman.mainint.WebmanExceptionHandler;
8 import com.teamkonzept.db.*;
9 import com.teamkonzept.webman.mainint.db.queries.accesscontrol.*;
10
11 /**
12  * $Header: /cvsroot/webman-cms/source/webman/de/webman/acl/db/queries/ActionInsert.java,v 1.2 2001/09/19 11:51:38 markus Exp $
13  *
14  * @version 0.10
15  * @since 0.10
16  * @author © 2000 Team-Konzept
17  */
18 public class ActionInsert
19     extends TKExtendedPrepQuery
20 {
21
22     // Constants
23
24     public static final String JavaDoc[] ORDER =
25     {
26         "NAME"
27     };
28
29     public static final Object JavaDoc[][] TYPES =
30     {
31         {"NAME", new Integer JavaDoc(Types.VARCHAR)}
32     };
33
34     public static final boolean[] RELEVANTS =
35     {
36         true
37     };
38
39   public static final String JavaDoc SQL = null;
40
41     protected static Class JavaDoc[] queryClasses = {
42       SelectIDWMAction.class, // [0]
43 InsertWMAction.class, // [1]
44 SelectWMAction.class // [2]
45 };
46
47 /* public static final String SQL = (new StringBuffer()).append("DECLARE @ID INT ")
48                                                          .append("SELECT @ID = ISNULL(MAX(WM_ACTION_ID) + 1, 1) FROM WM_ACTION ")
49                                                          .append("INSERT INTO WM_ACTION (WM_ACTION_ID, NAME) VALUES (@ID, ?) ")
50                                                          .append("SELECT * FROM WM_ACTION WHERE WM_ACTION_ID = @ID")
51                                                          .toString(); */
52
53
54     // Method implementations
55
56   public boolean execute() {
57     try {
58         init(queryClasses);
59
60         boolean isNotOpen = aTKDBConnection.isAutoCommit();
61         if (isNotOpen) {
62             aTKDBConnection.beginTransaction();
63         }
64
65         queries[0].execute(); // execute first query
66
67         ResultSet JavaDoc rs = queries[0].fetchResultSet();
68         Integer JavaDoc wmActionId = null;
69         if (rs != null && rs.next()) {
70           int max = 1;
71            max = rs.getInt(1) + 1; // get max if any and increase by 1
72 wmActionId = new Integer JavaDoc(max);
73         }
74
75         queries[1].setQueryParams("WM_ACTION_ID", wmActionId);
76         queries[1].setQueryParams("NAME", queryParams.get("NAME"));
77         queries[1].execute(); // ...and execute it
78
79         queries[2].setQueryParams("WM_ACTION_ID", wmActionId);
80         queries[2].execute();
81         addResult(queries[2].fetchResultSet()); // store result for later use
82
83         if (isNotOpen) {
84           aTKDBConnection.commitTransaction();
85         }
86     }
87     catch (SQLException JavaDoc sqle) {
88       WebmanExceptionHandler.getException(sqle);
89       try {
90         aTKDBConnection.rollbackTransaction();
91       }
92       catch (SQLException JavaDoc sqle2) {
93         WebmanExceptionHandler.getException(sqle2);
94       }
95     }
96     finally {
97         return hasResults();
98     }
99   }
100
101     public void initQuery (Connection JavaDoc connection)
102     {
103         super.initQuery(connection,
104                         true,
105                         ORDER,
106                         TYPES,
107                         RELEVANTS,
108                         SQL);
109     }
110
111 }
112
Popular Tags