springboot / querydsl 설정

 

 

🥕 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 체크

 

 

 

gradle - orther - compileQuerydsl 실행 : 

 

Q클래스 생성된것까지 확인.

 

 

 

실행까지.

 

 

 

설정에 에러가 있다면, 

 

https://devfoxstar.github.io/java/intellij-querydsl-error/

Intellij에서 QueryDSL 오류 (cannot find symbol Q class)

 

참조합시다.

 

# 레퍼런스 문서

 

http://querydsl.com/static/querydsl/4.0.1/reference/ko-KR/html_single/#intro

Querydsl - 레퍼런스 문서