springboot / querydsl 설정

JAVA

springboot / querydsl 설정

girin_dev 2022. 5. 31. 00:14

728x90

🥕 querydsl 설정을 통한 Q클래스 작동 및 실행 확인까지.

# springboot 2.7.0

build.gradle

buildscript {
    ext {
        queryDslVersion = "5.0.0"
    }
}

plugins {
    id 'org.springframework.boot' version '2.7.0'
    id 'io.spring.dependency-management' version '1.0.11.RELEASE'
    id 'java'
    id 'war'
    id "com.ewerk.gradle.plugins.querydsl" version "1.0.10"
}

configurations {
    compileOnly {
        extendsFrom annotationProcessor
    }
}

dependencies {

    // querydsl
    implementation "com.querydsl:querydsl-jpa:${queryDslVersion}"
    implementation "com.querydsl:querydsl-apt:${queryDslVersion}"

    annotationProcessor(
            "jakarta.persistence:jakarta.persistence-api",
            "jakarta.annotation:jakarta.annotation-api",
            )

}

// query dsl
def querydslDir = "$buildDir/generated/querydsl"
querydsl {
    jpa = true
    querydslSourcesDir = querydslDir
}
sourceSets {
    main.java.srcDir querydslDir
}
configurations {
    compileOnly {
        extendsFrom annotationProcessor
    }
    querydsl.extendsFrom compileClasspath
}
compileQuerydsl{
    options.annotationProcessorPath = configurations.querydsl

# QuerydslConfig.java

import com.querydsl.jpa.impl.JPAQueryFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

@Configuration
public class QuerydslConfig {

    @PersistenceContext
    private EntityManager entityManager;

    @Bean
    public JPAQueryFactory jpaQueryFactory() {
        return new JPAQueryFactory(entityManager);
    }

}

Entity to Qclass

import lombok.*;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
@Builder
@Getter
@ToString(exclude = "password")
@AllArgsConstructor
@NoArgsConstructor
public class Chief {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;

    private String email;

    private String password;

    private String address;

    private String phone;

    @Builder
    public static Chief createChief(long id, String email, String password, String address, String phone){
        return new Chief(id,email,password,address,phone);
    }

}

Dto to Qclass

import com.querydsl.core.annotations.QueryProjection;
import lombok.*;

@Getter
@Setter
@NoArgsConstructor
@ToString
public class ChiefDto {

    private long id;

    private String email;

    private String password;

    private String address;

    private String phone;

    @QueryProjection  // querydsl 
    public ChiefDto(long id, String email, String password, String address, String phone) {
        this.id = id;
        this.email = email;
        this.password = password;
        this.address = address;
        this.phone = phone;
    }
}

Repository 또는 RepositoryCustome 세팅.

상속을 회피하기위해 bean으로 등록한 JPAQueryFactory를 사용함.

import com.querydsl.jpa.impl.JPAQueryFactory;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Repository;

/*
    // 기존 방법 1.
    public interface MemberRepository extends JpaRepository<Member, Long>, MemberRepositoryCustom {}
    // 기존 방법2
    public class MemberRepositoryCustom extends QuerydslRepositorySupport {}
*/
@Repository
@RequiredArgsConstructor
public class ChiefRepositoryCustom {
    private final JPAQueryFactory queryFactory;

    public ChiefDto searchByKeyword(String keyword) {

        return null;
//        return queryFactory
//                .select(new ChiefDto(~~~))
//                .from()
//                .fetch();  와 같은 형식으로 사용.
    }
}

settings 체크