KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > acl > db > queries > oracle > PolicySelectByAtomicEventObject


1 package de.webman.acl.db.queries.oracle;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.Types JavaDoc;
5 import com.teamkonzept.db.TKPrepQuery;
6
7 /**
8  * $Header: /cvsroot/webman-cms/source/webman/de/webman/acl/db/queries/oracle/PolicySelectByAtomicEventObject.java,v 1.1 2001/08/20 08:25:09 mischa Exp $
9  *
10  * is identical to com.teamkonzept.webman.accesscontrol.db.queries.PolicySelectByAtomicEvent
11  * @version 0.10
12  * @since 0.10
13  * @author © 2000 Team-Konzept
14  */
15 public class PolicySelectByAtomicEventObject
16     extends TKPrepQuery
17 {
18
19     // Constants
20
21     public static final String JavaDoc[] ORDER =
22     {
23         "WM_USER_ID",
24         "WM_CONTEXT_ID",
25         "OBJECT_REFERENCE",
26         "OBJECT_TYPE",
27         "WM_EVENT_ID"
28     };
29
30     public static final Object JavaDoc[][] TYPES =
31     {
32         {"WM_USER_ID", new Integer JavaDoc(Types.INTEGER)},
33         {"WM_CONTEXT_ID", new Integer JavaDoc(Types.INTEGER)},
34         {"OBJECT_REFERENCE", new Integer JavaDoc(Types.INTEGER)},
35         {"OBJECT_TYPE", new Integer JavaDoc(Types.INTEGER)},
36         {"WM_EVENT_ID", new Integer JavaDoc(Types.INTEGER)}
37     };
38
39     public static final boolean[] RELEVANTS =
40     {
41         true
42     };
43
44     public static final String JavaDoc SQL = (new StringBuffer JavaDoc()).append("SELECT DISTINCT WM_POLICY.WM_POLICY_ID ")
45                                                          .append("FROM WM_POLICY, WM_ROLE_TASK, WM_TASK, WM_TASK_ACTION, WM_ACTION_EVENT ")
46                                                          .append("WHERE ")
47                                                          .append(" WM_POLICY.WM_USER_ID = ? AND ")
48                                                          .append(" WM_POLICY.WM_CONTEXT_ID = ? AND ")
49                                                          .append(" WM_POLICY.OBJECT_REFERENCE = ? AND ")
50                                                          .append(" WM_POLICY.OBJECT_TYPE = ? AND ")
51                                                          .append(" WM_POLICY.WM_ROLE_ID = WM_ROLE_TASK.WM_ROLE_ID AND ")
52                                                          .append(" WM_ROLE_TASK.WM_TASK_ID = WM_TASK.WM_TASK_ID AND ")
53                                                          .append(" WM_TASK.WM_CONTEXT_ID = WM_POLICY.WM_CONTEXT_ID AND ")
54                                                          .append(" WM_TASK.WM_TASK_ID = WM_TASK_ACTION.WM_TASK_ID AND ")
55                                                          .append(" WM_TASK_ACTION.WM_ACTION_ID = WM_ACTION_EVENT.WM_ACTION_ID AND ")
56                                                          .append(" WM_ACTION_EVENT.WM_EVENT_ID = ? ")
57                                                          .toString();
58
59
60     // Method implementations
61
62     public void initQuery (Connection JavaDoc connection)
63     {
64         super.initQuery(connection,
65                         true,
66                         ORDER,
67                         TYPES,
68                         RELEVANTS,
69                         SQL);
70     }
71
72 }
73
Popular Tags