博客

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;
		}

}