ibatis 实例 配置 源码

import java.io.Reader; import java.sql.SQLException; import java.util.List; import model.User; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; /** * * @代码功能:测试demo * @packageName * @file_name h2demo.java * @type_name h2demo * @author jiangx * @Description * * @email sziitjiang@163.com * @date 2011-4-22 下午11:13:07 */ public class h2demo { public static void update() { // 首先初始化iBatis获得一个SqlMapClient对象 String resource = "sqlmap-config.xml"; SqlMapClient sqlMap = null; try { Reader reader = Resources.getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (Exception e) { e.printStackTrace(); } // sqlMap系统初始化完毕，开始执行update操作 try { sqlMap.startTransaction(); User user = new User(); user.setId(new Integer(1)); user.setName("江伟雄"); user.setSex(new Integer(1)); sqlMap.update("updateUser", user); sqlMap.commitTransaction(); } catch (SQLException e) { System.out.println(e.getMessage()); } finally { try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } } public static List getUser() { // 首先初始化iBatis获得一个SqlMapClient对象 String resource = "sqlmap-config.xml"; com.ibatis.sqlmap.client.SqlMapClient sqlMap = null; List user = null; try { java.io.Reader reader = com.ibatis.common.resources.Resources .getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (Exception e) { e.printStackTrace(); } // sqlMap系统初始化完毕，开始执行getAllUser操作 try { sqlMap.startTransaction(); user = sqlMap.queryForList("getAllUser", null); sqlMap.commitTransaction(); } catch (SQLException e) { System.out.println(e.getMessage()); } finally { try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } return user; } public static void main(String[] args) { update(); List user = getUser(); for (int i = 0; i < user.size(); i++) { System.out.println(((User) user.get(i)).getName()); } } }