JPA实现@Query手写原生sql拼接动态sql并分页的方法

import java.math.BigDecimal;
import java.util.Collections;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Repository;


@Repository("dao")
public class CrawlerHistoryLogDaoImpl implements CrawlerNewHistoryDao {
	
	@PersistenceContext
	private EntityManager entityManager;
	
 
	@Override
    public Page<Object[]> getHistoryInfo(String crawlerId,
                                         String startDate,
                                         String description,
                                         Pageable pageable) {

        StringBuffer dataBuffer = new StringBuffer(
                "select h.title,h.CONTENT_URL,h.HISTORY_ID,h.CHANNEL_URL,h.description