文章目录
ibatis学习笔记(二)基本操作
上一次,做了一个简单的ibatis的例子,这回想针对上次的例子在继续研究
1.基本操作实例
(1)数据写入操作
Product prod = new Product(); prod.setName("联想 T400 笔记本"); prod.setPrice(8999); sqlMap.startTransaction(); sqlMap.insert("insertProduct", prod); sqlMap.commitTransaction();
(2)数据查询
Product prod = (Product)sqlMap.queryForObject("getProduct", 1);
(3)在指定对象中存放查询结果
Product prod = new Product(); sqlMap.queryForObject("getProduct", 1, prod);
(4)执行批量查询
sqlMap.queryForList("getAllUser", null);
(5)关于Auto Commit
自动执行
(6)查询指定范围内的数据
sqlMap.queryForList("getAllUser", null,1,1);
(7)结合RowHandler进行查询(select)
public class MyRowHandler implements RowHandler { public void handleRow (Object object, List list) throws SQLException { Product product = (Product) object; product.setQuantity (10000); sqlMap.update (“updateProduct”, product); } } sqlMap.startTransaction(); RowHandler rowHandler = new MyRowHandler(); List list = sqlMap.queryForList (“getProductList”, null, rowHandler); sqlMap.commitTransaction();
(8) 分页查询
PaginatedList list = sqlMap.queryForPaginatedList (“getProductList”, null, 10); list.nextPage(); list.previousPage();
(9)基于Map的批量查询(select)
sqlMap.startTransaction(); Map map = sqlMap.queryForMap (“getProductList”, null, “productCode”); sqlMap.commitTransaction(); Product p = (Product) map.get(“EST-93”);