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