조인할 세개의 테이블의 VO
public class OrderVO {
//발주변수
private String order_id;
private String ma_id;
private int order_qty;
private int order_sum;
private int order_vat;
private Date order_date;
private Date due_date;
private String whs_num;
private int order_emp;
// material
private String shelt_position;
private String ma_name;
private int ma_qty;
private String unit_cost;
// in_material
private Timestamp in_date;
mappers쪽의코드
<select id="getOrderList" resultType="com.itwillbs.domain.OrderVO">
SELECT o.order_id, m.ma_id, m.ma_name, m.ma_qty, o.order_vat,o.order_sum ,o.order_date, o.due_date, o.order_emp, o.order_qty, m.shelt_position, i.in_date,m.unit_cost
FROM material m, orders o, in_material i
WHERE m.ma_id = o.ma_id AND o.order_id = i.order_id
</select>후에 orserivce에 리스트를 넣은후 출력해주면 끝이다.!
