KickJava   Java API By Example, From Geeks To Geeks.

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


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