EntityManager原生SQL实现分页查询

记录一下做项目时jpa分页查询，使用entityManager执行sql

SQLUtils

/**
 * 自定义sql封装类
 */
public class SqlUtils {

    private static final String QUERY_SQL="SELECT " +
            "s.edition," +
            "s.name," +
            "p.manager_name," +
            "p.project_stage" +
            " FROM " +
            "xxxxx s" +
            " LEFT JOIN yyyy p ON s.id = p.xxxx_id ";
        public static String  applyQuerySql(String condition,Integer nowPage,Integer pageSize){
            Integer start = (nowPage-1)*pageSize;
            String limit = " limit "+start+","+pageSize;
            if(condition!=null){
                String patchwork = "where p.name like '%"+condition+"%'";
                return QUERY_SQL+patchwork+limit;
            }
            return QUERY_SQL + limit;
        }

}

查询业务处理

@PersistenceContext
private EntityManager entityManager;  

  public TableDataInfo applyList(@Request