KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBPropGroupNew.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 "PROPGROUP_NAME"
14  * output neuer DS
15  * erzeugt neuen Eintrag in PROPERTIES
16  */
17 public class TKDBPropGroupNew extends TKPrepQuery{
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23     { "PROPGROUP_NAME" };
24     
25     public final static Object JavaDoc[][] paramTypes =
26     {{"PROPGROUP_NAME", new Integer JavaDoc(Types.VARCHAR)}};
27         
28     public final static boolean[] setRelevants =
29         { true };
30         
31     public final static String JavaDoc sqlString =
32
33         "DECLARE @PID int " +
34
35         "BEGIN TRANSACTION " +
36         
37         "SELECT " +
38         " @PID=ISNULL(MAX(PROPERTY_GROUP_ID)+1, 0) " +
39         "FROM " +
40         " PROPERTY_GROUP " +
41         
42         "INSERT INTO " +
43         "PROPERTY_GROUP " +
44         " (PROPERTY_GROUP_ID, NAME) " +
45         "VALUES (@PID, ?) " +
46         
47         "COMMIT TRANSACTION ";
48
49     public void initQuery(Connection con) {
50         super.initQuery(
51             con,
52             isPrepared,
53             paramOrder,
54             paramTypes,
55             setRelevants,
56             sqlString );
57     }
58 }
59
60
Popular Tags