Cheers Richard. This now works fine... however when i try to use the table from
the woodstock basic the table shows two of everything. as below :
(the standard table works fine)
__________________________________________________________________________
Unique Id Unique Id
UserName UserName
PassWord
3 Zied Zied
4 Samuel Samuel
5 Rednose testing
6 sam sam
7 Balvinder freedom
8 red blue
28 Deepak Kumar
29 Name Pass
30 Shiraz Kumar
31 West Coast
32 south Coast
3 Zied Zied
4 Samuel Samuel
5 Rednose testing
6 sam sam
7 Balvinder freedom
8 red blue
28 Deepak Kumar
29 Name Pass
30 Shiraz Kumar
31 West Coast
32 south Coast
________________________________________________________________________
this is the code
version="2.1" xmlns:f="http://java.sun.com/jsf/core";
xmlns:h="http://java.sun.com/jsf/html"; xmlns:jsp="http://java.sun.com/JSP/Page";
xmlns:webuijsf="http://www.sun.com/webui/webuijsf";>
<jsp:directive.page contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"/>
<f:view>
<webuijsf:page id="page1">
<webuijsf:html id="html1">
<webuijsf:head id="head1">
<webuijsf:link id="link1" url="/resources/stylesheet.css"/>
</webuijsf:head>
<webuijsf:body id="body1" style="-rave-layout: grid">
<webuijsf:form id="form1">
<webuijsf:table augmentTitle="false" id="table1"
style="left: 168px; top: 96px; position: absolute; width: 450px" title="Current
Users" width="450">
<webuijsf:tableRowGroup id="tableRowGroup1"
sourceData="#{tableBean.perInfoAll}" sourceVar="currentRow">
<webuijsf:tableColumn headerText="Unique Id"
id="tableColumn1" sort="uid">
<webuijsf:staticText id="staticText1"
text="#{currentRow.value['uid']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn headerText="UserName"
id="tableColumn2" sort="name">
<webuijsf:staticText id="staticText2"
text="#{currentRow.value['name']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn headerText="PassWord"
id="tableColumn3" >
<webuijsf:staticText id="staticText3"
text="#{currentRow.value['pass']}"/>
</webuijsf:tableColumn>
</webuijsf:tableRowGroup>
</webuijsf:table>
</webuijsf:form>
</webuijsf:body>
</webuijsf:html>
</webuijsf:page>
</f:view>
</jsp:root>
uoting Richard Yee <[email protected]>:
> Remove the rows attribute from your h:dataTable tag or set it to 0
> (rows="0")
> This is what you currently have:
> <h:dataTable id="dt1" value="#{tableBean.perInfoAll}" var="item"
> bgcolor="#F1F1F1" border="10" cellpadding="5" cellspacing="3" rows="4"
> width="50%" dir="LTR" frame="hsides" rules="all" summary="This is a JSF code
> to
> create dataTable." >
>
> This is the documentation for the rows attribute:
> rows (must evaluate to int) The number of rows to display, starting
> with the one identified by the "first" property. If this value is set
> to zero, all available rows in the underlying data model will be
> displayed.
>
> This explains why only 4 rows are displayed.
>
> -Richard
>
>
>
>
> On Wed, Sep 16, 2009 at 10:11 AM, Richard Yee <[email protected]>
> wrote:
> > Are you using a debugger? Did you check the size of the list returned
> > by getperInfoAll()?
> >
> > -R
> >
> > On Wed, Sep 16, 2009 at 3:58 AM, <[email protected]> wrote:
> >> Quoting Richard Yee <[email protected]>:
> >> Cheers Richard, you woul be amazed how much difference changing the case
> made.
> >> However now i get the contents but not all
> >> _________________________________________________________________
> >> the table
> >>
> >> +-----+-----------+---------+
> >> | UID | NAME | PASS |
> >> +-----+-----------+---------+
> >> | 3 | Zied | Zied |
> >> | 4 | Samuel | Samuel |
> >> | 5 | Rednose | testing |
> >> | 25 | sam | sam |
> >> | 26 | Balvinder | freedom |
> >> | 27 | red | blue |
> >> | 28 | Deepak | Kumar |
> >> | 29 | Name | Pass |
> >> | 30 | Shiraz | Kumar |
> >> | 31 | West | Coast |
> >> | 32 | south | Coast |
> >> +-----+-----------+---------+
> >> 11 rows in set (0.00 sec)
> >> ____________________________________________________________
> >> the result(without html)
> >> This is The liset of all existing users
> >> UserId User Name User Pass
> >> 3 Zied Zied
> >> 4 Samuel Samuel
> >> 5 Rednose testing
> >> 25 sam sam
> >> The End
> >>
> >> ____________________________________________________________________-
> >>
> >>
> >>> I suggest using a debugger if you are not already doing so to step
> >>> through the call to getPerInfoAll method. Verify that it is reading
> >>> all of the rows and returning a list of all of the rows.
> >>>
> >>> In the code below, you should use #{item.name} and #{item.pass}
> >>> instead of #{item.Name} and #{item.Pass} I'd also suggest changing the
> >>> name of the getUID method to getUid
> >>> Also, the JDBC code should have a finally clause to close. the
> resources.
> >>>
> >>> -R
> >>>
> >>> <h:outputText value="#{item.Name}"></h:outputText>
> >>> </h:column>
> >>>
> >>> <h:column>
> >>> <f:facet name="header">
> >>> <h:outputText value="User Pass"/>
> >>> </f:facet>
> >>> <h:outputText value="#{item.Pass}"></h:outputText>
> >>> </h:column>
> >>>
> >>>
> >>> On Tue, Sep 15, 2009 at 10:17 AM, <[email protected]> wrote:
> >>> > Quoting Tommy Pham <[email protected]>:
> >>> >
> >>> >> ----- Original Message ----
> >>> >> > From: "[email protected]" <[email protected]>
> >>> >> > To: MyFaces Discussion <[email protected]>
> >>> >> > Sent: Tuesday, September 15, 2009 8:00:59 AM
> >>> >> > Subject: Re: Simple faces display page
> >>> >> >
> >>> >> > I did not mean struts i meant faces. Sorry for the confusion
> >>> >> >
> >>> >> > Quoting Tommy Pham :
> >>> >> >
> >>> >> > > ----- Original Message ----
> >>> >> > > > From: "[email protected]"
> >>> >> > > > To: [email protected]
> >>> >> > > > Sent: Tuesday, September 15, 2009 5:27:17 AM
> >>> >> > > > Subject: Simple faces display page
> >>> >> > > >
> >>> >> > > > I have copied the example from
> >>> >> (http://www.roseindia.net/jsf/data.shtml).
> >>> >> > > >
> >>> >> > > > th problem now is that my data.jsp does not show any contents. I
> am
> >>> >> using
> >>> >> > > > struts2
> >>> >> > > >
> >>> >> > > > does anyone know why ?
> >>> >> > >
> >>> >> > > The link you gave makes no mention of struts in the tutorial...
> >>> >> > >
> >>> >> > >
> >>> >>
> >>> >> Does your database have any data? Are you getting any errors?
> Warnings?
> >>> >>
> >>> >>
> >>> >
> >>> >
> >>>
> ____________________________________________________________________________
> >>> > Yes i have data in the database
> >>> > as shown below:
> >>> > mysql> select * from first;
> >>> > +-----+-----------+---------+
> >>> > | UID | NAME | PASS |
> >>> > +-----+-----------+---------+
> >>> > | 3 | Zied | Zied |
> >>> > | 4 | Samuel | Samuel |
> >>> > | 5 | Rednose | testing |
> >>> > | 25 | sam | sam |
> >>> > | 26 | Balvinder | freedom |
> >>> > | 27 | red | blue |
> >>> > | 28 | Deepak | Kumar |
> >>> > | 29 | Name | Pass |
> >>> > | 30 | Shiraz | Kumar |
> >>> > | 31 | West | Coast |
> >>> > | 32 | south | Coast |
> >>> > +-----+-----------+---------+
> >>> > 11 rows in set (0.11 sec)
> >>> >
> >>> >
> >>> > _____________________________________________________________________
> >>> > this is the java code
> >>> >
> >>> > import java.sql.*;
> >>> > import java.util.*;
> >>> >
> >>> > public class User {
> >>> >
> >>> > Connection con ;
> >>> > Statement ps;
> >>> > ResultSet rs;
> >>> > private List perInfoAll = new ArrayList();
> >>> >
> >>> > public List getperInfoAll() {
> >>> > int i = 0;
> >>> > try
> >>> > {
> >>> >
> >>> > Class.forName("com.mysql.jdbc.Driver");
> >>> > con =
> >>> >
> >>>
> DriverManager.getConnection("jdbc:mysql://localhost:3306/red","root","root");
> >>> > ps = con.createStatement();
> >>> > rs = ps.executeQuery("select * from First");
> >>> > while(rs.next()){
> >>> > System.out.println(rs.getInt(1));
> >>> > perInfoAll.add(new
> >>> perInfo(rs.getInt(1),rs.getString(2),rs.getString(3)));
> >>> > i++;
> >>> >
> >>> > }
> >>> >
> >>> > }
> >>> > catch (Exception e)
> >>> > {
> >>> > System.out.println("Error Data : " + e.getMessage());
> >>> > }
> >>> > return perInfoAll;
> >>> > }
> >>> >
> >>> >
> >>> > public class perInfo {
> >>> >
> >>> > int UID;
> >>> > String Name;
> >>> > String Pass;
> >>> >
> >>> >
> >>> > public perInfo(int UID, String Name,String Pass) {
> >>> > this.UID = UID;
> >>> > this.Name = Name;
> >>> > this.Pass = Pass;
> >>> >
> >>> > }
> >>> >
> >>> > public int getUID() {
> >>> > return UID;
> >>> > }
> >>> >
> >>> > public String getName() {
> >>> > return Name;
> >>> > }
> >>> >
> >>> > public String getPass() {
> >>> > return Pass;
> >>> > }
> >>> >
> >>> > }
> >>> >
> >>> > }
> >>> >
> >>> > ___________________________________________________________________
> >>> > this is the faces-config.xml
> >>> >
> >>> > <managed-bean>
> >>> > <managed-bean-name>tableBean</managed-bean-name>
> >>> > <managed-bean-class>simplehiber.User</managed-bean-class>
> >>> > <managed-bean-scope>request</managed-bean-scope>
> >>> > </managed-bean>
> >>> >
> >>> >
> >>> >
> >>> >
> >>> > ___________________________________________________________________
> >>> >
> >>> > the jsp page
> >>> >
> >>> > <%@ taglib uri="http://java.sun.com/jsf/html"; prefix="h"%>
> >>> > <%@ taglib uri="http://java.sun.com/jsf/core"; prefix="f"%>
> >>> >
> >>> > <f:view><html>
> >>> > <head>
> >>> >
> >>> > </head>
> >>> > <body>
> >>> > <center>
> >>> > <br><br><br>
> >>> > <h:dataTable id="dt1" value="#{tableBean.perInfoAll}" var="item"
> >>> > bgcolor="#F1F1F1" border="10" cellpadding="5" cellspacing="3" rows="4"
> >>> > width="50%" dir="LTR" frame="hsides" rules="all" summary="This is a
> JSF
> >>> code to
> >>> > create dataTable." >
> >>> >
> >>> > <f:facet name="header">
> >>> > <h:outputText value="This is The liset of all existing users" />
> >>> > </f:facet>
> >>> >
> >>> > <h:column>
> >>> > <f:facet name="header">
> >>> > <h:outputText value="UserId" />
> >>> > </f:facet>
> >>> > <h:outputText style="" value="#{item.UID}" ></h:outputText>
> >>> > </h:column>
> >>> >
> >>> > <h:column>
> >>> > <f:facet name="header">
> >>> > <h:outputText value="User Name"/>
> >>> > </f:facet>
> >>> > <h:outputText value="#{item.Name}"></h:outputText>
> >>> > </h:column>
> >>> >
> >>> > <h:column>
> >>> > <f:facet name="header">
> >>> > <h:outputText value="User Pass"/>
> >>> > </f:facet>
> >>> > <h:outputText value="#{item.Pass}"></h:outputText>
> >>> > </h:column>
> >>> >
> >>> > <f:facet name="footer">
> >>> > <h:outputText value="The End" />
> >>> > </f:facet>
> >>> >
> >>> > </h:dataTable><br>
> >>> >
> >>> >
> >>> > </center>
> >>> > </body></html></f:view>
> >>> > __________________________________________________________________
> >>> > the output(without html)
> >>> >
> >>> > This is The liset of all existing users
> >>> > UserId User Name User Pass
> >>> > 3
> >>> > The End
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>>
> >>
> >>
> >>
> >>
> >>
> >
>
