val mapOptitons=Map[String,String](
("url","jdbc:mysql://wangfutai:3306/hive"),
("user","hive"),
("password","hive"),
("dbtable","apptab")
)
//通过sparkSql,读取mysql中数据
val df=ssc.read.format("JDBC")//输入数据类型
//ip,acount,pwd
.options(mapOptitons)
.load()
df.registerTempTable("t_app")
//通过sparksql,添加数据
val prop=new Properties()
prop.setProperty("user","hive")
prop.setProperty("password","hive")
val sqlDF= ssc.sql("select * from t_app")
sqlDF.write.jdbc("jdbc:mysql://wangfutai:3306/hive","sparksql",prop)