KickJava   Java API By Example, From Geeks To Geeks.

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


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