--- On Tue, 9/15/09, ms...@gre.ac.uk <ms...@gre.ac.uk> wrote:
> From: ms...@gre.ac.uk <ms...@gre.ac.uk>
> Subject: Re: Simple faces display page
> To: "MyFaces Discussion" <users@myfaces.apache.org>
> Date: Tuesday, September 15, 2009, 12:17 PM
> 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");
Try this instead of the line above:
DriverManager.getConnection("jdbc:mysql://localhost:3306/red","root","root").newInstance();
> 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
>
