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