Icefaces Datatable

Hi all,

I am a newbie for icefaces.I have to display a set of values from a database table.The problem is values are not displayed in the corresponding page. Here is the code.

my viewfeedback.icefaces is

<ui:define name="pageTitle">#{msg.projectTitleOpeniReports}</ui:define>
      	 <ui:composition template="/WEB-INF/pages/template.xhtml">
      	
	<style type="text/css">
	div.center
	{
	text-align:center;
	}
	</style>
      	<ui:define name="header">
      		<ui:include src="/WEB-INF/pages/header.xhtml" />
      	</ui:define>
      	<ui:define name="body">

<f:view>
	<ice:form>

<ice:dataTable var="p" value="#{Reportdetails.feedbackdetails}" >
                          <ice:column>
                        <f:facet name="header">
                            <ice:outputText value="UserName #"/>
                        </f:facet>
                        <ice:outputText value="#{p.username}"/>
                    </ice:column>

<ice:column>
                        <f:facet name="header">
                            <ice:outputText value="Schema #"/>
                        </f:facet>
                        <ice:outputText value="#{p.schema}"/>
                    </ice:column>

<ice:column>
                        <f:facet name="header">
                            <ice:outputText value="AnalysisName #"/>
                        </f:facet>
                        <ice:outputText value="#{p.analysisname}"/>
                    </ice:column>

<ice:column>
                        <f:facet name="header">
                            <ice:outputText value="Comment #"/>
                        </f:facet>
                        <ice:outputText value="#{p.comment}"/>
                    </ice:column>

<ice:column>
                        <f:facet name="header">
                            <ice:outputText value="CreatedDate #"/>
                        </f:facet>
                        <ice:outputText value="#{p.createddate}"/>
                    </ice:column>
                     </ice:dataTable>
	</ice:form>
</f:view>
</ui:define>
</ui:composition>
</html>

and my ReportDetails.java is

package org.openi.web.ui.jsf.bean.reports.analysis;

import java.util.ArrayList;

public class ReportDetail {
	private String username;
	private String schema;
	private String analysisname;
	private String comment;
	private String createddate;
	ViewBean vb= new ViewBean();
	private ArrayList feedbackdetails=vb.getfeedback();;
	
	public ReportDetail(String username,String schema,String analysisname,String comment,String createddate){
		this.username=username;
		this.schema=schema;
		this.analysisname=analysisname;
		this.comment=comment;
		this.createddate=createddate;
	}
	
	public ReportDetail() {
		// TODO Auto-generated constructor stub
	}

public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getSchema() {
		return schema;
	}
	public void setSchema(String schema) {
		this.schema = schema;
	}
	public String getAnalysisname() {
		return analysisname;
	}
	public void setAnalysisname(String analysisname) {
		this.analysisname = analysisname;
	}
	public String getComment() {
		return comment;
	}
	public void setComment(String comment) {
		this.comment = comment;
	}
	public String getCreateddate() {
		return createddate;
	}
	public void setCreateddate(String createddate) {
		this.createddate = createddate;
	}
public static void main(String[] args) {
	System.out.println(new ReportDetail().feedbackdetails.size());
}
}

and viewbean is

package org.openi.web.ui.jsf.bean.reports.analysis;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class ViewBean {
	Connection connection;
	PreparedStatement ptsmt;
	ResultSet rs;
	private ArrayList<ReportDetail> reportdetails;
	
	
	
	public ArrayList<ReportDetail> getReportdetails() {
		return reportdetails;
	}
	public void setReportdetails(ArrayList<ReportDetail> reportdetails) {
		this.reportdetails = reportdetails;
	}
	public ViewBean(){
		
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/liferaytags", "root", "admin");
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

}
	public ArrayList<ReportDetail> getfeedback(){
		reportdetails=new ArrayList<ReportDetail>();
		ReportDetail rd=new ReportDetail();
		String query="select * from reportfeedback";
		try {
			ptsmt=connection.prepareStatement(query);
			rs=ptsmt.executeQuery();
			while (rs.next()) {
				String username=rs.getString("Username");
				rd.setUsername(username);
				String schema=rs.getString("Schema");
				rd.setSchema(schema);
				String analysisname=rs.getString("AnalysisName");
				rd.setAnalysisname(analysisname);
				String comment=rs.getString("Comment");
				rd.setComment(comment);
				String date=rs.getString("CreatedDate");
				rd.setCreateddate(date);
				reportdetails.add(rd);
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		
        }finally{
        	try {
				connection.close();
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
        }
		return reportdetails;
		
	}

public static void main(String[] args) {
	ViewBean vb= new  ViewBean();
	ArrayList al=vb.getfeedback();
	System.out.println(al.size());
	
}
}

and faces-config.xml is

<managed-bean>
<description>ReportDetails</description>
<display-name>ReportDetails</display-name>
<icon></icon>
<managed-bean-name>ReportDetail</managed-bean-name>
<managed-bean-class>org.openi.web.ui.jsf.bean.reports.analysis.ReportDetail</managed-bean-class>
<managed-bean-scope>session</managed-bean-scope>
</managed-bean>

Please suggest me to resolve this.

Looks like there's no getter for feedback details in your Report bean.

Hi Jason,

I have resolved the error.
Thanks a lot.