CustomizedNamedParameterJdbcTemplate.kt

fun convert(value: Any?, sqlType: Int, typeName: String?): Triple<Any?, Int, String?> {
    if (value is CodedEnum) {
        return Triple(value.code, sqlType, typeName)
    }

    return Triple(value, sqlType, typeName)
}

open class CustomizedNamedParameterJdbcTemplate(classicJdbcTemplate: JdbcOperations) :
        NamedParameterJdbcTemplate(classicJdbcTemplate) {
    override fun getPreparedStatementCreator(sql: String,
                                             paramSource: SqlParameterSource,
                                             customizer: Consumer<PreparedStatementCreatorFactory>?)
            : PreparedStatementCreator {
        val newParamSource = MapSqlParameterSource()

        paramSource.parameterNames?.forEach { name ->
            val (value, sqlType, typeName) = convert(
                    paramSource.getValue(name),
                    paramSource.getSqlType(name),
                    paramSource.getTypeName(name))
            if (typeName != null) {
                newParamSource.addValue(name, value, sqlType, typeName)
            } else {
                newParamSource.addValue(name, value, sqlType)
            }
        }

        return super.getPreparedStatementCreator(sql, newParamSource, customizer)
    }
}