Bugs item #825135, was opened at 2003-10-16 13:51
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=536613&aid=825135&group_id=73068
Category: main tag library
Group: v 1.0-b1
Status: Open
Resolution: None
Priority: 5
Submitted By: Joachim Martin (joachimm)
Assigned to: Nobody/Anonymous (nobody)
Summary: displaytag does not recognize BeanUtils DynaBeans
Initial Comment:
In this example, the first iterate tag works, but the
displaytag doesn't. The first iterate tag also works
if you hard-code the property to "SYSDATE".
Seems like if you are using commons-beanutils.jar,
this should work. And it would be a really slick way
to allow (power) end-users to run their own dynamic
reports embedded in apps.
I haven't tried this on the CVS HEAD.
--Joachim
=====================================
<%@ page import="java.sql.*,
java.util.*,org.apache.commons.beanutils.*" %>
<%@ taglib uri="/WEB-INF/tlds/struts-bean.tld"
prefix="bean" %>
<%@ taglib uri="/WEB-INF/tlds/struts-logic.tld"
prefix="logic" %>
<%@ taglib uri="/WEB-INF/tlds/displaytag.tld"
prefix="displaytag" %>
<%
Properties props = new Properties();
props.put("user", "YOUR_USER_HERE");
props.put("password", "YOUR_PW_HERE");
props.put("db", "YOUR_DB_HERE");
props.put("url",
"jdbc:oracle:thin:@YOUR_DB_INFO_HERE");
props.put("driver",
"oracle.jdbc.driver.OracleDriver");
Connection con = null;
Class.forName((String) props.get("driver"));
con = DriverManager.getConnection((String)
props.get("url"), props);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT sysdate
from dual");
RowSetDynaClass resultSet = new
RowSetDynaClass(rs, false);
rs.close();
stmt.close();
con.close();
request.setAttribute("resultSet", resultSet);
%>
<table border=0 cellpadding=0 cellspacing=0
bgcolor=FFFFFF><tr><tr>
<table border=0 cellpadding=4 cellspacing=1 bgcolor=000000>
<%-- headers for this result set --%>
<tr>
<logic:iterate id="fieldProperty" name="resultSet"
property="dynaProperties">
<th bgcolor=CCCCCC><bean:write name="fieldProperty"
property="name"/></th>
</logic:iterate>
</tr>
<%-- rows --%>
<logic:iterate id="row" name="resultSet" property="rows">
<tr>
<%-- fields --%>
<logic:iterate id="fieldProperty" name="resultSet"
property="dynaProperties">
<bean:define id="fieldName" name="fieldProperty"
property="name" type="java.lang.String"/>
<td bgcolor=FFFFFF><bean:write name="row"
property="<%=fieldName%>" ignore="true"></bean:write></td>
</logic:iterate>
</tr>
</logic:iterate>
</table>
</tr>
</table>
<displaytag:table name="resultSet" property="rows">
<displaytag:column property="sysdate"
></displaytag:column>
</displaytag:table>
<br>
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=536613&aid=825135&group_id=73068
-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
displaytag-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
