KickJava   Java API By Example, From Geeks To Geeks.

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


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