p:datatable filter and slect problem !

UI Components for JSF
Post Reply
kevinmart
Posts: 3
Joined: 25 Aug 2010, 17:48

29 Sep 2010, 17:47

Hello everyone ! When I develop my project i had one problem with p:datatable control . I had a simple database with faq table and use netbean to generated some pages for FAQ module (included list,create,update,edit ) .When testing this module , If i am not use filterBy in p:datatable in Litst.xhtml page and link to the view page , everything working perfect , but when use filterBy for searching some question i need , and javax.faces.model.NoRowAvailable Exception had been throw . Anybody can tell me what mistake i had made ? I am had change dynamic attribute to false but it still not working !
when i not use filterBy
Image
Image
whn i use join keyword
Image
Image
List.xhtml

Code: Select all

<p:dataTable width="1024" value="#{fAQController.items}" var="item" style="border:solid 1px">
                    <p:column>
                        <f:facet name="header">
                            <h:outputText value="#{bundle.ListFAQTitle_faQId}"/>
                        </f:facet>
                        <h:outputText value="#{item.faQId}"/>
                    </p:column>
                    <p:column filterBy="#{item.question}" filterMatchMode="contains">
                        <f:facet name="header">
                            <h:outputText value="#{bundle.ListFAQTitle_question}"/>
                        </f:facet>
                        <h:outputText value="#{item.question}"/>
                    </p:column>
                    <p:column>
                        <f:facet name="header">
                            <h:outputText value="#{bundle.ListFAQTitle_answer}"/>
                        </f:facet>
                        <h:outputText value="#{item.answer}"/>
                    </p:column>
                    <p:column>
                        <f:facet name="header">
                            <h:outputText value=""/>
                        </f:facet>
                        <h:commandLink action="#{fAQController.prepareView}" value="#{bundle.ListFAQViewLink}"/>
                        <h:outputText value=" "/>
                        <h:commandLink action="#{fAQController.prepareEdit}" value="#{bundle.ListFAQEditLink}"/>
                        <h:outputText value=" "/>
                        <h:commandLink action="#{fAQController.destroy}" value="#{bundle.ListFAQDestroyLink}"/>
                    </p:column>
                </p:dataTable>
FAQController.java

Code: Select all

package com.paulunisersity.jsf;

import com.paulunisersity.entities.FAQ;
import com.paulunisersity.jsf.util.JsfUtil;
import com.paulunisersity.jsf.util.PaginationHelper;
import com.paulunisersity.session.FAQFacade;
import java.util.List;

import java.util.ResourceBundle;
import javax.ejb.EJB;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.convert.Converter;
import javax.faces.convert.FacesConverter;
import javax.faces.model.DataModel;
import javax.faces.model.ListDataModel;
import javax.faces.model.SelectItem;

@ManagedBean (name="fAQController")
@SessionScoped
public class FAQController {

    private FAQ current;
    private DataModel items = null;
    @EJB private com.paulunisersity.session.FAQFacade ejbFacade;
    private PaginationHelper pagination;
    private int selectedItemIndex;

    public FAQController() {
    }

    public FAQ getSelected() {
        if (current == null) {
            current = new FAQ();
            selectedItemIndex = -1;
        }
        return current;
    }

    private FAQFacade getFacade() {
        return ejbFacade;
    }

    public PaginationHelper getPagination() {
        if (pagination == null) {
            pagination = new PaginationHelper(10) {

                @Override
                public int getItemsCount() {
                    return getFacade().count();
                }

                @Override
                public DataModel createPageDataModel() {
                    return new ListDataModel(getFacade().findRange(new int[]{getPageFirstItem(), getPageFirstItem()+getPageSize()}));
                }
            };
        }
        return pagination;
    }

    public String prepareList() {
        recreateModel();
        return "List";
    }

    public String prepareView() {
        current = (FAQ)getItems().getRowData();
        selectedItemIndex = pagination.getPageFirstItem() + getItems().getRowIndex();
        return "View";
    }

    public String prepareCreate() {
        current = new FAQ();
        selectedItemIndex = -1;
        return "Create";
    }

    public String create() {
        try {
            getFacade().create(current);
            JsfUtil.addSuccessMessage(ResourceBundle.getBundle("/Bundle").getString("FAQCreated"));
            return prepareCreate();
        } catch (Exception e) {
            JsfUtil.addErrorMessage(e, ResourceBundle.getBundle("/Bundle").getString("PersistenceErrorOccured"));
            return null;
        }
    }

    public String prepareEdit() {
        current = (FAQ)getItems().getRowData();
        selectedItemIndex = pagination.getPageFirstItem() + getItems().getRowIndex();
        return "Edit";
    }

    public String update() {
        try {
            getFacade().edit(current);
            JsfUtil.addSuccessMessage(ResourceBundle.getBundle("/Bundle").getString("FAQUpdated"));
            return "View";
        } catch (Exception e) {
            JsfUtil.addErrorMessage(e, ResourceBundle.getBundle("/Bundle").getString("PersistenceErrorOccured"));
            return null;
        }
    }

    public String destroy() {
        current = (FAQ)getItems().getRowData();
        selectedItemIndex = pagination.getPageFirstItem() + getItems().getRowIndex();
        performDestroy();
        recreateModel();
        return "List";
    }

    public String destroyAndView() {
        performDestroy();
        recreateModel();
        updateCurrentItem();
        if (selectedItemIndex >= 0) {
            return "View";
        } else {
            // all items were removed - go back to list
            recreateModel();
            return "List";
        }
    }

    private void performDestroy() {
        try {
            getFacade().remove(current);
            JsfUtil.addSuccessMessage(ResourceBundle.getBundle("/Bundle").getString("FAQDeleted"));
        } catch (Exception e) {
            JsfUtil.addErrorMessage(e, ResourceBundle.getBundle("/Bundle").getString("PersistenceErrorOccured"));
        }
    }

    private void updateCurrentItem() {
        int count = getFacade().count();
        if (selectedItemIndex >= count) {
            // selected index cannot be bigger than number of items:
            selectedItemIndex = count-1;
            // go to previous page if last page disappeared:
            if (pagination.getPageFirstItem() >= count) {
                pagination.previousPage();
            }
        }
        if (selectedItemIndex >= 0) {
            current = getFacade().findRange(new int[]{selectedItemIndex, selectedItemIndex+1}).get(0);
        }
    }

    public DataModel getItems() {
        if (items == null) {
            items = getPagination().createPageDataModel();
        }
        return items;
    }

    private void recreateModel() {
        items = null;
    }

    public String next() {
        getPagination().nextPage();
        recreateModel();
        return "List";
    }

    public String previous() {
        getPagination().previousPage();
        recreateModel();
        return "List";
    }

    public SelectItem[] getItemsAvailableSelectMany() {
        return JsfUtil.getSelectItems(ejbFacade.findAll(), false);
    }

    public SelectItem[] getItemsAvailableSelectOne() {
        return JsfUtil.getSelectItems(ejbFacade.findAll(), true);
    }

    @FacesConverter(forClass=FAQ.class)
    public static class FAQControllerConverter implements Converter {

        public Object getAsObject(FacesContext facesContext, UIComponent component, String value) {
            if (value == null || value.length() == 0) {
                return null;
            }
            FAQController controller = (FAQController)facesContext.getApplication().getELResolver().
                    getValue(facesContext.getELContext(), null, "fAQController");
            return controller.ejbFacade.find(getKey(value));
        }

        java.lang.Integer getKey(String value) {
            java.lang.Integer key;
            key = Integer.valueOf(value);
            return key;
        }

        String getStringKey(java.lang.Integer value) {
            StringBuffer sb = new StringBuffer();
            sb.append(value);
            return sb.toString();
        }

        public String getAsString(FacesContext facesContext, UIComponent component, Object object) {
            if (object == null) {
                return null;
            }
            if (object instanceof FAQ) {
                FAQ o = (FAQ) object;
                return getStringKey(o.getFaQId());
            } else {
                throw new IllegalArgumentException("object " + object + " is of type " + object.getClass().getName() + "; expected type: "+FAQController.class.getName());
            }
        }

    }
    public List<FAQ> getAllFaq(){
        return ejbFacade.findAll();
    }

}


Post Reply

Return to “PrimeFaces”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 16 guests