import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.List;
import java.util.Objects;
import java.util.stream.Collectors;
import java.util.stream.Stream;

public class App {
	private static Connection c;

	public static void updateXml(String nom) throws Exception {
		Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		c = DriverManager.getConnection("jdbc:oracle:thin:@oracle.fil.univ-lille1.fr:1521:filora","vanmarcke","azerty");
		PreparedStatement ps = c.prepareStatement("update candidats set cv = ? where nom in (Select nom from bossut.m12018 where username = ?)");
		File f = new File("C:\\Users\\ixpub\\Downloads\\CV");
		ps.setString(1,f+"\\"+nom+".xml");
		ps.setString(2,nom);
		ps.executeQuery();
	}

	File f = new File("C:\\Users\\ixpub\\Downloads\\CV");
	List<String> listXMLFile = Stream.of(Objects.requireNonNull(f.listFiles())).map(File::getName).collect(Collectors.toList());

	public static void main(String [] args) throws Exception {
		File f = new File("C:\\Users\\ixpub\\Downloads\\CV");
		List<String> listXMLFile = Stream.of(Objects.requireNonNull(f.listFiles())).map(File::getName).collect(Collectors.toList());
		for (String xml:listXMLFile) {
			//System.out.println(xml.substring(0, xml.length()-4));
			updateXml(xml.substring(0, xml.length()-4));
		}
	}
}