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