MybatisPlus配置数据源

最新推荐文章于 2025-06-13 15:02:31 发布

原创最新推荐文章于 2025-06-13 15:02:31 发布 · 2.5k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#java #intellij-idea #spring

mybatisplus 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何使用MybatisPlus进行数据源配置，包括设置全局配置、配置SQLSessionFactoryBean、TransactionManager等，并展示了具体实现代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MybatisPlus配置数据源

MybatisPlus关键设置

引入的包为baomidou
MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();

完整config配置,

@Configuration
@MapperScan(basePackages = {"com.yck.mapper"}, sqlSessionTemplateRef = "mhspSqlSessionTemplate")
public class DataSourceConfig {

		public static final String MAPPER_LOCATION_PATTERN = "classpath:mapper/*.xml";
		
		@Bean
		public DataSourceTransactionManager mhspTransactionManager (@Autowired DataSource mhspDataSource) {
			return new DataSourceTransactionManager (mhspDataSource);
		}
		
		public SqlSessionFactory mhspSqlSessionFactory (@Autowired DataSource mhspDataSource) throws Exception {
			MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
			bean.setDataSource(mhspDataSource);
			bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(MAPPER_LOCATION_PATTERN));
			// 全局配置
			bean.setGlobalConfig(globalConfig);
			// 配置打印sql语句
			MybatisConfiguration configuration = new MybatisConfiguration();
			configuration.setLogImpl(StdOutImpl.class);
			return bean.getObject();
		}
		
		@Bean
		public SqlSessionTemplate mhspSqlSessionTemplate(@Qualifier("mhspSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
			return new SqlSessionTemplate(sqlSessionFactory);
		}
		
		@Bean
		public GlobalConfig globalConfig() {
				GlobalConfig conf = new GlobalConfig();
				GlobalConfig.DbConfig dbConfig = new GlobalConfig.DbConfig();
				dbConfig.setKeyGenerator(new OracleKeyGenerator());
				dbConfig.setIdType(IdType.values()[1]);
				confi.setDbConfig(dbConfig);
				return conf;
		}

}