KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBPresContInsert.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  * TKDBPresContInsert
16  * input "PRESENTATION_ID", "COMPONENT_TYPE", "INTEGRATION_TYPE",
17  * "INTEGRATION_NAME", "INTEGRATION_SHORTNAME", "FORM_ID",
18  *
19  * ouptut neu erzeugter DS aus PRESENTATION_CONTENT
20  *
21  * erzeugt neuen Eintrag in PRESENTATION_COMPONENT + PRESENTATION_CONTENT
22  */
23 public class TKDBPresContInsert extends TKPrepQuery{
24
25     public final static boolean isPrepared =
26         true;
27     
28     public final static String JavaDoc[] paramOrder =
29         {"PRESENTATION_ID", "COMPONENT_TYPE", "INTEGRATION_TYPE",
30          "INTEGRATION_NAME", "INTEGRATION_SHORTNAME", "FORM_ID" };
31     
32     public final static Object JavaDoc[][] paramTypes =
33         {{"INTEGRATION_NAME", new Integer JavaDoc(Types.VARCHAR)},
34          {"INTEGRATION_SHORTNAME", new Integer JavaDoc(Types.VARCHAR)}};
35                 
36     public final static boolean[] setRelevants =
37         { true };
38         
39     public final static String JavaDoc sqlString =
40         "DECLARE @PIDX int " +
41         "DECLARE @PID int " +
42         
43         "SELECT @PID = ? " +
44         
45         "BEGIN TRANSACTION " +
46         
47         "SELECT " +
48         " @PIDX=ISNULL(MAX(PRESENTATION_COMPONENT_IDX)+1, 0) " +
49         "FROM " +
50         " PRESENTATION_COMPONENT " +
51         "WHERE " +
52         " PRESENTATION_ID = @PID " +
53
54         "INSERT INTO " +
55         " PRESENTATION_COMPONENT " +
56         " (PRESENTATION_ID, PRESENTATION_COMPONENT_IDX, " +
57         " COMPONENT_TYPE, INTEGRATION_TYPE, " +
58         " INTEGRATION_NAME, INTEGRATION_SHORTNAME) " +
59         "VALUES " +
60         " (@PID, @PIDX, ?, ?, ?, ?) " +
61         
62         "INSERT INTO " +
63         " PRESENTATION_CONTENT " +
64         " (PRESENTATION_ID, PRESENTATION_COMPONENT_IDX, " +
65         " FORM_ID) " +
66         "VALUES " +
67         " (@PID, @PIDX, ?) " +
68         
69         "SELECT " +
70         " * " +
71         "FROM " +
72         " PRESENTATION_CONTENT " +
73         "WHERE " +
74         " PRESENTATION_ID = @PID " +
75         "AND " +
76         " PRESENTATION_COMPONENT_IDX = @PIDX " +
77
78         "COMMIT ";
79     
80     public void initQuery(Connection con) {
81         super.initQuery(
82             con,
83             isPrepared,
84             paramOrder,
85             paramTypes,
86             setRelevants,
87             sqlString );
88     }
89 }
90
91
Popular Tags