myfaces-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno Aranda <brunoara...@gmail.com>
Subject Re: how to display data in DataTable
Date Mon, 18 Jul 2005 13:29:08 GMT
> I get an error that the resultsetDatamodel is not implemented......i hope this help....


Actually, the javax.faces.model.ResultSetDataModel is not implemented.
Every method is throwing an UnsupportedOperationException. If someone
wants to implement it, please do so. It should not be difficult,

Regards,

Bruno

2005/7/18, Shibi Thomas <shibimary@gmail.com>:
> I am using myfaces. 
>   
> The bean class [searchbean] looks like this : 
>   
>  public JdbcRowSet getdataresult()
>     {
>         if (dataresult != null)
>         return dataresult;
>         else
>             return null;
>     } 
>   
> public String doQuery()
>     { 
>      ................. 
> .    ................. 
>      try {
>             dataresult  =Connect(sqlquery);
>         } catch (SQLException e) {
>             e.printStackTrace();  //To change body of catch statement use
> File | Settings | File Templates. 
>             ctx.addMessage(null, new FacesMessage(e.toString()));
>             return "error";
>         } catch (ClassNotFoundException e) {
>             e.printStackTrace();  //To change body of catch statement use
> File | Settings | File Templates. 
>             ctx.addMessage(null, new FacesMessage(e.toString()));
>             return "error";
>         }
>                     //--------finished
>       return "success";
>     }     
>   
>  
> 
> public JdbcRowSet Connect (String query) throws SQLException,
> ClassNotFoundException { 
> 
>       Class.forName("org.postgresql.Driver");
>       JdbcRowSetImpl jrs = new JdbcRowSetImpl();
>       jrs.setCommand(sqlquery);
>       jrs.setUrl("jdbc: postgresql://bungo:5432/vods");
>       jrs.setUsername("vodsview");
>       jrs.setPassword("");
>         System.out.println("inside this method connect");
>       jrs.execute(); 
>       return jrs;
>     } 
>   
> the showresult.jsp looks like this 
>   
>  
> 
> <?xml version="1.0"?>
> <jsp:root version="2.0" xmlns:jsp=" http://java.sun.com/JSP/Page"
>  xmlns:h="http://java.sun.com/jsf/html "
>  xmlns:f="http://java.sun.com/jsf/core "
>     xmlns:x="http://myfaces.apache.org/extensions"> 
> 
>  <jsp:directive.page contentType="text/html;charset=UTF-8"
>   isELIgnored="false" />
>  <jsp:output omit-xml-declaration="true" doctype-root-element="html" 
>   doctype-system="http://www.w3.org/TR/html4/loose.dtd"
>   doctype-public="-//W3C//DTD HTML 4.01 Transitional//EN" /> 
> 
>  <html>
>   <head>
>    <title>VODS log search result</title>
>   </head>
>   <body>
>    This is the result page.
>       <f:view> 
>         <h:dataTable  id = "data"
>                 rendered = "true"
>                 styleClass= "table-background"
>                 rowClasses= "table-odd-row,table-even-row" 
>                 cellpadding="3"
>                 value="#{searchBean.dataresult}"
>                 var="row"> 
> 
>            <h:column>
>             <f:facet name= "Header">
>             <h:outputText value ="Sender"/>
>             </f:facet> 
>             <h:outputText value ="#{row.Sender}" />
>            </h:column> 
> 
> 
>        </h:dataTable>
>       </f:view>
>       </body>
>   </html>
> </jsp:root>I get an error that the resultsetDatamodel is not
> implemented......i hope this help.... 
>   
> Shibi
>  
>   
> On 7/18/05, Johannes Hiemer <jhiemer@web.de> wrote: 
> > 
> > Hi Shibi,
> > here is an example on how it works for me:
> > <h:dataTable id="bean" rowClasses="row" 
> >                                value="#{searchSystemdataSpringBean.bean}"
> >                                var="systemdata" styleClass="hidden">
> >                                <h:column> 
> >                                        <f:facet
> name="header">
> >                                               
> <h:outputText value="#{bundle.searchSystemTagNumber}" />
> >                                        </f:facet> 
> >                                        <h:commandButton
> styleClass="button" id="tagnumber" value="#{systemdata.sdtagnumber}" 
> onclick="javascript: passToParentWindow(id, value)" /> 
> >                                </h:column>
> >                                <h:column>
> >                                        <f:facet
> name="header">
> >                                               
> <h:outputText  value="#{ bundle.searchSystemModel}" />
> >                                        </f:facet>
> >                                        <h:outputText
> id="model" value="#{systemdata.sdmodel}" /> 
> >                                </h:column>
> >                                <h:column>
> >                                        <f:facet
> name="header">
> >                                               
> <h:outputText  value="#{ bundle.searchSystemSn}" />
> >                                        </f:facet>
> >                                        <h:outputText
> id="systemnumber" value="#{systemdata.sdsn}" /> 
> >                                </h:column>
> >                                <h:column>
> >                                        <f:facet
> name="header">
> >                                               
> <h:outputText value="#{ bundle.searchSystemType}" />
> >                                        </f:facet>
> >                                        <h:outputText
> id="systemtype" value="#{systemdata.sdtype}" /> 
> >                                </h:column>
> >                        </h:dataTable>
> > The important things are value="#{searchSystemdataSpringBean.bean}"
> assigning the values from the backed bean, the next stept is putting these
> values into var="systemdata", and after that you can output them normaly
> like this: 
> > <h:outputText id="systemtype" value="#{systemdata.sdtype}" />
> > 
> >        private List bean;
> > 
> >        public void search(ActionEvent event) {
> >                HtmlDataTable dataTable = (HtmlDataTable)
> event.getComponent()
> >                                .findComponent("bean");
> >                if (getSystemdata().getSdtagnumber() ==
> null) {
> >                        bean =
> getSystemdataManager().getSystemdatas(); 
> >                }
> >        }
> > As you can see, bean is just a normal list.
> > That's the way it works for me, if you could provide a bit more code, it
> would be easyer to figure out your problem.
> > 
> > Hope that helps. 
> > 
> > Regards Johannes
> > wishfully waiting for the cooling tempest.
> > 
> > "MyFaces Discussion" <users@myfaces.apache.org> schrieb am 18.07.05
> 13:57:47:
> > > Hi,   i am trying to use <x:dataTable to diplay a resultset [from
> postgresql]. I have wrapped the resultset into a JDBCrowset. I am using
> jetty . Basically the data doesn't get displayed on the we browser.   i get
> the  following error: 
> > >   13:40:15.610 WARN!! [P1-19]
> org.apache.myfaces.renderkit.html.HtmlRenderKitImpl.
> > > getRenderer(HtmlRenderKitImpl.java:67) >36> Unsupported
> component-family/rendere
> > > r-type: javax.faces.ViewRoot /org.apache.myfaces.Table  
>  Could anybody give an example of how they have done this
> or kindy help me here
> > > --
> > > Kind Regards
> > > Shibi Thomas
> > >
> > >
> > >
> > >
> > 
> > 
> >
> ______________________________________________________________
> > Verschicken Sie romantische, coole und witzige Bilder per SMS!
> > Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193
> > 
> > 
> 
>  
> 
> -- 
> Kind Regards 
> Shibi Thomas 
> 
> Can a mother forget the baby at her breast and have no compassion on the
> child she has borne? 
> Though she may forget, I will not forget you! See, I have engraved you on
> the palms of my hands; your walls are ever before me. [Isaiah 49:15,16] 
> 
> 
>

Mime
View raw message