[MYBATIS] (MVC 2) SaleItemDao, SaleItemMapper

📌 SaleItemDao.java 내용 수정

package dao;

import java.util.List;

import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import dao.mapper.SaleItemMapper;
import logic.SaleItem;

@Repository
public class SaleItemDao {
	@Autowired //sqlSessionTemplate 객체 주입
	private SqlSessionTemplate template;

	public void insert(SaleItem saleitem) {
		template.getMapper(SaleItemMapper.class).insert(saleitem);
	}

	public List<SaleItem> list(int saleid) { //saleid 별 상품목록 가져오는
		return template.getMapper(SaleItemMapper.class).list(saleid);
	}
}

 

 

📌 SaleItemMapper.java 생성

package dao.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import logic.SaleItem;

public interface SaleItemMapper {

	@Insert("insert into saleitem (saleid, seq, itemid, quantity, price) values( #{saleid},#{seq},#{itemid},#{quantity},#{item.price})")
	void insert(SaleItem saleitem);

	@Select("select * from saleitem where saleid = #{saleid}")
	List<SaleItem> list(int saleid);

}