Mybatis通用动态新增数据

　　通过修改接口入参，动态获取表名、字段名，新增数据。

//获取接口入参
JSONObject jsonParams = JSONObject.fromObject("inParamXml");
 
Map<String, Object> params = new HashMap<>();
List<String> keys = new ArrayList<>();
List<String> values = new ArrayList<>();
 
//获取表名 主键名 主键值
String tableName = jsonParams.getString("tableName");
String primaryKey = jsonParams.getString("primaryKey");
String primaryValue = jsonParams.getString(primaryKey);
Set<?> entrySet = jsonParams.entrySet();
Iterator<?> iterator = entrySet.iterator();
 
while (iterator.hasNext()) {
    Entry<String, String> entry = (Entry<String, String>) iterator.next();
    String key = entry.getKey();
    String value = entry.getValue();
    if (!"tableName".equals(key) && !"primaryKey".equals(key) && !primaryKey.equals(key)) {
        keys.add(key);
        values.add(value);
    }
}
params.put("primaryKey", primaryKey);
params.put("primaryValue", primaryValue);
params.put("tableName", tableName);
params.put("keys", keys);
params.put("values", values);

　　Mybatis动态sql配置

<!-- 通用新增数据 -->
<insert id="insertCommonInsertInfo"  parameterType="java.util.Map">
    INSERT INTO ${tableName} 
        (${primaryKey},
    <foreach collection='keys' item='key' close=')' separator=','>
        <if test="value != null && value !=''">
            ${keys[index]}
        </if>
    </foreach>
    VALUES
        (${primaryValue},
    <foreach collection='values' item='value' close=')' separator=','>
        <if test="value != null && value !=''">
            ${value}
        </if>
    </foreach>
    ON DUPLICATE KEY UPDATE
    <foreach collection='values' item='value' index='index' separator=','>
        <if test="value != null && value !=''">
            ${keys[index]} = #{value}
        </if>
    </foreach>
</insert>