在上一次计算的结果的基础上,我们可以将该结果写入数据库
下面贴出代码:
def data2MySql(part:Iterator[(String,Int)]) = {
val conn: Connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/lfr","root","123456")
val p = conn.prepareStatement("insert into access_log(province,counts) values(?,?)")
part.foreach(
data => {
println(data._1)
println(data._2)
p.se