ykmykm4608

혹시 fetchjoin 적용 안된거 같은데 할필요가 없는걸까요?&nbsp;<pre class="hljs"><code> public List<Transaction> findTransactionList(Long accountId, String gubun, Integer page){

 JPAQuery<Transaction> query = jpaQueryFactory.selectFrom(transaction);

 return query
 .leftJoin(transaction.withdrawAccount).leftJoin(transaction.depositAccount)
 .where(gubunCheck(gubun, accountId))
 .limit(3).offset(page*3)
 .fetch();

 }
 
 private BooleanExpression gubunCheck(String gubun, Long accountId){
 if (!StringUtils.hasText(gubun)){
 return
 transaction.withdrawAccount.id.eq(accountId).or(transaction.depositAccount.id.eq(accountId));

 }else if(TransactionEnum.valueOf(gubun) == TransactionEnum.DEPOSIT){
 return
 fetchjtransaction.depositAccount.id.eq((accountId));
 }else if(TransactionEnum.valueOf(gubun) == TransactionEnum.WITHDRAW){
 return
 transaction.withdrawAccount.id.eq(accountId);
 }else {
 return null;
 }
 }</code></pre>

JPQL 동적쿼리 부분 - > QUERYDSL 마이그레이션 후 질문

<img src="https://cdn.inflearn.com/public/files/posts/b59257d0-aefa-4dd8-93fb-7c716f2b7969/image.png">&nbsp;<img src="https://cdn.inflearn.com/public/files/posts/746f6660-2f1f-4a84-adef-116f9f679108/image.png">이렇게 하니 되네요,,? QAccout Q클래스가 맞았나 봅니다..,,<pre class="hljs"><code>QAccount withdrawAccount = QAccount.account;
QAccount depositAccount = QAccount.account;</code></pre>

첨에 터미널에서 mysql 설치하는거부터 생략하고 워크벤치로 했었는데 cmd로도 가능한거였꾼여 감사합닏...&nbsp;<img src="https://cdn.inflearn.com/public/files/posts/b2f68713-31bb-437e-b64e-1ad9b644aef3/image.png">

ykmykm4608

投稿