spark写入mysql

spakr中df的内容写入mysql

• rdd或其他内容转化为df
• 配置数据库的属性
• 调用df的写入方法

    //ds转化为df
    val frame = sprak.createDataFrame(value)
    val prop =new Properties()
    prop.setProperty("user","root")
    prop.setProperty("password","123")

    frame.write.jdbc("jdbc:mysql://localhost:3306/ssm","dmp",prop)