/Java/Java code to compare csv file against a table

Java code to compare csv file against a table

HashMap<String, String> f1 = new HashMap<String, String>();
HashMap<String, String> f2 = new HashMap<String, String>();
// read f1, f2; use PK field as the key
List<String> deleted = new ArrayList<String>();
List<String> updated = new ArrayList<String>();
for(Map.Entry<String, String> entry : f1.keySet()) {
    if(!f2.containsKey(entry.getKey()) {
        deleted.add(entry.getValue());
    } else {
        if(!f2.get(entry.getKey().equals(f1.getValue())) {
            updated.add(f1.getValue());
        }
    }
}
for(String key : f1.keySet()) {
    f2.remove(key);
}
// f2 now contains only "new" rows

Source: stackoverflow.com

Similar codes

0 vote202 views1 answer
How to set to nothing a ComboBox in java
Java
-1 vote187 views1 answer
Executorservice in java
Java
2 votes208 views1 answer
How to pass enum in postman body
Java
0 vote177 views1 answer
Java access enum per index
Java
0 vote312 views1 answer
P=
Java
0 vote171 views1 answer
Set path in windows
Java
0 vote290 views1 answer
Treeset java descending order using comparator
Java
0 vote175 views1 answer
Interface extending interface in java
Java
1 vote171 views1 answer
How to convert char to uppercase java
Java
0 vote184 views1 answer
Minecraft addlayer(u) in the type rendererlivingentity<t> is not applicable for the arguments
Java