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 PolicySelectByUserContext 15 extends TKPrepQuery 16 { 17 18 20 public static final String [] ORDER = 21 { 22 "WM_USER_ID", 23 "WM_CONTEXT_ID" 24 }; 25 26 public static final Object [][] TYPES = 27 { 28 {"WM_USER_ID", new Integer (Types.INTEGER)}, 29 {"WM_CONTEXT_ID", new Integer (Types.INTEGER)} 30 }; 31 32 public static final boolean[] RELEVANTS = 33 { 34 true 35 }; 36 37 public static final String SQL = (new StringBuffer ()).append("SELECT WM_POLICY_ID FROM WM_POLICY WHERE ") 38 .append("WM_USER_ID = ? AND ") 39 .append("WM_CONTEXT_ID = ? ") 40 .toString(); 41 42 43 45 public void initQuery (Connection connection) 46 { 47 super.initQuery(connection, 48 true, 49 ORDER, 50 TYPES, 51 RELEVANTS, 52 SQL); 53 } 54 55 } 56 | Popular Tags |