KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > duplication > oracle > TKDBPutProperty


1 package com.teamkonzept.webman.mainint.db.queries.duplication.oracle;
2
3 import com.teamkonzept.db.*;
4 //import com.teamkonzept.lib.*;
5

6 import java.io.*;
7 import java.util.*;
8 import java.sql.*;
9
10 /**
11  *
12  */

13 public class TKDBPutProperty extends TKPrepQuery{
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "NAME", "VALUE"};
20     
21     public final static Object JavaDoc[][] paramTypes =
22         {{ "NAME", new Integer JavaDoc(Types.VARCHAR) },
23          { "VALUE", new Integer JavaDoc(Types.VARCHAR) }
24         };
25                 
26     public final static boolean[] setRelevants =
27         null;
28         
29     public final static String JavaDoc 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