KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sybase > TKDBPropNew


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBPropNew.java,v 1.2 2001/08/15 12:50:09 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sybase;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBPropNew
13  * input "PROP_NAME"
14  * output neuer DS
15  * erzeugt neuen Eintrag in PROPERTIES
16  */
17 public class TKDBPropNew extends TKPrepQuery{
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23     { "PROP_NAME" ,
24       "PROP_VALUE" };
25     
26     public final static Object JavaDoc[][] paramTypes =
27     {{"PROP_NAME", new Integer JavaDoc(Types.VARCHAR)},
28      {"PROP_VALUE", new Integer JavaDoc(Types.LONGVARCHAR)}};
29         
30     public final static boolean[] setRelevants =
31         { true };
32         
33     public final static String JavaDoc sqlString =
34
35         "DECLARE @PID int " +
36
37         "BEGIN TRANSACTION " +
38         
39         "SELECT " +
40         " @PID=ISNULL(MAX(PROPERTY_ID)+1, 0) " +
41         "FROM " +
42         " PROPERTY " +
43         
44         "INSERT INTO " +
45         "PROPERTY " +
46         " (PROPERTY_ID, NAME, VALUE) " +
47         "VALUES (@PID, ?, ?) " +
48         
49         "COMMIT TRANSACTION " +
50
51         "SELECT @PID as PROP_ID ";
52     
53     public void initQuery(Connection con) {
54         super.initQuery(
55             con,
56             isPrepared,
57             paramOrder,
58             paramTypes,
59             setRelevants,
60             sqlString );
61     }
62 }
63
64
Popular Tags