spark rdd mysql_spark以rdd方式读写mysql

packagecom.home.sparkimportjava.sql.{DriverManager, PreparedStatement}importjava.time.LocalDateTimeimportorg.apache.spark.rdd.RDDimportorg.apache.spark.{SparkConf, SparkContext}importscala.collection.mutable

object Ex_mysql2 {

def main(args: Array[String]): Unit={

val conf= new SparkConf(true).setMaster("local[*]").setAppName("spark mysql demo")

val sc= newSparkContext(conf)

val driverClassName= "com.mysql.jdbc.Driver"val url= "jdbc:mysql://localhost:3306/busdata?characterEncoding=utf8&useSSL=false"val user= "root"val password= "root"

//写入

val logBuffer =mutable.ListBuffer[(String, String, String, String, String, String)]()importjava.time.format.DateTimeFormatter

val ofPattern= DateTimeFormatter.ofPattern("yyyy-MM-dd hh:mm:ss")for (i

logBuffer.+=