ibatis入门实例（全代码）

package com.ibatis; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import java.util.List; import com.ibatis.common.resources.Resources; import com.ibatis.model.User; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class UserTest { private static SqlMapClient init() { // 初始化并获得一个SqlMapClient对象 String resource = "com/ibatis/maps/SqlMapConfig.xml"; SqlMapClient sqlMap = null; try { Reader reader = Resources.getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (IOException e) { e.printStackTrace(); } return sqlMap; } /** * 根据Id查找用户 * * @return */ public static User getUserById() { // 初始化并获得一个SqlMapClient对象 SqlMapClient sqlMap = init(); User user = null; try { sqlMap.startTransaction(); user = (User) sqlMap.queryForObject("getUser", 2); sqlMap.commitTransaction(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } return user; } /** * 添加用户 * * @return */ public static void addUser() { // 初始化并获得一个SqlMapClient对象 SqlMapClient sqlMap = init(); User user = new User(); try { user.setName("lala"); user.setSex("male"); sqlMap.startTransaction(); sqlMap.insert("saveUser", user); sqlMap.commitTransaction(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } } /** * 更新用户 * * @return */ public static void updateUser() { // 初始化并获得一个SqlMapClient对象 SqlMapClient sqlMap = init(); User user = new User(); try { user.setId(1); user.setName("1"); user.setSex("m"); sqlMap.startTransaction(); sqlMap.update("updateUser", user); sqlMap.commitTransaction(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } } /** * 删除用户 * * @return */ public static void deleteUser() { // 初始化并获得一个SqlMapClient对象 SqlMapClient sqlMap = init(); try { sqlMap.startTransaction(); sqlMap.delete("deleteUser", 1); sqlMap.commitTransaction(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } } /** *查找所有用户 * * @return */ public static List<User> findAllUser() { // 初始化并获得一个SqlMapClient对象 SqlMapClient sqlMap = init(); List<User> list=null; try { sqlMap.startTransaction(); list = sqlMap.queryForList("getAllUser", null); sqlMap.commitTransaction(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } return list; } public static void main(String[] args) { User user = getUserById(); System.out.println(user.getName() + ":" + user.getSex()); //addUser(); updateUser(); //deleteUser(); List<User> list = findAllUser(); for(User u:list){ System.out.println(u.getName() + ":" + u.getSex()); } } }