scala读取mysql_转： spark：scala读取mysql的4种方法

转自：http://blog.csdn.net/liuzongxi/article/details/51764104

1. 引入mysql的驱动包到/usr/local/spark/spark-1.6.0-bin-hadoop2.6/lib/Hbase(目录根据配置而不同)

mysql-connector-Java-5.1.7-bin.jar

并在mysql创建表stock:

CREATE TABLE `stock` (

`id` decimal(20,0) DEFAULT NULL,

`stock_code` varchar(20) DEFAULT NULL,

`stock_cname` varchar(50) DEFAULT NULL,

`stock_ename` varchar(50) DEFAULT NULL,

`mark` varchar(255) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2.scala程序

package com.wonhigh.test

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

object SparkOnMysql {

def main(args: Ar