Please guys am new to J2EE I want to paginate a large result set from an SQL query am using MySQL for eg. if i have 50 records in my DB and i need only 10 records at a time then i will have a next and previous links to go through the records my sql query looks like this

<sql:query var="employees" datasource="jdbc/myDB" >

SELECT * FROM employee

</sql:query>

<c:forEach var="employee" items="${employees.rows}">
<table>
<td>
${employee.firstname}
</td>
</table>
</c:forEach>