scala写入mysql_scala数据批量写入数据库

package com.dfssi.dataplatform

import java.sql.{Connection, DriverManager, PreparedStatement, Statement}

import java.util

import com.alibaba.fastjson.{JSON, JSONObject}

import com.dfssi.dataplatform.analysis.jdbc.SQL

import org.apache.spark.broadcast.Broadcast

import org.apache.spark.internal.Logging

import org.apache.spark.rdd.RDD

import org.apache.spark.{SparkConf, SparkContext}

import scala.collection.mutable

/**

* description:

*

* @author WangHD

* @date 2020/5/13 0013 10:37

* @version 1.0

*/

case class RowData(id: String, district: String, enterprise: String, originalMsg: String, vid: String, vin: String, commandSign: String) extends Serializable

object DataToMysql extends Serializable with Logging {

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