KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.acl.db.queries;
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/PolicySelectByContentTree.java,v 1.2 2001/10/05 14:28:42 markus Exp $
9  *
10  * @version 0.10
11  * @since 0.10
12  * @author © 2000 Team-Konzept
13  */
14 public class PolicySelectByContentTree
15     extends TKPrepQuery
16 {
17
18     // Constants
19
20     public static final String JavaDoc[] ORDER =
21     {
22         "OBJECT_REFERENCE",
23         "WM_USER_ID",
24         "WM_CONTEXT_ID",
25         "OBJECT_TYPE"
26     };
27
28     public static final Object JavaDoc[][] TYPES =
29     {
30         {"OBJECT_REFERENCE", new Integer JavaDoc(Types.INTEGER)},
31         {"WM_USER_ID", new Integer JavaDoc(Types.INTEGER)},
32         {"WM_CONTEXT_ID", new Integer JavaDoc(Types.INTEGER)},
33         {"OBJECT_TYPE", new Integer JavaDoc(Types.INTEGER)}
34     };
35
36     public static final boolean[] RELEVANTS =
37     {
38         true
39     };
40
41     public static final String JavaDoc SQL = (new StringBuffer JavaDoc()).append("SELECT POLICY.WM_POLICY_ID ")
42                                                          .append("FROM WM_POLICY POLICY, CONTENT_TREE CONTENT, CONTENT_TREE TREE ")
43                                                          .append("WHERE ")
44                                                          .append(" CONTENT.CONTENT_NODE_ID = ? AND ")
45                                                          .append(" TREE.LEFT_NR <= CONTENT.LEFT_NR AND ")
46                                                          .append(" TREE.RIGHT_NR >= CONTENT.RIGHT_NR AND ")
47                                                          .append(" TREE.CONTENT_NODE_ID = POLICY.OBJECT_REFERENCE AND ")
48                                                          .append(" POLICY.WM_USER_ID = ? AND ")
49                                                          .append(" POLICY.WM_CONTEXT_ID = ? AND ")
50                                                          .append(" POLICY.OBJECT_TYPE = ? ")
51                                                          .append("ORDER BY TREE.LEFT_NR ASC")
52                                                          .toString();
53
54
55     // Method implementations
56
57     public void initQuery (Connection JavaDoc connection)
58     {
59         super.initQuery(connection,
60                         true,
61                         ORDER,
62                         TYPES,
63                         RELEVANTS,
64                         SQL);
65     }
66
67 }
68
Popular Tags