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 >> > >> > >> > >> > >> > >> > >> > > > > >
