<div>
&lt;html&gt;<br />
&lt;body&gt;<br />
&lt;%<br />
ResultSet rs = //from your Access db<br />
%&gt;<br />
&lt;% while ( rs.next() ){//move resultset onto the next row %&gt;<br />
A line of db stuff &lt;%= rs.getString(&quot;id&quot;) %&gt;&lt;!-- get by column name --&gt;<br />
A line of db stuff &lt;%= rs.getString(2) %&gt;&lt;!-- get by column index (start from 1)--&gt;<br />
&lt;% } %&gt;<br />
&lt;/body&gt;<br />
&lt;/html&gt;<br />
-------------<br />
When you get a resultset, you need to call rs.next() as a query returns a resultset witht cursor positioned before the first row initially. This method works for single or multiple rows.
</div>


<html>
<body>
<%
ResultSet rs = //from your Access db
%>
<% while ( rs.next() ){//move resultset onto the next row %>
A line of db stuff <%= rs.getString("id") %>
A line of db stuff <%= rs.getString(2) %>
<% } %>
</body>
</html>
-------------
When you get a resultset, you need to call rs.next() as a query returns a resultset witht cursor positioned before the first row initially. This method works for single or multiple rows.

<div>
how do I get a ResultSet? &nbsp;Please give an example , thanks
</div>


how do I get a ResultSet?  Please give an example , thanks

<div>
<div class="content wysiwyg-content">
I have a jsp which needs to be populated with values from a query in an Access database. The query only returns one row.<br />
My jsp consists of text boxes which need to be filled with the fields in the query.<br />
<br />
How is this done? &nbsp;
</div>
</div>


I have a jsp which needs to be populated with values from a query in an Access database. The query only returns one row.
My jsp consists of text boxes which need to be filled with the fields in the query.

How is this done?  

JSP - display single record from database

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.