<%@ page language="java" contentType="text/html;charset=Windows-31J"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<sql:setDataSource dataSource="jdbc/datasource" var="db"/>
<sql:transaction dataSource="${db}" >
<sql:update sql="update emp set salary=300 where emp_id = 'E01'" />
<sql:update sql="delete from emp where emp_id = 'E02'" />
</sql:transaction>
|