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 <richard.k....@gmail.com> 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, <ms...@gre.ac.uk> wrote:
>> Quoting Richard Yee <richard.k....@gmail.com>:
>> 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, <ms...@gre.ac.uk> wrote:
>>> > Quoting Tommy Pham <tommy...@yahoo.com>:
>>> >
>>> >> ----- Original Message ----
>>> >> > From: "ms...@gre.ac.uk" <ms...@gre.ac.uk>
>>> >> > To: MyFaces Discussion <users@myfaces.apache.org>
>>> >> > 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: "ms...@gre.ac.uk"
>>> >> > > > To: users@myfaces.apache.org
>>> >> > > > 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
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>
>>
>>
>>
>>
>
