使用JPA/原生查询在MySql中进行批量/批处理搜索

@Entity
@Table(name = "my_table")
public class MyEntity {
    @Id
    private Long id;
    private String name;
    // other fields and getters/setters
}

@Repository
public interface MyEntityRepository extends JpaRepository<MyEntity, Long> {
    @Query("SELECT e FROM MyEntity e WHERE e.name LIKE %:keyword%")
    List<MyEntity> searchByName(@Param("keyword") String keyword);
}

@Service
public class MyService {
    @Autowired
    private MyEntityRepository repository;

    public List<MyEntity> searchEntities(String keyword) {
        return repository.searchByName(keyword);
    }
}

@Repository
public class MyEntityRepository {
    @PersistenceContext
    private EntityManager entityManager;

    public List<MyEntity> searchByName(String keyword) {
        String sql = "SELECT * FROM my_table WHERE name LIKE '%" + keyword + "%'";
        Query query = entityManager.createNativeQuery(sql, MyEntity.class);
        return query.getResultList();
    }
}

@Service
public class MyService {
    @Autowired
    private MyEntityRepository repository;

    public List<MyEntity> searchEntities(String keyword) {
        return repository.searchByName(keyword);
    }
}