1 package de.webman.acl.db.queries; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.TKPrepQuery; 6 7 14 public class PolicyUpdate 15 extends TKPrepQuery 16 { 17 18 20 public static final String [] ORDER = 21 { 22 "WM_USER_ID", 23 "WM_ROLE_ID", 24 "WM_CONTEXT_ID", 25 "OBJECT_REFERENCE", 26 "OBJECT_TYPE", 27 "POLICY_ACCESS", 28 "WM_POLICY_ID" 29 }; 30 31 public static final Object [][] TYPES = 32 { 33 {"WM_USER_ID", new Integer (Types.INTEGER)}, 34 {"WM_ROLE_ID", new Integer (Types.INTEGER)}, 35 {"WM_CONTEXT_ID", new Integer (Types.INTEGER)}, 36 {"OBJECT_REFERENCE", new Integer (Types.INTEGER)}, 37 {"OBJECT_TYPE", new Integer (Types.INTEGER)}, 38 {"POLICY_ACCESS", new Integer (Types.CHAR)}, 39 {"WM_POLICY_ID", new Integer (Types.INTEGER)} 40 }; 41 42 public static final boolean[] RELEVANTS = 43 { 44 false 45 }; 46 47 public static final String SQL = "UPDATE WM_POLICY SET WM_USER_ID = ?, WM_ROLE_ID = ?, WM_CONTEXT_ID = ?, OBJECT_REFERENCE = ?, OBJECT_TYPE = ?, POLICY_ACCESS = ? WHERE WM_POLICY_ID = ?"; 48 49 50 52 public void initQuery (Connection connection) 53 { 54 super.initQuery(connection, 55 true, 56 ORDER, 57 TYPES, 58 RELEVANTS, 59 SQL); 60 } 61 62 } 63 | Popular Tags |