sparksql--JDBC

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)