<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<html>
<body>
<c:set var="s" value="select * from emp"/>
<c:out value="${s}"/><br>
<sql:query var="query1" dataSource="jdbc/myoracle" sql="${s}">
</sql:query>
<table border="1">
<c:forEach var="row" items="${query1.rows}">
<tr>
<td><c:out value="${row.empno}"/></td>
<td><c:out value="${row.ename}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
<%@ page contentType="text/html;charset=KSC5601"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<html>
<body>
<c:set var="s" value="select * from emp where ename='KING'"/>
<c:out value="${s}"/><br>
<sql:query var="query1" dataSource="jdbc/myoracle" sql="${s}">
</sql:query>
<table border="1" cellspacing=0>
<c:forEach var="row" items="${query1.rows}">
<tr>
<td><c:out value="${row.empno}"/></td>
<td><c:out value="${row.ename}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
<%@ page contentType="text/html;charset=KSC5601"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<html>
<body>
<c:set var="s" value="select * from emp where ename=? and deptno=?"/>
<c:out value="${s}"/><br>
<sql:query var="query1" dataSource="jdbc/myoracle" sql="${s}">
<sql:param value="${'KING'}"/>
<sql:param value="${1}"/>
</sql:query>
<table border="1" cellspacing=0>
<c:forEach var="row" items="${query1.rows}">
<tr>
<td><c:out value="${row.empno}"/></td>
<td><c:out value="${row.ename}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
<%@ page contentType="text/html;charset=KSC5601"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<html>
<body>
<sql:query var="query1" dataSource="jdbc/myoracle">
select * from emp where ename=? and deptno=?
<sql:param value="${'KING'}"/>
<sql:param value="${10}"/>
</sql:query>
<table border="1" cellspacing=0>
<c:forEach var="row" items="${query1.rows}">
<tr>
<td><c:out value="${row.empno}"/></td>
<td><c:out value="${row.ename}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
<%@ page contentType="text/html;charset=KSC5601"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<html>
<body>
한개의 레코드를 업데이트한다<p>
<sql:update var="updateCount" dataSource="jdbc/myoracle">
UPDATE emp SET sal=? WHERE ename='SMITH'
<sql:param value="800"/>
</sql:update>
업데이트한 레코드 수: ${ updateCount }
</body>
</html>