1 package de.webman.acl.db.queries.sybase; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.TKPrepQuery; 6 7 14 public class PropertyInsert 15 extends TKPrepQuery 16 { 17 18 20 public static final String [] ORDER = 21 { 22 "WM_USER_ID", 23 "NAME", 24 "VALUE" 25 }; 26 27 public static final Object [][] TYPES = 28 { 29 {"WM_USER_ID", new Integer (Types.INTEGER)}, 30 {"NAME", new Integer (Types.VARCHAR)}, 31 {"VALUE", new Integer (Types.VARCHAR)} 32 }; 33 34 public static final boolean[] RELEVANTS = 35 { 36 true 37 }; 38 39 public static final String SQL = (new StringBuffer ()).append("DECLARE @ID INT ") 40 .append("SELECT @ID = ISNULL(MAX(WM_PROPERTIES_ID) + 1, 1) FROM WM_PROPERTIES ") 41 .append("INSERT INTO WM_PROPERTIES (WM_PROPERTIES_ID, WM_USER_ID, NAME, VALUE) VALUES (@ID, ?, ?, ?) ") 42 .append("SELECT * FROM WM_PROPERTIES WHERE WM_PROPERTIES_ID = @ID") 43 .toString(); 44 45 46 48 public void initQuery (Connection connection) 49 { 50 super.initQuery(connection, 51 true, 52 ORDER, 53 TYPES, 54 RELEVANTS, 55 SQL); 56 } 57 58 } 59 | Popular Tags |