import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedList;


     public class DBHash {



       public static void main(String[] args) {
    	   HashMap<Long,String> data = new HashMap<Long,String>();
    	   ArrayList<Long> data2 = new ArrayList<Long>();
    	   LinkedList<Long> data3 = new LinkedList<Long>();

    	   final int size = 100;
         try {
           DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
           Connection connection = DriverManager.getConnection(
             "jdbc:oracle:thin:@mtsthelens.informatik.hs-fulda.de:1521:ORALV9A",
             "DBTA04","DBTA04");
           Statement stmt = connection.createStatement();




           long starttime = System.currentTimeMillis();

	       ResultSet resultSet = stmt.executeQuery(
	             "SELECT COUNT(DISTINCT CK1) FROM PROJA14.R"+ size +"K");
	       while (resultSet.next())
	       {
	             System.out.println(resultSet.getInt(1));
	       }
	       resultSet.close();

	       long endtime = System.currentTimeMillis();
	       long elapsedtime = endtime - starttime;

	       System.out.println("Verstrichene Zeit in Millisekunden: " + elapsedtime);

	       //Aus Datenbank lesen
	       starttime = System.currentTimeMillis();
           resultSet = stmt.executeQuery("Select * From PROJA14.R"+ size + "K");

	       while (resultSet.next()) {
        	   long result = resultSet.getLong("CK1");
        	   if(!resultSet.wasNull())
        	   {
        		   data2.add(result);
        	   }

             }
	       resultSet.close();
	       System.out.println("Count: " + data2.size());
	       endtime = System.currentTimeMillis();
	       elapsedtime = endtime - starttime;


	       //HashMap
	       System.out.println("");
	       starttime = System.currentTimeMillis();

           for(int i = 0; i < data2.size();i++) {
        	   long datensatz = data2.get(i);
        	   if(data.get(datensatz) == null)
        	   {
        		   data.put(datensatz, "");
        	   }

             }

           endtime = System.currentTimeMillis();
	       elapsedtime = endtime - starttime;
	       System.out.println("HashMap:");
           System.out.println("Count: " + data.size());
	       System.out.println("Verstrichene Zeit in Millisekunden: " + elapsedtime);

	       System.out.println("");
	       starttime = System.currentTimeMillis();
	       for(int i = 0; i < data2.size(); i++)
	       {
	    	   if(!data3.contains(data2.get(i)))
	    	   {
	    		   data3.add(data2.get(i));
	    	   }
	       }

	       endtime = System.currentTimeMillis();
	       elapsedtime = endtime - starttime;
	       System.out.println("ArrayList:");
           System.out.println("Count: " + data3.size());
	       System.out.println("Verstrichene Zeit in Millisekunden: " + elapsedtime);


	       /**
	       System.out.println("");
	       starttime = System.currentTimeMillis();
           resultSet = stmt.executeQuery("Select * From PROJA14.R"+ size + "K");
           while (resultSet.next()) {
        	   long result = resultSet.getLong("CK1");
        	   if(data.get(result) == null)
        	   {
        		   data.put(result, "");
        	   }

             }

           endtime = System.currentTimeMillis();
	       elapsedtime = endtime - starttime;
           resultSet.close();
           System.out.println("Count: " + data.size());
	       System.out.println("Verstrichene Zeit in Millisekunden: " + elapsedtime);**/

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