String query = null;
  private void mapNodesToHosts(Experiment experiment, 			       String assemblyMatch ) {    NodeComponent[] nodeComponents = experiment.getNodes();    HostComponent[] hostComponents = experiment.getHosts();    try {      Connection conn = DBUtils.getConnection();      Map substitutions = new HashMap();      substitutions.put(":assemblyMatch", assemblyMatch);      Statement stmt = conn.createStatement();      String query = DBUtils.getQuery("queryHostNodes", substitutions);      //      System.out.println(query);      ResultSet rs = stmt.executeQuery(query);      while(rs.next()) {	String hostName = rs.getString(1);	String nodeName = rs.getString(2);		for (int i=0; i < hostComponents.length; i++) {	  HostComponent hc = hostComponents[i];	  if (hc.getShortName().equals(hostName)) {	    for (int j=0; j < nodeComponents.length; j++) {	      NodeComponent nc = nodeComponents[j];	      if (nc.getShortName().equals(nodeName)) {		hc.addNode(nc);		break;	      }	      	    }	    	    break;	  }	  	}       }      rs.close();      stmt.close();      conn.close();       } catch (SQLException se) {      System.err.println("Caught SQL exception: " + se);      se.printStackTrace();    }  }