public Connection getmySQLConnection() {
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://euk.military.co.uk/p2836r42_eukmilitary?", "p2836r42_eukmil","eukmil10");
    return con;
    } catch (Exception e) {
    System.out.println("Exception: " + e.getMessage());
    return null;
    }
  }