mybaits的sqlSession工厂工具类

最新推荐文章于 2022-06-28 09:51:33 发布

MengXniu

最新推荐文章于 2022-06-28 09:51:33 发布

阅读量195

点赞数

分类专栏： Java 工具类文章标签： mybatis sql

本文链接：https://blog.csdn.net/xumao11/article/details/106620328

版权

Java 工具类专栏收录该内容

7 篇文章 0 订阅

订阅专栏

import java.io.IOException;
import java.io.InputStream;

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

public class MybatisSessionFactory {
	private static  final String FILE="mybatis.config.xml";
    private static SqlSessionFactory sqlSessionFactory;

    public static SqlSession getSession() {
		try {
			InputStream resourceAsStream = Resources.getResourceAsStream(FILE);
			sqlSessionFactory=new SqlSessionFactoryBuilder().build(resourceAsStream);
	    	SqlSession sqlSession=sqlSessionFactory.openSession();
	    	return sqlSession;
		} catch (IOException e) {
			 throw ExceptionFactory.wrapException("Error building SqlSession.", e);
		}       
		
//        SqlSession sqlSession=THREAD_LOCAL.get();
//        if (sqlSession==null){
//            if (sqlSessionFactory==null){
//                InputStream resourceAsStream=null;
//                try {
//                    resourceAsStream= Resources.getResourceAsStream(FILE);
//                } catch (IOException e) {
//                    e.printStackTrace();
//                }
//                sqlSessionFactory=new SqlSessionFactoryBuilder().build(resourceAsStream);
//            }
//            sqlSession=sqlSessionFactory.openSession();
//            THREAD_LOCAL.set(sqlSession);
//        }
//        return sqlSession;
    }

    private static  final ThreadLocal<SqlSession> THREAD_LOCAL=new ThreadLocal<>();
    public static void closeSession(){
        SqlSession sqlSession = THREAD_LOCAL.get();
        THREAD_LOCAL.set(null);
        if (sqlSession!=null){
            sqlSession.close();
        }
    }
}