[bes]

http://docs.oracle.com/javaee/5/tutorial/doc/bnakc.html
http://stackoverflow.com/questions/1...sp-not-working

<%@ page contentType="text/html;charset=UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<%@ page import="java.util.Locale"%>
<% Locale.setDefault(Locale.ENGLISH); %>

<sql:setDataSource driver="oracle.jdbc.driver.OracleDriver"
	url="jdbc:oracle:thin:@localhost:1521:XE" 
	user="system" password="12345" var="db" />
	
<sql:query dataSource="${db}" var="typeOfBoat">
	SELECT a FROM a_test_table where a=? <sql:param value="${param['my_param']}"/>
</sql:query>
<select name="TypeofBoat">
	<c:forEach var="row" items="${typeOfBoat.rowsByIndex}">
		<c:forEach var="column" items="${row}">
			<option>${column}</option>
		</c:forEach>
	</c:forEach>
</select>

PS: Читаем доки, учимся гуглить