mybatis获取SqlSession工具类

最新推荐文章于 2024-01-07 14:42:11 发布

嗷嗷卷

最新推荐文章于 2024-01-07 14:42:11 发布

阅读量384

点赞数

分类专栏：笔记文章标签： mybatis java 开发语言

本文链接：https://blog.csdn.net/qq_54587730/article/details/127174688

版权

笔记专栏收录该内容

2 篇文章 0 订阅

订阅专栏

package com.mybatis.utils;

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 java.io.IOException;

public class SqlSessionUtil {
    private SqlSessionUtil() {}
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }
    private static ThreadLocal<SqlSession> local = new ThreadLocal<>();
    public static SqlSession openSession(){
        SqlSession sqlSession = local.get();
        if (sqlSession == null) {
            sqlSession = sqlSessionFactory.openSession();
            local.set(sqlSession);
        }
        return sqlSession;
    }

    public static void close(SqlSession sqlSession){
        if (sqlSession != null){
            sqlSession.close();
            local.remove();
        }
    }
}

采用了ThreadLocal。

源自：动力节点-老杜