bookdaoimpl.java

来自「在线商店」· Java 代码 · 共 48 行

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驱动来执行
	*/

}