package kr.co.beauty.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import kr.co.beauty.vo.WishVO;

@Mapper
@Repository
public interface MyShopDAO {
	//wishlist
	public List<WishVO> selectWishlist(@Param("email") String email);
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "<https://mybatis.org/dtd/mybatis-3-mapper.dtd>">
<mapper namespace="kr.co.beauty.dao.MyShopDAO">
	
	<!-- 위시리스트 -->
	<select id="selectWishlist" resultType="WishVO">
		SELECT A.*, B.prodName, B.disPrice, B.thumb1 
		FROM `wish` as A JOIN `product` as B 
		ON A.prodNo = B.prodNo 
		WHERE A.email = #{email};
	</select>
	
</mapper>