iBatis初级入门案例
小弟今天在Javaeye上面碰到一个好文章,是iBatis的入门,上面讲了一个小例子,觉得不错,不过代码里面有部分错,已纠正!
我用的是MyEclipse8.5+MySQL;
第一步是建数据库
?3,接下来开始配置SqlMapConfig.xml文件
?
?
4,当然这里我么还需要写一个实体类,一边做OR Mapping映射package com.dagmom;import java.io.Reader;import java.sql.SQLException;import java.util.List;import com.dagmom.model.User;import com.ibatis.common.resources.Resources;import com.ibatis.sqlmap.client.SqlMapClient;import com.ibatis.sqlmap.client.SqlMapClientBuilder;public class ExampleMain { public static void update(){ //首先初始化iBatis获得一个SqlMapClient对象 String resource = "com/dagmom/maps/SqlMapConfig.xml"; SqlMapClient sqlMap = null; try{ Reader reader = Resources.getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); }catch(Exception e){ e.printStackTrace(); } //sqlMao系统初始化完毕,开始执行update操作 try{ sqlMap.startTransaction(); User user = new User(); user.setId(new Integer(1)); user.setName("guhao"); 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/dagmom/maps/SqlMapConfig.xml"; SqlMapClient sqlMap = null; List user = null; try{ Reader reader = 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) { System.out.print("x"); update(); List user = getUser(); System.out.println(user); }}?这个程序很简单,而且大家对iBatis应该有入门级的了解了,以后就容易了!?
?