J
java9394
I have multiple updates based on the same update query. What is the
best way to do it in jstl sql way? Would the following way create too
many update query instance?
<sql:setDatasource var="myDataSource"...../>
<c:forEach var="row" items="${entries}">
<sql:update dataSource="${myDataSource}">
update table1 set fieldB = ? where fieldA = ?
<sqlaram value="${row.getFieldB()}"/>
<sqlaram value="${row.getFieldA()}"/>
</sql:update>
</c:forEach>
many thanks.
java9394
best way to do it in jstl sql way? Would the following way create too
many update query instance?
<sql:setDatasource var="myDataSource"...../>
<c:forEach var="row" items="${entries}">
<sql:update dataSource="${myDataSource}">
update table1 set fieldB = ? where fieldA = ?
<sqlaram value="${row.getFieldB()}"/>
<sqlaram value="${row.getFieldA()}"/>
</sql:update>
</c:forEach>
many thanks.
java9394