KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBSiteDocNew.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  * TKDBSiteDocNew
13  * input -> PK: SITE_NODE_ID, deen nicht -> SITE_NODE_DOC_IDX
14  * input -> update: der Rest
15  * ouput neuer Datensatz
16  */
17 public class TKDBSiteDocNew extends TKPrepQuery{
18
19     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         {"SITE_NODE_ID", "SITE_NODE_ID",
24          "PRESENTATION_ID", "DOCUMENT_NAME", "DOCUMENT_SHORTNAME",
25          "INHERITABLE", "DOCUMENT_TYPE", "EXTERNAL_URL", "INHERIT_END_LEVEL", "INHERIT_BEGIN_LEVEL", "SITE_NODE_ID" };
26     
27     public final static Object JavaDoc[][] paramTypes =
28         {{"EXTERNAL_URL", new Integer JavaDoc(Types.VARCHAR)}};
29         
30     public final static boolean[] setRelevants =
31         { true };
32         
33     public final static String JavaDoc sqlString =
34         "DECLARE @ID int " +
35         
36         "BEGIN TRANSACTION " +
37
38         "SELECT " +
39         " @ID=ISNULL(MAX(SITE_NODE_DOC_IDX)+1, 0) " +
40         "FROM " +
41         " SITE_DOCUMENT " +
42         "WHERE " +
43         " SITE_NODE_ID = ? " +
44
45         "INSERT INTO " +
46         " SITE_DOCUMENT " +
47         " (SITE_NODE_ID, SITE_NODE_DOC_IDX, " +
48         " PRESENTATION_ID, " +
49         " DOCUMENT_NAME," +
50         " DOCUMENT_SHORTNAME, " +
51         " INHERITABLE, DOCUMENT_TYPE, EXTERNAL_URL, INHERIT_END_LEVEL, INHERIT_BEGIN_LEVEL) " +
52         "VALUES " +
53         " ( ?, @ID, ?, ?, ?, ?, ?, ?, ?, ?) " +
54         
55         "COMMIT TRANSACTION " +
56
57         "SELECT " +
58         " * " +
59         "FROM " +
60         " SITE_DOCUMENT " +
61         "WHERE " +
62         " SITE_NODE_ID = ? " +
63         "AND " +
64         " SITE_NODE_DOC_IDX = @ID ";
65
66     public void initQuery(Connection con) {
67         super.initQuery(
68             con,
69             isPrepared,
70             paramOrder,
71             paramTypes,
72             setRelevants,
73             sqlString );
74     }
75 }
76
77
Popular Tags