/
positiveParamUpdateBodyContentTest.jsp
71 lines (55 loc) · 2.8 KB
/
positiveParamUpdateBodyContentTest.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<%--
Copyright (c) 2003, 2018 Oracle and/or its affiliates. All rights reserved.
This program and the accompanying materials are made available under the
terms of the Eclipse Public License v. 2.0, which is available at
http://www.eclipse.org/legal/epl-2.0.
This Source Code may also be made available under the following Secondary
Licenses when the conditions for such availability set forth in the
Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
version 2 with the GNU Classpath Exception, which is available at
https://www.gnu.org/software/classpath/license.html.
SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0
--%>
<%@ taglib prefix="c" uri="jakarta.tags.core" %>
<%@ taglib prefix="sql" uri="jakarta.tags.sql" %>
<%@ taglib prefix="tck" uri="http://java.sun.com/jstltck/jstltck-util" %>
<%@ page import="javax.sql.*, java.util.*" %>
<tck:test testName="positiveParamUpdateBodyContentTest">
<%
pageContext.setAttribute("key", new Integer("1"));
%>
<%-- Number of rows to be affected by the DML statements --%>
<c:set var="expectedRowsAffected" value="${1}" />
<!-- Validate sql:update and sql:params actions allows for the
execution of a SQL statement specifying parameters -->
<h1>Validate sql:update and sql:params actions allows for the
execution of a SQL statement specifying parameters </h1>
<p>
<%-- Clear out our table prior to starting the test --%>
<sql:update var="updateCount" dataSource="${applicationScope.jstlDS}">
<c:out value="${sqlProps.Delete_AllRows_Query}" />
</sql:update>
<sql:update var="updateCount" dataSource="${applicationScope.jstlDS}">
<c:out value="${sqlProps.Insert_Row_Query}" escapeXml='false'/>
</sql:update>
<sql:update var="updateCount2"
dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>' >
<c:out value="${sqlProps.Delete_Jstl_Tab2_Using_Param_Query}" escapeXml='false' />
<sql:param value='<%= pageContext.getAttribute("key") %>' />
</sql:update>
<c:choose>
<c:when test="${updateCount2 == expectedRowsAffected}">
The SQL statement executed correctly and returned the correct
update count of <strong><c:out value="${expectedRowsAffected}" />
</strong>.<p>
</c:when>
<c:otherwise>
<strong>Error:</strong> The SQL statement "<strong>
<c:out value="${sqlProps.Delete_Jstl_Tab2_Using_Param_Query}" />
</strong>" resulted in an update count of <strong>
<c:out value="${updateCount2}" /></strong> and the
the expected update count was <strong>
<c:out value="${expectedRowsAffected}" /></strong>!<p>
</c:otherwise>
</c:choose>
</tck:test>