阅读背景:

Rhythmk 一步一步学 JAVA(11)Ibatis 环境配置

来源:互联网 

1.项目文件分布。

 

2、example1.java:

package com.rhythmk.example1;

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.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class example1 {

	private static String resource = "com\rhythmk\example1\SqlMapConfig.xml";
	private static SqlMapClient sqlMapClient = null;
	static {
		System.out.println(System.getProperty("user.dir"));
		try {
			Reader reader = Resources.getResourceAsReader(resource);
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		GetAllUser();
		
		GetUserById(1);
	}

	/*
	 * 根据ID 获取User
	 */
	public static void GetUserById(Integer id) {
		User user = null;
		try {

			sqlMapClient.startTransaction();

			user = (User) sqlMapClient.queryForObject("selectById",
					new Integer("1"));
			System.out.println(user.getName());
			sqlMapClient.commitTransaction();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static void GetAllUser() {
		List<User> list = null;
		try {

			list = (List<User>) sqlMapClient.queryForList("selectAll");
			for (User user : list) {
				System.out.println(user.getId() + "," + user.getName());
			}

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	

}
packa



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: