QuestionAsk Questions?
srikala
how to display database data in jsf page
1 Answer(s) 4 years and 7 months ago
Posted in : Java Server Faces Questions
1 Answer(s) 4 years and 7 months ago
Posted in : Java Server Faces Questions
View Answers
October 29, 2008 at 12:50 PM
Hi friend,
Some step to be member to solve the problem.
1.First visit to link :
http://www.roseindia.net/jsf/dataTable.shtml
2.Do some changes in "TableBean.java" class :
package roseindia;
import java.sql.*;
import java.util.*;
public class TableBean {
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/userdetails","root","root";);
ps = con.createStatement();
rs = ps.executeQuery("select * from userlogin");
while(rs.next())
{
perInfoAll.add(i,new perInfo(rs.getString(1),rs.getString(2)));
i++;
}
}
catch (Exception e)
{
System.out.println("Error Data : " + e.getMessage());
}
return perInfoAll;
}
public class perInfo {
String uname;
String password;
public perInfo(String uname, String password) {
this.uname = uname;
this.password = password;
}
public String getUname() {
return uname;
}
public String getPassword() {
return password;
}
}
}
"faces-config.xml"
<managed-bean>
<managed-bean-name>item</managed-bean-name>
<managed-bean-class>roseindia.TableBean</managed-bean-class>
<managed-bean-scope>request</managed-bean-scope>
</managed-bean>
"data.jsp"
<%@ taglib uri="http://java.sun.com/jsf/html"; prefix="h"%>
<%@ taglib uri="http://java.sun.com/jsf/core"; prefix="f"%>
<f:view><html><body>
<h:form>
<br><br><br>
<h:dataTable id="dt1" value="#{item1.perInfoAll}" var="item" bgcolor="#F1F1F1" border="10" cellpadding="5" cellspacing="3" first="0" rows="2" 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 'dataTable' demo" />
</f:facet>
<h:column>
<f:facet name="header">
<h:outputText value="uname" />
</f:facet>
<h:outputText value="#{item.uname}"></h:outputText>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="password"/>
</f:facet>
<h:outputText value="#{item.password}"></h:outputText>
</h:column>
<f:facet name="footer">
<h:outputText value="The End" />
</f:facet>
</h:dataTable><br>
</h:form>
</body></html></f:view>
Thanks
Some step to be member to solve the problem.
1.First visit to link :
http://www.roseindia.net/jsf/dataTable.shtml
2.Do some changes in "TableBean.java" class :
package roseindia;
import java.sql.*;
import java.util.*;
public class TableBean {
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/userdetails","root","root";);
ps = con.createStatement();
rs = ps.executeQuery("select * from userlogin");
while(rs.next())
{
perInfoAll.add(i,new perInfo(rs.getString(1),rs.getString(2)));
i++;
}
}
catch (Exception e)
{
System.out.println("Error Data : " + e.getMessage());
}
return perInfoAll;
}
public class perInfo {
String uname;
String password;
public perInfo(String uname, String password) {
this.uname = uname;
this.password = password;
}
public String getUname() {
return uname;
}
public String getPassword() {
return password;
}
}
}
"faces-config.xml"
<managed-bean>
<managed-bean-name>item</managed-bean-name>
<managed-bean-class>roseindia.TableBean</managed-bean-class>
<managed-bean-scope>request</managed-bean-scope>
</managed-bean>
"data.jsp"
<%@ taglib uri="http://java.sun.com/jsf/html"; prefix="h"%>
<%@ taglib uri="http://java.sun.com/jsf/core"; prefix="f"%>
<f:view><html><body>
<h:form>
<br><br><br>
<h:dataTable id="dt1" value="#{item1.perInfoAll}" var="item" bgcolor="#F1F1F1" border="10" cellpadding="5" cellspacing="3" first="0" rows="2" 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 'dataTable' demo" />
</f:facet>
<h:column>
<f:facet name="header">
<h:outputText value="uname" />
</f:facet>
<h:outputText value="#{item.uname}"></h:outputText>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="password"/>
</f:facet>
<h:outputText value="#{item.password}"></h:outputText>
</h:column>
<f:facet name="footer">
<h:outputText value="The End" />
</f:facet>
</h:dataTable><br>
</h:form>
</body></html></f:view>
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
