KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBDocContentPut.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  * TKDBDocContentPut
13  * Schreibt einen DS fuer einen Document_Content
14  *
15  * Input: Kompl. DS
16  * Output: none
17  */
18 public class TKDBDocContentPut extends TKPrepQuery{
19
20     public final static boolean isPrepared =
21         true;
22     
23     public final static String JavaDoc[] paramOrder =
24         {
25           "SELECTION_TYPE", "SELECTION_DATA",
26           "SITE_NODE_ID", "SITE_NODE_DOC_IDX",
27           "PRESENTATION_COMPONENT_IDX", "CONTENT_NODE_ID"
28          };
29     
30     public final static Object JavaDoc[][] paramTypes =
31         {{"SELECTION_TYPE", new Integer JavaDoc(Types.VARCHAR)}};
32                 
33     public final static boolean[] setRelevants =
34         { false };
35         
36     public final static String JavaDoc sqlString =
37     
38         "DECLARE @ST VARCHAR(80) " +
39         "DECLARE @SID INT " +
40
41         "SELECT @ST = ? " +
42         "SELECT @SID = NULL " +
43
44         "BEGIN TRANSACTION " +
45
46         "IF ( @ST IS NOT NULL ) " +
47         "BEGIN " +
48             "SELECT " +
49             " @SID = ISNULL(MAX(SELECTION_ID) + 1,0) " +
50             "FROM " +
51             " CONTENT_SELECTION " +
52             
53             "INSERT INTO "+
54             " CONTENT_SELECTION " +
55             " (SELECTION_ID, SELECTION_TYPE, SELECTION_DATA) " +
56             "VALUES " +
57             " (@SID, @ST, ?) " +
58         "END " +
59
60     
61         "INSERT INTO " +
62         " DOCUMENT_CONTENT " +
63         " (SITE_NODE_ID, SITE_NODE_DOC_IDX, " +
64         " PRESENTATION_COMPONENT_IDX, CONTENT_NODE_ID, " +
65         " SELECTION_ID ) " +
66         "VALUES " +
67         "(?,?,?,?, @SID) " +
68         
69         "COMMIT TRANSACTION ";
70     
71     public void initQuery(Connection con) {
72         super.initQuery(
73             con,
74             isPrepared,
75             paramOrder,
76             paramTypes,
77             setRelevants,
78             sqlString );
79     }
80 }
81
82
83
Popular Tags