Mybatis系列之设置自动提交事务

通过网上资料和自己尝试，初步判断是事务没提交导致的，网上资料搜索到Mybatis SqlSession默认是不自动提交事务的，所以尝试开启Mybatis SqlSession自动提交事务

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.stereotype.Service;

/**
 * 获取Spring上下文
 */
@Service
public class ApplicationContextHolder implements ApplicationContextAware { private static ApplicationContext ctx;

	@Override
	public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {
		ctx = applicationContext;
	} public static ApplicationContext getApplicationContext() {
		return ctx;
	} @SuppressWarnings("unchecked")
	public static <T> T getBean(String beanName) {
		return (T) ctx.getBean(beanName);
	} public static <T> T getBean(Class<T> clazz) {
		return ctx.getBean(clazz);
	}

	/**
	 * 设置Mybatis自动提交事务
	 * @Author mazq
	 * @Date 2020/05/29 13:51
	 * @return org.apache.ibatis.session.SqlSession
	 */
	public static SqlSession getSqlSession(){
		SqlSessionFactory sqlSessionFactory  = (SqlSessionFactory)ctx.getBean("sqlSessionFactory");
		return sqlSessionFactory.openSession(true);
	}
}


  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
  
16
  
17
  
18
  
19
  
20
  
21
  
22
  
23
  
24
  
25
  
26
  
27
  
28
  
29
  
30
  
31
  
32
  
33
  
34
  
35
  
36
  
37
  
38
  
39
  
40
  
41
  
42
  
43
  
44
  
45
  
46
  
47
  
48
  
49
  
50
 

然后在对应dao类后面加上代码：

// Mybatis自动提交事务 SqlSession mybatisSqlSession = ApplicationContextHolder.getSqlSession(); mybatisSqlSession.commit();

  

 

  
1
  
2
  
3
 

文章来源: smilenicky.blog.csdn.net，作者：smileNicky，版权归原作者所有，如需转载，请联系作者。

原文链接：smilenicky.blog.csdn.net/article/details/106497185