SQL PrepareStatement using 'IN' : I would like to know how I can return a result set from a query as a map. 
This is my query where 'nameCodesString' is a list of strings:

    try (PreparedStatement stmt = conn
    					.prepareStatement("select n.CODE, l.VALUE"
    							+ " from TNAME n join TPROPERTIES l on n.UIDPK = l.OBJECT_UID"
    							+ " where n.CODE IN (" + nameCodesString + ")")) {
    				try (ResultSet rs = stmt.executeQuery()) {
    					while (rs.next()) {
    						log.info("rs {}",rs);
    						nameCode = rs.getString(1);
    						displayName = rs.getString(2);
    						Person.add(new PersonDTO(nameCode, displayName, ""));
    					}
    				}
    			}

The result should be a code and a value. I am not sure how I can do this all in one connection to the database.

Thanks