sparksql jdbc mysql_SparkSQL-通过JDBC读写mysql数据库

object JdbcDatasourceTest {

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

val spark = SparkSession

.builder()

.appName("JdbcDatasourceTest")

.master("local")

.getOrCreate()

//url:

// jdbc:mysql://master:3306/test

// jdbc:oracle://master:3306/test

// jdbc:db2://master:3306/test

// jdbc:derby://master:3306/test

// jdbc:sqlserver://master:3306/test

// jdbc:postgresql://master:3306/test

val mysqlUrl = "jdbc:mysql://master:3306/test"

//1: 读取csv文件数据

val optsMap = Map("header" -> "true", "inferSchema" -> "true")

val df = spark.read.options(optsMap).csv(s"${BASE_PATH}/jdbc_demo_data.csv")

df.show()

val properties = new Properties()

properties.put("user", "root")