|
1 package com.teamkonzept.webman.mainint.db.queries.accesscontrol;
2
3 import com.teamkonzept.db.TKPrepQuery;
4 import java.sql.Connection  ;
5 import java.sql.SQLException ;
6 import java.sql.Types ;
7
8 public class InsertProperty extends TKPrepQuery
9 {
10
11 public final static boolean PREPARED = true;
12
13 public final static String [] ORDER = {
14 "WM_PROPERTIES_ID",
15 "WM_USER_ID",
16 "NAME",
17 "VALUE"
18 };
19
20 public static final Object [][] TYPES =
21 {
22 {"WM_USER_ID", new Integer (Types.INTEGER)},
23 {"NAME", new Integer (Types.VARCHAR)},
24 {"VALUE", new Integer (Types.VARCHAR)}
25 };
26
27 public final static boolean[] RELEVANTS = { true };
28
29 public final static String SQL_STRING = "INSERT INTO WM_PROPERTIES (WM_PROPERTIES_ID, WM_USER_ID, NAME, VALUE) VALUES (?, ?, ?, ?)";
30
31 public void initQuery(Connection con) {
32 super.initQuery(
33 con,
34 PREPARED,
35 ORDER,
36 TYPES,
37 RELEVANTS,
38 SQL_STRING );
39 }
40
41 }
42 |
Popular Tags |
Java API By Example, From Geeks To Geeks.