JSP JSTL < SQL: transaction > tag: transaction
•
Java
and
statements isolationLevel:="read_committed" |"read_uncommitted" |"repeatable_read" |"serializable"
Example
<%@page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%> <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%> <sql:setDataSource driver="com.microsoft.jdbc.sqlserver.sqlServerDriver" url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=db_testH" user="sa"password=""var="conn"/> <sql:transaction dataSource="${conn}" isolation="read_uncommitted"> <sql:update sql="UPDATE tb_user SET pwd=?WHERE username=?"> <sql:param value="1224"></sql:param> <sql:param value="zs"></sql:param> </sql:update> <sql:update sql="UPDATE tb_user SET id=?WHERE username=?"> <sql:param value="123"></sql:param> <sql:param value="zs"></sql:param> </sql:update> </sql:transaction>
The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
二维码