|
1
5 package com.teamkonzept.webman.mainint.db.queries.sybase;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11
17 public class TKDBSiteDocUpdatePres extends TKPrepQuery{
18
19 public final static boolean isPrepared =
20 true;
21
22 public final static String  [] paramOrder =
23 { "SITE_NODE_ID", "SITE_NODE_DOC_IDX",
24 "PRESENTATION_ID", "DOCUMENT_NAME", "DOCUMENT_SHORTNAME",
25 "INHERITABLE", "DOCUMENT_TYPE", "EXTERNAL_URL", "INHERIT_END_LEVEL", "INHERIT_BEGIN_LEVEL"
26 };
27
28 public final static Object [][] paramTypes =
29 {{"EXTERNAL_URL", new Integer (Types.VARCHAR)}};
30
31 public final static boolean[] setRelevants =
32 { false };
33
34 public final static String sqlString =
35 "DECLARE @ID int " +
36 "DECLARE @IDX int " +
37
38 "SELECT @ID = ? " +
39 "SELECT @IDX = ? " +
40
41 "CREATE TABLE #temp (SELECTION_ID int) " +
42
43 "BEGIN TRANSACTION " +
44
45 "DELETE FROM " +
46 " DOCUMENT_REFERENCE " +
47 "WHERE " +
48 " ( " +
49 " SRC_SITE_NODE_ID = @ID " +
50 " AND " +
51 " SRC_SITE_NODE_DOC_IDX = @IDX " +
52 " ) " +
53
54 "INSERT INTO " +
55 " #temp " +
56 " (SELECTION_ID) " +
57 "SELECT " +
58 " SELECTION_ID " +
59 "FROM " +
60 " DOCUMENT_CONTENT " +
61 "WHERE " +
62 " SITE_NODE_ID = @ID " +
63 "AND " +
64 " SITE_NODE_DOC_IDX = @IDX " +
65 "AND " +
66 " SELECTION_ID IS NOT NULL " +
67
68 "DELETE FROM " +
69 " DOCUMENT_CONTENT " +
70 "WHERE " +
71 " SITE_NODE_ID = @ID " +
72 "AND " +
73 " SITE_NODE_DOC_IDX = @IDX " +
74
75 "DELETE FROM " +
76 " CONTENT_SELECTION " +
77 "WHERE " +
78 " SELECTION_ID IN ( " +
79 "SELECT " +
80 " SELECTION_ID " +
81 "FROM " +
82 " #temp " +
83 ") " +
84
85 "UPDATE " +
86 " SITE_DOCUMENT " +
87 "SET " +
88 " PRESENTATION_ID = ?," +
89 " DOCUMENT_NAME = ?," +
90 " DOCUMENT_SHORTNAME = ?," +
91 " INHERITABLE = ?, " +
92 " DOCUMENT_TYPE = ?, " +
93 " EXTERNAL_URL = ?, " +
94 " INHERIT_END_LEVEL = ?, " +
95 " INHERIT_BEGIN_LEVEL = ? " +
96 "WHERE " +
97 " SITE_NODE_ID = @ID " +
98 "AND " +
99 " SITE_NODE_DOC_IDX = @IDX " +
100
101 "COMMIT TRANSACTION " +
102
103 "DROP TABLE #temp ";
104
105 public void initQuery(Connection con) {
106 super.initQuery(
107 con,
108 isPrepared,
109 paramOrder,
110 paramTypes,
111 setRelevants,
112 sqlString );
113 }
114 }
115
116 |
Popular Tags |
Java API By Example, From Geeks To Geeks.