카테고리 없음
spring boot querydsl study (2)
머룽
2023. 4. 20. 09:53
우리는 어제 querydsl의 기본적인 API들을 살펴보고 변경사항도 같이 살펴봤다.
이번시간은 간단한 동적쿼리와 join에 대해 알아보자. 심도있는 것은 나중에 살펴보도록하고..
일단 엔티티부터 코드로 보자. 아래 엔티티로 공부를 할 예정이라 포스팅도 같이 했다. 추가되면 그때 그때 추가 하겠다.
@Entity
public class Account {
@Id
@GeneratedValue
@Column(name = "ACCOUNT_ID")
private Long id;
private String name;
private String password;
private String email;
@OneToMany(mappedBy = "account")
private List<Order> orders = new ArrayList<>();
//getter setter hashcode equals etc..
}
@Entity
@Table(name = "ORDERS")
public class Order {
@Id
@GeneratedValue
@Column(name = "ORDER_ID")
private Long id;
@ManyToOne
@JoinColumn(name = "ACCOUNT_ID")
private Account account;
@OneToMany(mappedBy = "order")
private List<OrderItem> orderItems = new ArrayList<>();
@Temporal(TemporalType.TIMESTAMP)
private Date orderDate;
//getter setter hashcode equals etc..
}
@Entity
@Table(name = "ORDER_ITEM")
public class OrderItem {
@Id
@GeneratedValue
@Column(name = "ORDER_ITEM_ID")
private Long id;
@ManyToOne
@JoinColumn(name = "ITEM_ID")
private Item item;
@ManyToOne
@JoinColumn(name = "ORDER_ID")
private Order order;
private Integer orderPrice;
private Integer count;
//getter setter hashcode equals etc..
}
@Entity
public class Item {
@Id
@GeneratedValue
@Column(name = "ITEM_ID")
private Long id;
private String name;
private Integer price;
private Integer stockQuantity;
//getter setter hashcode equals etc..
}
@Override
public List<Order> orders(){
QOrder order = QOrder.order;
QAccount account = QAccount.account;
return from(order)
.leftJoin(order.account, account).fetchJoin()
.fetch();
}
@Override
public List<Order> orders(Long id){
QOrder order = QOrder.order;
QAccount account = QAccount.account;
JPQLQuery query = from(order)
.leftJoin(order.account, account);
if(id != null){
query.where(account.id.goe(id));
}
return query
.fetchJoin().fetch();
}
@Override
public List<Order> orders(Long id){
QOrder order = QOrder.order;
QAccount account = QAccount.account;
JPQLQuery query = from(order)
.leftJoin(order.account, account).fetchJoin();
BooleanBuilder booleanBuilder = new BooleanBuilder();
if(id != null){
booleanBuilder.and(account.id.goe(id));
}
query.where(booleanBuilder);
return query.fetch();
}