티스토리 뷰
1. select 문
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head><title>JSTL sql 예제 - query </title></head>
<body>
<sql:query var="rs" dataSource="jdbc/myoracle">select * from test</sql:query>
<table>
<tr>
<c:forEach var="columnName" items="${rs.columnNames}">
<th> <c:out value="${columnName}" /> </th>
</c:forEach>
</tr>
<c:forEach var="row" items="${rs.rowsByIndex}" varStatus="i">
<tr>
<td>${i.count}</td>
<c:forEach var="column" items="${row}" varStatus="i">
<td>
<c:if test="${column!=null}">
<c:out value="${column}" />
</c:if>
<c:if test="${column==null}">
</c:if>
</td>
</c:forEach>
</tr>
</c:forEach>
</table>
</body>
</html>
2. update 문
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head><title>JSTL sql 예제 - update, param</title></head>
<body>
<sql:update dataSource="jdbc/myoracle">
update test set pwd=? where id=?
<sql:param value="${'555'}" />
<sql:param value="${'aa'}" />
</sql:update>
<sql:query var="rs" dataSource="jdbc/myoracle">select * from test</sql:query>
<table>
<tr>
<th></th>
<c:forEach var="columnName" items="${rs.columnNames}">
<th> <c:out value="${columnName}" /> </th>
</c:forEach>
</tr>
<c:forEach var="row" items="${rs.rowsByIndex}" varStatus="i">
<tr>
<td>${i.count }</td>
<c:forEach var="column" items="${row}">
<td>
<c:if test="${column!=null}">
<c:out value="${column}" />
</c:if>
<c:if test="${column==null}">
</c:if>
</td>
</c:forEach>
</tr>
</c:forEach>
</table>
</body>
</html>
'Jsp&Servlet' 카테고리의 다른 글
| ArrayList 컬렉션 객체 배열을 JSTL를 사용하여 표현하기 (0) | 2017.02.01 |
|---|---|
| jsp에서 자바 변수를 form 전송하기 (0) | 2017.02.01 |
| Connection Pool 개념 (0) | 2017.01.31 |
| JSTL (0) | 2017.01.31 |
| 이클립스 properties 플러그인 설치하기 (0) | 2017.01.31 |