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 ContextInsert 15 extends TKPrepQuery 16 { 17 18 20 public static final String [] ORDER = 21 { 22 "NAME", 23 "SHORTCUT" 24 }; 25 26 public static final Object [][] TYPES = 27 { 28 {"NAME", new Integer (Types.VARCHAR)}, 29 {"SHORTCUT", new Integer (Types.VARCHAR)} 30 }; 31 32 public static final boolean[] RELEVANTS = 33 { 34 true 35 }; 36 37 public static final String SQL = (new StringBuffer ()).append("DECLARE @ID INT ") 38 .append("SELECT @ID = ISNULL(MAX(WM_CONTEXT_ID) + 1, 1) FROM WM_CONTEXT ") 39 .append("INSERT INTO WM_CONTEXT (WM_CONTEXT_ID, NAME, SHORTCUT) VALUES (@ID, ?, ?) ") 40 .append("SELECT * FROM WM_CONTEXT WHERE WM_CONTEXT_ID = @ID") 41 .toString(); 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 |