jstl sql 사용


jstl sql 사용

<sql:query var="rs_site" dataSource="jdbc/postgres"> select site_id from esm_site_agent group by site_id order by site_id </sql:query> <ul id="browser"> <c:forEach var="rows_site" items="${rs_site.rows}"> <li><span class="folder">${rows_site.site_id}</span> <sql:query var="rs_agent" dataSource="jdbc/postgres"> select agent_id from esm_site_agent where site_id=? <sql:param>${rows_site.site_id}</sql:param> </sql:query> <ul> <c:forEach var="rows_agent" items="${rs_agent.rows}"> <li><span class="fil...


#IT·컴퓨터

원문링크 : jstl sql 사용