how to do prepared statement in jstl sql way

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 = ?
<sql:param value="${row.getFieldB()}"/>
<sql:param value="${row.getFieldA()}"/>
</sql:update>

</c:forEach>

many thanks.

java9394
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,772
Messages
2,569,593
Members
45,111
Latest member
KetoBurn
Top