<p:dataTable var="contractorsTable" value="#{ContractorsBean.contractorList}">
                            <p:column sortBy="#{contractorsTable.id}">  
                                <f:facet name="header">
                                    <h:outputText value="ID" />  
                                </f:facet>
                                <h:outputText value="#{contractorsTable.id}">
                                </h:outputText>
                            </p:column>  
                            <p:column sortBy="#{contractorsTable.name}">  
                                 <f:facet name="header">Наименование</f:facet>
                                <h:outputText value="#{contractorsTable.name}" />  
                            </p:column>  
                            <p:column headerText="Город">  
                                <h:outputText value="#{contractorsTable.city}" />  
                            </p:column>  
                        </p:dataTable>

@ManagedBean(name = "ContractorsBean")
public class ContractorsBean implements Serializable {

    private List<Contractor> contractorList;
    private PhoenixDBService dBService = new PhoenixDBService();

    public ContractorsBean() throws SQLException {
        dBService.init();
        getAllContractors();
    }

    public void getAllContractors() throws SQLException {
        String sql = "select * from contractor order by id";
        PreparedStatement ps = dBService.getStatement(sql);
        ResultSet rs = ps.executeQuery();
        contractorList = new ArrayList<Contractor>();
        while (rs.next()) {
            Contractor newContr = new Contractor();
            newContr.setId(Integer.valueOf(rs.getString("id").toString()));
            newContr.setName(rs.getString("name"));
            newContr.setCity(rs.getString("city"));
            contractorList.add(newContr);
        }
    }

    public List<Contractor> getContractorList() {
        return contractorList;
    }

    public void setContractorList(List<Contractor> contractorList) {
        this.contractorList = contractorList;
    }
}