Spark连接数据库（查询，将数据插入数据库）

1 需要的maven包：

 <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>6.0.6</version>
    </dependency>

2 代码

import java.sql.{Connection, DriverManager}

object scal_Mysql1 {

  var conn: Connection = null

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

    try {
      Class.forName("com.mysql.jdbc.Driver")
      println("驱动加载成功")
      conn = DriverManager.getConnection("jdbc:mysql://HadoopNode1:3306/test?user=root&password=000000&useSSL=false")
      println("数据库连接成功")
      val statement = conn.createStatement()
      //执行插入操作
//      println("开始插入数据")
       val rs2 = statement.executeUpdate("INSERT INTO   student (id, NAME) VALUES (2, 'zhangsheng');")
      println("插入数据完成")
      //查询数据
      val resultSet = statement.executeQuery("select * from emp ")
      while (resultSet.next()) {

        println(resultSet.getString(1))

      }
    } catch {
      case _: Exception => 0
    } finally {
      conn.close()
    }

  }
}