mybatis 不同数据库厂商切换不同的sql语句

参考一：多数据库支持
参考二：demo

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

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sunyard.bigdata.dao.NoteMapper">

    <select id="queryAll" resultType="com.sunyard.bigdata.pojo.Note" databaseId="oracle">
        SELECT USER_ID,USER_NAME,USER_AGE FROM T_USER   
    </select>
    <select id="queryAll" resultType="com.sunyard.bigdata.pojo.Note" databaseId="mysql">
        SELECT user_id,user_name,user_age FROM t_user
    </select>
</mapper>