scala写入mysql_spark 计算结果写入mysql 案例及常见问题解决

package com.jxd

import org.apache.spark.SparkContext

import org.apache.spark.SparkConf

import java.sql.Connection

import java.sql.DriverManager

object hello {

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

var conf = new SparkConf().setAppName("Hello World")

var sc = new SparkContext(conf)

var input = sc.textFile("test/hello", 2)

var count = input.flatMap(name => name.split(" ")).map((_, 1)).reduceByKey(((a, b) => a + b))

count.foreachPartition(insertToMysql)

}

def insertToMysql(iterator: Iterator[(String, Int)]): Unit = {

val driver = "com.mysql.jdbc.Driver"

val url = "jdbc:mysql://192.168.10.58:3306/test"

val username = "root"

val password = "1"

var connectionMq