package dao.impl;

import java.sql.SQLException;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;

import domain.BookInfo;

public class BookDAOImpl implements dao.BookDAO {
	SqlMapClient sqlMap = SqlMapConfig.getSqlMap();

	public void add(BookInfo book) throws SQLException {
		sqlMap.update("addBook", book);//第一個參數是映射文件的ID，第二個是傳入的對象參數
	}

	public List findAll() throws SQLException {
		List list = sqlMap.queryForList("findAllBook");
		return list;
	}

	public byte[] getCover(BookInfo book) throws SQLException {

			BookInfo book1 = (BookInfo) sqlMap.queryForObject("getCover",book);
			return book1.getCover();
	}
	
	//insert,update,delete,queryForObject(返回持久化的VO),queryForList,queryForMap,
	//queryForMap,queryForPaginatedList（返回的都是持久化VO的集合，PaginatedList有翻頁功能）
	/*運用事務
	 * try{
		sqlMap.startTransaction();
		BookInfo book1 = (BookInfo) sqlMap.queryForObject("getCover",book);
		
		sqlMap.commitTransaction();
	}finally{
		sqlMap.endTransaction();
	}
	
	批量處理非查詢的SQL語句
	sqlMap.startBatch();
	...... //條用添加，更新，刪除等非查詢的SQL
	sqlMap.executeBatch();
	在調用sqlMap.executeBatch()時所有處理SQL將通過JDBC驅動來執行
	*/

}