examplemain.java

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());
		}

	}
}