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