julia

package db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.bson.BsonArray;
import org.bson.BsonDocument;
import org.bson.Document;
import org.bson.codecs.configuration.CodecRegistry;
import org.bson.conversions.Bson;

import com.mongodb.BasicDBObject;
import com.mongodb.DBCursor;
import com.mongodb.MongoClient;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;


public class Main {
	public static void main(String[] args) throws SQLException {



		//Mysql
		//mysql();
		mongodb();
	}


	public static void mongodb() {

		MongoClient mongoClient = new MongoClient("localhost", 27017);
		MongoDatabase db = mongoClient.getDatabase("database");

		MongoCollection<Document> coll = db.getCollection("Player");

		BasicDBObject query = new BasicDBObject("name", "Jessica Ruiz");
		long start = System.currentTimeMillis();
		FindIterable cursor = coll.find(query);
		long end = System.currentTimeMillis();

		 System.out.println(start);
	     System.out.println(end);
	     System.out.println("Difference");
	     System.out.println( end - start);




		mongoClient.close();
	}

	public static void mysql() throws SQLException {
		 Connection connection = null; //need to initialize a java.sql.Connection from JDBC.
		  try {

			  Class.forName("com.mysql.jdbc.Driver");

			  connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db-class","root","root");

	      } catch (Exception ex) {
	          ex.printStackTrace();
	      }


		    String sql = "SELECT * from Player as p where p.Name = 'Jessica Ruiz'";

		    PreparedStatement ps = connection.prepareStatement(sql);


		    long start = System.currentTimeMillis();


		    ResultSet rs = ps.executeQuery();


		    long end = System.currentTimeMillis();

		    ArrayList<String> matchingResult = new ArrayList<String>();
		    while (rs.next())
		    {
		        String name = rs.getString("name");
		        matchingResult.add(name);
		    }

		    for (String single : matchingResult) {
		    	System.out.println(single);
		    }

		    System.out.println(start);
		    System.out.println(end);
		    System.out.println("Difference");
		    System.out.println( end - start);

		}


}