How can I use a resultset from a remote connection I get with a bean and display this on a JSP table? I am puting the resultset into an array and can put this into a list but I really need it in a table.
I would avoid working directly with the database connection and/or connection from within your JSP.
A common way to do this is to write a bean that represents a single row in your table. Loop through the result set, creating one row bean for each row in the resultset and add it to a List (java.util.ArrayList is commonly used for this). Then bind the list of row beans to request scope and forward to the JSP. From within the JSP you'll be able to use JSTL/EL to loop through the list of rowBeans to present your data as an HTML table.
When you say "Dynamic Table' do you just mean that you don't know the number and names of the columns in the resultsets returned from your database query or is Dynamic Table the brand name of some third party library that you're using?
There is nothing in JSTL called Dynamic Table.
Joined: Nov 16, 2004
I am using Websphere Development Studio. The term Dynamic Table is the name on the component listed in the set of tools. I an earlier post it was suggested to use ArrayList and then a nested set of c:forEach tags. Can you tell me how to do the nesting so the contents of list one is in column one and list two is in column two etc?