KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.duplication;
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 @NAME varchar(254) "
32     +" DECLARE @VALUE varchar(254) "
33     +" SELECT @NAME = ? "
34     +" SELECT @VALUE = ? "
35
36     +" DELETE FROM PROPERTY "
37     +" WHERE NAME = @NAME "
38     
39     +" INSERT INTO PROPERTY (PROPERTY_ID, NAME, VALUE) "
40     +" SELECT ISNULL( MAX(PROPERTY_ID)+1,1), @NAME, @VALUE "
41     +" FROM PROPERTY ";
42
43       
44  
45     
46     public void initQuery(Connection con) {
47         super.initQuery(
48             con,
49             isPrepared,
50             paramOrder,
51             paramTypes,
52             setRelevants,
53             sqlString );
54     }
55 }
Popular Tags