/**
 *
 */
package com;

import java.sql.DriverManager;
import java.sql.SQLException;

import org.apache.spark.SparkConf;
import org.apache.spark.SparkContext;
import org.apache.spark.api.java.JavaPairRDD;
import org.apache.spark.rdd.JdbcRDD;

import scala.Function0;
import scala.Function1;


public class JdbcRddTest {
    public static void main(String[] args) throws Exception {
	SparkConf sparkConf = new SparkConf().setAppName("JdbcRddTest");
	sparkConf.setMaster("local");
	SparkContext ctx = new SparkContext(sparkConf);

	JavaPairRDD<String, String> performanceMap = null;



	Function0 f = new Function0() {


	    @Override
	    public Object apply() {
		try {
		    Class.forName("com.mysql.jdbc.Driver").newInstance();
		  String URL = "jdbc:mysql://171.23.123.221:3306/test";
		  	String userName = "tech";
	String password = "a@123";
		    return DriverManager.getConnection(URL, userName, password);
		} catch (Exception e) {
		    return null;
		}

	    }

	    @Override
	    public byte apply$mcB$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public char apply$mcC$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public double apply$mcD$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public float apply$mcF$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public int apply$mcI$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public long apply$mcJ$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public short apply$mcS$sp() {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public void apply$mcV$sp() {
		// TODO Auto-generated method stub

	    }

	    @Override
	    public boolean apply$mcZ$sp() {
		// TODO Auto-generated method stub
		return false;
	    }
	};
	Function1 fun1 = new Function1() {

	    @Override
	    public Function1 andThen(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcDD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcDF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcDI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcDJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcFD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcFF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcFI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcFJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcID$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcIF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcII$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcIJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcJD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcJF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcJI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcJJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcVD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcVF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcVI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcVJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcZD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcZF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcZI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 andThen$mcZJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Object apply(Object arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public double apply$mcDD$sp(double arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public double apply$mcDF$sp(float arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public double apply$mcDI$sp(int arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public double apply$mcDJ$sp(long arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public float apply$mcFD$sp(double arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public float apply$mcFF$sp(float arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public float apply$mcFI$sp(int arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public float apply$mcFJ$sp(long arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public int apply$mcID$sp(double arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public int apply$mcIF$sp(float arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public int apply$mcII$sp(int arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public int apply$mcIJ$sp(long arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public long apply$mcJD$sp(double arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public long apply$mcJF$sp(float arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public long apply$mcJI$sp(int arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public long apply$mcJJ$sp(long arg0) {
		// TODO Auto-generated method stub
		return 0;
	    }

	    @Override
	    public void apply$mcVD$sp(double arg0) {
		// TODO Auto-generated method stub

	    }

	    @Override
	    public void apply$mcVF$sp(float arg0) {
		// TODO Auto-generated method stub

	    }

	    @Override
	    public void apply$mcVI$sp(int arg0) {
		// TODO Auto-generated method stub

	    }

	    @Override
	    public void apply$mcVJ$sp(long arg0) {
		// TODO Auto-generated method stub

	    }

	    @Override
	    public boolean apply$mcZD$sp(double arg0) {
		// TODO Auto-generated method stub
		return false;
	    }

	    @Override
	    public boolean apply$mcZF$sp(float arg0) {
		// TODO Auto-generated method stub
		return false;
	    }

	    @Override
	    public boolean apply$mcZI$sp(int arg0) {
		// TODO Auto-generated method stub
		return false;
	    }

	    @Override
	    public boolean apply$mcZJ$sp(long arg0) {
		// TODO Auto-generated method stub
		return false;
	    }

	    @Override
	    public Function1 compose(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcDD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcDF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcDI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcDJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcFD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcFF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcFI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcFJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcID$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcIF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcII$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcIJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcJD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcJF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcJI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcJJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcVD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcVF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcVI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcVJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcZD$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcZF$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcZI$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }

	    @Override
	    public Function1 compose$mcZJ$sp(Function1 arg0) {
		// TODO Auto-generated method stub
		return null;
	    }
	};

	JdbcRDD<?> mysqlJdbcRDD = new JdbcRDD(ctx, f, sql, 1, 3, 0, fun1, null);

	mysqlJdbcRDD.collect();

    }
}
