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 PolicySelectByUserRoleContextTypeReference 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_TYPE", 26 "OBJECT_REFERENCE" 27 }; 28 29 public static final Object [][] TYPES = 30 { 31 {"WM_USER_ID", new Integer (Types.INTEGER)}, 32 {"WM_ROLE_ID", new Integer (Types.INTEGER)}, 33 {"WM_CONTEXT_ID", new Integer (Types.INTEGER)}, 34 {"OBJECT_TYPE", new Integer (Types.INTEGER)}, 35 {"OBJECT_REFERENCE", new Integer (Types.INTEGER)} 36 }; 37 38 public static final boolean[] RELEVANTS = 39 { 40 true 41 }; 42 43 public static final String SQL = (new StringBuffer ()).append("SELECT WM_POLICY_ID FROM WM_POLICY WHERE ") 44 .append("WM_USER_ID = ? AND ") 45 .append("WM_ROLE_ID = ? AND ") 46 .append("WM_CONTEXT_ID = ? AND ") 47 .append("OBJECT_TYPE = ? AND ") 48 .append("OBJECT_REFERENCE = ? ") 49 .toString(); 50 51 52 54 public void initQuery (Connection connection) 55 { 56 super.initQuery(connection, 57 true, 58 ORDER, 59 TYPES, 60 RELEVANTS, 61 SQL); 62 } 63 64 } 65 | Popular Tags |