If you know all the possible columns, you could create a bean with all
the getters and setters and populate it from the result set, or, you
would have to dynamically create setters and getters on a bean.
Matt
On 3/20/06, JaumeG <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I'm doing a Database COnsole that results in DisplatTags COlumns.
> I have a problem because I dont have setters and Getters methods for the
> ResultQuery because The Results ara Variable depending on The Query
> Executed.
>
> I would like to know how to solve this problem.
>
> I put my code.
>
> Thanks in advance.
>
>
> int i = 0;
> try {
> Statement stmt = con.createStatement();
> stmt.setMaxRows(numeroMaxRegistros); // limited to 20000
> ResultSet rs = stmt.executeQuery("select * from pers");
> ResultSetMetaData rsmd = rs.getMetaData();
> int cols = rsmd.getColumnCount();
> ArrayList ar = new ArrayList();
>
> int j = 0;
> while (rs.next() && i++<numeroMaxRegistros) {
> String[] elementos = new String[cols];
> for (j = 1; j <= cols; j++) {
> elementos[j-1]=rs.getString(j);
> }
> ar.add(elementos);
> }
>
> request.setAttribute("array",ar); %>
>
> <display:table name="array" requestURI="sqlconsAction.do?accion=sort"
> pagesize="10" defaultsort="1" defaultorder="ascending" >
> <display:setProperty name="paging.banner.group_size" value="8"/>
> <display:setProperty name="paging.banner.item_name">
> </display:setProperty>
> <display:setProperty name="paging.banner.items_name">
> </display:setProperty>
> <display:setProperty name="paging.banner.no_items_found">
> </br></display:setProperty>
> <display:setProperty name="paging.banner.one_item_found">
> </br></display:setProperty>
> </display:table>
>
> <%
> rs.close();
> stmt.close();
> con.close();
> --
> View this message in context:
> http://www.nabble.com/Database-Console---help-t1311595.html#a3494829
> Sent from the DisplayTag - General forum at Nabble.com.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> displaytag-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/displaytag-user
>
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
displaytag-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/displaytag-user
