iBatis入门例子

package com.ctgusec.zhupan; import java.sql.SQLException; import java.util.List; import com.ctgusec.zhupan.model.User; import com.ibatis.sqlmap.client.SqlMapClientBuilder; /** * * @author zhupan */ public class ExampleMain { public static void update() { //首先初始化iBatis获得一个SqlMapClient对象 String resource = "com/ctgusec/zhupan/maps/SqlMapConfig.xml"; com.ibatis.sqlmap.client.SqlMapClient sqlMap = null; try { java.io.Reader reader = com.ibatis.common.resources.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("zhupan"); 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 = "com/ctgusec/zhupan/maps/SqlMapConfig.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()); } } }