KickJava   Java API By Example, From Geeks To Geeks.

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


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/PropertyUpdate.java,v 1.1 2001/08/20 08:25:09 mischa Exp $
9  *
10  * @version 0.10
11  * @since 0.10
12  * @author © 2000 Team-Konzept
13  */

14 public class PropertyUpdate
15     extends TKPrepQuery
16 {
17
18     // Constants
19

20     public static final String JavaDoc[] ORDER =
21     {
22         "WM_USER_ID",
23         "NAME",
24         "VALUE",
25         "WM_PROPERTIES_ID"
26     };
27
28     public static final Object JavaDoc[][] TYPES =
29     {
30         {"WM_USER_ID", new Integer JavaDoc(Types.INTEGER)},
31         {"NAME", new Integer JavaDoc(Types.VARCHAR)},
32         {"VALUE", new Integer JavaDoc(Types.VARCHAR)},
33         {"WM_PROPERTIES_ID", new Integer JavaDoc(Types.INTEGER)}
34     };
35
36     public static final boolean[] RELEVANTS =
37     {
38         false
39     };
40
41     public static final String JavaDoc SQL = "UPDATE WM_PROPERTIES SET WM_USER_ID = ?, NAME = ?, VALUE = ? WHERE WM_PROPERTIES_ID = ?";
42
43
44     // Method implementations
45

46     public void initQuery (Connection JavaDoc connection)
47     {
48         super.initQuery(connection,
49                         true,
50                         ORDER,
51                         TYPES,
52                         RELEVANTS,
53                         SQL);
54     }
55
56 }
57
Popular Tags