1 package com.teamkonzept.webman.mainint.db.queries.duplication.oracle; 2 3 import com.teamkonzept.db.*; 4 6 import java.io.*; 7 import java.util.*; 8 import java.sql.*; 9 10 13 public class TKDBPutProperty extends TKPrepQuery{ 14 15 public final static boolean isPrepared = 16 true; 17 18 public final static String [] paramOrder = 19 { "NAME", "VALUE"}; 20 21 public final static Object [][] paramTypes = 22 {{ "NAME", new Integer (Types.VARCHAR) }, 23 { "VALUE", new Integer (Types.VARCHAR) } 24 }; 25 26 public final static boolean[] setRelevants = 27 null; 28 29 public final static String sqlString = 30 31 " DECLARE " 32 + " prop_name VARCHAR2(254); " 33 + " prop_val VARCHAR2(254); " 34 + " BEGIN " 35 + " prop_name := ?; " 36 + " prop_val := ?; " 37 38 + " DELETE FROM PROPERTY " 39 + " WHERE NAME = prop_name; " 40 41 + " INSERT INTO PROPERTY (PROPERTY_ID, NAME, VALUE) " 42 + " SELECT nvl( MAX(PROPERTY_ID)+1,1),prop_name, prop_val " 43 + " FROM PROPERTY; " 44 + " END; " 45 ; 46 47 48 49 public void initQuery(Connection con) { 50 super.initQuery( 51 con, 52 isPrepared, 53 paramOrder, 54 paramTypes, 55 setRelevants, 56 sqlString ); 57 } 58 } | Popular Tags |