hi

can anybody help me

i have table in database and i want to read 10 rows from it per one page

by using JSP

this is my code

<H1>The Table of Results</H1>

<%

Connection connection = DriverManager.getConnection(

"jdbc:mysql://localhost/metasearch", "user", "aaa");

Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_READ_ONLY) ;

ResultSet resultset =

statement.executeQuery("select id,url,summery,title from Links") ;

%>

<table class="style1">

<% while(resultset.next()){ %>

<tr>

<td valign="top"><%= resultset.getString(1) %>-</td>

<td><a href= "<%= resultset.getString(2) %>"><%= resultset.getString(4) %></a>

<%= resultset.getString(3) %>

<%= resultset.getString(2) %></td>

</tr>

<% } %>

</table>