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"),否则提示找不到合适的驱动