jstl sql
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<hr width="500" color="red" align="left">
<sql:setDataSource
url="jdbc:mysql://127.0.0.1:1521/testdb?useUnicode=true&characterEncoding=UTF8"
driver="org.gjt.mm.mysql.Driver"
user="root"
password="root123"
var="db"
scope="application"/>
<sql:query var="list" dataSource="${db}">
select * from test_table
</sql:query>
<c:forEach var="j" items="${list.rows}">
${j}<br>
</c:forEach>
<c:forEach var="j" items="${list.rows}">
${j.}<br><!--l.column_name -->
</c:forEach>
<hr width="500" color="red" align="left">
</body>
</html>
JSTL tab ex) : https://ahnsk39.blogspot.com/2017/08/jstljsp-standard-tag-library.html
