Scala 连接 mysql

来源:互联网 发布:如何使用淘宝购物 编辑:程序博客网 时间:2024/05/18 00:19


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()    }  }}


0 0
原创粉丝点击