//web.xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd"> <web-app> <resource-ref> <res-ref-name>jdbc/address</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app> <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %> <html> <head> <title>Utilisation de transaction</title> <sql:setDataSource var="conn" dataSource="jdbc/Boutiques" /> </head> <body> <h1>Modifier Un client</h1> <sql:transaction dataSource="${conn}" isolation="TRANSACTION_SERIALIZABLE"> <sql:update> INSERT INTO Clients (nom, prenom, adresse, pays, email) VALUES (?, ?, ?, ?, ?) <sql:param value='${param["nom"]}'/> <sql:param value='${param["prenom"]}'/> <sql:param value='${param["adresse"]}'/> <sql:param value='${param["pays"]}'/> <sql:param value='${param["email"]}'/> </sql:update> <sql:query var="client"> SELECT * FROM Clients </sql:query> <table width="90%" border="1"> <tr> <!-- Lire l'entête de la table Clients --> <c:forEach var="columnName" items="${client.coltumnNames}"> <th> <c:out value="${columnName}"/> </th> </c:forEach> </tr> <!-- Lire le contenu de la table Clients--> <c:forEach var="row" items="${client.rowsByIndex}"> <tr> <c:forEach var="column" items="${row}"> <td><c:out value="${column}"/></td> </c:forEach> </tr> </c:forEach> </table> </sql:transaction> </body> </html> |
Cet article JSP: Utilisation de transaction dans la requête de mise à jour de la base de données est apparu en premier sur .