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