Mybatis的配置使用在SpringFramework中(需要的拿走)

需要的拿走

这套mybatis连接池配置可以承受大量用户访问而不出现卡顿

package com.xin.config;

import javax.sql.DataSource;

import org.apache.ibatis.logging.stdout.StdOutImpl;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.context.annotation.Bean;

import com.alibaba.druid.pool.DruidDataSource;

public class MyBatisConfig {
	// 数据源(数据库连接池)
	@Bean
	public DataSource druidDataSourceBean() {
		DruidDataSource dataSource = new DruidDataSource();
		dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
		dataSource.setUrl("jdbc:mysql://localhost:3306/my_db?charset=utf8mb4&useSSL=false&useTimezone=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true");
		dataSource.setUsername("root");
		dataSource.setPassword("a12345678900");
		dataSource.setMaxActive(50);
	
		return dataSource;
	}
	
	// SqlSessionFactory(注入DataSource数据源)
	@Bean
	public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) throws Exception {
		SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
		
		// 注入DataSource
		sqlSessionFactoryBean.setDataSource(dataSource);
		
		// 开启日志
		SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBean.getObject();
		Configuration config = sqlSessionFactory.getConfiguration();
		config.setLogImpl(StdOutImpl.class);
		
		
		return sqlSessionFactoryBean;
	}
	
	// 映射器扫描
	@Bean
	public MapperScannerConfigurer mapperScannerConfigurer() {
		MapperScannerConfigurer mapperScanner = new MapperScannerConfigurer();
		
		// 设置扫描包
		mapperScanner.setBasePackage("com.apesource.mapper");
		
		//注入SqlSessionFactoryBean在容器中的名称
		mapperScanner.setSqlSessionFactoryBeanName("sqlSessionFactoryBean"); 
		return mapperScanner;
	}
}

需要的依赖

    	<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>5.2.1.RELEASE</version>
		</dependency>


		<!-- MySQL驱动依赖 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.26</version>
		</dependency>

		<!-- MyBatis依赖 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<!-- 3.5.7版本解决JEP-290漏洞 -->
			<version>3.5.7</version>
		</dependency>

		<!-- MyBatis-Spring 依赖 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>2.0.6</version>
		</dependency>

		<!-- alibaba数据库连接池druid依赖 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.2.6</version>
		</dependency>