sql_transaction.jsp

来自「JavaWeb高级特性书中源代码」· JSP 代码 · 共 39 行

<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=gb2312" %>
<sql:setDataSource var="myDataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/it315" user="zxx" password="green" />
<div style="float:left">
转帐之前:
<sql:query var="myquery" dataSource="${myDataSource}">
	select * from account
</sql:query>
<table border="1">
	<tr><td>name</td><td>balance</td></tr>
	<c:forEach var="row" items="${myquery.rows}">
		<tr><td>${row.name}</td><td>${row.balance}</td></tr>
	</c:forEach>
</table></div>
<sql:transaction dataSource="${myDataSource}" isolation="read_committed">
	<sql:update>
		update account set balance=balance-? where name=?
		<sql:param value="${param.balance}" />
		<sql:param value="${param.fromName}" />
	</sql:update>
	<sql:update>
		update account set balance=balance+? where name=?
		<sql:param value="${param.balance}" />
		<sql:param value="${param.toName}" />
	</sql:update>
</sql:transaction>
<div style="float:left; margin-left:20px">
${param.fromName}向${param.toName}转帐之后:
<sql:query var="myquery" dataSource="${myDataSource}">
	select * from account
</sql:query>
<table border="1">
	<tr><td>name</td><td>balance</td></tr>
	<c:forEach var="row" items="${myquery.rows}">
		<tr><td>${row.name}</td><td>${row.balance}</td></tr>
	</c:forEach>
</table></div>