?? sql_transaction.jsp
字號:
<%@ 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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -