KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBPresInsert.java,v 1.2 2001/08/15 12:50:09 markus Exp $
3  *
4  */
5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */
8 package com.teamkonzept.webman.mainint.db.queries.sybase;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13
14 /*
15  * TKDBPresInsert
16  * input "PRESENTATION_NAME", "PRESENTATION_SHORTNAME",
17           "TEMPLATE_ID",
18  * ouptut neu erzeugter DS
19  *
20  * erzeugt neuen Eintrag in PRESENTATION
21  */
22 public class TKDBPresInsert extends TKPrepQuery{
23
24     public final static boolean isPrepared =
25         true;
26     
27     public final static String JavaDoc[] paramOrder =
28         {"PRESENTATION_NAME", "PRESENTATION_SHORTNAME",
29           "TEMPLATE_ID" };
30     
31     public final static Object JavaDoc[][] paramTypes =
32         {{"PRESENTATION_NAME", new Integer JavaDoc(Types.VARCHAR)},
33          {"PRESENTATION_SHORTNAME", new Integer JavaDoc(Types.VARCHAR)}};
34                 
35     public final static boolean[] setRelevants =
36         { true };
37         
38     public final static String JavaDoc sqlString =
39         "DECLARE @PID int " +
40         
41         "BEGIN TRANSACTION " +
42         
43         "SELECT " +
44         " @PID=ISNULL(MAX(PRESENTATION_ID)+1, 0) " +
45         "FROM " +
46         " PRESENTATION " +
47
48         "INSERT INTO " +
49         " PRESENTATION " +
50         " (PRESENTATION_ID, PRESENTATION_NAME, PRESENTATION_SHORTNAME, " +
51         " TEMPLATE_ID) " +
52         "VALUES " +
53         " (@PID, ?, ?, ?) " +
54         
55         "SELECT " +
56         " * " +
57         "FROM " +
58         " PRESENTATION " +
59         "WHERE " +
60         " PRESENTATION_ID = @PID " +
61
62         "COMMIT ";
63     
64     public void initQuery(Connection con) {
65         super.initQuery(
66             con,
67             isPrepared,
68             paramOrder,
69             paramTypes,
70             setRelevants,
71             sqlString );
72     }
73 }
74
75
Popular Tags