springboot配合mybtiasplus获取当前数据库类型

根据_databaseId查询，例：select a.*,#{_databaseId} from table_a

    <select id="getDbType" resultType="java.lang.String">
        select
        <if test="_databaseId == 'oracle' || _databaseId == 'dm'">
            'oracle'
        </if>
        <if test="_databaseId == 'mysql'">
            'mysql'
        </if>
        from dual
    </select>

根据数据库类型进行序列处理

    <select id="getSeqByName" resultType="java.lang.Long">
        select
        <if test="_databaseId == 'oracle' || _databaseId == 'dm'">
            ${seqName}.NEXTVAL from dual
        </if>
        <if test="_databaseId == 'mysql'">
            nextVal(#{seqName})
        </if>
    </select>