when i not use filterBy
whn i use join keyword
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>
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();
}
}