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
分享
二维码
< <上一篇
下一篇>>