gourav garg

Please check the following attached file .

It helps to resolve your problem

Second thing is it helps to display the data from result to datatable without
knowing number of columns and name of the columns . Even I used text alignment
for numeric column.

Please change text file to java file.

If any query please call any time
+919781379000
+919478679200

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package gourav.garg; import java.io.Serializable; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.faces.bean.ManagedBean; import javax.faces.bean.ViewScoped; /** * This is managed bean for JSF * It helps to draw the <code>h:datatable</code> or <code>p:datatable</code> * without knowing the number of columns in <code>java.sql.ResultSet</code> * and without knowing the name of columns in <code>java.sql.ResultSet</code> * * @author gouravgarg * @see xhtml Source Code as attached with * Thanks to following links : * http://www.java2s.com/Code/Java/JSTL/JSTLConditionalSupportSimpleConditionalExecutionExample.htm * http://www.javabeat.net/tips/46-hdatatable-java-server-faces-jsf.html * * @version 1.6 * * */ @ManagedBean @ViewScoped public class TestBean implements Serializable { public TestBean() { setReteriveSalary(); } /** * Help to align the values in <code>h:datatable</code> or <code>p:datatable</code> * as per business logic * @param i Columns Number * @return String value for text align */ public String findAlign(int i) { if (getListColumnsInfo().get(i).getClassName().trim().equals("java.lang.String")) { return "left"; } else if (getListColumnsInfo().get(i).getClassName().trim().equals("java.math.BigDecimal")) { return "right"; } return "left"; } private void setReteriveSalary() { listMonthlySalaryDetail = new ArrayList<ArrayList<String>>(); listColumnsInfo = new ArrayList<ColumnInfo>(); Connection conn = null; try { //Change it for db connection as per your business logic // conn = DBConn.getConnection(); String sql = " select * from MASTERHR.SALDTL_DELH_012012 "; System.out.println(sql); PreparedStatement pst = conn.prepareStatement(sql); ResultSet rs = pst.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); setNoOfColumns(rsmd.getColumnCount()); for (int i = 1; i <= getNoOfColumns(); i++) { ColumnInfo ci = new ColumnInfo(i, rsmd.getColumnLabel(i), rsmd.getColumnClassName(i)); listColumnsInfo.add(ci); } ArrayList<String> items = null; while (rs.next()) { items = new ArrayList<String>(); for (int i = 1; i <= getNoOfColumns(); i++) { items.add(rs.getString(i)); } listMonthlySalaryDetail.add(items); } conn.close(); } catch (Exception ex) { ex.printStackTrace(); if (conn != null) { try { conn.close(); } catch (SQLException ex1) { ex1.printStackTrace(); } } } System.out.println("Size listMonthlySalaryDetail : " + listMonthlySalaryDetail.size()); } public List<ColumnInfo> getListColumnsInfo() { return listColumnsInfo; } public void setListColumnsInfo(List<ColumnInfo> listColumnsInfo) { this.listColumnsInfo = listColumnsInfo; } public int getNoOfColumns() { return noOfColumns; } public void setNoOfColumns(int noOfColumns) { this.noOfColumns = noOfColumns; } public List<ArrayList<String>> getListMonthlySalaryDetail() { return listMonthlySalaryDetail; } public void setListMonthlySalaryDetail(List<ArrayList<String>> listMonthlySalaryDetail) { this.listMonthlySalaryDetail = listMonthlySalaryDetail; } private List<ArrayList<String>> listMonthlySalaryDetail; private List<ColumnInfo> listColumnsInfo; private int noOfColumns; }

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package gourav.garg; import java.io.Serializable; /** * * @author gourav garg */ public class ColumnInfo implements Serializable { private int no; private String name; private String className; public String getClassName() { return className; } public void setClassName(String className) { this.className = className; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getNo() { return no; } public void setNo(int no) { this.no = no; } public ColumnInfo(int no, String name, String className) { this.no = no; this.name = name; this.className = className; } @Override public String toString() { return "ColumnInfo{" + "no=" + no + ", name=" + name + ", className=" + className + '}'; } }


<ui:composition xmlns="http://www.w3.org/1999/xhtml" xmlns:h="http://java.sun.com/jsf/html" xmlns:p="http://primefaces.org/ui" xmlns:ui="http://java.sun.com/jsf/facelets" xmlns:c="http://java.sun.com/jsp/jstl/core" xmlns:f="http://java.sun.com/jsf/core"> <p:dataTable value="#{testBean.listMonthlySalaryDetail}" id="row" var="row" paginator="true" rows="15" paginatorTemplate="#{treeBean.MTreeNode.data} {CurrentPageReport} {FirstPageLink} {PreviousPageLink} {NextPageLink} {LastPageLink} {RowsPerPageDropdown}" rowsPerPageTemplate="10,15,25" paginatorPosition="top" > <c:forEach var="i" begin="0" end="#{testBean.noOfColumns-1}" step="1"> <p:column headerText="#{testBean.listColumnsInfo.get(i).name}" style="text-align: #{testBean.findAlign(i)}}"> <h:outputLabel value="#{row.get(i)}"/> </p:column> </c:forEach> </p:dataTable> </ui:composition>