1

2

3

4

5

6

7

8

9

10

11

12

13

package com.frank.jpaBatchSave.repository;

import com.frank.jpaBatchSave.entity.Person;

import org.springframework.data.jpa.repository.Query;

import org.springframework.data.repository.PagingAndSortingRepository;

import org.springframework.stereotype.Repository;

import java.util.List;

@Repository

public interface PersonRepository extends PagingAndSortingRepository<Person, Integer> {

    @Query("select distinct new Person(p.name, p.province, p.city) from Person p")

    List<Person> getAllPerson();

}

1

2

3

4

5

public Person(String name, String province, String city) {

        this.name = name;

        this.province = province;

        this.city = city;

    }

1

2

@Query(value = "SELECT * from table where id= :id", nativeQuery = true)

List<aa> getByaaId(@Param("id") BigInteger id);

1

2

3

4

5

6

7

8

9

10

@Data

@NoArgsConstructor

@AllArgsConstructor

public class aaDto {

    private String aa;

    private String bb;

    private String cc;

}

@Query(value = "SELECT new com.xxx.xxx.dto.aaDto(i.aa,i.bb,i.cc) FROM table1 i JOIN table2 e on i.id=e.id")

List<aaDto> getList();

1

2

3

List<Map<String, Object>>

@Query(value = "SELECT a.aa,b.bb from a LEFT JOIN b a.id=b.id", nativeQuery = true)

List<Map<String, String>> getFundAccountList();

1

public interface xxxDTORepository extends JpaRepository<xxxDTO, Long>

1

2

@PersistenceContext

private EntityManager entityManager;