spark2.x数据写入到数据库

df.repartition(1).write.mode(SaveMode.Overwrite)
        .format("jdbc")
        .option("driver", "com.mysql.jdbc.Driver")
        .option("url", "jdbc:mysql://127.0.0.1:3306/bcm?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false")
        .option("dbtable", "bcm_test.online_vehicles_test")
        .option("user", "bad")
        .option("password", "123456")
        .save()

注意的是

需要添加option("driver", "com.mysql.jdbc.Driver")，否则提示找不到合适的驱动