import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Driver {
 private static int money;


 public static void main(String[] args) throws InterruptedException {
  doStuff();
 }

 public static void doStuff() {
  long startTime = System.currentTimeMillis();
  Thread t1 = new Thread(new dbClient());
  Thread t2 = new Thread(new Thread2());
  String dbHost = "#";
  String dbPort = "#";
  String dbDatabase = "#";
  String dbUser = "#";
  String dbPassword = "#";
  System.out.println("Running dbClient");
  Connection con;
  try {
   System.out.println(startTime);
   System.out.println("***Thread 1 initiated.");
   String url = "jdbc:mysql://" + dbHost + ":" + dbPort + "/" + dbDatabase;
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   con = DriverManager.getConnection(url, dbUser, dbPassword);
   //Man skal uncomment nedenstående sætning for at ændre på om metoden laver dirty read eller ej
   //con.setAutoCommit(false);
   money = 0;
   int userid;
   Statement stmt = con.createStatement();
   for (int i = 0; i < 800; i++) {
    ResultSet rs = stmt.executeQuery("SELECT * FROM Bank");
    while (rs.next()) {
     money = rs.getInt("balance");
     userid = rs.getInt("id");
    }
   }
   stmt.close();
   con.close();
   System.out.println("Disconnected from database");

  } catch (Exception e) {
   e.printStackTrace();
  }
  long endTime = System.currentTimeMillis();
  System.out.println(endTime);
  long totalTime = endTime - startTime;
  System.out.println(totalTime);
 }
}