在配合mysqlplus之后效果更佳，可以直接兼容各种数据库

---

#mysqlplus兼容常用mysql、oracle、sqlserver等还兼容国产的达梦、人大金仓等

1.配置加载bean，databaseId

@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.mapper调用方法

2.1 第一种

<mapper namespace="com.xxx.mapper" > 
 
<select id="list" resultType="com.xxx.base.TestDemo" databaseId="mysql">
       SELECT * from test_demo
</select>
 
<select id="list" resultType="com.xxx.base.TestDemo" databaseId="oracle">
       SELECT * from test_demo
</select>
 
</mapper>

2.1 第二种

<mapper namespace="com.xxx.mapper" > 
 
<select id="list" resultType="com.xxx.base.TestDemo">
      <if test="_databaseId == 'oracle'">
          SELECT * from test_demo
      </if>
        <if test="_databaseId == 'mysql'">
          SELECT * from test_demo
      </if>
</select>
</mapper>