如何在我的spark 2.4.7中连接和写入postgres jdbc？

import org.apache.spark.sql.{SparkSession, SaveMode}

// 导入PostgreSQL JDBC驱动程序
import org.postgresql.Driver

val spark = SparkSession.builder()
  .appName("Spark PostgreSQL Example")
  .config("spark.master", "local")
  .getOrCreate()

val jdbcUrl = "jdbc:postgresql://localhost:5432/mydatabase"
val connectionProperties = new java.util.Properties()
connectionProperties.setProperty("user", "myuser")
connectionProperties.setProperty("password", "mypassword")

val df = spark.read
  .jdbc(jdbcUrl, "mytable", connectionProperties)

val jdbcUrl = "jdbc:postgresql://localhost:5432/mydatabase"
val connectionProperties = new java.util.Properties()
connectionProperties.setProperty("user", "myuser")
connectionProperties.setProperty("password", "mypassword")

df.write
  .mode(SaveMode.Append)
  .jdbc(jdbcUrl, "mytable", connectionProperties)