Scala 连接 mysql

import java.sql.DriverManager


/**
  * Created by root on 16-11-2.
  */
object OnlineWordcount {
  def main(args: Array[String]): Unit = {
    val conn = DriverManager.getConnection(
      "jdbc:mysql://Master:3306/sparkstreaming?useSSL=false",
      "root",
      "123"
    )
    try{
      val sql = "insert into streaming_itemcount(item,count) values ('test3',21)"
      val stmt = conn.createStatement()
      stmt.execute(sql)
      
    }catch {
      case e:Exception => e.printStackTrace()
    }finally {
      conn.close()
    }


  }
}