JdbcTemplate

fun <T> create(connection: Connection, sql: String, id: (Long) -> T, vararg params: Any): T {
    return connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS).use { statement ->
        for (i in params.indices) {
            val param = params[i]
            val parameterIndex = i + 1

            when (param) {
                is String -> statement.setString(parameterIndex, param)
                is Int -> statement.setInt(parameterIndex, param)
                is Long -> statement.setLong(parameterIndex, param)
                is Boolean -> statement.setBoolean(parameterIndex, param)
                is LocalDate -> statement.setDate(parameterIndex, Date.valueOf(param))
            }
        }
        statement.executeUpdate()
        val keys = statement.generatedKeys
        keys.next()
        id(keys.getLong(1))
    }
}