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