本文整理汇总了Scala中org.apache.spark.sql.jdbc.JdbcDialect类的典型用法代码示例。如果您正苦于以下问题：Scala JdbcDialect类的具体用法？Scala JdbcDialect怎么用？Scala JdbcDialect使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了JdbcDialect类的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Scala代码示例。
示例1: SqlServerSink
//设置package包名称以及导入依赖的类
package yumi.pipeline.sinks
import java.sql.{Connection, PreparedStatement}
import org.apache.spark.sql.jdbc.JdbcDialect
import org.apache.spark.sql.types._
class SqlServerSink extends DatabaseSink
with Serializable {
override def bulkInsertStatement (conn: Connection,
table: String,
rddSchema: StructType,
dialect: JdbcDialect,
rowCount: Int) : PreparedStatement = {
val columns = rddSchema.fields.map(x => dialect.quoteIdentifier(x.name)).mkString(",")
val parameters = rddSchema.fields.map(_ => "?").mkString("(", ",", ")")
val sql = new StringBuilder(s"INSERT INTO $table($columns) VALUES ")
(1 to rowCount).foldLeft(false) { (prependComma, index) =>
if (prependComma) {
sql.append(", ")
}
sql.append(parameters)
true
}
conn.prepareStatement(sql.toString())
}
} 示例2: OracleDatabaseSink
//设置package包名称以及导入依赖的类
package yumi.pipeline.sinks
import java.sql.{Connection, PreparedStatement}
import org.apache.spark.sql.jdbc.JdbcDialect
import org.apache.spark.sql.types._
class OracleDatabaseSink extends DatabaseSink with Serializable {
override def bulkInsertStatement (conn: Connection,
table: String,
rddSchema: StructType,
dialect: JdbcDialect,
rowCount: Int) : PreparedStatement = {
val columns = rddSchema.fields.map(x => dialect.quoteIdentifier(x.name)).mkString(",")
val parameters = rddSchema.fields.map(_ => "?").mkString(s"INTO $table($columns) VALUES (", ",", ")")
val sql = new StringBuilder("INSERT ALL ")
(1 to rowCount).foldLeft(false) { (prependComma, index) =>
if (prependComma) {
sql.append(" ")
}
sql.append(parameters)
true
}
sql.append(" SELECT 1 FROM DUAL")
conn.prepareStatement(sql.toString())
}
} 示例3: MySqlSink
//设置package包名称以及导入依赖的类
package yumi.pipeline.sinks
import java.sql.{Connection, PreparedStatement}
import org.apache.spark.sql.jdbc.JdbcDialect
import org.apache.spark.sql.types._
class MySqlSink extends DatabaseSink with Serializable {
override def bulkInsertStatement (conn: Connection,
table: String,
rddSchema: StructType,
dialect: JdbcDialect,
rowCount: Int) : PreparedStatement = {
val columns = rddSchema.fields.map(x => dialect.quoteIdentifier(x.name)).mkString(",")
val parameters = rddSchema.fields.map(_ => "?").mkString("(", ",", ")")
val sql = new StringBuilder(s"INSERT INTO $table($columns) VALUES ")
(1 to rowCount).foldLeft(false) { (prependComma, index) =>
if (prependComma) {
sql.append(", ")
}
sql.append(parameters)
true
}
conn.prepareStatement(sql.toString())
}
} 示例4: PostgreSqlSink
//设置package包名称以及导入依赖的类
package yumi.pipeline.sinks
import java.sql.{Connection, PreparedStatement}
import org.apache.spark.sql.jdbc.JdbcDialect
import org.apache.spark.sql.types._
class PostgreSqlSink extends DatabaseSink with Serializable {
override def bulkInsertStatement (conn: Connection,
table: String,
rddSchema: StructType,
dialect: JdbcDialect,
rowCount: Int) : PreparedStatement = {
val columns = rddSchema.fields.map(x => dialect.quoteIdentifier(x.name)).mkString(",")
val parameters = rddSchema.fields.map(_ => "?").mkString("(", ",", ")")
val sql = new StringBuilder(s"INSERT INTO $table($columns) VALUES ")
(1 to rowCount).foldLeft(false) { (prependComma, index) =>
if (prependComma) {
sql.append(", ")
}
sql.append(parameters)
true
}
conn.prepareStatement(sql.toString())
}
}