记一次ORACLE动态插入数据（表名动态、字段动态）遇到的CLOB字段问题、开发语言JAVA

Mapper中的方法

    @InsertProvider(type = SqlProvider.class, method = "insertData")
    void insertData(Map tableDataMap);

SqlProvider类

class SqlProvider
{
    @SuppressWarnings("unchecked")
    public String updateByPrimaryKey(Map tableDataMap)
    {
        SQL sql = new SQL();
        sql.UPDATE(tableDataMap.get("tableName") + "");
        Set < String > keySet = tableDataMap.keySet();
        for(String cloumn: keySet)
        {
            Object columnValue = tableDataMap.get(cloumn);
            if(cloumn.equals("tableName") == false && cloumn.equals("id") == false)
            {
                if(columnValue instanceof Integer || columnValue instanceof Long || columnValue instanceof Double || columnValue instanceof Float || columnValue instanceof Boolean)
                {
                    sql.SET(cloumn + "=" + columnValue);
                }
                else if((columnValue + "").length() > 4000)
                {
                    sql.SET(cloumn + "=#{" + cloumn + ",jdbcType=CLOB}");
                }
                else
                {
                    sql.SET(cloumn + "= '" + columnValue + "'");
                }
            }
        }
        sql.WHERE("id = " + tableDataMap.get("id") + "");
        return sql.toString();
    }
 
 
    @SuppressWarnings("unchecked")
    public String insertData(Map tableDataMap)
    {
        SQL sql = new SQL();
        sql.INSERT_INTO(tableDataMap.get("tableName") + "");
        sql.VALUES("id", IdWorker.nextId() + "");
        Set < String > keySet = tableDataMap.keySet();
        for(String cloumn: keySet)
        {
            Object columnValue = tableDataMap.get(cloumn);
            if(cloumn.equals("tableName") == false)
            {
                if(columnValue instanceof Integer || columnValue instanceof Long || columnValue instanceof Double || columnValue instanceof Float || columnValue instanceof Boolean)
                {
                    sql.VALUES(cloumn, "" + columnValue);
                }
                else if((columnValue + "").length() > 4000)
                {
                    sql.VALUES(cloumn, "#{" + cloumn + ",jdbcType=CLOB}");
                }
                else
                {
                    sql.VALUES(cloumn, "'" + columnValue + "'");
                }
            }
        }
        return sql.toString();
    }
}

 参考文档：https://my.oschina.net/u/4329170/blog/3963594

https://mybatis.org/mybatis-3/zh/statement-builders.html

其中最实用的

https://www.programcreek.com/java-api-examples/index.php?api=org.apache.ibatis.jdbc.SQL