ibatis学习笔记(二)——ibatis测试类的具体写法

package com.ibatis.test;

	import java.io.IOException;
	import java.io.Reader;
	import java.sql.SQLException;
	import java.util.Iterator;
	import java.util.List;

	import com.ibatis.common.resources.Resources;
	import com.ibatis.sqlmap.client.SqlMapClient;
	import com.ibatis.sqlmap.client.SqlMapClientBuilder;
	import com.wyq.pojo.User;



	public class TestIbatis {
	    public void readSqlMapConfig(){
	        
	    }
	    public static void main(String args[]){
	        Reader reader=null;
	        /**//*SqlMapClient是ibatis的核心组件，提供数据操作的基础平台,可以通过 
                       sqlMapClientBuilder创建
	         * 
	         * */
	        SqlMapClient sqlMap=null;
	        String resource="sqlMapConfig.xml";
	        try{
	         reader=Resources.getResourceAsReader(resource);
	         sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
	         
	         sqlMap.startTransaction();
	         
	        /**//* //数据写入操作（insert,update,delete）
	         User user=new User();
	         user.setName("Erica");
	         user.setSex(new Integer(1));
	         sqlMap.insert("User.insertUser",user);*/
	         
	         /**//*//数据查询操作（select）
	         Integer key=new Integer(1);
	         User users=(User)sqlMap.queryForObject("User.getUsers", key);
	         System.out.println("id==="+users.getId());
	         System.out.println("name==="+users.getName());
	         System.out.println("sex==="+users.getSex());*/
	         
	         /**//*//在指定对象中放查询结果
	         Integer key=new Integer(1);
	         User user=new User();
	         sqlMap.queryForObject("User.getUsers", key,user);
	         System.out.println("id==="+user.getId());
	         System.out.println("name==="+user.getName());
	         System.out.println("sex==="+user.getSex());*/
	         
	         /**//*//执行批量查询
	         List list=sqlMap.queryForList("User.getUsers",null);
	         Iterator it=list.iterator();
	         while(it.hasNext()){
	             User user=(User)it.next();
	             System.out.println("id==="+user.getId());
	             System.out.println("name==="+user.getName());
	             System.out.println("sex==="+user.getSex());
	         }*/
	         
	         /**//*//查询指定范围内的数据
	         List list=sqlMap.queryForList("User.getUsers",null,0,3);
	         Iterator it=list.iterator();
	         while(it.hasNext()){
	             User user=(User)it.next();
	             System.out.println("id==="+user.getId());
	             System.out.println("name==="+user.getName());
	             System.out.println("sex==="+user.getSex());
	         }*/
	         
	         sqlMap.commitTransaction();
	         System.out.print("操作成功！");
	         
	        }catch(IOException e){
	            System.out.print("读取配置文件失败！");
	        }catch(SQLException ex){
	            System.out.print("操作数据出现异常！");
	        }
	        
	    }

	}