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
474,432
Messages
2,571,682
Members
48,796
Latest member
Greg L.

Latest Threads

Top