您可以将数据帧从scala插入到Teradata存储过程中吗？

import java.sql.{Connection, DriverManager}

val jdbcUrl = "jdbc:teradata://<hostname>/<database>"
val username = "<username>"
val password = "<password>"

// 建立数据库连接
val connection: Connection = DriverManager.getConnection(jdbcUrl, username, password)

val tableName = "<table_name>"
val dataFrame = // 您的数据帧

val insertSQL = s"INSERT INTO $tableName VALUES (?, ?, ?)" // 假设有3列需要插入

val preparedStatement = connection.prepareStatement(insertSQL)

// 遍历数据帧的每一行，并将数据插入到Teradata数据库中
dataFrame.collect().foreach { row =>
  preparedStatement.setString(1, row.getString(0))
  preparedStatement.setInt(2, row.getInt(1))
  preparedStatement.setDouble(3, row.getDouble(2))
  preparedStatement.executeUpdate()
}

preparedStatement.close()