KickJava   Java API By Example, From Geeks To Geeks.

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


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