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