spring兼容mysql_springboot + mybatis 支持oracle和mysql切换含源码

1、springboot 启动类加入bean 如下

// DatabaseIdProvider元素主要是为了支持不同的数据库

@Bean

public DatabaseIdProvider getDatabaseIdProvider() {

DatabaseIdProvider databaseIdProvider = new VendorDatabaseIdProvider();

Properties properties = new Properties();

properties.setProperty("Oracle", "oracle");

properties.setProperty("MySQL", "mysql");

databaseIdProvider.setProperties(properties);

return databaseIdProvider;

}

2、application.yml 配置

spring:

datasource:

# 使用mysql

# driver-class-name: com.mysql.jdbc.Driver

# url: jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncod