KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > acl > db > queries > sybase > PolicyInsert


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