The example explains the JSP obtains the resultset result set the data the method _jsp the programming

to get all records

<% @page language= "java" contenttype= "text/html;charset=gb2312"%> <% @page import= "java.sql.*"%> <! DOCTYPE html>  

gets the record for the specified field in all records

<% @page language= "java" contenttype= "text/html;charset=gb2312"%> <% @page import= "java.sql.*"%> <! DOCTYPE html>  

gets the record for the specified starting position and number of bars

<% @page language= "java" contenttype= "text/html;charset=gb2312"%> <% @page import= "java.sql.*"%> <!
    DOCTYPE html>  

Traversing the data in resultset and converting it into a table
looking for a long time on the internet to traverse the data in the resultset and then populate it in a Web page table, there is said that the resultset data into a two-dimensional array, and then output, but two-bit array needs to specify the storage size in advance, inconvenient amplification. In fact, the following methods can be used:

while (Rs.next ()) {
    out.println ("<tr><td>" +rs.getstring (1) + "</td><td>" +rs.getstring ( 2) + "</td><td>" +rs.getstring (3) + "</td><td>"
        +rs.getstring (4) + "</td><td> "+rs.getstring (5) +" </td><td> "+rs.getstring (6) +" </td><td> "
        +rs.getstring (7) +" </ Td><td> "+rs.getstring (8) +" </td><td> "+rs.getstring (9) +" </td><td> "
        + Rs.getstring (a) + "</td><td>" +rs.getstring (one) + "</td><td>" +rs.getstring (a) + "</td ><tr> ");
}