jpa手写sql_JPA实现@Query手写原生sql拼接动态sql并分页的方法 - it610.com

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 PagegetHistoryInfo(String crawlerId,

String startDate,

String description,

Pageable pageable) {

StringBuffer dataBuffer = new StringBuffer(

"select h.title,h.CONTENT_URL,h.HISTORY_ID,h