[JPA] QueryDSL 조회시 원하는 컬럼만 가져오기

Member.java

@Data
@Entity
@Table(name = "member")
public class Member {

	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private int id;
	
	private String name;
	private String email;
}

 

MemberDTO.java

@Getter
public class MemberDTO {
	private String name;
	private String email;
	
	@QueryProjection
	public MemberDTO(String name, String email) {
		this.name = name;
		this.email = email;
	}
}

 

MemberRepository.java

public interface MemberRepository extends JpaRepository<Member, Integer>, MemberRepositoryCustom {

}

 

MemberRepositoryCustom.java

public interface MemberRepositoryCustom {

	List<MemberDTO> findByNameOrEmail(String type, String keyword);
}

 

MemberRepositoryCustomImpl.java

@RequiredArgsConstructor
public class MemberRepositoryCustomImpl implements MemberRepositoryCustom {

	private final JPAQueryFactory jpaQueryFactory;
	private final QMember qMember = QMember.member;
	
	@Override
	public List<MemberDTO> findByNameOrEmail(String type, String keyword) {
		
		List<MemberDTO> content = jpaQueryFactory
				.select(new QMemberDTO(qMember.name, qMember.email))
				.from(qMember)
				.where(qMember.email.contains(keyword))
				.fetch();
		return content;
	}
}

 

MemberController.java

@RestController
@RequiredArgsConstructor
public class MemberController {

	private final MemberRepository memberRepository;
	
	@GetMapping("members/search")
	public ResponseEntity<List<MemberDTO>> selectMemberByNameOrEmail(
			@RequestParam String type, 
			@RequestParam String keyword){
		List<MemberDTO> list = memberRepository.findByNameOrEmail(type, keyword);
		return ResponseEntity.ok(list);
	}
}