引入mysql的jar包
package com.agm.database
import java.sql.DriverManager
import org.apache.spark.SparkContext
import org.apache.spark.rdd.JdbcRDD
import org.apache.spark.SparkConf
import org.apache.spark.sql.SQLContext
import java.util.Properties
import org.apache.log4j.{Level, Logger}
object SparkOnMysql {
def main(args: Array[String]) {
Logger.getLogger("org").setLevel(Level.ERROR)
val sparkConf = new SparkConf().setMaster("local").setAppName("spark sql test");
val sc = new SparkContext(sparkConf);
val sqlContext = new SQLContext(sc);
//1. 不指定查询条件
//这个方式链接MySql的函数原型是:
//我们只需要提供Driver的url,需要查询的表名,