ibatis事务控制案例

package com.test.test; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import com.ibatis.common.resources.Resources; import com.test.voo.*; import java.io.Reader; import java.io.IOException; import java.util.List; import java.sql.SQLException; /** * This is not a best practices class. It's just an example * to give you an idea of how iBATIS works. For a more complete * example, see JPetStore 5.0 at http://www.ibatis.com. */ public class SimpleExample { /** * SqlMapClient instances are thread safe, so you only need one. * In this case, we'll use a static singleton. So sue me. ;-) */ private static SqlMapClient sqlMapper; /** * It's not a good idea to put code that can fail in a class initializer, * but for sake of argument, here's how you configure an SQL Map. */ static { try { Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); } catch (IOException e) { // Fail fast. throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e); } } public static List selectAllAccounts () throws SQLException { return sqlMapper.queryForList("selectAllProducts"); } public static Product selectProductById (int productid) throws SQLException { return (Product) sqlMapper.queryForObject("selectProductById", productid); } public static void insertProduct (Product Product) throws SQLException { sqlMapper.insert("insertProduct", Product); } public static void updateProduct (Product Product) throws SQLException { sqlMapper.update("updateProduct", Product); } public static void deleteProduct (int productid) throws SQLException { sqlMapper.delete("deleteProductById", productid); } public static void main(String []args) { //测试事务 try { Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); //事务控制 sqlMapper.startTransaction(); //添加两个产品 Product p1=new Product(); p1.setProductname("苹果2"); p1.setPrice(22.35f); sqlMapper.insert("insertProduct", p1); Product p2=new Product();//品名为null ，出错 p2.setPrice(22); sqlMapper.insert("insertProduct", p2); sqlMapper.commitTransaction(); } catch (Exception e) { e.printStackTrace(); try { sqlMapper.endTransaction(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } // try { // // //查询全部 // System.out.println("................查询全部..............."); // List all=SimpleExample.selectAllAccounts(); // for(int i=0;i<all.size();i++) // { // System.out.println((Product)all.get(i)); // } // // //查询单一 // System.out.println("................查询单一..............."); // Product p1=SimpleExample.selectProductById(4); // System.out.println(p1); // // //增加 // System.out.println("................增加..............."); // Product p2=new Product(); // p2.setProductname("苹果"); // p2.setPrice(22.35f); // SimpleExample.insertProduct(p2); // // //修改 // System.out.println("................修改..............."); // Product p3=new Product(); // p3.setProductid(2); // p3.setProductname("西瓜"); // p3.setPrice(222.35f); // SimpleExample.updateProduct(p3); // // //删除 // System.out.println("................删除..............."); // SimpleExample.deleteProduct(4); // // } catch (SQLException e) { // // TODO Auto-generated catch block // e.printStackTrace(); // } } }