SpringBoot-JPA自定义SQL（分页）语句

package com.example.clothingmanager.dao;

import com.example.clothingmanager.bean.Clothes;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @author Huangyt
 * @version 1.0
 * @date 2020/5/7 16:45
 */
public interface ClothesDao extends JpaRepository<Clothes, String> {
	//第一种写法
    @Query(value = "select * from tb_clothes where cname like CONCAT('%', :keyword, '%')", nativeQuery = true, countQuery = "select count(1) from tb_clothes")
    public Page<Clothes> findByKeyword(String keyword, Pageable pageable);
	
	//第二种写法
    //@Query(value = "select * from tb_clothes where cname like CONCAT('%', ?1, '%')", nativeQuery = true, countQuery = "select count(1) from tb_clothes")
    //public Page<Clothes> findByKeyword(String keyword, Pageable pageable);
}

}

第一种写法确保无误，不会报错。

但是第二种写法虽然这里不报错，但是在其它地方可能会报错，所以还是统一采取第一种写法好

采取第二种写法可能会无法读取参数：

Could not locate ordinal parameter [1], expecting one of []

调用

package com.example.clothingmanager;

import com.example.clothingmanager.bean.Clothes;
import com.example.clothingmanager.dao.ClothesDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;

import java.util.List;

@SpringBootTest
class ClothingmanagerApplicationTests {
    @Autowired
    ClothesDao clothesDao;

    @Test
    void contextLoads() {
        Sort.Order order = new Sort.Order(Sort.Direction.DESC, "citem");
        Pageable pageable = PageRequest.of(1, 5, Sort.by(order));
        Page<Clothes> list = clothesDao.findByKeyword("衣服", pageable);
        
        System.out.println(list.getContent().size());
        for(Clothes clothes : list.getContent()){
            System.out.println(clothes);
        }
    }

}