如何使用Spring和Hibernate在Primefaces中执行懒惰的dataTable？

我必须将我的dataTable转换为惰性dataTable。我该怎么做？这是我的示例代码：

IndexBean.java

@Name("indexBean")
public class IndexBean implements Serializable {

    private static final long serialVersionUID = 1L;

    @Inject
    UserService userService;
    private List userList;

    @Inject
    MessageService messageService;
    private List messageList;

    private Integer dataTableRendered;

    public void getAllUser() {
        setDataTableRendered(1);
        userList = new ArrayList();
        userList = userService.getAllUser();
        if (userList.size() > 0) {
            addMessageSuccess("Success", "Success");
        } else {
            addMessageError("Failure", "Failure!");
        }
    }

    public void getAllMessages() {
        setDataTableRendered(2);
        messageList = new ArrayList();
        messageList = messageService.getAllMessages();
        if (messageList.size() > 0) {
            addMessageSuccess("Success", "Success");
        } else {
            addMessageError("Failure", "Failure!");
        }
    }

    public void addMessageSuccess(String summary, String detail) {
        FacesMessage message = new FacesMessage(FacesMessage.SEVERITY_INFO, summary, detail);
        FacesContext.getCurrentInstance().addMessage(null, message);
    }

    public void addMessageError(String summary, String detail) {
        FacesMessage message = new FacesMessage(FacesMessage.SEVERITY_ERROR, summary, detail);
        FacesContext.getCurrentInstance().addMessage(null, message);
    }

    public List getUserList() {
        return userList;
    }
    public void setUserList(List userList) {
        this.userList = userList;
    }
    public List getMessageList() {
        return messageList;
    }
    public void setMessageList(List messageList) {
        this.messageList = messageList;
    }
    public Integer getDataTableRendered() {
        return dataTableRendered;
    }
    public void setDataTableRendered(Integer dataTableRendered) {
        this.dataTableRendered = dataTableRendered;
    }
}

index.xhtml

UserService.java

public interface UserService {

    public List getAllUser();
}

UserServiceImpl.java

@Service("userService")
@Component
@Transactional
public class UserServiceImpl implements UserService {


    @Autowired
    private UserDAO userDAO;

    @Override
    public List getAllUser() {
        return userDAO.getAllUser();
    }

}

UserDAO.java

public interface UserDAO {

    public List getAllUser();

}

UserDAOImpl.java- 实际上此sql更复杂。

@Component
@Repository("userDAO")
public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {


    @SuppressWarnings("unchecked")
    @Override
    public List getAllUser() {
        List userList = new ArrayList();
        String sql = "select * from SECRETDB.USER";


        try {
            Query query = getSession().createSQLQuery(sql).addScalar("userOID", StringType.INSTANCE)
                    .addScalar("userName", StringType.INSTANCE).addScalar("firstName", StringType.INSTANCE)
                    .setResultTransformer(Transformers.aliasToBean(User.class)).setCacheable(false)
                    .setCacheMode(CacheMode.IGNORE);

            userList = query.list();
            getSession().clear();
        } catch (HibernateException e) {
            getSession().clear();
            e.printStackTrace();
        }

        return userList;
    }

User.java

public class User {

    private String userOID;
    private String userName;
    private String firstName;

    public String getUserOID() {
        return userOID;
    }

    public void setUserOID(String userOID) {
        this.userOID = userOID;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

}

HibernateDaoSupport.java

public abstract class HibernateDaoSupport {

    @Autowired
    private SessionFactory sessionFactory;

    protected Session getSession() {
        return sessionFactory.getCurrentSession();
    }
}

Mahendran Ay.. 5

在index.xhtml中的数据表中，我看到了

  value="#{indexBean.userList }" paginator="true" rows="10"
            lazy="true" 

userList指向的位置

  private List userList; 

错了 它应该是

  private LazyUserDataModel userList

请阅读展示和userguide页167-168实施LazyDataModel。这里没有人会教你实现它。下面是使用hibernate和JPA的通用lazydatamodel的示例。

  public class GenericLazyDataModel extends LazyDataModel {

@Transient
protected static Logger debugLogger = Logger.getLogger("DebugLogger");

protected EntityManager entityManager;
protected String hqlQuery;
private String countQuery;
protected List defaultSortFields;
protected List currentObjectList;
protected List