package com.sessionfactory;

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

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.yihaomen.mybatis.model.UserAndBook;

public class SessionFactory {

	private static SqlSessionFactory sqlSessionFactory;
	private static Reader reader;
	public static SqlSession session = null;
	static {
		try {
			reader = Resources.getResourceAsReader("Configuration.xml");
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static SqlSession getSession() {
 
		return session = sqlSessionFactory.openSession();
	}

	public static void closeSession() {
		if (session != null) {
			session.close();
		}
	}

	public static void main(String[] args) {
		getSession();
 

		List<UserAndBook> uabList = session
				.selectList("com.yihaomen.mybatis.model.UserMapper.selectUserAndBook");

		for (UserAndBook uab : uabList) {
			System.out.println(uab.getBookName()+"\t"+uab.getUserAddress());
		}

	}
}