testibatis.java

CRM源码CRM源码CRM源码CRM源码CRM源码CRM源码

package com.bjsxt.crm.test;

import java.io.Reader;
import java.util.Iterator;
import java.util.List;

import com.bjsxt.crm.model.User;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class TestIbatis {
	
	public static void main(String[] args) throws Exception{
		
	Reader reader = Resources.getResourceAsReader("sqlMapConfig.xml");
	
	SqlMapClient sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
	
	reader.close();
	/*
	for(int i=0; i<10; i++){
		User u = new User();
		u.setUsername("用户_"+i);
		u.setPassword("密码_"+i);
		sqlMapper.insert("insertUser", u);
		
	}
	*/
	try{
		sqlMapper.startTransaction();
		List<User> list = sqlMapper.queryForList("selectAllUsers");
		
		for(Iterator<User> user = list.iterator(); user.hasNext();){
			User u = user.next();
			System.out.println(u.getUsername());
			
		}
	
	sqlMapper.commitTransaction();
	}finally{
		sqlMapper.endTransaction();
		
	}
		
	}

}